Les Nouveautés des Outils IMS Décembre 2007

IMS Tools - Les Nouveautés 2H2007

[email protected] 1

© 2007 IBM Corporation

IBM Software Group

Les Nouveautés des Outils IMSDécembre 2007

Hélène LyonSouth-Europe IMS Technical [email protected]


IBM Software Group

DB2 and IMS Tools

2000: Reduce your TCO

2007: Reduce your TCOIncrease your value

2004 Autonomic Computing and End to End Monitoring

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 and databases

2003: Integration of products, new capabilities, better performance

2001-2002 Product replacements

2003-Day 1 Support


[email protected] 2


IBM Software Group

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

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

Performance Management� IMS Buffer Pool Analyzer� IMS Performance Analyzer � IMS Problem Investigator�Tivoli OMEGAMON XE for IMS

for z/OS� IMS Network Compression

Facility

Application Management� IMS Connect Extension� IMS MFS Reversal Utilities� IMS Batch Terminal Simulator� IMS Batch Backout Manager� IMS Program Restart Facility

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

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

IMS Tools Product Portfolio

Data Gouvernance� IMS Audit Management Expert � IBM Data Encryption for IMS and DB2

Databases


IBM Software Group

IMS Tools - Delivering Customer Value

� 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 Sysplex Manager


� IBM Data Encryption for IMS and DB2 Databases

� IBM Tivoli OMEGAMON XE for IMS on z/OS

� IMS Database Control Suite



� 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 Tools

� IMS Audit Management Expert


� IMS Command Control Facility

� IMS Database Recovery Facility

� IMS HP Change Accumulation


� 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

2004

2005

2006

2007

� New Tools

� IMS Tools Knowledge Base

� IMS Recovery Expert


� IMS HALDB Conversion and Maintenance Aid

� IMS HP Change Accumulation


� IMS HP Unload

� IMS Queue Control Facility

� IMS Workload Router

� IMS Buffer Pool Analyzer


� IMS Index Builder

Continued focus on lowering

customer’s TCO and providing

greater autonomic computing!!


[email protected] 3


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

ReorganizationsImage CopiesRecovery

� Converting to and managing HALDBs

� Complying with regulations and auditing requirements

� IMS Knowledge Base

� Future Autonomic directions


IBM Software Group

IMS SysplexManager

IMS Buffer Pool Analyzer

OMEGAMON XE for IMS

IMS Performance Analyzer

Analyze

Tune and Control

Monitor

DB System

Applications

Network

IMS Problem Investigator

IMS Connect Extensions

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.


[email protected] 4


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

� 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

� Exceptions & Alerts

� Integrated alert/automation in the TEP

� 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

� XE Snapshot Historical

� Snapshot historical stored in the Tivoli Data Warehouse


IBM Software Group

Monitor And Analyze IMS Subsystem Performance

Use OMEGAMON XE for IMS and the TEP to monitor critical IMS resources

Click to navigate to various IMS resource displays


[email protected] 5


IBM Software Group

IMS Performance Analyzer

� A comprehensive batch performance monitor to analyz e, 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

NewIntegration


IBM Software Group

IPIRSMNU Report Set - TRFDFLT Line 1 of 12Command ===> Scroll ===> PAGE

Description . . . OMEGAMON TRF Basics

Enter "/" to select action.

** Reports ** Active - Options Yes

TRF Global Yes- Database Usage Reports Yes

DLI Call List NoDLI Call Summary NoDB2 Call List YesDB2 Call Summary Yes

- Message Queue Reports (Form-based) YesList NoSummary Yes

- Trace Reports YesRecord Trace Yes

** End of Reports **

IMS PA - Provide insight into TRF Extractor records for BMP, DBD, DB2, DLI, FP

TRF Report Set

This report, in List and Summary forms, provides statistics on calls to DB2 subsystems

OMEGAMON TRF DB2 Call Summary _____________________________

Extractor output from 23May2007 10.40.50.8 to 23May2007 10.41.42.9 Page 2 Call Total Average Minimum Maximum Calls per Calls per

Trancode Count Elapsed Elapsed Elapsed Elapsed second minute ________ ________ ________ ________ ________ ________ __________ __________ DSN8CS 23 0.389624 0.016940 0.000105 0.164244 0.44 26.48

DSN8PS 22 0.107009 0.004864 0.000104 0.039592 0.42 25.33

Total 45 0.496633 0.011036 0.000104 0.164244 0.86 51.82

IMS Performance Analyzer 4.1

OMEGAMON TRF DB2 Call List __________________________

Extractor output from 23May2007 10.40.50.8 Page 1DB2 Call Total Average Minimum Maximum Recovery

Time Trancode Program PST SSID Count Elapsed Elapsed Elapsed Elapsed Token __________ ________ ________ ___ ____ ________ ________ ________ ________ ________ _____________ 10.40.50.8 DSN8CS DSN8IC0 2 DB2P 21 0.371054 0.017669 0.000105 0.164244 I9DE/00000004 10.41.21.2 DSN8CS DSN8IC0 2 DB2P 2 0.018570 0.009285 0.000683 0.017887 I9DE/00000006 10.41.42.9 DSN8PS DSN8IP0 2 DB2P 22 0.107009 0.004864 0.000104 0.039592 I9DE/00000008


[email protected] 6


IBM Software Group

IMS Performance Analyzer 4.1 Transaction Resource Usage

________________________________ SUMM0001 Printed at 15:57:27 20Jul2007 Data from 14.12.04 22May2007 to 12.02.16 23May2007 Page 3

Avg Avg Avg Avg 90% 90% 90% 90% Avg Tran InputQ Process OutputQ Total InputQ Process OutputQ Total CPU

Trancode Count Time Time Time IMS Time Time Time Time IMS Time Time - 4 0 36750559 0 36750559 0 72978168 0 72978168 9 CEXSCONV 8 57 22 0 79 172 36 0 204 0 CEXSNONC 1 147 17126 0 17273 147 17126 0 17273 0 CEXTCONV 10 4129 327 0 4456 20599 1543 0 20851 0 CEXTNONC 7 621359 298 0 621657 2119486 1286 0 2119548 0 DSN8CS 2 11 637 0 648 13 925 0 938 26 DSN8PP 18 9 372 0 381 11 595 0 602 0 DSN8PS 18 9 353 0 362 12 505 0 516 1 DSN8PT 15 8 272 0 280 10 367 0 376 0 IVTCV 13 17 266 0 283 62 377 0 408 0 IVTNO 13 14 60 0 74 56 265 0 320 0 IVTNV 11 9 13 0 22 16 37 0 51 0 Total 156 28156 942613 0 970770 366154 11500400 0 11529808 1

Record trace reports format input records for human analysis

Extractor output from 22May2007 14.12.04.2 Page 4 ---- Time ----- Ty hh.mm.ss.thmiju Trancode pe _______________ ________ __ 14.12.04.200000 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 -Class - PST Id 1CPU time 0.018767 SRB time 0.003207Private storage below 16M 65,536 Private storage above 16M 102,400Input message length 0 Output message length 0Input queue time 0.000000 Program input queue time 0.0Processing time 7.47E+02 Internal application response time 0.000000Output queue time 0.000000 Total response time 0.000000Pseudo-Abend/SCC/User-Abend ( / / ) VTAM input node BALG Q-count at syncpoint 0 BALG Q-time 0.000000Time of input msg on EMHQ 0.000000 Time of output msg on EMHQ 0.000000VSO reads from dataspace 0 VSO reads from DASD to dataspace 0VSO updates to dataspace 0 01 UTC -08 UTC 2007-05-22 14.12.04.226068 07 UTC 2007-05-23 10.28.13.970291Input queue time 1 0.000000 Input queue time 2 0.000000Program execution time 7.29E+04 CQS output time 0.000000 Local output queue time 0.000000Output queue time 0.000000 SMF system id FTS1 Recovery token (IMSID/OASN) I9DE/00000001Alternate CQS output time 0.000000 Alternate local output Q time 0.000000Output messages back to in dest 0

IMS PA TRF Reports continued

Message Queue Report Summary by trancode


IBM Software Group

IMS Problem Investigator

� IMS Problem Investigator is an IMS TM and DB log analy sis tool

� It helps you solves complex, time-consuming problem s 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

� It can analyze the events collected by IMS Connect Ex tensions inconjunction with records in IMS OLDS and SLDS log data sets

� Combined graphic analysis gives an end-to-end pictu re of transactions

� View the message flow of the transaction

NewIntegration


[email protected] 7


IBM Software Group

Start of Connect transaction

Start of IMStransaction

Connectresumes

Connect transaction ends after 0.278 seconds

IMS Problem Investigator …


IBM Software Group

File Menu Edit Mode Navigate Filter Time Lab els 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.THMIJUCode Description Date 2007-04-18 We dnesday LSN

/ ---- -------------------------------------------- --------------------------__ B001 Resource Trace Region=0001 0000000000001422S_ B021 DLI Database Trace Database=DI21PART Func=GH U 0000000000001444__ B021 DLI Database Trace Database=DI21PART Func=R EPL 0000000000001446__ B021 DLI Database Trace Database=DI21PART Func=G HU 0000000000001447__ B021 DLI Database Trace Database=DI21PART Func=D LET 000000000000144A__ B021 DLI Database Trace Database=DI21PART Func=I SRT 000000000000144D

File Menu Format Help --------------------------------------------------- -------------------BROWSE IPI000.QADATA.TCOMG007.I9DE.OMGLOG Re cord 00002314 Line 00000000 Command ===> ______________________________________ __________ Scroll ===> PAGEForm ===> + 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 . . . 0 9.40.46.026537.703

+0000 OMLDRECLL . . . . . . . . . . 0074 +0002 OMLDRECZZ . . . . . . . . . . 0000 +0004 OMLDRECID . . . . . . . . . . B0 OMLDSUBID .......... 21+0006 OMLDFLAG1 . . . . . . . . . . 00 OMLDFLAG2 .......... 00+0008 OMLDRSV . . . . 0000000000000000000000000000 000000000000 +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 . . . . . . . . . . C9F9C4C5404040 400000000B00000000 +0062 OMLDEPCBT . . . . . . . . . . 00 ************************************ End of data ** **************************

IMS PI Processing TRF Collector records in IMS log files

Press F4 to switch to DUMP format

Enter line action “S” to format a particular record

Use F10/F11 to scroll left/right to view compact or expanded details, by time or by LSN


[email protected] 8


IBM Software Group

IMS Connect Extensions

� Enhances IMS Connect performance, availability & secu rity

� Enhances IMS Connect availability with dynamic worklo ad management� Management of customer user exits and control of input message traffic

� Improves system security with flexible access contr ol

� 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

� Provides instrumentation and performance reporting f or 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

Unique Feature


IBM Software Group

IMS Buffer Pool Analyzer

� Analytic capabilities to help improve IMS buffer poo l utilization

� 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 appli cation performance

R2 in 12/2007


[email protected] 9


IBM Software Group

IMS Sysplex Manager

� Management of IMS in a Sysplex/IMSPlex is operation ally 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


IBM Software Group

IMS HALDB Conversion and Maintenance Aid

� Single-step conversion to a HALDB in real time

� 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 user-partitioned 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.

V3 in 03/2007


[email protected] 10


IBM Software Group

Risk Management

Identifying, measuring,

reporting and choosing how to manage risks to those objectives

Compliance

Executing objectives with

integrity and confidence

Governance

Setting objectives and knowing

whether or not they have been

achieved


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$$$




IBM Software Group

•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

The Requirements of Regulatory Compliance

� People : Professionals with regulatory experience will be hired to enable firms to meet and anticipate new re gulatory requirements

� Process : More robust processes and procedures will enable top management to monitor and enhance regulatory compliance

� Technology : Significant investment will be made. The following are critical for your DB2 and IMS systems :

. . . which drive investment in several areas

Regulators have multiple goals. . .

� Improved risk management across the enterprise

� Integrity of financial reporting processes and related business practices

�Customer information security

Anti-Money Laundering

Gramm-Leach Bliley

Department of Defense -5015.2

SEC Rule 17A-4

Corporate Information Security Accountability Act of 2003

California Bill 1386

Patriot Act HIPAA

Sarbanes Oxley

Basel II


IBM Software Group

Enterprise Data Governance

The top challenge The top challenge for 43% of CFOsfor 43% of CFOs

is improving is improving governance, governance,

controls, and risk controls, and risk managementmanagement

CFO Survey: Current state & future direction,

IBM Business Consulting Services

� Optim Test Data Management

� IBM Data Encryption for IMS and DB2

�Data Server access control

� Optim for Custom Applications� Optim for Siebel� Optim for JD Edwards� Optim for Peoplesoft� Optim for Oracle E-Business� Optim for Amdocs

AuditAuditSecuritySecurity RetentionRetentionPrivacyPrivacy

Enterprise Data GovernanceEnterprise Data Governance

� DB2 and IMS Audit Mgmt. Expert� Consul Insight & zSecure




IBM Software Group

IBM Data Encryption for IMS and DB2 Databases

� Segment level encryption

� Supports all levels of IMS – with no application chang es 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 compres sion


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?




IBM Software Group

IMS Audit Management Expert

� Assists a company comply with regulations

� Companion to DB2 Audit Management Expert

� 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

� 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®.

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.

V2 in 12/2007


IBM Software Group

IMS Audit Management Expert …

There is one agent per IMS

system

Audit

Repository

DB2Subsystem

IMS Audit Management

Expert SERVER

IMS Audit Management

Expert AGENT

z/OS

IMS LOG

SMF LOG

IMS Audit Management Expert

Reporting GUI

IMS Audit Management ExpertAdministrator GUI

Monitored

DatabaseMonitored

DatabaseMonitored

Databases




IBM Software Group

IMS Audit Management Expert - Reporting Facilities

�Robust reporting options enable auditors to view an d report on data in a variety of ways

� Auditors can view audit data from several perspecti ves:

�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 fu rther investigation

� Batch Reporting

IMS Audit Management Expert helps auditors answer questions like :

�Who updated the PAYROLL database on IMS3 in the last week?


IBM Software Group

IMS Audit Management Expert - Reporting Facilities




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


IBM Software Group

Autonomics increases the value of IMS to the enterprise

� Ensures customers get the best value from IMS by perf orming 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 techno logies that facilitate emerging business needs

� TM Resource adapter, DLIModel utility, JDBC Connector, MFS Web support, SOAP Gateway, XML DB




IBM Software Group

IMS Autonomic Tools Strategy

� Phase 1 – Output Repository

� Phase 2 – Conditional Execution

� Phase 3 – Passive Autonomics

� Phase 4 – Active Autonomics

Problem determination

Problem avoidance

Problem prediction

4

3

2

1 �


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 databasesAutomatic scheduling and management of corrective actions




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

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!

V1 in 6/2007


IBM Software Group

SERVER: PRODITKB Primary Option Men u ITKB V.R.MM

Administration Help

Select an option or press End to exit.

*Knowledge Base Server Name . . .:________Recon ID . . . . . . . . . . . :________

Display Database Report Output1. List of Databases with Reports2. List of DDnames with Reports3. List of Report Jobs4. List of Reports Titles5. List of Products6 List My Reports . . . ________7. List Reports using Selection Criteria8 List of recently viewed Reports9. Display list of all Reports Available

Select an option or press End to exit.

*Knowledge Base Server Name . . .:________Recon ID . . . . . . . . . . . :________

Display Database Report Output1. List of Databases with Reports2. List of DDnames with Reports3. List of Report Jobs4. List of Reports Titles5. List of Products6 List My Reports . . . ________7. List Reports using Selection Criteria8 List of recently viewed Reports9. Display list of all Reports Available




IBM Software Group

SERVER: PRODITKB Report Selection Cri teria ITKB V.R.MM

Help

Type criteria for reports, then press Enter to see selected reports or press End to exit.

Commands: SAVE setname, RETRIEVE setname , CLEAR

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 ID . . . . . . ________ Z/OS SYSID . . . . _____ ___Job Name . . . . . ________ Step Name . . . . . _____ ___Job Number . . . . ________

Date and Time Range _ (J ob , S tep, R eport)Start Date . . . . __________ Time . . __________ End Date . . . . .__________ Time . . __________

History . . . . . . _ (Y/N)

Type criteria for reports, then press Enter to see selected reports or press End to exit.

Commands: SAVE setname, RETRIEVE setname , CLEAR

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 ID . . . . . . ________ Z/OS SYSID . . . . _____ ___Job Name . . . . . ________ Step Name . . . . . _____ ___Job Number . . . . ________

Date and Time Range _ (J ob , S tep, R eport)Start Date . . . . __________ Time . . __________ End Date . . . . .__________ Time . . __________

History . . . . . . _ (Y/N)

User defined search criteria with the ability

to save filters…“My Boss’ Report”


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.

2007

2008

2009

2007

2008

2009

• Report Output Repository

•Sensor data•Environmental data•Options

• Policies- Options- Requirements

• Decision Making

• Proactive Systems Management

• Resource analysis to avoid problems




IBM Software Group

IMS Recovery Expert (IMS RE) Version 1

� 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

� Requires the use of� IMS Tools Knowledge Base (ITKB)

� IMS Tools Online System Interface (TOSI)

� IMS Tools Generic Partner Exit (GPR)

V1 in 12/2007

6 separate featuresRecovery 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 additionRECON Copy (RECONCOPY)Database List (DBLIST)


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




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

� 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

1 / 4


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

� 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 reorganizationSystem (IMSid)

2 / 4




IBM Software Group


� 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

� 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 classNone

3 / 4


IBM Software Group


� 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

� 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

4 / 4




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


IBM Software Group

Documents

Les Nouveautés des Outils IMS Décembre 2007