CA Insight DPM collects data from the z/OS subsystem interface, DB2 and z/OS control blocks and DB2 performance traces to provide online access to critical performance statistics. When transactions use dynamic SQL that enters DB2 through various gateways or JDBC connections, it is crucial that your DB2 subsystems and applications are performing at their best. Overview As DB2 applications increase in complexity and the DB2 databases grow in size, ensuring performance is becoming increasingly critical. STA DB(DBNAME) SPACE(TSNAME) ACCESS (UT)ħ.PRODUCT SHEET CA Insight Database Performance Monitor for DB2 for z/OSĬA Insight™ Database Performance Monitor for DB2 for z/OS CA Insight™ Database Performance Monitor for DB2 for z/OS (CA Insight DPM) provides real-time performance monitoring of DB2 applications and subsystems, enabling the rapid detection and correction of performance problems. Go to CA DB2 Tools, and go to 'C' Command Processor, and key in: To place a tablespace in 'Utility Pending':

The PriQty & SecQty are computed for you.Ħ. Key in 'Totals' at the command line and press enter. if the table space has 10 parts and total number of estimated rows = 1,000,000, then key in 100,000). On the next screen, change the quantity to the desired number of rows for that partition (e.g. Go to CA DB2 Tools, RC/Query, display the table space and press enter, alter it, and key in 'S' under CMD of part 1, and press enter. Calculate space for partitioned table space/indexes: Default SQLID can be changed too, for e.g.

Go to CA DB2 Tools, RC/Migrator, and then Quick Migration and key in 'T' and then the table name, creator and type over 'N' with 'Y' from TS onwards and press PF3, key in 'Y' to update options and enter 'Y' to unload data. Go to CA DB2 Tools, RC/Query, display the table and press enter, alter it, and key in 1, 2, 3 etc under PK for the specific columns.Ĥ. Go to CA DB2 Tools, Recovery Analyzer (Z), Special Recovery Services (5) and the (1), enter DB name and then 'x's in all. Use model library ‘11.MODEL' and member 'MJUTLIC2', enter 'Yes' for symbolic FULL, and the desired RETPD. Go to CA DB2 Tools, Database Analyzer, Utility Manager, and then place 'Q' for Quick Path, and then enter the DB/Tablespace name, 'C' and then enter 'A'. Generate Image Copy for a tablespace or an entire DB using CA Tools:

Ca db2 tools manual