Overview—Post-processing


Post-processing is the time during the Reorg function or the Online Reorg function reorganization after the database has been reorganized but before the database is ready for access by users.

Because the database has been reorganized, the post-processing tasks must complete.

Post-processing includes the following tasks:

  • Data set name swapping
  • DBRC notifications
  • Restart processing, if needed

Note

If for any reason the job does not complete the post-processing tasks, you must execute the restart process or perform the post-processing tasks manually.

If you specify SWAP(NO) to delay the post-processing tasks, you must execute the restart process to swap the data set names. For more information, see Restart-process.

The instructions in this section apply to a standard Reorg function or Online Reorg function reorganization. If you specified INPUT(UNLDFILE) for the Reorg function, you cannot delay post-processing tasks. However, if a failure occurs during post-processing, you can restart the tasks by following the instructions in Restart-process.

Note

Although you can perform the post-processing tasks manually, BMC recommends that you specify options to let the products complete post-processing tasks automatically.

During post-processing, messages are issued that report the beginning and completion of each task; these messages are written to the BMCMSG data set. The following figure shows a sample of post-processing messages written during a Reorg function reorganization that involved a primary database, a primary index, and three secondary indexes:

BMC90043I POST PROCESSING STARTED
BMC90086I CHANGE.DB DBD(CUSTOMER) NOAUTH
BMC90086I CHANGE.DB DBD(CUSTINDX) NOAUTH
BMC90086I CHANGE.DB DBD(CUSTNDX1) NOAUTH
BMC90086I CHANGE.DB DBD(CUSTNDX2) NOAUTH
BMC90086I CHANGE.DB DBD(CUSTNDX3) NOAUTH
BMC90044I IDCAMS PROCESSING STARTED FOR FRF/EP DATA SET SWAPPING
BMC90045I IDCAMS PROCESSING ENDED WITH RETURN CODE 0
BMC90080I NOTIFY.REORG DBD(CUSTOMER) RUNTIME(961591346259)
BMC90080I NOTIFY.REORG DBD(CUSTINDX) RUNTIME(961591346259)
BMC90080I NOTIFY.REORG DBD(CUSTNDX1) RUNTIME(961591346259)
BMC90080I NOTIFY.REORG DBD(CUSTNDX2) RUNTIME(961591346259)
BMC90080I NOTIFY.REORG DBD(CUSTNDX3) RUNTIME(961591346259)
BMC90086I CHANGE.DB DBD(CUSTOMER) AUTH READOFF
BMC90086I CHANGE.DB DBD(CUSTINDX) AUTH READOFF
BMC90086I CHANGE.DB DBD(CUSTNDX1) AUTH READOFF
BMC90086I CHANGE.DB DBD(CUSTNDX2) AUTH READOFF
BMC90086I CHANGE.DB DBD(CUSTNDX3) AUTH READOFF
BMC90043I POST PROCESSING COMPLETED

The following figure shows a sample of post-processing messages written during an Online Reorg function reorganization that involved a primary database and a primary index.

BMC90043I  POST PROCESSING STARTED
BMC90044I  IDCAMS PROCESSING STARTED FOR FRF/EP DATA SET SWAPPING
BMC90045I  IDCAMS PROCESSING ENDED WITH RETURN CODE 0
BMC90080I  NOTIFY.REORG DBD(HIPOQC) RUNTIME(970841121135)
BMC90080I  NOTIFY.REORG DBD(HIIVQC) RUNTIME(970841121135)
BMC90083I  NOTIFY.IC DBD(HIPOQC) DDN(HIPOQC) ICDSN(CRF.FAMQC.HIPOQC.HIPOQC.IC1)
           RUNTIME(970841121139)
BMC90083I  NOTIFY.IC DBD(HIIVQC) DDN(HIIVQC) ICDSN(CRF.FAMQC.HIIVQC.HIIVQC.IC1)
           RUNTIME(970841121139)
BMC90086I  CHANGE.DB DBD(HIPOQC) AUTH READOFF
BMC90086I  CHANGE.DB DBD(HIIVQC) AUTH READOFF
BMC90000I  /STA DB HIPOQC   HIIVQC
BMC90442I  IMS SUBSYSTEM CRFA REMOVED
BMC90085I  NOTIFY.PRILOG STARTIME(970841122543) DSN(CRF.FAMQC.CRFRDER)
BMC90043I  POST PROCESSING COMPLETED

In the Reorg function, you can reorganize to shadow data sets or to an image copy, depending on the value of the SWAP keyword. In the Online Reorg function, you always reorganize to shadow data sets.

If you reorganize to shadow data sets (SWAP(YES) or SWAP(DELETE)), the Reorg function or the Online Reorg function can automatically swap data set names and notify DBRC of the reorganization. If you specify SWAP(NO), you must perform these tasks manually.

If you reorganize to an image copy (SWAP(YES,IC) or SWAP(S,IC)), the Reorg function restores the image copy after the reorganization and completes the DBRC notifications. The SWAP(x,IC) option is available in the Reorg function only.

You can use the IDCAMS and DBRC commands provided in this section as examples. (For details about DBRC and IDCAMS commands, see the IBM references.) For more information about how the Reorg function and the Online Reorg function work with DBRC, see DBRC-support.

This section contains the following topics:




 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*