This syntax enables you to define a start point or an end point in the DB2 log. You can define the point as a relative byte address (RBA) value, a log record sequence number (LRSN) value, an existing log mark, or a date and time value.
Range definition syntax diagram
|RBA | LRSN X 'byteString'|
Describes a start or end point as a specific RBA or LRSN value. Enter a 1 to 12-character hexadecimal value in the following format:
Describes a start or end point as a specific log mark. A log mark is a symbolic name that represents a given point in the log. A log mark name
Within the Range definition, use existing (not newly created) log marks. Remember that a log mark created within a job step (one run of Log Master) cannot be referenced within that step.
You can create a log mark by using the LOGMARK statement or the MARKSCAN keyword of the LOGSCAN statement. For more information see LOGMARK statement or MARKSCAN. Log Master maintains log mark information in the Repository (in a table named ALPMARK).
You can reference log marks using a numeric value appended to the log mark name. This technique enables you to reuse the same log mark name and refer to specific log points by the numeric suffix. The suffix can be a relative or absolute generation.
Use this keyword only in the TO portion of the Scan range definition. This keyword defines the end point of the log scan as the most recent RBA/LRSN value that DB2 has written to the log when your Log Master job begins executing.
If the current job or job step includes the MARKSCAN keyword of the LOGSCAN statement to establish a new log mark, the new log mark will correspond to the RBA/LRSN selected for CURRENT.
Use this keyword only in the TO portion of the Scan range definition. This keyword defines the end point of the log scan as the RBA/LRSN value of the end point of the most recently-written archive log file (when your Log Master job begins executing). Use this keyword to reduce the chance of reading active log files on the current DB2 subsystem.
In a data sharing environment, Log Master determines the end points of the most recent archive log files of all members and then uses the earliest of those end points. If the current job or job step uses the MARKSCAN keyword of the LOGSCAN statement to establish a new log mark, the new log mark will correspond to the RBA/LRSN selected for LAST ARCHIVE.
|DATE (mm/dd/yyyy) / TIME (hh:mm:ss)|
Specify a start point or end point according to date and time.
Use any of the available date and time formats in the Range definition, but remember that to control the date and time displayed in reports, you must use the OPTION statement (for more information, see DATEFMT). Log Master supports the following date and time formats:
The default format is ISO.