A conditional restart control record

You can create a conditional restart control record in the BSDS.

To create a new conditional restart control record in the BSDS, you must execute the change log inventory utility and use the CRESTART control statement. For example, to truncate the log, to specify the earliest log RBA, and to bypass backout, use a statement similar to the following statement:

CRESTART CREATE,STARTRBA=28000,ENDRBA=58000,BACKOUT=NO

To specify a cold start, make the values of STARTRBA and ENDRBA equal with a statement similar to the following statement:

CRESTART CREATE,STARTRBA=4A000,ENDRBA=4A000

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

To truncate the Db2® logs via conditional restart by specifying a timestamp rather than an RBA value, use a statement similar to the following statement:

CRESTART CREATE,ENDTIME=20051402030068

An existing 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.