STARTDB control statement

Specifies whether a /START DB command is issued automatically after the completion of post-reorganization processing.

This control statement is optional. The default is STARTDB=NO.

Read syntax diagramSkip visual syntax diagramSTARTDB=NOYESYES,RORDUPEX,FORCE

STARTDB=YES must be specified together with NAMESWAP=YES, IMSCMD=YES,TOSI, and TOSIXCFGRP=grpname.

If STARTDB=YES is specified, the Smart Reorg utility sends the following command to the IMS online subsystems, to which the /DBR command has been issued by the Smart Reorg utility:
/START DB dbname LOCAL DBALLOC

The second parameter of the STARTDB control statement, which is the access option and is applied as the value of the ACCESS parameter of the /START DB command, is optional and it specifies the access intent RO, RD, UP, or EX.

If the job is run for a HALDB, the /START DB command is issued for the HALDB master and HALDB partitions. If the second parameter is omitted, the ACCESS parameter is omitted and the /START DB command is issued only for HALDB partitions.

The third parameter, FORCE, is optional. This parameter specifies that if AUTHFAIL=WTOR is specified and CANCEL is entered as the response for message HPSG0336A, after the DBRC flags are restored, the Smart Reorg utility issues a /START DB command to the IMS online subsystems to which the utility previously issued the /DBR command.

Restrictions:
  • The access option of the STARTDB control statement and the GLOBAL option of the IMSCMDOPT control statement are mutually exclusive.
  • If one or more of the following conditions are met, the /START DB command is not issued even if STARTDB=YES is specified:
    • Reorganization processing fails.
    • Name swap processing or DBRC notification processing fails.
    • NEWDBD control statement is specified.
    • Prefix resolution and update processing for non-HALDB is not done for logical relationships.
    • Secondary indexes building for non-HALDB is not done.
    • For HALDBs, either the ILDS is not built or the PSINDEX is not built.
    • Image Copy Needed (ICNEEDED) flag is turned on.
    • In Conditional Reorganization mode, CONDREORG=YES is specified with UNLOADONLY=YES and the CRSS determines that the database reorganization is necessary. In this case, the Smart Reorg utility expects a database reorganization to occur in the succeeding job step.
Tip: You can change the option parameters for the /STA commands by using IMSCMDOPT control statements. For more information, see IMSCMDOPT control statement.