1 / 63

The IBM IMS Tools Solution

Maintaining High Database Performance IMS DB Administration Solution. The IBM IMS Tools Solution. Margaret M Wilson IMS Tools Market Manager wilsonmm@us.ibm.com. Data Administration Solutions. IBM Data Encryption for IMS and DB2 Databases IMS Batch Backout Manager

ajaxe
Download Presentation

The IBM IMS Tools Solution

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Maintaining High Database Performance IMS DB Administration Solution The IBM IMS Tools Solution Margaret M Wilson IMS Tools Market Manager wilsonmm@us.ibm.com

  2. Data Administration Solutions • IBM Data Encryption for IMS and DB2 Databases • IMS Batch Backout Manager • IMS HD Compression Extended • IMS MFS Reversal Utilities • IMS Program Restart Facility • IMS HALDB Conversion and Maintenance Aid • IMS Database Control Suite Health Check Components • IMS Database Repair Facility • IMS Library Integrity Utilities • IMS High Performance Pointer Checker

  3. IBM Data Encryption for IMS and DB2 Databases v1.1 5655-P03 • Protects sensitive and private data in both IMS and DB2 databases • Functions: • IMS - Segment level encryption – standard IMS Segment/Edit Compression • DB2 - Row level encryption – DB2 EDITPROC • Requires Security Analyst/System Programmer expertise: • Set up an encryption key token or tokens using z/OS Integrated Cryptographic Services Facility (ICSF) before this product can be utilized • Your Value: • Uses ANSI Data Encryption Algorithm (DEA) – the U.S. National Institute of Science and Technology (NIST) Data Encryption Standard • Complies with US privacy and security regulations • Health care – Health Insurance Portability and Accountability Act of 1996 • Financial services industry – Gramm-Leach-Bliley Act of 1999

  4. IMS Batch Backout Manager v1.1 5697-H75 • Automates the batch backout process after application abends • Functions: • Dynamically allocates an interim SLDS for Log close • Closes the interim batch SLDS • Dynamically allocates the new batch SLDS for backout • Performs the batch backout: • Forces allocation of batch SLDS for jobs with no logs allocated (by specific or generic job name) • Forces DBRC=Y (or DBRC=N) for IMS batch systems not generated with DBRC=FORCE • Your Value: • Reduce system downtime by automating manual backout tasks • Enhances database availability by minimizing downtime • More productive use of your DBA resources

  5. IMS Hardware Data Compression – Extended v2.2 5655-E02 • Productivity aid for implementing Hardware Assisted Data Compression • Functions: • Extends IMS basic HDC support with utilities that ease compression implementation and provide additional flexibility and function • Works on Image Copies, High Performance Unload files and IMS Unload files • Includes sample Compression Dictionaries • Enables effectiveness of existing dictionaries to be assessed • Allows monitoring of dictionary effectiveness over time • Builds DBD and Reload JCL • Your Value: • Reduces DASD requirements and I/O • Minimizes CPU overhead • Provides flexibility to implement compression tailored to your needs

  6. IMS MFS Reversal Utilities v1.1 5655-F45 • Converts MFS control blocks into MFS source and compares MFS libraries • Functions: • MFS Reversal Utility - converts MFS MID/MOD/DIF/DOF control blocks back into IMS MFS utility control statements. • Provides summary reports of the IMS FORMAT library, including the relationships among members • MFS Compare Utility - compares two sets of MFS source libraries to quickly highlight differences between them • Your Value: • Validation of what is operating in an IMS environment • Recreation of lost MFS source libraries

  7. IMS Program Restart Facility v2.1 5655-E14 • Restarts abended IMS batch jobs and enhances IMS Application Extended Checkpoint/Restart facilities • Functions: • Enables restart on any system in Sysplex without changes to JCL • Used to restart programs that do not abend but end with a non-zero return code • Can supply global parameters to all batch/BMP jobs (i.e.. without JCL changes) • Useful in a data sharing environment to provide JCL parameters • IRLM=, IRLMNM= • IMSGROUP=groupname + list of IMS ids in group • Automatically uses the correct restart checkpoint ID if using the IMS Extended Restart facility • Your Value: • Helps you avoid costly and time-consuming database recoveries with manual restarts • Reduces the overhead of applications that take too frequent checkpoints • Protects against starting an abended job with a valid but incorrect checkpoint ID

  8. IMS HALDB Conversion & Maintenance Aid v2.1 5655-K47 • Analyzes, models, and converts existing IMS databases to a HALDB format • Functions: • Conversion Capability • DEDB (without SDEP) to PHDAM • User partitioning to 1 HALDB partition • Initial HALDB Load Assistance • Support for PROCOPT=L Programs • Support Secondary index and logical relationships • Partition Maintenance Aid • Merge multiple partitions into one and divide one partition into multiple partitions • Clone partition definitions across RECONS and copy HALDB across RECONS • Your Value: • Guides DBAs thru HALDB conversion with minimal manual intervention • Reduces administrative costs • Take advantage of database capacity with less DBA effort More information

  9. IMS HALDB Conversion and Maintenance Aid • Unique in the marketplace • Supports Full Function DBs, DEDBs, User partition DBs • Productivity Aid for DBAs involved in HALDB conversion • Requires no HALDB experience and little IMS expertise • Makes conversion fool-proof and straight-forward • Conversion Aid • Utilities to assist in converting IMS DBs to HALDBs • Easy-to-use ISPF front-end • Automatic DBD conversion • Partition modeling tool • Partition Maintenance Aid • Dividing partitions that are too big • Cloning partition definitions across RECONS • Copying HALDB across RECONS • Display DBRC Status • Status Code BA Aid • Wait before a status like "Partition Not Available" is sent to application • Initial HALDB Load Assistance High Availability Large Data Base (in base IMS product since IMS V7) the strategic data base type for IMS essential for customers with growth constrained DBs critical for customers to achieve their 24x7 availability goals BUT... nontrivial to implement ... ... especially for programmers setting up their own development/test environments

  10. Rules for DBD Conversion

  11. Rules for Partitioning

  12. Rules for Index Partitioning

  13. Rules for Partition and Dataset Names

  14. Rules for Space Allocation

  15. IMS Database Control Suite v3.2 5655-L08 • Serves as the focal point for all database maintenance operations • Functions: • Supports Full Function, HALDB, and Fast Path DBs • Exploits IMS Base Utilities and/or IMS HP Tools • Intuitive ISPF Front-end: • Integrates control of DBA activities • Backup and recover • Database reorganization • Space monitoring • Managing database and application descriptors (DBD, PSB) • Managing RECON data sets • Your Value: • Improved IMS administrator productivity • Ease-of-use with JCL steam re-use • Increased knowledge of database activities and performance with improved database reporting

  16. IMS Database Control Suite - Utility and IBM Tool Support • IMS Database Control Suite supports the following IMS base utilities: • HD Unload and Reload, Prefix Resolution, etc. • Image Copy, Image Copy 2 and Online Image Copy • DB Recovery utility • DEDB Initialization and all IMS online DEDB utilities • The product supports the following IBM Tools: • High Performance Image Copy (including DB recovery) • HP Unload and HP Load • IMS Parallel Reorganisation • High Performance Prefix Resolution • Index Builder • High Performance Pointer Checker • Database Recovery Facility • Fast Path Basic Tools • Library Integrity Utilities • ISPF links to the following IBM tools: • HALDB Conversion and Maintenance Aid • High Performance Change Accumulation • DB Repair Facility ISPF UI

  17. IMS Database Control Suite A common trend is that customers expectfewer peopleto managemore databaseswithbroader, but less deep skills • The IMS Data Base Control Suite is designed to address this problem - It increases the productivity of IMS DB personnel by allowing them to • Generate JCL for ad hoc or scheduled usage of IBM’s IMS tools and utilities • Perform online DB space management and exception reporting • Perform DBRC functions and exception reporting without knowledge of DBRC command syntax • For customers who are moving to a full DBRC-managed DB environment, DB Control Suite’s DBRC interface will significantly shorten the “learning curve”

  18. Migrating from DBCS v3.1 to DBCS v3.2 • Start DBCS v3.2 using the same high level qualifier for permanent data sets that you used for v3.1 • If this is the first time signing on, this panel will appear • Enter Y to migrate your data sets. A migration batch JCL will be generated. • Submit the job - v3.1 data will be migrated to new v3.2 tables (v3.1 tables will remain unchanged). DBCS will sign off. • Restart DBCS normally, the IDs that you used in v31. will be available in v3.2. An output report will list what data was moved.

  19. Option 1 - Set up environment Main Menu Option 1

  20. Set up panel Option 4

  21. Subtask 4 - Load DBDSGRPS from the Recon

  22. Option 2 – Run jobs Main Menu Option 2

  23. “Run Jobs” Options • Option 2 – Recover databases • Generate DB recovery job for any members of DBDSGRP • Generate index build job for selected secondary indexes • Option 1 – Backup databases • Generate image copy job for a DBDSGRP • Option 3 – Monitor/Reorganise databases in group • Generate space monitoring job • Generate HP Pointer Checker job • Generate DB Reorg job • Option 4 – Fast Path Support • Generate initialisation or online utility jobs for selected DEDBs and areas • Option 5 – DB Recovery Facility • Provides ISPF access to all batch functions of DRF Option 6 – shows all functions from options 1, 2, and 3

  24. Common Features of Running Jobs 1 After choosing the utility functional area, you will be asked to specify the DBDSGRP 2 Selection panels provide a “F string” facility 3 Three choices for JOBNAME for the generated job. e.g. COOPEARx, A004xxx, or anyname

  25. A standard image copy will be offered. Use High Performance Image Copy tool if available IMS Image Copy 2 will always be offered Supports IMS V8 parallel IC facility If the DBDSGRP has been defined with an OIC PSBname, OIC will also be offered Job List 1 - Backup databases

  26. Job List 2 - Recovery databases A standard recovery will be offered. If IC2 was used for the backup, then the IMS base recovery utility will use it automatically If HP Image Copy is defined, then the HPIC Recovery utility will also be offered If IMS Index Builder is defined, there will be an option to rebuild selected indexes with IIB DFSPREC0 will be offered for HALDB primary index and ILDS recovery Note: IMS Database Recovery Facility tool is offered via “Run Jobs” Menu Option 5

  27. Timestamp Recovery

  28. Options 1, 2 and 3 relate to DB Control Suite’s space monitoring function Requires High Performance Pointer Checker be installed Option 4 is used to access HP Pointer Checker DB Reorganisation Job List 3 – Monitoring/Reorganize databases

  29. Database Control Suite’s Space Monitoring Facility • DB Control Suite includes a DBDS space monitor function • Runs as a batch job, but can process Online databases • Reports on exceptions to key user-specified thresholds • Number of extents, percentage of free space, number of CI splits, etc. • Gathers data in a History file • Same history file as used by HP Pointer Checker! • Can display the key data from the history file for selected datasets and optionally browse the space monitor report

  30. Subtask 4 - More Monitor related jobs • HP Pointer Checker will be offered (if available) • Multiple Reorg options will be offered • Just a reorg ((will use HP Unload/HP Load if available) • Reorg followed by image copies • Reorg preceded and followed by image copies • IMS Parallel Reorg tool will also be offered if available • With same image copy options

  31. Backup and Recovery is handled the same as for full function DBs Pointer Checking and Offline Reorg will be offered if the FP Basic Tools are available Additionally, DB Control Suite provides access to the Area Initialization Utility (DBFUNIN0) and the five Online Fast Path Utilities (“Run Jobs” option 4) Subsequent panels allow you to enter input parameters. For example - Job List 4 - Fast Path support

  32. Job List 5 – Database Recovery Facility • Using IMS Database Recovery Facility • Replaced Online Recovery Service (ORS) tool • Highest performance by recovering multiple DBDSs in parallel • Provides time-stamp recovery (as for base IMS) and ‘Point in Time’(PITR)” recovery (for recovery to “any time”)

  33. You select object-type to be recovered • DBDS, DB, or a DBRC group • Then specify name and time-stamp recovery information Using IMS Database Recovery Facility …

  34. Option 3 - Maintain RECON Main Menu Option 3

  35. DBRC User Interface • On the RECON Group Selection panel, you can choose a DBDSGRP or specify a DBDname • To get unfiltered access, enter DBDname of “ALLDBDS”

  36. DBRC User Interface Global commands were added for CHANGE ADS, DBDS, DB, IC, PART and Notify IC and ALLOC

  37. You can also access DBRC directly from the “select a control suite” panel DBRC Fast Access DBRC Fast Access is available even when no DBDSGRPs have been defined to Control Suite

  38. DBRC User Interface … Note: all DBDSGRPs are listed, not just the current Control Suite group For a DBRC function, either select it (S), or specify ‘H’ to get a detailed explanation

  39. DBRC Updates • Updating RECON records is equally easy • e.g. to set off a DBDS Recovery Needed flag A log is maintained of all your DBRC activity • Browse it with ISPF • Delete old data with a standard DBCS DBRC Utility job

  40. DBRC Exceptions Report Result of “F UTIL”

  41. PF1 Help Facilities • Almost every DBCS screen offers general help and field level help • Put cursor on field and hit PF1 • Especially useful on DBRC screens, where there are many fields that can be entered

  42. Option 4 - Perform library integrity checking Main Menu Option 4

  43. Library Integrity Checking • Library Integrity Utilities • DB Control Suite includes a full ISPF interface into the IMS Library Integrity Utilities (LIU) tool Full online access to all DBD and ACB management functions

  44. Option 5 – ISPF links to other IMS tools Main Menu Option 5

  45. Links to Other Tools • Three other ISPF-based IMS tools can be accessed from DB Control Suite

  46. Option 6 - System administration Main Menu Option 6

  47. Subtask 1 Backup table data set • All information about your DB control suite and its DBDSGRPs is stored in your IDLTABL data set • As always, it is advisable to maintain regular backups Subtask 1

  48. Subtask 3 - Diagnosis

  49. Function 3 – Tool Library APAR Information The Load Module APAR Status Report shows the module name, alias name, CSECT name, APAR number, and APAR fix date.

  50. Support for capturing trace info for error diagnosis • At the Primary Panel, IDLP92: • Type in uppercase: VPUT DEBUG2 Y SHARED • Type in uppercase: VPUT DEBUG2 Y SHARED / *This outputs into tracer data set */ Hit ENTER • Type in uppercase: VPUT DEBUG MODULENAME SHARED Hit ENTER • Type in uppercase: VPUT DEBUG MODULENAME SHARED /* modulename = exec you want traced */ Hit ENTER • Then run the part of the program you want traced and exit from DBCS • 2. On Exit, you will be shown USERID.TRACER which contains the trace.

More Related