Using CA tools for multiple tasks

1. Generate Image Copy for a tablespace or an entire DB using CA Tools:
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'. Enter 'IC'. Use model library ‘NODE1.ND2.CAI.R11.MODEL' and member 'MJUTLIC2', enter 'Yes' for symbolic FULL, and the desired RETPD.

2. Check restricted tables/indexes:
Go to CA DB2 Tools, Recovery Analyzer (Z), Special Recovery Services (5) and the (1), enter DB name and then 'x's in all.

3. Create Primary key for a table:
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.

4. Quick migrate (e.g. to remove statistics etc):
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. Default SQLID can be changed too, for e.g. ABCXYZ.

5. Calculate space for partitioned table space/indexes:
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. On the next screen, change the quantity to the desired number of rows for that partition (e.g. if the table space has 10 parts and total number of estimated rows = 1,000,000, then key in 100,000). Key in 'Totals' at the command line and press enter. The PriQty & SecQty are computed for you.

6. To place a tablespace in 'Utility Pending':
Go to CA DB2 Tools, and go to 'C' Command Processor, and key in:
-STA DB(DBNAME) SPACE(TSNAME) ACCESS (UT)

7. To bring the tablespace back to normal status:
Go to CA DB2 Tools, and go to 'C' Command Processor, and key in:
-STA DB(DBNAME) SPACE(TSNAME) ACCESS (FORCE)