Creating a conditional restart control record

A conditional restart control record (CRCR) is defined in the BSDS and is used by Db2 to direct a conditional restart.

About this task

A conditional restart control record governs any START DB2 operation until one of these events occurs:

  • A restart operation completes.
  • A CRESTART CANCEL statement is issued.
  • A new conditional restart control record is created.

Procedure

To create a conditional restart control record in the BSDS, execute the DSNJU003 (change log inventory) utility with the CRESTART statement.
Examples:
  • To truncate the log, specify the earliest log RBA, and bypass backout, use a statement similar to the following statement:
    CRESTART CREATE,STARTRBA=28000,ENDRBA=58000,BACKOUT=NO
  • To specify a cold start, specify equal values for STARTRBA and ENDRBA, as shown in the following example statement:
    CRESTART CREATE,STARTRBA=4A000,ENDRBA=4A000

    In most cases when doing a cold start, set the STARTRBA and ENDRBA to an RBA value that is greater than the highest used RBA.

  • To truncate the Db2 logs by using a conditional restart with a timestamp rather than an RBA value, use a statement similar to the following statement:

    CRESTART CREATE,ENDTIME=20051402030068