Skip to Content

Initial status consideration for MODIFY jobs

For BMC AMI Copy to start (or restart) MODIFY jobs, the initial status of the space or partition must meet certain requirements.

These requirements include:

  • The space and database must have an initial start status of RW, RO, or UT.
  • MODIFY will not run on a space that is in UTUT or UTRO status. If the space is in UTRW status, it will issue a warning and return code of 4.

Related topic

Concurrency-issues

  • The space can be in any of the following statuses:

    • CHECK-pending (CHKP) status
    • COPY-pending (COPY) status
    • informational COPY (ICOPY) status
    • REORG-pending (REORP) status
    • auxiliary warning (AUXW) status

    If the space is in any status other than those listed, the utility will not run.

Warning

Important

Each partition in a table space might have a different initial status.

Jobs with the MODIFY command will not alter the space status except to put it in COPY-pending status when necessary.

The MODIFY command invokes the Db2 MODIFY RECOVERY utility when certain database descriptor (DBD) cleanup functions are required. If Db2 MODIFY RECOVERY is invoked, it will put the space in UTRW and might set the space in COPY-pending status. For more information about concurrency rules for the Db2 MODIFY RECOVERY utility, see the IBM Db2 for z/OS Utility Guide and Reference.

Persistent Read Only status and MODIFY

MODIFY TS ... DSNUM n is supported by BMC AMI Copy for partitions in PRO status.

BMC AMI Copy modifies table spaces in PRO status in the following ways:

  • MODIFY TS .... DSNUM ALL with one or more partitions are in PRO status issues message BMC180184E and fails with return code 8. If ON ERROR BADSTATUS SKIP is specified, processing continues.
  • MODIFY TS .... DSNUM n with partition n in PRO status issues message BMC180186I and continues successfully, but will retain the last 2 rows in SYSIBM.SYSCOPY. If there are fewer than two rows in SYSIBM.SYSCOPY when MODIFY starts, these rows, if any, are retained and BMC310408 is issued.


 

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

BMC AMI Copy for Db2 13.1