IBM Software Group

1. IBM Software Group DB2 Utilities Management-Part 2 David R. Schwartz dschwar@us.ibm.com

2. DB2 Tools Product Portfolio - Dec 2003 Application Management Database Administration • DB2 Bind Manager • DB2 Data Archive Expert • DB2 Path Checker • DB2 Table Editor • DB2 Test Database Generator • DB2 Web Query Tool • IMS and DB2 Encryption • Administration Tool • Object Compare Utilities • Utilities Suite • High Performance Unload • Automation Tool Performance Management Recovery • Performance Manager • Bufferpool Analyzer • Performance Expert • Query Monitor • SQL Performance Analyzer • IBM Application Recovery Tool for IMS and DB2 Databases • DB2 Archive Log Accelerator • DB2 Change Accumulation Tool • DB2 Log Analysis Tool • DB2 Object Restore Tool • Batch Thread Cancel Replication • Data Propagator • Replidata • DB2 II Classic Federation for z/OS

3. Object Management Ensure that the DB2 catalog contains correct information. Support DBA operations on one or many objects. DB2 Administration Tool DB2 Object Comparison • DB2 Administration Tool • Drill down catalog navigation • Migrate changes between systems • Alter multiple objects in one operation • Operate on single or multiple objects • Manage space of DB2 objects • DB2 Object Comparison Tool • Compare existing objects with definitions • Synchronize objects between systems

4. Tools designed for .... • DB2 Database Administrators • Create and manage objects • Manage authorizations to objects • Display tablespace and index status • Run utilities • Manage Change of DB2 structures • DB2 System Administrators • Display and manage Bufferpools • Display and update Zparm values • Display and manage threads, traces and logs • DB2 Application Developers • Display object definition • Manage plans and packages • Prototype SQL • Create test objects

5. DB2 Admin • Version 7 - GA July, 2005 • Satisfies over 40 customer requirements • Allow '*' or '%' for wild-carding • GRANT authorizations for a user or set of objects • New Primary Commands • BIND/REBIND • STA & STO • REVOKE • MIG • Eliminate small objects from performance queries • FIND capability on table display • New DSP command to show dependent plans/packages • New DSN line command to show data set names • Show SQL statement from Explain panels • Control of MODIFY in image copy jobs • Change Database/Tablespace in ALC • etc.

6. DB2 Object Compare • Version 7 - GA in July, 2005 • Drop with Recover • Summary report improvements • Allow utility options • Amend LOAD card statement • Definition of target from source specification • Batch interface enhancements • Escalate to tablespace for partitioned tables • Support for more ALTER statements

7. New Change Management • Statement of direction in June Announce • Changes are logged - audit of changes possible • Changes can be built and deployed later • Virtual changes can be built on top of changes not yet deployed • Changes can be promoted the next level • Meta data now stored in DB2 • Versions • Masks • Ignores • Compare will be able to generate target version files automatically

8. Utility Management Manage DB2 systems with high performance utilities and automation DB2 Catalog Runstats Repository DB2 Automation Tool DB2 Utilities Suite DB2 High Performance Unload Utility Options Repository Exceptions Repository Object Repository • DB2 Automation Tool • Creates maintenance jobs when criteria is reached • Set it and forget it philosophy • DB2 Utilities Suite • Complete function utilities • Supports latest level of DB2 • DB2 High Performance Unload • Supports cross-system unload formats • Accepts other unload product's syntax Utility-Job

9. Automation Tool -- A tool designed for .... • DB2 Database Administrators • Define exception criteria for backups (COPY utility) and data organization (REORG utility) • Variety of statistics available (catalog, history, RTS) • Date/Time • Combinatorial • Group like objects together (eg, all tablespaces used by an application) so they can be worked on as a unit • Fastpath JCL generator for many utilities • Easy to use point in time recovery assist • DB2 System Administrators • Manage dataset placement • Create a disaster recovery profile for being able to recover DB2 at a remote site

10. Automation Tool V2 • GA, June, 2004 • Over 20 customer requirements satisfied • Point in time assist for RECOVER generation • Disaster Recovery support • Support for more Online REORG parms (drain-wait, etc.) • Intelligent use of REUSE on REORG • Fast backup at the datset level for EMC and IBM DASD • Termination of utilities in case of failure • Ability to override/specify many system parameters (work device, MAXPRIME, region, primary/secondary values, etc.)

11. Automation Tool -- V2.2, March, 2005 • Highest priority requirements satisfied • Specify a maximum and minimum number of jobs • DISCARD on REORG • COPY to tape or DASD based on size • Ability to customize your own JCL skeletons • Allow users to add job steps • Ability to split REORG into PAUSE followed by CONTINUE

12. High Performance Unload V2 • Mostly V8 support but includes the following requirements • Automatically generate sequential SYSRECx • Creator specification • Specify target table name • User override of output record length • Better integration with DB2 Admin (get SSID on launch) • More compatibility with CA's Fast Unload • September, 2004, GA

13. Summary • Our (DM Tools) strategy gains increased focus on autonomic computing • Our database tools have autonomic characteristics today • Our database tools will follow the autonomic evolution in an effort to make IT less complex • Value statements apply: • Tools from the database company • Comprehensive cross-platforms integrated tools with common interfaces • Improving customer time to value and total cost of ownership • Long term commitment to DB2 and IMS customers • IBM Data Management Tools for DB2 on the web • ibm.com/software/data/db2imstools/