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=4A000In 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