DSNJU004 (print log map) output
The output of the DSNJU004 (print log map) utility is various backup and recovery information for a subsystem or data sharing members.
Specifically, DSNJU004 output includes the following information:
- The data set name (DSN) of the BSDS.
- The system date and time (SYSTEM TIMESTAMP), and the date and time that the BSDS was last changed by the change log inventory utility (UTILITY TIMESTAMP). For more information about these timestamp values in the output, see Timestamps in the BSDS.
- The integrated catalog facility (ICF) catalog name that is associated with the BSDS.
- The highest-written RBA. The value is updated each time the log buffers are physically written to disk.
- The highest RBA that was offloaded.
- Log RBA ranges (STARTRBA and ENDRBA) and data set information for active and archive log data sets. The last active log data set that is listed in the output is the current active log.
- Information about each active log data set. This information includes the starting and ending RBAs within the data set, the date and time the data set was created, and the data set name (DSN) and status. You might see consecutive active or archive log data sets with an end LRSN value that is the same as the beginning LRSN value of the next data set. For a description of the active log data set information in the output, see Active log data set status.
- Information about each archive log data set. This information includes the starting and ending RBAs within the data set, the date and time the data set was created, and the data set name (DSN), unit and volume of storage, and status. You might see consecutive active or archive log data sets with an end LRSN value that is the same as the beginning LRSN value of the next data set.
- Conditional restart control records. For a description of this output, see Reading conditional restart control records.
- The contents of the checkpoint description queue.
- Archive log command history. For a description of this output, see Archive log command history.
- The distributed data facility (DDF) communication record. This record contains the location name as defined by Db2, any alias names for the location name, and the LU name as defined by VTAM®. Db2 uses this information to establish the distributed database environment.
- The tokens for all BACKUP SYSTEM utility records. The token identifies each backup version that was created. For a description of this output, see System-level backup information.
- The ENFM START RBA/LRSN field contains one of
the following values:
- In a non-data sharing environment, the RBA when the most recent enabling-new-function mode job started on the subsystem. If the enabling-new-function mode job was never run on the subsystem, this field contains zeroes.
- In a data sharing environment, the LRSN when the most recent enabling-new-function mode job started on a member. If the enabling-new-function mode job was never run on a member, this field contains zeroes.
- Information about members of a data sharing group, including deactivated members and destroyed members whose slots were reclaimed.
The following figures show example output from the DSNJU004 (print log map) utility.
- Example DSNJU004 output for a subsystem
- The sample print log map utility output in the following figure is for a non-data-sharing subsystem.
*************************************************************************************** * * * LOG MAP OF THE BSDS DATA SET BELONGING TO MEMBER 'NO NAME ' OF GROUP 'NO NAME '. * * * *************************************************************************************** DSNJCNVB CONVERSION PROGRAM HAS RUN DDNAME=SYSUT1 DSNJCNVT CONVERSION PROGRAM HAS NOT RUN DDNAME=SYSUT1 LOG MAP OF BSDS DATA SET COPY 1, DSN=DSNC000.DB2A.BSDS01 LTIME INDICATES LOCAL TIME, ALL OTHER TIMES ARE GMT. DATA SHARING MODE IS OFF SYSTEM TIMESTAMP - DATE=2012.256 LTIME=13:50:24.23 UTILITY TIMESTAMP - DATE=2012.256 LTIME=11:50:58.15 VSAM CATALOG NAME=DSNC000 HIGHEST RBA WRITTEN 0000000000007FA798CE 2012.256 20:50:57.4 HIGHEST RBA OFFLOADED 0000000000007FA6AFFF RBA WHEN CONVERTED TO V4 00000000000069957FFF THIS BSDS HAS MEMBER RECORDS FOR THE FOLLOWING MEMBERS: HOST MEMBER NAME: MEMBER ID: 0 GROUP NAME: BSDS COPY 1 DATA SET NAME: BSDS COPY 2 DATA SET NAME: ENFM START RBA/LRSN: 00000000000000000000 **** DISTRIBUTED DATA FACILITY **** COMMUNICATION RECORD 20:51:19 SEPTEMBER 12, 2012 LOCATION=STLEC1 IPNAME=(NULL) PORT=NULL SPORT=NULL RPORT=NULL ALIAS=(NULL) IPV4=NULL IPV6=NULL GRPIPV4=NULL GRPIPV6=NULL LUNAME=SYEC1DB2 PASSWORD=DB2PW1 GENERICLU=(NULL)
ACTIVE LOG COPY 1 DATA SETS START RBA/TIME END RBA/TIME DATE/LTIME DATA SET INFORMATION ---------------------- ---------------------- ---------- -------------------- 0000000000007FA6B000 0000000000007FA6FFFF 2011.110 DSN=DSNC000.DB2A.LOGCOPY1.DS02 2012.256 20:50:44.8 2012.256 20:50:49.3 9:17 STATUS=TRUNCATED, REUSABLE 0000000000007FA70000 0000000000007FA73FFF 2011.110 DSN=DSNC000.DB2A.LOGCOPY1.DS03 2012.256 20:50:49.3 2012.256 20:50:57.4 9:17 STATUS=TRUNCATED, REUSABLE 0000000000007FA74000 00000000000080E23FFF 2011.110 DSN=DSNC000.DB2A.LOGCOPY1.DS01 2012.256 20:50:57.4 ........ .......... 9:17 STATUS=REUSABLE ARCHIVE LOG COPY 1 DATA SETS NO ARCHIVE DATA SETS DEFINED FOR THIS COPY ACTIVE LOG COPY 2 DATA SETS NO ACTIVE DATA SETS DEFINED FOR THIS COPY ARCHIVE LOG COPY 2 DATA SETS NO ARCHIVE DATA SETS DEFINED FOR THIS COPY CONDITIONAL RESTART CONTROL RECORD 20:51:19 SEPTEMBER 12, 2012 **** ACTIVE CRCR RECORD **** NO CRCR RECORDS ARE ACTIVE **** CRCR IDENTIFIER 0002 USE COUNT 1 RECORD STATUS CRCR NOT ACTIVE PROCESSING STATUS COLD START (STARTRBA = ENDRBA) FORWARD = NO BACKOUT = NO STARTRBA 000000000000000FE000 ENDRBA 000000000000000FE000 ENDLRSN NOT SPECIFIED ENDTIME NOT SPECIFIED EARLIEST REQUESTED RBA 00000000000000000000 FIRST LOG RECORD RBA 00000000000000000000 ORIGINAL CHECKPOINT RBA 00000000000000000000 NEW CHECKPOINT RBA (CHKPTRBA) NOT SPECIFIED CRCR CREATED 19:51:36 SEPTEMBER 12, 2012 BEGIN RESTART 20:49:12 SEPTEMBER 12, 2012 RESTART PROGRESS STARTED ENDED ======= ===== CURRENT STATUS REBUILD NO NO FORWARD RECOVERY PHASE NO NO BACKOUT RECOVERY PHASE NO NO CRCR IDENTIFIER 0001 USE COUNT 1 RECORD STATUS CRCR NOT ACTIVE SUCCESSFUL RESTART PROCESSING STATUS COLD START (STARTRBA = ENDRBA) FORWARD = NO BACKOUT = NO STARTRBA 00000000000069958000 ENDRBA 00000000000069958000 ENDLRSN NOT SPECIFIED ENDTIME NOT SPECIFIED EARLIEST REQUESTED RBA 00000000000000000000 FIRST LOG RECORD RBA 00000000000000000000 ORIGINAL CHECKPOINT RBA 00000000000000000000 NEW CHECKPOINT RBA (CHKPTRBA) NOT SPECIFIED CRCR CREATED 16:17:06 APRIL 20, 2011 BEGIN RESTART 16:19:39 APRIL 20, 2011 END RESTART 16:19:48 APRIL 20, 2011 RESTART PROGRESS STARTED ENDED ======= ===== CURRENT STATUS REBUILD YES YES FORWARD RECOVERY PHASE YES YES BACKOUT RECOVERY PHASE YES YES CHECKPOINT QUEUE 20:51:19 SEPTEMBER 12, 2012 ....
TIME OF CHECKPOINT 14:10:13 JUNE 22, 2012 BEGIN CHECKPOINT RBA 0000000000007AD2C562 END CHECKPOINT RBA 0000000000007AD2ECBE END CHECKPOINT STCK 00C9C2079978DA000000 TIME OF CHECKPOINT 17:06:49 JUNE 13, 2012 BEGIN CHECKPOINT RBA 0000000000007AD1FE4B END CHECKPOINT RBA 0000000000007AD2B2BE END CHECKPOINT STCK 00C9B6DE530C48000000 SHUTDOWN CHECKPOINT TIME OF CHECKPOINT 22:46:33 JUNE 12, 2012 BEGIN CHECKPOINT RBA 0000000000007ACFBB93 END CHECKPOINT RBA 0000000000007AD02A9E END CHECKPOINT STCK 00C9B5E85C1961000000 TIME OF CHECKPOINT 22:46:29 JUNE 12, 2012 BEGIN CHECKPOINT RBA 0000000000007AC0F000 END CHECKPOINT RBA 0000000000007AC6D6B4 END CHECKPOINT STCK 00C9B5E8582489000000 ARCHIVE LOG COMMAND HISTORY 20:51:19 SEPTEMBER 12, 2012 DATE TIME RBA MODE WAIT TIME ------------ ---------- -------------------- ------- ---- ----- SEP 12, 2012 20:50:57.4 0000000000007FA73A2E QUIESCE YES 5 D SEP 12, 2012 20:50:49.3 0000000000007FA6F35E SEP 12, 2012 20:50:44.8 0000000000007FA6ACC2 QUIESCE NO 5 D SEP 12, 2012 20:50:39.9 0000000000007FA66543 DSNJ401I DSNUPBHR BACKUP SYSTEM UTILITY HISTORY RECORD NOT FOUND SYSTEM CCSIDS 20:51:19 SEPTEMBER 12, 2012 SYSTEM CCSIDS -------------------- ASCII SBCS = 1252 ASCII MIXED = 65534 ASCII DBCS = 65534 EBCDIC SBCS = 37 EBCDIC MBCS = 65534 EBCDIC DBCS = 65534 UNICODE SBCS = 367 UNICODE MBCS = 1208 UNICODE DBCS = 1200 DSNJ200I DSNJU004 PRINT LOG UTILITY PROCESSING COMPLETED SUCCESSFULLY - Example DSNJU004 output for a data sharing member
- The sample print log map utility output in the following figure is for a member of a
data sharing group.
************************************************************************************** * * * LOG MAP OF THE BSDS DATA SET BELONGING TO MEMBER 'DL51 ' OF GROUP 'DSNL5 '. * * * ************************************************************************************** DSNJCNVT CONVERSION PROGRAM HAS RUN DDNAME=GROUP LOG MAP OF BSDS DATA SET COPY 1, DSN=DSNL5LOG.DL51.BSDS01 LTIME INDICATES LOCAL TIME, ALL OTHER TIMES ARE GMT. DATA SHARING MODE IS ON SYSTEM TIMESTAMP - DATE=2013.164 LTIME=13:17:24.34 UTILITY TIMESTAMP - DATE=2013.098 LTIME= 1:06:04.02 VSAM CATALOG NAME=DSNL5SYS HIGHEST RBA WRITTEN 000000004C45C60F9E9E 2013.164 20:17:47.3 HIGHEST RBA OFFLOADED 000000004C45ACB5CFFF RBA WHEN CONVERTED TO V4 00000000000000000000 MAX RBA FOR TORBA 00000000000000000000 MIN RBA FOR TORBA 00000000000000000000 STCK TO LRSN DELTA 00000000000000000000 THIS BSDS HAS MEMBER RECORDS FOR THE FOLLOWING MEMBERS: HOST MEMBER NAME: DL51 MEMBER ID: 1 GROUP NAME: DSNL5 BSDS COPY 1 DATA SET NAME: DSNL5LOG.DL51.BSDS01 BSDS COPY 2 DATA SET NAME: DSNL5LOG.DL51.BSDS02 ENFM START RBA/LRSN: 00C72DC5B25477000000 MEMBER NAME: DL53 MEMBER ID: 2 GROUP NAME: DSNL5 BSDS COPY 1 DATA SET NAME: DSNL5LOG.DL53.BSDS01 BSDS COPY 2 DATA SET NAME: DSNL5LOG.DL53.BSDS02 MEMBER NAME: DL52 MEMBER ID: 3 GROUP NAME: DSNL5 BSDS COPY 1 DATA SET NAME: DSNL5LOG.DL52.BSDS01 BSDS COPY 2 DATA SET NAME: DSNL5LOG.DL52.BSDS02 MEMBER NAME: DL54 MEMBER ID: 4 GROUP NAME: DSNL5 BSDS COPY 1 DATA SET NAME: DSNL5LOG.DL54.BSDS01 BSDS COPY 2 DATA SET NAME: DSNL5LOG.DL54.BSDS02 MEMBER NAME: DL55 MEMBER ID: 5 GROUP NAME: DSNL5 BSDS COPY 1 DATA SET NAME: DSNL5LOG.DL55.BSDS01 BSDS COPY 2 DATA SET NAME: DSNL5LOG.DL55.BSDS02 THIS MEMBER WAS QUIESCED ON 2013.161 AT 14:23:22.9 MEMBER NAME: DL56 MEMBER ID: 6 GROUP NAME: DSNL5 BSDS COPY 1 DATA SET NAME: DSNL5LOG.DL56.BSDS01 BSDS COPY 2 DATA SET NAME: DSNL5LOG.DL56.BSDS02 THIS MEMBER WAS QUIESCED ON 2013.133 AT 18:30:06.9 MEMBER NAME: DESTROYED MEMBER ID: 7 GROUP NAME: DSNL5 BSDS COPY 1 DATA SET NAME: BSDS COPY 2 DATA SET NAME: THIS MEMBER WAS DESTROYED ON 2012.150 AT 17:54:09.5 THIS MEMBER ID IS AVAILABLE FOR REUSE **** DISTRIBUTED DATA FACILITY **** COMMUNICATION RECORD 20:17:49 JUNE 13, 2013 LOCATION=DSNL5 IPNAME=(NULL) PORT=50200 SPORT=50290 RPORT=50201 ALIAS=DSNL5NETT01,DSNL5NETT02,DSNL5NETT03, DSNL5NETT04,DSNL5NETT05 IPV4=9.30.178.71 IPV6=ABCD::91E:B247 GRPIPV4=9.30.178.50 GRPIPV6=ABCD::91E:B232 LUNAME=STBDL51 PASSWORD=(NULL) GENERICLU=STBDL5GACTIVE LOG COPY 1 DATA SETS START RBA/LRSN/TIME END RBA/LRSN/TIME DATE/LTIME DATA SET INFORMATION ---------------------- ---------------------- ---------- -------------------- 000000004C444BBDD000 000000004C44A455CFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY1.DS03 00CB81C00D9C43400400 00CB81C3CE783A060000 9:41 STATUS=REUSABLE 2013.164 16:35:33.3 2013.164 16:52:20.9 000000004C44A455D000 000000004C44FC39CFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY1.DS05 00CB81C3CE783A060000 00CB81C962BC23D21200 9:41 STATUS=TRUNCATED, REUSABLE 2013.164 16:52:20.9 2013.164 17:17:18.5 000000004C44FC39D000 000000004C45541DCFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY1.DS04 00CB81C962BC23D21200 00CB81CE3D7E49E72400 10:16 STATUS=REUSABLE 2013.164 17:17:18.5 2013.164 17:39:01.6 000000004C45541DD000 000000004C45ACB5CFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY1.DS01 00CB81CE3D7E49E72400 00CB81D320A86B598000 9:41 STATUS=REUSABLE 2013.164 17:39:01.6 2013.164 18:00:53.6 000000004C45ACB5D000 000000004C46054DCFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY1.DS02 00CB81D320A86B598000 .................... 9:41 STATUS=NOTREUSABLE 2013.164 18:00:53.6 ........ .......... ARCHIVE LOG COPY 1 DATA SETS START RBA/LRSN/TIME END RBA/LRSN/TIME DATE/LTIME DATA SET INFORMATION ---------------------- ---------------------- ---------- -------------------- 000000003ECDEE9AE000 000000003ECE4732DFFF 2013.074 DSN=DSNL5AR1.DL51.D13074.T0753360.A0165898 00CB108020450A8B8600 00CB10817DEBA05B8000 7:54 VOL=ARX081 UNIT=SYSDA 2013.074 14:47:52.2 2013.074 14:53:58.8 CATALOGUED 000000003ECE4732E000 000000003ECE9FCADFFF 2013.074 DSN=DSNL5AR1.DL51.D13074.T0800383.A0165899 00CB10817DEBA05B8000 00CB10831082B6008800 8:01 VOL=ARX030 UNIT=SYSDA 2013.074 14:53:58.8 2013.074 15:01:01.0 CATALOGUED ... 000000004C44A455D000 000000004C44FC39CFFF 2013.164 DSN=DSNL5AR1.DL51.D13164.T1016560.A0176325 00CB81C3CE783A060000 00CB81C962BC23D21200 10:17 VOL=ARX054 UNIT=SYSDA 2013.164 16:52:20.9 2013.164 17:17:18.5 CATALOGUED 000000004C44FC39D000 000000004C45541DCFFF 2013.164 DSN=DSNL5AR1.DL51.D13164.T1038388.A0176326 00CB81C962BC23D21200 00CB81CE3D7E49E72400 10:39 VOL=ARX755 UNIT=SYSDA 2013.164 17:17:18.5 2013.164 17:39:01.6 CATALOGUED 000000004C45541DD000 000000004C45ACB5CFFF 2013.164 DSN=DSNL5AR1.DL51.D13164.T1100310.A0176327 00CB81CE3D7E49E72400 00CB81D320A86B598000 11:01 VOL=ARX224 UNIT=SYSDA 2013.164 17:39:01.6 2013.164 18:00:53.6 CATALOGUED ACTIVE LOG COPY 2 DATA SETS START RBA/LRSN/TIME END RBA/LRSN/TIME DATE/LTIME DATA SET INFORMATION ---------------------- ---------------------- ---------- -------------------- 000000004C444BBDD000 000000004C44A455CFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY2.DS03 00CB81C00D9C43400400 00CB81C3CE783A060000 9:41 STATUS=REUSABLE 2013.164 16:35:33.3 2013.164 16:52:20.9 000000004C44A455D000 000000004C44FC39CFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY2.DS05 00CB81C3CE783A060000 00CB81C962BC23D21200 9:41 STATUS=REUSABLE 2013.164 16:52:20.9 2013.164 17:17:18.5 000000004C44FC39D000 000000004C45541DCFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY2.DS04 00CB81C962BC23D21200 00CB81CE3D7E49E72400 10:16 STATUS=REUSABLE 2013.164 17:17:18.5 2013.164 17:39:01.6 000000004C45541DD000 000000004C45ACB5CFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY2.DS01 00CB81CE3D7E49E72400 00CB81D320A86B598000 9:41 STATUS=REUSABLE 2013.164 17:39:01.6 2013.164 18:00:53.6 000000004C45ACB5D000 000000004C46054DCFFF 2011.193 DSN=DSNL5LOG.DL51.LOGCOPY2.DS02 00CB81D320A86B598000 .................... 9:41 STATUS=NOTREUSABLE 2013.164 18:00:53.6 ........ ..........ARCHIVE LOG COPY 2 DATA SETS NO ARCHIVE DATA SETS DEFINED FOR THIS COPY CONDITIONAL RESTART CONTROL RECORD 20:17:51 JUNE 13, 2013 **** ACTIVE CRCR RECORD **** NO CRCR RECORDS ARE ACTIVE **** CRCR IDENTIFIER 0003 USE COUNT 1 RECORD STATUS CRCR NOT ACTIVEf SUCCESSFUL RESTART PROCESSING STATUS FORWARD = YES BACKOUT = NO STARTRBA NOT SPECIFIED ENDRBA NOT SPECIFIED ENDLRSN NOT SPECIFIED ENDTIME NOT SPECIFIED EARLIEST REQUESTED RBA 00000000000000000000 FIRST LOG RECORD RBA 00000000000000000000 ORIGINAL CHECKPOINT RBA 00000000000000000000 NEW CHECKPOINT RBA (CHKPTRBA) NOT SPECIFIED CRCR CREATED 14:55:09 JANUARY 04, 2012 BEGIN RESTART 14:55:38 JANUARY 04, 2012 END RESTART 14:56:37 JANUARY 04, 2012 RESTART PROGRESS STARTED ENDED ======= ===== CURRENT STATUS REBUILD YES YES FORWARD RECOVERY PHASE YES YES BACKOUT RECOVERY PHASE YES YES CRCR IDENTIFIER 0002 USE COUNT 1 RECORD STATUS CRCR NOT ACTIVE SUCCESSFUL RESTART PROCESSING STATUS COLD START (STARTRBA = ENDRBA) FORWARD = NO BACKOUT = NO STARTRBA 0000000011BE80000000 ENDRBA 0000000011BE80000000 ENDLRSN NOT SPECIFIED ENDTIME NOT SPECIFIED EARLIEST REQUESTED RBA 00000000000000000000 FIRST LOG RECORD RBA 00000000000000000000 ORIGINAL CHECKPOINT RBA 00000000000000000000 NEW CHECKPOINT RBA (CHKPTRBA) NOT SPECIFIED CRCR CREATED 21:24:13 OCTOBER 16, 2011 BEGIN RESTART 21:51:25 OCTOBER 16, 2011 END RESTART 21:59:35 OCTOBER 16, 2011 RESTART PROGRESS STARTED ENDED ======= ===== CURRENT STATUS REBUILD YES YES FORWARD RECOVERY PHASE YES YES BACKOUT RECOVERY PHASE YES YES CRCR IDENTIFIER 0001 USE COUNT 1 RECORD STATUS CRCR NOT ACTIVE SUCCESSFUL RESTART PROCESSING STATUS FORWARD = NO BACKOUT = YES STARTRBA NOT SPECIFIED ENDRBA NOT SPECIFIED ENDLRSN NOT SPECIFIED ENDTIME NOT SPECIFIED EARLIEST REQUESTED RBA 00000000000000000000 FIRST LOG RECORD RBA 00000000000000000000 ORIGINAL CHECKPOINT RBA 00000000000000000000 NEW CHECKPOINT RBA (CHKPTRBA) NOT SPECIFIED CRCR CREATED 17:48:37 MARCH 23, 2010 BEGIN RESTART 17:49:57 MARCH 23, 2010 END RESTART 17:51:28 MARCH 23, 2010 RESTART PROGRESS STARTED ENDED ======= ===== CURRENT STATUS REBUILD YES YES FORWARD RECOVERY PHASE YES YES BACKOUT RECOVERY PHASE YES YES CHECKPOINT QUEUE 20:17:51 JUNE 13, 2013 TIME OF CHECKPOINT 20:16:43 JUNE 13, 2013 BEGIN CHECKPOINT RBA 000000004C45C2CE07F2 END CHECKPOINT RBA 000000004C45C2D9AA15 END CHECKPOINT LRSN 00CB81F17D7369468E00 TIME OF CHECKPOINT 20:14:43 JUNE 13, 2013 BEGIN CHECKPOINT RBA 000000004C45BF6B54F0 END CHECKPOINT RBA 000000004C45BF781379 END CHECKPOINT LRSN 00CB81F10AEDE3280400 TIME OF CHECKPOINT 20:12:43 JUNE 13, 2013 BEGIN CHECKPOINT RBA 000000004C45B97FCACF END CHECKPOINT RBA 000000004C45B98AFE56 END CHECKPOINT LRSN 00CB81F0984E2858AC00 ....TIME OF CHECKPOINT 17:02:21 JUNE 13, 2013 BEGIN CHECKPOINT RBA 000000004C44CCDE6D2F END CHECKPOINT RBA 000000004C44CCE8B409 END CHECKPOINT LRSN 00CB81C60AC5C633A600 TIME OF CHECKPOINT 17:00:21 JUNE 13, 2013 BEGIN CHECKPOINT RBA 000000004C44C50572CF END CHECKPOINT RBA 000000004C44C50FB946 END CHECKPOINT LRSN 00CB81C598549EB09000 TIME OF CHECKPOINT 16:58:21 JUNE 13, 2013 BEGIN CHECKPOINT RBA 000000004C44BBDF62C0 END CHECKPOINT RBA 000000004C44BBE9CC54 END CHECKPOINT LRSN 00CB81C525E39E4CAE00 TIME OF CHECKPOINT 16:56:21 JUNE 13, 2013 BEGIN CHECKPOINT RBA 000000004C44B36E23A6 END CHECKPOINT RBA 000000004C44B3787B59 END CHECKPOINT LRSN 00CB81C4B372E7DD0400 TIME OF CHECKPOINT 16:54:21 JUNE 13, 2013 BEGIN CHECKPOINT RBA 000000004C44ACA3882B END CHECKPOINT RBA 000000004C44ACB70485 END CHECKPOINT LRSN 00CB81C441338C1B2600 ARCHIVE LOG COMMAND HISTORY MEMBER DL51 DATA SHARING GROUP DSNL5 CONTAINS 7 MEMBERS 20:17:51 JUNE 13, 2013 DATE/SDATE TIME/STIME RBA MODE WAIT TIME SCOPE CMD ORIGIN STATUS ACTIVE ------------ ---------- -------------------- ------- ---- ----- ----- ---------- ------ ------ JUN 10, 2013 13:25:41.9 000000004B744729CE22 QUIESCE NO 5 D G DL51 ORIGINATOR 5 JUN 03, 2013 15:12:07.0 000000004A22F3390BE4 QUIESCE NO 5 D G DL51 ORIGINATOR 5 MAY 20, 2013 15:54:03.1 00000000485391AC2858 QUIESCE NO 5 D G DL51 ORIGINATOR 5 MAY 13, 2013 16:20:31.7 0000000047B36F159850 QUIESCE NO 5 D G DL51 ORIGINATOR 5 MAY 06, 2013 13:25:22.9 000000004666B2D550FF QUIESCE NO 5 D G DL51 ORIGINATOR 5 APR 29, 2013 16:26:52.2 000000004576BE7884CA QUIESCE NO 5 D G DL51 ORIGINATOR 5 APR 22, 2013 14:12:22.4 00000000445250177700 QUIESCE NO 5 D G DL51 ORIGINATOR 5 APR 15, 2013 13:25:32.3 00000000435BF4740EC7 QUIESCE NO 5 D G DL51 ORIGINATOR 5 APR 08, 2013 13:25:58.9 00000000422B9CEA328A QUIESCE NO 5 D G DL51 ORIGINATOR 5 APR 01, 2013 19:04:21.2 0000000040CD3F8A2AA1 QUIESCE NO 5 D G DL51 PARTICIPANT 5 MAR 24, 2013 18:31:45.1 000000003F805C3E4A6C QUIESCE NO 5 D G DL51 PARTICIPANT 5 MAR 11, 2013 13:25:27.1 000000003DD42CA2D062 QUIESCE NO 5 D G DL51 ORIGINATOR 5 DSNJ401I DSNUPBHR BACKUP SYSTEM UTILITY HISTORY RECORD NOT FOUND SYSTEM CCSIDS 20:17:51 JUNE 13, 2013 SYSTEM CCSIDS -------------------- ASCII SBCS = 1252 ASCII MIXED = 65534 ASCII DBCS = 65534 EBCDIC SBCS = 37 EBCDIC MBCS = 65534 EBCDIC DBCS = 65534 UNICODE SBCS = 367 UNICODE MBCS = 1208 UNICODE DBCS = 1200 DSNJ200I DSNJU004 PRINT LOG UTILITY PROCESSING COMPLETED SUCCESSFULLY - Example DSNJU004 output for deactivated and destroyed members
- The sample print log map utility output in the following figure is for a deactivated member and
a destroyed member of a data sharing
group.
DSNJCNVB CONVERSION PROGRAM HAS RUN DDNAME=SYSUT1 DSNJCNVT CONVERSION PROGRAM HAS NOT RUN DDNAME=SYSUT1 LOG MAP OF BSDS DATA SET COPY 1, DSN=DSNC000.DB2B.BSDS01 LTIME INDICATES LOCAL TIME, ALL OTHER TIMES ARE GMT. DATA SHARING MODE IS ON SYSTEM TIMESTAMP - DATE=2012.256 LTIME=11:35:42.52 UTILITY TIMESTAMP - DATE=2012.256 LTIME=10:40:27.07 VSAM CATALOG NAME=DSNC000 HIGHEST RBA WRITTEN 0000000000000000682A 0000.000 00:00:00.0 HIGHEST RBA OFFLOADED 00000000000010000FFF RBA WHEN CONVERTED TO V4 00000000000012F04FFF MAX RBA FOR TORBA 00000000000012F04FFF MIN RBA FOR TORBA 00000000000000000000 STCK TO LRSN DELTA 00000000000000000000 THIS BSDS HAS MEMBER RECORDS FOR THE FOLLOWING MEMBERS: HOST MEMBER NAME: DB2B MEMBER ID: 2 GROUP NAME: DSNCAT BSDS COPY 1 DATA SET NAME: DSNC000.DB2B.BSDS01 BSDS COPY 2 DATA SET NAME: DSNC000.DB2B.BSDS02 ENFM START RBA/LRSN: 00000000000000000000 MEMBER NAME: DB2A MEMBER ID: 1 GROUP NAME: DSNCAT BSDS COPY 1 DATA SET NAME: DSNC000.DB2A.BSDS01 BSDS COPY 2 DATA SET NAME: DSNC000.DB2A.BSDS02 MEMBER NAME: DESTROYED MEMBER ID: 3 GROUP NAME: DSNCAT BSDS COPY 1 DATA SET NAME: BSDS COPY 2 DATA SET NAME: THIS MEMBER WAS DESTROYED ON 2012.109 AT 04:12:30.2 THIS MEMBER ID IS AVAILABLE FOR REUSE MEMBER NAME: DB2D MEMBER ID: 4 GROUP NAME: DSNCAT BSDS COPY 1 DATA SET NAME: DSNC000.DB2D.BSDS01 BSDS COPY 2 DATA SET NAME: DSNC000.DB2D.BSDS02 THIS MEMBER WAS DEACTIVATED ON 2012.109 AT 01:46:52.4
Timestamps in the BSDS
The output of the DSNJU004 (print log map) utility includes many timestamps that are recorded in the BSDS. Those timestamps record the date and time of various system events.
Timestamps in the output column LTIME are in local time. All other timestamps are in Coordinated Universal Time (UTC).
The following timestamps are included in the header section of the reports:
- System timestamp
- Reflects the date and time that the BSDS was last updated. The BSDS can be updated by several
events:
- Db2 startup.
- The write threshold is reached during log write activities.
The BSDS might be updated several times a second, or it might not be updated for several seconds, minutes, or even hours. The frequency of updates depends on the number of output buffers that you specified and the system activity rate.
- An error situation where Db2 drops into single-BSDS mode from its normal dual BSDS mode. This action might occur when a request to get, insert, point to, update, or delete a BSDS record is unsuccessful. When this error occurs, Db2 updates the timestamp in the remaining BSDS to force a timestamp mismatch with the disabled BSDS.
- Utility timestamp
- The date and time that the contents of the BSDS were altered by the change log inventory (DSNJU003) utility.
The following timestamps are included in the active and archive log data sets of the reports:
- Active log date
- The date on which the active log data set was originally allocated on the Db2 subsystem.
- Active log time
- The time at which the active log data set was originally allocated on the Db2 subsystem.
- Archive log date
- The date of creation (not allocation) of the archive log data set.
- Archive log time
- The time of creation (not allocation) of the archive log data set.
The following timestamps are included in the conditional restart control record portion of the report that is shown in DSNJU004 (print log map) output:
- Conditional restart control record
- The current time and date. This data is reported for information only and is not kept in the BSDS.
- CRCR created
- The time and date of creation of the CRCR by the CRESTART option in the change log inventory utility.
- Begin restart
- The time and date that the conditional restart was attempted.
- End restart
- The time and date that the conditional restart ended.
- STARTRBA (timestamp)
- The time at which the control interval was written.
- ENDRBA (timestamp)
- The time at which the last control interval was written.
- Time of checkpoint
- The time and date that are associated with the checkpoint record that was used during the conditional restart process.
The following timestamps are included in the checkpoint queue and the DDF communication record sections of the report.
- Checkpoint queue
- The current time and date. This data is reported for information only and is not kept in the BSDS.
- Time of checkpoint
- The time and date that the checkpoint was taken.
- DDF communication record (heading)
- The current time and date. This data is reported for information only, and is not kept in the BSDS.
Active log data set status
The BSDS records the status of an active log data set as one of the status values that are listed in the following table.
| Status | Meaning |
|---|---|
| NEW | The data set was defined but never used by Db2, or the log is truncated at a point before the data set was created. In either case, the data set starting and ending RBA values are reset to zero. |
| REUSABLE | Either the data set is new and has no records, or the data set was offloaded. In the print log map output, the start RBA value for the last REUSABLE data set is equal to the start RBA value of the last archive log data set. |
| NOT REUSABLE | The data set contains records that have not been offloaded. |
| STOPPED | The offload processor encountered an error while reading a record, and that record could not be obtained from the other copy of the active log. Alternatively, an error occurred during truncation of the data set following a write I/O error. |
| TRUNCATED | One of these conditions exists:
|
The status value for each active log data set is displayed in the print log map utility output, as shown in the following example output:
ACTIVE LOG COPY 1 DATA SETS
START RBA/LRSN/TIME END RBA/LRSN/TIME DATE/LTIME DATA SET INFORMATION
---------------------- ---------------------- ---------- --------------------
00000000000026A05000 00000000000027DB4FFF 2011.122 DSN=DSNC000.DB2A.LOGCOPY1.DS02
00C9FAE422D486000000 00C9FAE427BF40000000 16:49 STATUS=REUSABLE
2012.219 19:35:03.9 2012.219 19:35:09.0
00000000000027DB5000 00000000000028B65FFF 2011.122 DSN=DSNC000.DB2A.LOGCOPY1.DS03
00C9FAE427BF40000000 00CA28653CDD94000000 16:49 STATUS=TRUNCATED, REUSABLE
2012.219 19:35:09.0 0000.000 00:00:00.0
00000000000028B66000 00000000000029F15FFF 2011.122 DSN=DSNC000.DB2A.LOGCOPY1.DS01
00CA28653CDD94000000 .................... 16:49 STATUS=REUSABLE
2012.256 00:12:15.8 ........ ..........Archive log command history
The print log map utility output also displays the archive log command history, as shown in the following example output.
ARCHIVE LOG COMMAND HISTORY
20:51:19 SEPTEMBER 12, 2012
DATE TIME RBA MODE WAIT TIME
------------ ---------- -------------------- ------- ---- -----
SEP 12, 2012 20:50:57.4 0000000000007FA73A2E QUIESCE YES 5 D
SEP 12, 2012 20:50:49.3 0000000000007FA6F35E
SEP 12, 2012 20:50:44.8 0000000000007FA6ACC2 QUIESCE NO 5 D
SEP 12, 2012 20:50:39.9 0000000000007FA66543 The values in the TIME column represent the time that the ARCHIVE LOG command was issued. This time value is saved in the BSDS and is converted to printable format at the time that the print log map utility is run. Therefore, this value, when printed, can differ from other time values that were recorded concurrently. Some time values are converted to printable format when they are recorded, and then they are saved in the BSDS. These printed values remain the same when the printed report is run.
Reading conditional restart control records
The print log map utility also lists information about each conditional restart control record and each checkpoint. A sample description of a checkpoint record in the queue is shown in the following example output.
CHECKPOINT QUEUE
19:31:37 SEPTEMBER 12, 2012
TIME OF CHECKPOINT 19:31:26 SEPTEMBER 12, 2012
BEGIN CHECKPOINT RBA 00000000000028C12842
END CHECKPOINT RBA 00000000000028C16B7A
END CHECKPOINT LRSN 00CA296855DA8EB58000
TIME OF CHECKPOINT 19:31:20 SEPTEMBER 12, 2012
BEGIN CHECKPOINT RBA 00000000000028C0C280
END CHECKPOINT RBA 00000000000028C1057A
END CHECKPOINT LRSN 00CA29684FE13EFAC000
TIME OF CHECKPOINT 19:31:06 SEPTEMBER 12, 2012
BEGIN CHECKPOINT RBA 00000000000028C059FE
END CHECKPOINT RBA 00000000000028C09C7A
END CHECKPOINT LRSN 00CA29684275C34C4000
...
TIME OF CHECKPOINT 19:34:52 AUGUST 06, 2012
BEGIN CHECKPOINT RBA 000000000000243F3D36
END CHECKPOINT RBA 000000000000243F8C26
END CHECKPOINT LRSN 00C9FAE41852F2000000A sample description of a conditional restart control record is shown in the following example output.
CRCR IDENTIFIER 0001
USE COUNT 0
RECORD STATUS
CRCR NOT ACTIVE
CRCR NOT USED
PROCESSING STATUS
FORWARD = YES
BACKOUT = YES
STARTRBA NOT SPECIFIED
ENDRBA NOT SPECIFIED
ENDLRSN NOT SPECIFIED
ENDTIME NOT SPECIFIED
EARLIEST REQUESTED RBA 00000000000000000000
FIRST LOG RECORD RBA 00000000000000000000
ORIGINAL CHECKPOINT RBA 00000000000000000000
NEW CHECKPOINT RBA (CHKPTRBA) 00000FF00000000FF000
CRCR CREATED 18:13:54 SEPTEMBER 12, 2012
RESTART PROGRESS STARTED ENDED
======= =====
CURRENT STATUS REBUILD NO NO
FORWARD RECOVERY PHASE NO NO
BACKOUT RECOVERY PHASE NO NO
CRCR IDENTIFIER 0002
USE COUNT 1
RECORD STATUS
CRCR NOT ACTIVE
SUCCESSFUL RESTART
PROCESSING STATUS
COLD START (STARTRBA = ENDRBA)
FORWARD = NO
BACKOUT = NO
STARTRBA 00000000000012F05000
ENDRBA 00000000000012F05000
ENDLRSN NOT SPECIFIED
ENDTIME NOT SPECIFIED
EARLIEST REQUESTED RBA 00000000000000000000
FIRST LOG RECORD RBA 00000000000000000000
ORIGINAL CHECKPOINT RBA 00000000000000000000
NEW CHECKPOINT RBA (CHKPTRBA) NOT SPECIFIED
CRCR CREATED 23:49:14 MAY 02, 2011
BEGIN RESTART 23:51:43 MAY 02, 2011
END RESTART 23:52:04 MAY 02, 2011
RESTART PROGRESS STARTED ENDED
======= =====
CURRENT STATUS REBUILD YES YES
FORWARD RECOVERY PHASE YES YES
BACKOUT RECOVERY PHASE YES YESSystem-level backup information
The print log map utility also displays information about system-level backup copies that are created by the BACKUP SYSTEM utility. An example of system-level backup information is shown in the following figure.
BACKUP SYSTEM UTILITY HISTORY
SUBSYSTEM ID DB2A
17:04:03 AUGUST 08, 2014
START STCK DATA COMPLETE DATA/LOG COMPLETE
DATA LOG RBLP LRSN DATE LTIME
---------------- ---------------- -------------------- -------------------- --------------------
CD931537CA6A07E4 CD931538D10F85B8 000000000000A5140114 000000000000A51A0411 2014/08/08 09:53:19
TOKEN = C4C2F2C1CD931537CA6A07E40000A5140114 TYPE=I
Z/OS 2.01 CAT=YES
LOCATION NAME = ALTERNATE1
CD93150C1F3D0740 CD93150DADBC3348 000000000000A5102AC5 000000000000A515079F 2014/08/08 09:52:34
TOKEN = C4C2F2C1CD93150C1F3D07400000A5102AC5 TYPE=I
Z/OS 2.01 CAT=YES
LOCATION NAME = ALTERNATE1
CD93124D9A983334 0000000000000000 000000000000A50079AA 000000000000A50C458B 2014/08/08 09:40:18
TOKEN = C4C2F2C1CD93124D9A9833340000A50079AA
Z/OS 2.01 CAT=YES
LOCATION NAME = ALTERNATE1
For each system-level
backup, you can use the listed location name to determine the copy pool that is associated
with it. In the preceding example, the first system-level backup that is listed uses copy
pool DSN$ALTERNATE1$DB, which is an alternate database copy pool. For more information about
the Db2 naming convention for copy
pools, see Copy pools.
When a log copy pool is restored, accurate date and time values are not displayed for the system-level backup that is used to restore the copy pool. Instead, the DATA/LOG DATE value is displayed as 0000/00/00, and the COMPLETE LTIME value is displayed as 00:00:00. The reason is that this information is not recorded in the BSDS until after the system-level backup is complete. Therefore, this information is not available at the time that the backup copy of the BSDS is made.
The following figure shows an example of an incremental system-level backup. TYPE applies to only the database copy pool history entries.
BACKUP SYSTEM UTILITY HISTORY
SUBSYSTEM ID DB2A
00:05:08 SEPTEMBER 14, 2012
START STCK DATA COMPLETE
DATA LOG RBLP LRSN
---------------- ---------------- -------------------- --------------------
CA2AC09F0F4456A0 0000000000000000 0000000000007FADA6AC 0000000000007FB42C2C
TOKEN = C4C2F2C1CA2AC09F0F4456A000007FADA6AC
Z/OS 1.13 CAT=YES
LOCATION NAME = STLEC1
CA2AC09B25879868 0000000000000000 0000000000007FAB97E2 0000000000007FB0B9B4
TOKEN = C4C2F2C1CA2AC09B2587986800007FAB97E2
Z/OS 1.13 CAT=YES
LOCATION NAME = STLEC1
CA2AC096C479E0E8 0000000000000000 0000000000007FA5C090 0000000000007FAD1A28
TOKEN = C4C2F2C1CA2AC096C479E0E800007FA5C090 TYPE=I
Z/OS 1.13 CAT=YES
LOCATION NAME = STLEC1