Hide Notes 

Slide 1: IMS Tools - Les Nouveautés 2H2007 IBM Software Group Les Nouveautés des Outils IMS Décembre 2007 Hélène Lyon South-Europe IMS Technical Leader helene.lyon@fr.ibm.com © 2007 IBM Corporation IBM Software Group DB2 and IMS Tools Reducing TCO is our first focus Provide autonomic features to add capability and simplify operations Avoid tedious tasks and reduce errors Preserve your investment in z/OS applications 2004 Autonomic Computing and databases and End to End Monitoring 2000: Reduce your TCO 2007: Reduce your TCO Increase your value 2003: Integration of products, new capabilities, better performance 2001-2002 Product replacements 2003Day 1 Support © 2007 IBM Corporation helene.lyon@fr.ibm.com 1
Slide 2: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Tools Product Portfolio Database Administration IMS Library Integrity Utilities IMS HALDB Conversion and Maintenance Aid IMS Sequential Randomizer Generator IMS HD Compression- Extended IMS Database Repair Facility IMS Tools Knowledge Base Performance Management IMS Buffer Pool Analyzer IMS Performance Analyzer IMS Problem Investigator Tivoli OMEGAMON XE for IMS for z/OS IMS Network Compression Facility Data Gouvernance IMS Audit Management Expert IBM Data Encryption for IMS and DB2 Databases Application Management IMS Connect Extension IMS MFS Reversal Utilities IMS Batch Terminal Simulator IMS Batch Backout Manager IMS Program Restart Facility Recovery Management IMS DEDB Fast Recovery IMS HP Image Copy IMS HP Change Accumulation IBM Application Recovery Tool for IMS and DB2 Databases IMS Database Recovery Facility IMS Recovery Expert Utilities Management Full Function Databases IMS HP Unload IMS HP Load IMS Index Builder IMS HP Prefix Resolution IMS Parallel Reorg IMS HP Pointer Checker IMS Online Reorg Facility Fast Path Databases IMS HP Fast Path Utilities Administration IMS Database Control Suite TM/Online System Management IMS ETO Support IMS Queue Control Facility IMS Parameter Manager IMS HP Sysgen Tool IMS Command Control Facility IMS Workload Router IMS Sysplex Manager © 2007 IBM Corporation Information Integration IMS DataPropagator Websphere Classic Replication Server for z/OS Websphere Classic Federation Server for z/OS Websphere Classic Data Event Publisher for z/OS IBM Software Group IMS Tools - Delivering Customer Value 2007 2006 2005 2004 New Tools IMS Connect Extensions IMS Online Reorganization Facility IMS Parameter Manager New Releases/New Function IMS Connect IMS Database Repair Facility IMS HP Fast Path Utilities IMS HP Image Copy IMS HP Load IMS Prefix Resolution IMS Parallel Reorganization IMS Performance Analyzer IMS Queue Control Facility IMS Workload Router New Tools IMS Tools Knowledge Base IMS Recovery Expert New Releases/New Function IMS HALDB Conversion and Maintenance Aid IMS HP Change Accumulation IMS Connect Extensions IMS HP Unload IMS Queue Control Facility IMS Workload Router IMS Buffer Pool Analyzer IMS HP Fast Path Utilities IMS Index Builder New Tools IMS Audit Management Expert New Tools IMS Sysplex Manager New Releases/New Function IBM Data Encryption for IMS and DB2 Databases IBM Tivoli OMEGAMON XE for IMS on z/OS IMS Database Control Suite IMS Connect Extensions IMS HP Fast Path Utilities IMS HP Image Copy IMS HP Sysgen Tools IMS Problem Investigator WebSphere II Classic Event Publisher for IMS WebSphere II Classic Event Publisher for VSAM WebSphere II Classic Federation for z/OS New Releases/New Function IMS Command Control Facility IMS Database Recovery Facility IMS HP Change Accumulation IMS HP Fast Path Utilities IMS HP Pointer Checker IMS HP Sysgen Tools IMS Online Reorganization Facility IMS Parallel Reorganization IMS Performance Analyzer IMS Problem Investigator IMS Sysplex Manager Tivoli OMEGAMON XE for IMS on z/OS WebSphere Classic Data Event Publisher for z/OS WebSphere Classic Federation Server for z/OS WebSphere Classic Replication Server for z/OS Continued focus on lowering customer’s TCO and providing greater autonomic computing!! © 2007 IBM Corporation helene.lyon@fr.ibm.com 2
Slide 3: IMS Tools - Les Nouveautés 2H2007 IBM Software Group Lowering TCO DBA Time = Money Reduce cost by optimizing IMS performance Is Performance Tuning a Luxury or a Necessity? Lowering the cost of Reorganizations Image Copies Recovery Converting to and managing HALDBs Complying with regulations and auditing requirements IMS Knowledge Base Future Autonomic directions © 2007 IBM Corporation IBM Software Group IMS Performance Management Tools Tools to monitor and tune IMS systems and applications to obtain optimal performance and lowest cost IMS is at the heart of the enterprise. Consequently, when a performance issue occurs often the tendency is to blame….. IMS. IMS Connect Extensions IMS Sysplex Manager Monitor OMEGAMON XE for IMS IMS Buffer Pool Analyzer Analyze DB System Tune and Control Applications Network IMS Performance Analyzer IMS Problem Investigator © 2007 IBM Corporation helene.lyon@fr.ibm.com 3
Slide 4: IMS Tools - Les Nouveautés 2H2007 IBM Software Group OMEGAMON XE For IMS on z/OS V4.1 Real Time Monitor Subsystems, regions, resources, pools, DBs, Fast path IMS Connect, OTMA Historical analysis of transaction response Bottlenecks and IMS resources Transaction Reporting Facility (TRF) Detailed transaction & database data – individual transactions Suitable for performance analysis & chargeback Data retrieved from IMS log Response Time Analysis (RTA) Transaction Response time by user defined groups Bottleneck Analysis Workload performance and task analysis Operator Assist & Integrated Console Facility IMS resource commands XE Snapshot Historical Snapshot historical stored in the Tivoli Data Warehouse Exceptions & Alerts Integrated alert/automation in the TEP © 2007 IBM Corporation IBM Software Group Monitor And Analyze IMS Subsystem Performance Click to navigate to various IMS resource displays Use OMEGAMON XE for IMS and the TEP to monitor critical IMS resources © 2007 IBM Corporation helene.lyon@fr.ibm.com 4
Slide 5: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Performance Analyzer A comprehensive batch performance monitor to analyze, report on, and thereby improve your IMS Performance Information on IMS system performance for Tuning Capacity Planning Management Reporting Reporting on IMS through ISPF dialog or batch commands Support for IMS versions 8, 9, and 10 Shared Queue support - merges logs to produce end to end transaction response times Fast Path reporting for log and monitor Combined TCP/IP + IMS reporting with IMS Connect Extensions IMS PA V4.1 reports from TRF Extractor output records with APAR PK43823 Integration New © 2007 IBM Corporation IBM Software Group IMS PA - Provide insight into TRF Extractor records for BMP, DBD, DB2, DLI, FP IPIRSMNU Command ===> Report Set - TRFDFLT Line 1 of 12 Scroll ===> PAGE Description . . . OMEGAMON TRF Basics Enter "/" to select action. ** Reports ** Options TRF Global Database Usage Reports DLI Call List DLI Call Summary DB2 Call List DB2 Call Summary Message Queue Reports (Form-based) List Summary Trace Reports Record Trace ** End of Reports ** Active Yes Yes Yes No No Yes Yes Yes No Yes Yes Yes - This report, in List and Summary forms, provides statistics on calls to DB2 subsystems TRF Report Set - - Time __________ 10.40.50.8 10.41.21.2 10.41.42.9 Trancode ________ DSN8CS DSN8CS DSN8PS Program ________ DSN8IC0 DSN8IC0 DSN8IP0 PST ___ 2 2 2 DB2 SSID ____ DB2P DB2P DB2P IMS Performance Analyzer 4.1 OMEGAMON TRF DB2 Call List __________________________ Extractor output from 23May2007 10.40.50.8 Call Total Average Minimum Maximum Count Elapsed Elapsed Elapsed Elapsed ________ ________ ________ ________ ________ 21 0.371054 0.017669 0.000105 0.164244 2 0.018570 0.009285 0.000683 0.017887 22 0.107009 0.004864 0.000104 0.039592 Page Recovery Token _____________ I9DE/00000004 I9DE/00000006 I9DE/00000008 1 Trancode ________ DSN8CS DSN8PS Total Call Count ________ 23 22 45 OMEGAMON TRF DB2 Call Summary _____________________________ Extractor output from 23May2007 10.40.50.8 to 23May2007 10.41.42.9 Total Average Minimum Maximum Calls per Calls per Elapsed Elapsed Elapsed Elapsed second minute ________ ________ ________ ________ __________ __________ 0.389624 0.016940 0.000105 0.164244 0.44 26.48 0.107009 0.496633 0.004864 0.011036 0.000104 0.000104 0.039592 0.164244 0.42 0.86 25.33 51.82 Page 2 © 2007 IBM Corporation helene.lyon@fr.ibm.com 5
Slide 6: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Performance Analyzer 4.1 Transaction Resource Usage ________________________________ Data from 14.12.04 22May2007 to 12.02.16 23May2007 90% 90% InputQ Process Time Time 0 72978168 172 36 147 17126 20599 1543 2119486 1286 13 925 11 595 12 505 10 367 62 377 56 265 16 37 366154 11500400 90% 90% OutputQ Total Time IMS Time 0 72978168 0 204 0 17273 0 20851 0 2119548 0 938 0 602 0 516 0 376 0 408 0 320 0 51 0 11529808 Avg CPU Time 9 0 0 0 0 26 0 1 0 0 0 0 1 IMS PA TRF Reports continued Page 3 SUMM0001 Printed at 15:57:27 20Jul2007 Avg Avg InputQ Process Time Time 0 36750559 57 22 147 17126 4129 327 621359 298 11 637 9 372 9 353 8 272 17 266 14 60 9 13 28156 942613 Trancode CEXSCONV CEXSNONC CEXTCONV CEXTNONC DSN8CS DSN8PP DSN8PS DSN8PT IVTCV IVTNO IVTNV Total Tran Count 4 8 1 10 7 2 18 18 15 13 13 11 156 Avg Avg OutputQ Total Time IMS Time 0 36750559 0 79 0 17273 0 4456 0 621657 0 648 0 381 0 362 0 280 0 283 0 74 0 22 0 970770 Message Queue Report Summary by trancode Record trace reports format input records for human analysis Page 4 Extractor output from 22May2007 14.12.04.2 ---- Time ----hh.mm.ss.thmiju _______________ 14.12.04.200000 Trancode ________ Ty pe __ 10 Transaction: message send/receive or program schedule/process/end Input LTERM Region type IFP Job name I9DEIFP1 Step name IFP PSB name DFSIVP4 Userid DFSIVP4 IMS name I9DE IMS version 1 Class PST Id CPU time 0.018767 SRB time 0.003207 Private storage below 16M 65,536 Private storage above 16M 102,400 Input message length 0 Output message length 0 Input queue time 0.000000 Program input queue time 0.0 Processing time 7.47E+02 Internal application response time 0.000000 Output queue time 0.000000 Total response time 0.000000 Pseudo-Abend/SCC/User-Abend ( / / ) VTAM input node 0.000000 BALG Q-count at syncpoint 0 BALG Q-time Time of input msg on EMHQ 0.000000 Time of output msg on EMHQ 0.000000 VSO reads from dataspace 0 VSO reads from DASD to dataspace 0 VSO updates to dataspace 0 01 UTC 08 UTC 2007-05-22 14.12.04.226068 07 UTC 2007-05-23 10.28.13.970291 Input queue time 1 0.000000 Input queue time 2 0.000000 Program execution time 7.29E+04 CQS output time 0.000000 Local output queue time 0.000000 Output queue time 0.000000 SMF system id FTS1 Recovery token (IMSID/OASN) I9DE/00000001 0.000000 Alternate CQS output time 0.000000 Alternate local output Q time © 2007 Output messages back to in dest 0 IBM Corporation IBM Software Group IMS Problem Investigator IMS Problem Investigator is an IMS TM and DB log analysis tool It helps you solves complex, time-consuming problems easily and inexpensively Analysis of IMS event data can help identify problematic applications and identify system performance issues Process OMEGAMON TRF records on the IMS log the same way as IMS system log records Integration New It can analyze the events collected by IMS Connect Extensions in conjunction with records in IMS OLDS and SLDS log data sets Combined graphic analysis gives an end-to-end picture of transactions View the message flow of the transaction © 2007 IBM Corporation helene.lyon@fr.ibm.com 6
Slide 7: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Problem Investigator … Start of Connect transaction Start of IMS transaction Connect resumes Connect transaction ends after 0.278 seconds © 2007 IBM Corporation IBM Software Group IMS PI Processing TRF Collector records in IMS log files Use F10/F11 to scroll left/right to view compact or expanded details, by time or by LSN File Menu Edit Mode Navigate Filter Time Labels Options Help -----------------------------------------------------------------------------BROWSE IPI000.QADATA.TCOMG007.I9DE.OMGLOG Record 00002280 More: < > Command ===> ________________________________________________ Scroll ===> PAGE Forwards / Backwards . . HH.MM.SS.THMIJU Time of Day . . 09.40.32.THMIJU Code Description Date 2007-04-18 Wednesday LSN / ---- ---------------------------------------------------------------------__ B001 Resource Trace Region=0001 0000000000001422 S_ B021 DLI Database Trace Database=DI21PART Func=GHU 0000000000001444 __ B021 DLI Database Trace Database=DI21PART Func=REPL 0000000000001446 __ B021 DLI Database Trace Database=DI21PART Func=GHU 0000000000001447 __ B021 DLI Database Trace Database=DI21PART Func=DLET 000000000000144A __ B021 DLI Database Trace Database=DI21PART Func=ISRT 000000000000144D Enter line action “S” to format a particular record File Menu Format Help ---------------------------------------------------------------------BROWSE IPI000.QADATA.TCOMG007.I9DE.OMGLOG Record 00002314 Line 00000000 Command ===> ________________________________________________ Scroll ===> PAGE Form ===> + Use Form in Filter Format ===> STD_ ********************************* Top of data ******************************** +0004 Code . . . B021 DLI Database Trace +0064 STCK . . . C076975928B29B42 LSN . . . . 0000000000001444 Date . . . 2007-04-18 Wednesday Time . . . 09.40.46.026537.703 +0000 OMLDRECLL . . . . . . . . . . 0074 +0002 OMLDRECZZ . . . . . . . . . . 0000 +0004 OMLDRECID . . . . . . . . . . B0 OMLDSUBID.......... 21 +0006 OMLDFLAG1 . . . . . . . . . . 00 OMLDFLAG2.......... 00 +0008 OMLDRSV . . . . 0000000000000000000000000000000000000000 +001C OMLDPSTNR . . . . . . . . . . 0001 +001E OMLDDBD . . . . 'DI21PART' OMLDCTIME . . . . . . . C076975928645402 +0030 OMLDRTIME . . . . . . C076975928AE9802 OMLDIO . . . . 00000000 +0040 OMLDFUNC . . . 'GHU ' OMLDRCODE . . . . . . . ' ' +001E OMLDLTERM . . . . . . . . . . 'DI21PART' +0046 OMLDUSID . . . 'FUNTRM65' +0052 OMLDRKTKN . . . . . . . . . . C9F9C4C5404040400000000B00000000 +0062 OMLDEPCBT . . . . . . . . . . 00 ************************************ End of data **************************** Press F4 to switch to DUMP format © 2007 IBM Corporation helene.lyon@fr.ibm.com 7
Slide 8: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Connect Extensions Enhances IMS Connect performance, availability & security Enhances IMS Connect availability with dynamic workload management Management of customer user exits and control of input message traffic Improves system security with flexible access control Event recording & performance monitoring features Examine the details and timing of internal IMS Connect events Collects performance and accounting information for IMS Connect IMS Connect internal and external transit times and latency times Exception reporting showing failures and timeouts Unique Feature Provides instrumentation and performance reporting for IMS Connect Creates detailed IMS Connect reports in conjunction with IMS Performance Analyzer Solves IMS Connect problems in conjunction with IMS Problem Investigator Displays IMS Connect activity and utilization in real time Enables reporting for Omegamon XE, IMS Performance Analyzer, and IMS Problem Investigator Integration © 2007 IBM Corporation IBM Software Group IMS Buffer Pool Analyzer Analytic capabilities to help improve IMS buffer pool utilization R2 in 12/2007 Determine if adding or subtracting buffers will improve the performance of a selected buffer pool Model buffer pool usage to determine I/O rates for various numbers of buffers in each pool Identify which databases most heavily use each database sub-pool Provide I/O rates and buffering requirements for a specific database to facilitate required buffer pool changes for database structure alterations Perform “what if” scenario analysis, including the impact of creating new buffer pools or changing the buffer size of a database. Visualize the impact of change—before it’s too late Benefits include also overall improvements to application performance © 2007 IBM Corporation helene.lyon@fr.ibm.com 8
Slide 9: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Sysplex Manager Management of IMS in a Sysplex/IMSPlex is operationally cumbersome and challenging for IMS customers. IMS Sysplex Manager is a tool designed to help you better control the IMS environment A simple to use TSO/ISPF interface to view the IMSPlex as a single system image with aggregated data elements Providing detailed information about key IMSPlex components: datasharing structure, shared message queue structures and content, RM structure and content, all related address spaces. Operational capabilities to make users more productive: IMS type 1 and 2 command capability, IMS system level command audit trail, detailed resource views such as trans, programs, databases, dependent regions with integrated group command capabilities for immediate user response. Ability to generate and collect diagnostics from all address spaces simultaneously. Functions that enhance the base capabilities of IMSPlex support: real-time RM structure content update, shared queues browse, delete, recover Functions to allow shared queue users to create affinities for one or more IMS systems to partition workload where necessary Functions to protect from system outages: shared message queue overflow protection Automatic long-lock notification to help prevent system bottlenecks Benefits include improvements to the operations of IMS in a Sysplex © 2007 IBM Corporation IBM Software Group IMS HALDB Conversion and Maintenance Aid Single-step conversion to a HALDB in real time V3 in 03/2007 Near-Real Time conversion (no extended outage for Gen and unload/reload activity) DBDLIB conversion - creates the JCL to convert entire database description (DBD) libraries Offline Reorganization of PSINDEX databases - used offline & includes index pointer healing Easier Maintenance Merge partitions that are too small – Divide partitions that are too big Merge HALDBs - merge identical HALDB databases and used to combine userpartitioned databases into one multipartition HALDB. Delete Partition - removes the PSINDEX records of the deleted partition. Add Partition using LOAD processing - improves performance as the PSINDEX records are sorted and inserted sequentially. © 2007 IBM Corporation helene.lyon@fr.ibm.com 9
Slide 10: IMS Tools - Les Nouveautés 2H2007 IBM Software Group Governance Setting objectives and knowing whether or not they have been achieved Risk Management Identifying, measuring, reporting and choosing how to manage risks to those objectives Compliance Executing objectives with integrity and confidence © 2007 IBM Corporation IBM Software Group Potential Costs of A Security Breach $Cost of research and recovery $Cost of notifying customers $Cost of lost customers / business $ Additional regulatory requirements and fines $Claims from trusted vendors and business partners $$$ DAMAGE TO THE BRAND © 2007 IBM Corporation helene.lyon@fr.ibm.com 10
Slide 11: IMS Tools - Les Nouveautés 2H2007 IBM Software Group The Requirements of Regulatory Compliance Regulators have multiple goals. . . Improved risk management across the enterprise Integrity of financial reporting processes and related business practices Customer information security . . . which drive investment in several areas People: Professionals with regulatory experience will be hired to enable firms to meet and anticipate new regulatory requirements Process: More robust processes and procedures will enable top management to monitor and enhance regulatory compliance Technology: Significant investment will be made. following are critical for your DB2 and IMS systems: The Patriot Act Anti-Money Laundering HIPAA SEC Rule 17A-4 Basel II Gramm-Leach Bliley •Encrypt sensitive data •Protect sensitive production data •Save data for future audits and to comply with retention rules •Auditability - discover who did what, where and when Corporate Information Security Accountability Act of 2003 California Bill 1386 Department of Defense 5015.2 Sarbanes Oxley © 2007 IBM Corporation IBM Software Group Enterprise Data Governance The top challenge for 43% of CFOs is improving governance, controls, and risk management Enterprise Data Governance Data Server access control Security CFO Survey: Privacy state & future direction, Retention Audit Current IBM Business Consulting Services DB2 and IMS Audit Mgmt. Expert Consul Insight & zSecure Optim Test Data Management IBM Data Encryption for IMS and DB2 Optim Optim Optim Optim Optim Optim for Custom Applications for Siebel for JD Edwards for Peoplesoft for Oracle E-Business for Amdocs © 2007 IBM Corporation helene.lyon@fr.ibm.com 11
Slide 12: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IBM Data Encryption for IMS and DB2 Databases Segment level encryption Supports all levels of IMS – with no application changes needed Exploits System z and S/390 Crypto Hardware features, which results in low overhead encryption/decryption Uses the ANSI Data Encryption Algorithm (DEA), also known as the U.S. National Institute of Science and Technology (NIST) Data Encryption Standard (DES) algorithm Supports both secure key and clear key encryption Compatible with IMS utilities and Tools Performance is similar to segment level data compression © 2007 IBM Corporation IBM Software Group Database Security The assertion Any business should know who is reading or changing their valuable information stored in their databases For the DBA Management says: “We have to audit access to tables with sensitive data, so get with the auditors and take care of it!” Now what ?? What audit information do we want? Where do we put it? How do we get reports from all of this data? What other sources of audit information is there? How do I set up enough reports to keep the Auditors busy? How much of my time will I have to spend with the Auditors? How do we get the Auditors to do this themselves? © 2007 IBM Corporation helene.lyon@fr.ibm.com 12
Slide 13: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Audit Management Expert Assists a company comply with regulations Companion to DB2 Audit Management Expert V2 in 12/2007 Collects and correlates IMS data access information From IMS logs Changes to databases User access to the IMS system via SIGNON PSB and database ‘change of state’ activity System STOP and START activity From SMF Access to database data sets and image copy data sets Into a central DB2 repository IMS does not log DB GET (reads) to databases! The total number of reads for all DB in application will be in the accounting record, but there is no record of read only. Auditors use a GUI Reporting interface Provides auditors with flexible options for examining the data in the audit repository Auditors do not need mainframe access Auditors can export audit data into other applications such as Excel®. © 2007 IBM Corporation IBM Software Group IMS Audit Management Expert … z/OS IMS Audit Management Expert SERVER Audit Repository DB2 Subsystem IMS Audit Management Expert Reporting GUI IMS Audit Management Expert AGENT IMS LOG SMF LOG Monitored Database Monitored Database Monitored Databases IMS Audit Management Expert Administrator GUI There is one agent per IMS system © 2007 IBM Corporation helene.lyon@fr.ibm.com 13
Slide 14: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Audit Management Expert - Reporting Facilities Robust reporting options enable auditors to view and report on data in a variety of ways Auditors can view audit data from several perspectives: Overview – View all of the subsystems currently being monitored Subsystem - View activity for a selected subsystem Detail - View details for a particular type of activity for a selected subsystem Graphical or Tabular Thresholds can be set to flag data that may need further investigation Batch Reporting IMS Audit Management Expert helps auditors answer questions like : Who updated the PAYROLL database on IMS3 in the last week? © 2007 IBM Corporation IBM Software Group IMS Audit Management Expert - Reporting Facilities © 2007 IBM Corporation helene.lyon@fr.ibm.com 14
Slide 15: IMS Tools - Les Nouveautés 2H2007 IBM Software Group Optim Enterprise Architecture Single, scalable, interoperable EDM solution provides a central point to deploy policies to extract, store, port, and protect application data records from creation to deletion © 2007 IBM Corporation IBM Software Group Autonomics increases the value of IMS to the enterprise Ensures customers get the best value from IMS by performing all the tasks needed for: Superior database performance On Demand Reorganization Superior transaction response time Optimize key databases Monitor and adjust performance for critical transactions High availability Prevents outages by anticipating problems Fast and assured recovery Manages recovery requirements ensuring image copies are timely and available Frees resources, allowing exploitation of IMS technologies that facilitate emerging business needs TM Resource adapter, DLIModel utility, JDBC Connector, MFS Web support, SOAP Gateway, XML DB © 2007 IBM Corporation helene.lyon@fr.ibm.com 15
Slide 16: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Autonomic Tools Strategy Problem determination Phase 1 – Output Repository 1 Phase 2 – Conditional Execution Problem prediction 2 Phase 3 – Passive Autonomics 3 Phase 4 – Active Autonomics Problem avoidance 4 © 2007 IBM Corporation IBM Software Group IMS Knowledge Base A platform to share information amongst tools Workbench transforms islands of data into an information resource Common report repository and viewing interface Imposed synergy A pathway to autonomics Smart products Requested actions are conditioned on customer defined requirements, i.e. policy driven Problem avoidance and Autonomics Automatic monitoring and analysis of application databases Automatic scheduling and management of corrective actions © 2007 IBM Corporation helene.lyon@fr.ibm.com 16
Slide 17: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Tools Knowledge Base V1 Enhancing the user experience with IMS Tools Single source Where is my report? Easy to use search capabilities Find, Filter, Time Ranges History for analysis V1 in 6/2007 What did Space Monitor report the last time I ran it against this database? Last month? Six months ago? History of actions Did I run Pointer Checker against this database recently? Did my co-worker? Was this database Reorganized last month? Turning islands of data into useful information! © 2007 IBM Corporation IBM Software Group Administration SERVER: PRODITKB Help Primary Option Menu ITKB V.R.MM Select an option or press End to exit. *Knowledge Base Server Name. . .:________ Recon ID . . . . . . . . . . . :________ Display Database Report Output 1. List of Databases with Reports 2. List of DDnames with Reports 3. List of Report Jobs 4. List of Reports Titles 5. List of Products 6 List My Reports . . . ________ 7. List Reports using Selection Criteria 8 List of recently viewed Reports 9. Display list of all Reports Available © 2007 IBM Corporation helene.lyon@fr.ibm.com 17
Slide 18: IMS Tools - Les Nouveautés 2H2007 IBM Software Group Help SERVER: PRODITKB Report Selection Criteria ITKB V.R.MM Type criteria for reports, then press Enter to see selected reports or press End to exit. Commands: SAVE setname, RETRIEVE setname, CLEAR ________ _________________________ ________ ________ ________ ________ ________ ________ _______________ ____________________________________________ ____________________________________________ ____________________________________________ ________ Z/OS SYSID . . . . ________ Step Name . . . . . ________ Recon ID . . . . . Recon1 Name . . . . IMS ID ..... Database DBD Name . Partition or Area . Database DD Name . DBRC Group Name . . ITKB Group Name . . Product Name(S) . . Product Name(L) . . Report Title(S) . . Report Title(L) . . Report Type . . . . User defined search criteria with the ability to save filters… “My Boss’ Report” User ID . . . . . . ________ Job Name . . . . . ________ Job Number . . . . ________ Date and Time Range _ (Job , Step, Report) Start Date . . . . __________ Time . . __________ End Date . . . . .__________ Time . . __________ History . . . . . . _ (Y/N) © 2007 IBM Corporation IBM Software Group Looking Forward – Autonomic Management of IMS The IMS Tools Knowledge Base is going to evolve from a pure report output repository in the beginning to a full autonomic solution in the end. 2008 2008 7 200 7 200 •Sensor data •Environmental data • Report Output •Options Repository • Policies 2009 2009 • Proactive Systems Management • Resource analysis to avoid problems - Options - Requirements • Decision Making © 2007 IBM Corporation helene.lyon@fr.ibm.com 18
Slide 19: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Recovery Expert (IMS RE) Version 1 V1 in 12/2007 A new MS Tools that provides features to ensure that the IMS database environment is recoverable Does not perform the actual database recovery IMS Database Recovery Facility (DRF) is the recommended tool for performing IMS database recoveries Provides six unique features Create clean recovery points Locate existing recovery points Identify problems which may affect recoveries Verify needed recovery assets Condition RECON data sets for disaster recovery Issue IMS commands via batch 6 separate features Recovery Point Creation (RPCR) Recovery Point Identification (RPID) Verify Recovery Assets (VERIFY) RECON Data Set Cleanup (RCU) IMS Command Interface (IMSCMD) Health Checker (HCHECK) And in addition RECON Copy (RECONCOPY) Database List (DBLIST) Requires the use of IMS Tools Knowledge Base (ITKB) IMS Tools Online System Interface (TOSI) IMS Tools Generic Partner Exit (GPR) © 2007 IBM Corporation IBM Software Group IMS Recovery Expert (IMS RE) Version 1 … Components IMS Recovery Expert Batch Job Job is control card driven to indicate which features are performed IMS Tools Knowledge Base Server (ITKBSRVR) ITKB is required! An ITKB server must be active in order for any IMS RE job to execute IMS Control Region (IMS CR) IMS RE has a presence in the IMS CR for pausing CICS/ODBA threads and is established via the IMS Partner Exit (DFSPPUE0) IMS RE also uses TOSI which also establishes a presence using DFSPPUE0 Batch Message Processing Region (BMP) IMS RE requires a presence in any BMPs for pausing them at checkpoint time when the Recovery Point Create (RPCR) feature is executing © 2007 IBM Corporation helene.lyon@fr.ibm.com 19
Slide 20: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Recovery Expert Supporting Features Recovery Point Creation (RPCR) Provide the ability to create recovery points for one or more databases The customer will have the option of having databases /DBR’d or /DBD’d Databases will be restarted only on those systems which they were started before the process Optionally provide a synchronized log switch across all IMS systems in the environment Feature uses the IMS Tools Online System Interface which provides synchronous /DBR and /DBD commands Provides IMS region controller (DFSRRC00) front-end for pausing BMPs at checkpoint. Also works with Program Restart Facility (PRF) for pausing BMPs at checkpoint, if present Provides CICS/ODBA intercept which will ‘pause’ APSB (allocate PSB) requests when needed 1/4 Recovery Point Identification (RPID) Interrogate information in the RECON to identify recovery points and/or recovery time spans to which one or more databases can be recovered Identifies recovery time spans individually and common to all databases specified Future enhancement: Will optionally read archived logs (SLDS) to identify points in which the database is allocated but no updates are being performed © 2007 IBM Corporation IBM Software Group IMS Recovery Expert Supporting Features Identification and Verification of Recovery Assets (VERIFY) Interrogate information in the RECON to identify the assets (logs, change accums, image copies, etc…) which are required to recover one or more databases Once identified, processing options allow for: Listing of recovery assets (default, always done) Verification that the recovery asset is cataloged Allocation and opening of the file to ensure data set is usable 2/4 RECON Data Set Cleanup (RCU) Required for disaster recovery environment At the disaster recovery site, the RECON data sets must be conditioned to match the recovery environment The following RECON records are affected: Data set allocation Log data sets PRILOG record Image copies (beyond the recovery timestamp) Change accumulation Database reorganization System (IMSid) © 2007 IBM Corporation helene.lyon@fr.ibm.com 20
Slide 21: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Recovery Expert Supporting Features Health Checker (HCHECK) Interrogate IMS database information looking for potential problems relating to the recoverability of the environment Utilize information from the RECON data sets and the catalog Currently includes a list of over 20 items that can be checked More items will be added based on customer requirements Future enhancement will save error conditions in the repository and autonomic processes will take action to correct the problems identified 3/4 IMS Command Interface (IMSCMD) Utilizes the IMS Tools Online System Interface to provide a batch IMS Command interface Allows any type-1 IMS command supported through an AO application Output from commands displayed in the report file Provides three levels of security: Same-as IMS Application class None © 2007 IBM Corporation IBM Software Group IMS Recovery Expert Supporting Features RECON Copy (RECONCOPY) This feature creates a copy of the live RECON data sets prior to the IMS RE feature executing The IMS RE feature will access the RECON copy data sets instead of the live RECON data sets This feature eliminates the impact of IMS RE processing on production workloads RECONCOPY is valid for all features except for RPCR and IMSCMD RECONCOPY is required for RCU RECON copies can be deleted at job step termination or left allocated and cataloged 4/4 Database List (DBLIST) Most IMS RE features require the customer to specify which databases, database data sets, areas and/or partitions are to be processed DBLIST allows the customer to specify one or more databases, database data sets, fast path areas, HALDB partitions, RECON DBDS groups, RECON Change Accumulation groups, or RECON Recovery groups IMS RE pre-processes the list by using the DBRC Application Programming Interface (DSPAPI) to access information in the RECON data sets DBLIST entries are validated, expanded and passed to other IMS RE features All entries in the DBLIST must be defined to the RECON data sets © 2007 IBM Corporation helene.lyon@fr.ibm.com 21
Slide 22: IMS Tools - Les Nouveautés 2H2007 IBM Software Group IMS Tools Summary Continue to add frequent value to all our products Investment is strong Continue to Integrate Solutions Proven record of delivering your requirements Day one support for new versions of IMS A future vision Focus on automation and autonomics Committed to your success We look forward to continuing our work with you © 2007 IBM Corporation IBM Software Group © 2007 IBM Corporation helene.lyon@fr.ibm.com 22