Bmc reorg plus for db2 manual

The BMC Software utility products for Db2 address the needs of database administrators (DBAs) and system administrators by providing high-performance database administration and utility products. The REORG PLUS for DB2 product is a BMC Software product for reorganizing Db2 databases.  · Problem: We had encountered issue with Online BMC DB2 Reorg job, the job was in Terminate utility phase and went into RETRY mode, and able to complete the REORG as some thread was holding the REORG job. The job was in retry mode for a long time and the table was in locked status, due to the BMC defaults options in the system. As the table locks was . REORG PLUS executes only part of this phase when invoking DSNUTILB. All phases During all phases except the DSNUTILB phase, REORG PLUS updates the BMCUTIL and BMCSYNC DB2 tables.

ALTER for DB2 and CHANGE MANAGER for DB2. CATALOG MANAGER for DB2. DASD MANAGER PLUS and CATALOG MANAGER share some functions with each other and with ALTER and CHANGE MANAGER, as follows: ALTER and CHANGE MANAGER can access the DASD MANAGER PLUS BMCSTATS and space estimation functions. They can also access the EVENTS table. You can tell REORG PLUS to TERM, which wipes away all traces the REORG was attempted (all rows are deleted from BMCUTIL and BMCSYNC) and a condition code 8 is returned, or ABEND which causes a U ABEND (and BMCUTIL and BMCSYNC are still cleaned up). Look at TIMEOUT in the manual for additional information concerning ON FAILURE specifications. BMC REORG PLUS for DB2 The REORG PLUS for DB2 product enables you to reorganize Db2 databases. Notices. updated 08 Feb. Log in or register to view this page.

6 Feb *IBM and DB2 are registered trademarks of International Business Machines BMC Software?s Day-Plus Free Trial. documentation set. 1 Jul Capacity Plus for DB2, VSAM Assist, VSAM I/O Plus, The Mechanic, CICS/VSAM, BMCSTATS, Reorg Plus, Copy Plus, Fast Path Series. Experience in IMS database administration will be a significant plus for the Experience with IBM and BMC DB2 utilities; BMC NGT (formerly CDB) Reorg and.