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. For a description of this output, see Figure 6.
- 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 RBA or LRSN when the subsystem was converted to enabling-new-function mode.
- 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 LOG MAP OF BSDS DATA SET COPY 1, DSN=DSNC910.BSDS01 LTIME INDICATES LOCAL TIME, ALL OTHER TIMES ARE GMT. DATA SHARING MODE IS OFF SYSTEM TIMESTAMP - DATE=2007.011 LTIME=18:58:19.11 UTILITY TIMESTAMP - DATE=2007.008 LTIME= 0:19:33.53 VSAM CATALOG NAME=DSNC910 HIGHEST RBA WRITTEN 0000384B7A15 2007.011 06:27:04.4 HIGHEST RBA OFFLOADED 000000000000 RBA WHEN CONVERTED TO V4 000000000000 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: 000000000000 **** DISTRIBUTED DATA FACILITY **** COMMUNICATION RECORD 04:44:04 JANUARY 12, 2007 LOCATION=STLEC1 IPNAME=(NULL) PORT=446 SPORT=NULL RPORT=5001 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 -------------------- -------------------- -------- ----- -------------------- 000036C18000 0000375EFFFF 2005.263 17:36 DSN=DSNC910.LOGCOPY1.DS03 2007.008 21:51:30.7 2007.008 22:07:30.7 PASSWORD=(NULL) STATUS=REUSABLE 0000375F0000 000037FC7FFF 2005.263 17:36 DSN=DSNC910.LOGCOPY1.DS01 2007.008 22:07:30.7 2007.008 22:13:15.5 PASSWORD=(NULL) STATUS=REUSABLE 000037FC8000 00003899FFFF 2005.263 17:36 DSN=DSNC910.LOGCOPY1.DS02 2007.008 22:13:15.5 ........ .......... PASSWORD=(NULL) STATUS=REUSABLE ARCHIVE LOG COPY 1 DATA SETS NO ARCHIVE DATA SETS DEFINED FOR THIS COPY ACTIVE LOG COPY 2 DATA SETS START RBA/TIME END RBA/TIME DATE LTIME DATA SET INFORMATION -------------------- -------------------- -------- ----- -------------------- 000036C18000 0000375EFFFF 2005.263 17:36 DSN=DSNC910.LOGCOPY2.DS03 2007.008 21:51:30.7 2007.008 22:07:30.7 PASSWORD=(NULL) STATUS=REUSABLE 0000375F0000 000037FC7FFF 2005.263 17:36 DSN=DSNC910.LOGCOPY2.DS01 2007.008 22:07:30.7 2007.008 22:13:15.5 PASSWORD=(NULL) STATUS=REUSABLE 000037FC8000 00003899FFFF 2005.263 17:36 DSN=DSNC910.LOGCOPY2.DS02 2007.008 22:13:15.5 ........ .......... PASSWORD=(NULL) STATUS=REUSABLE ARCHIVE LOG COPY 2 DATA SETS NO ARCHIVE DATA SETS DEFINED FOR THIS COPY DSNJ401I DSNRJPCR RESTART CONTROL RECORD NOT FOUND CHECKPOINT QUEUE 04:44:05 JANUARY 12, 2007 TIME OF CHECKPOINT 02:58:33 JANUARY 12, 2007 BEGIN CHECKPOINT RBA 0000384B8090 END CHECKPOINT RBA 0000384BA4C0 END CHECKPOINT STCK BFFDF5B0AE7C TIME OF CHECKPOINT 06:26:54 JANUARY 11, 2007 BEGIN CHECKPOINT RBA 0000384B3F31 END CHECKPOINT RBA 0000384B7A15 END CHECKPOINT STCK BFFCE26E2478 SHUTDOWN CHECKPOINT TIME OF CHECKPOINT 04:06:56 JANUARY 11, 2007 BEGIN CHECKPOINT RBA 0000384AB000 END CHECKPOINT RBA 0000384AD7BE END CHECKPOINT STCK BFFCC31B6815 TIME OF CHECKPOINT 20:07:35 JANUARY 10, 2007 BEGIN CHECKPOINT RBA 000038484198 END CHECKPOINT RBA 00003848761A END CHECKPOINT STCK BFFC57F6EC70 TIME OF CHECKPOINT 20:06:49 JANUARY 10, 2007 BEGIN CHECKPOINT RBA 000038449F2E END CHECKPOINT RBA 00003844D3C0 END CHECKPOINT STCK BFFC57CB6CFD TIME OF CHECKPOINT 19:54:11 JANUARY 10, 2007 BEGIN CHECKPOINT RBA 0000384098E4 END CHECKPOINT RBA 00003840C0B8 END CHECKPOINT STCK BFFC54F80848 . . .
BEGIN CHECKPOINT RBA 000035CBA4FD END CHECKPOINT RBA 000035CBE608 END CHECKPOINT STCK BF2025C5621E TIME OF CHECKPOINT 16:51:36 JULY 19, 2006 BEGIN CHECKPOINT RBA 000035C3FDAF END CHECKPOINT RBA 000035C43EC4 END CHECKPOINT STCK BF2025C50CEA TIME OF CHECKPOINT 16:51:36 JULY 19, 2006 BEGIN CHECKPOINT RBA 000035C0D767 END CHECKPOINT RBA 000035C11760 END CHECKPOINT STCK BF2025C4E1F8 TIME OF CHECKPOINT 16:51:36 JULY 19, 2006 BEGIN CHECKPOINT RBA 000035BE8240 END CHECKPOINT RBA 000035BEC302 END CHECKPOINT STCK BF2025C4C7D5 TIME OF CHECKPOINT 16:51:35 JULY 19, 2006 BEGIN CHECKPOINT RBA 000035BB82AB END CHECKPOINT RBA 000035BCBB6A END CHECKPOINT STCK BF2025C4B137 TIME OF CHECKPOINT 16:48:56 JULY 19, 2006 BEGIN CHECKPOINT RBA 000035B5EA64 END CHECKPOINT RBA 000035B61BC4 END CHECKPOINT STCK BF20252C3DE4 DSNJ401I DSNJU104 ARCHIVE LOG COMMAND HISTORY RECORD NOT FOUND DSNJ401I DSNUPBHR BACKUP SYSTEM UTILITY HISTORY RECORD NOT FOUND SYSTEM CCSIDS 04:44:05 JANUARY 12, 2007 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 'V91A ' OF GROUP 'DSNCAT '. * * * ***************************************************************************************** DSNJCNVB CONVERSION PROGRAM HAS RUN DDNAME=SYSUT1 LOG MAP OF BSDS DATA SET COPY 1, DSN=DSNC910.BSDS01 LTIME INDICATES LOCAL TIME, ALL OTHER TIMES ARE GMT. DATA SHARING MODE IS ON SYSTEM TIMESTAMP - DATE=2006.299 LTIME= 8:58:20.49 UTILITY TIMESTAMP - DATE=2007.012 LTIME=10:00:20.82 VSAM CATALOG NAME=DSNC910 HIGHEST RBA WRITTEN 00002B7458B4 2006.299 15:58:04.9 HIGHEST RBA OFFLOADED 000000000000 RBA WHEN CONVERTED TO V4 00000CF0F0A6 MAX RBA FOR TORBA 00000CF0F0A6 MIN RBA FOR TORBA 000000000000 STCK TO LRSN DELTA 000000000000 THIS BSDS HAS MEMBER RECORDS FOR THE FOLLOWING MEMBERS: HOST MEMBER NAME: V91A MEMBER ID: 1 GROUP NAME: DSNCAT BSDS COPY 1 DATA SET NAME: DSNC910.BSDS01 BSDS COPY 2 DATA SET NAME: DSNC910.BSDS02 ENFM START RBA/LRSN: 000000000000 MEMBER NAME: V91B MEMBER ID: 2 GROUP NAME: DSNCAT BSDS COPY 1 DATA SET NAME: DSNC918.BSDS01 BSDS COPY 2 DATA SET NAME: DSNC918.BSDS02 **** DISTRIBUTED DATA FACILITY **** COMMUNICATION RECORD 18:05:25 JANUARY 12, 2007 LOCATION=STLEC1 IPNAME=(NULL) PORT=446 SPORT=NULL RPORT=5001 ALIAS=(NULL) IPV4=NULL IPV6=NULL GRPIPV4=NULL GRPIPV6=NULL LUNAME=SYEC1DB2 PASSWORD=DB2PW1 GENERICLU=SYEC1GLU ACTIVE LOG COPY 1 DATA SETS START RBA/LRSN/TIME END RBA/LRSN/TIME DATE LTIME DATA SET INFORMATION -------------------- -------------------- -------- ----- -------------------- 000029DB8000 00002A78FFFF 2005.263 17:36 DSN=DSNC910.LOGCOPY1.DS01 BF215D6C20F3 BF215E3D8600 PASSWORD=(NULL) STATUS=REUSABLE 2006.201 16:05:55.0 2006.201 16:09:34.6 00002A790000 00002B167FFF 2005.263 17:36 DSN=DSNC910.LOGCOPY1.DS02 BF215E3D8600 BF2168CB4F59 PASSWORD=(NULL) STATUS=REUSABLE 2006.201 16:09:34.6 2006.201 16:56:47.6 00002B168000 00002BB3FFFF 2005.263 17:36 DSN=DSNC910.LOGCOPY1.DS03 BF2168CB4F59 ............ PASSWORD=(NULL) STATUS=REUSABLE 2006.201 16:56:47.6 ........ .......... ARCHIVE LOG COPY 1 DATA SETS NO ARCHIVE DATA SETS DEFINED FOR THIS COPY
ACTIVE LOG COPY 2 DATA SETS START RBA/LRSN/TIME END RBA/LRSN/TIME DATE LTIME DATA SET INFORMATION -------------------- -------------------- -------- ----- -------------------- 000029DB8000 00002A78FFFF 2005.263 17:36 DSN=DSNC910.LOGCOPY2.DS01 BF215D6C20F3 BF215E3D8600 PASSWORD=(NULL) STATUS=REUSABLE 2006.201 16:05:55.0 2006.201 16:09:34.6 00002A790000 00002B167FFF 2005.263 17:36 DSN=DSNC910.LOGCOPY2.DS02 BF215E3D8600 BF2168CB4F59 PASSWORD=(NULL) STATUS=REUSABLE 2006.201 16:09:34.6 2006.201 16:56:47.6 00002B168000 00002BB3FFFF 2005.263 17:36 DSN=DSNC910.LOGCOPY2.DS03 BF2168CB4F59 ............ PASSWORD=(NULL) STATUS=REUSABLE 2006.201 16:56:47.6 ........ .......... ARCHIVE LOG COPY 2 DATA SETS NO ARCHIVE DATA SETS DEFINED FOR THIS COPY DSNJ401I DSNRJPCR RESTART CONTROL RECORD NOT FOUND CHECKPOINT QUEUE 18:05:25 JANUARY 12, 2007 TIME OF CHECKPOINT 15:57:53 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B742232 END CHECKPOINT RBA 00002B7458B4 END CHECKPOINT LRSN BF9C9272E481 SHUTDOWN CHECKPOINT TIME OF CHECKPOINT 15:38:07 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B73BEDE END CHECKPOINT RBA 00002B73E458 END CHECKPOINT LRSN BF9C8DFC9AE2 END CHECKPOINT LRSN BF9C8DFC9AE2 TIME OF CHECKPOINT 14:45:29 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B72F57E END CHECKPOINT RBA 00002B731ABA END CHECKPOINT LRSN BF9C8238F7F6 TIME OF CHECKPOINT 13:52:34 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B722C78 END CHECKPOINT RBA 00002B725152 END CHECKPOINT LRSN BF9C7664E895 TIME OF CHECKPOINT 12:59:07 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B716C2B END CHECKPOINT RBA 00002B719402 END CHECKPOINT LRSN BF9C6A7355D2 TIME OF CHECKPOINT 12:05:55 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B708488 END CHECKPOINT RBA 00002B70A9B8 END CHECKPOINT LRSN BF9C5E8E6C30 TIME OF CHECKPOINT 11:13:16 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B6FBB22 END CHECKPOINT RBA 00002B6FE0A6 END CHECKPOINT LRSN BF9C52CA437D TIME OF CHECKPOINT 10:20:21 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B6EF344 END CHECKPOINT RBA 00002B6F180A END CHECKPOINT LRSN BF9C46F69881 TIME OF CHECKPOINT 09:26:54 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B6E3344 END CHECKPOINT RBA 00002B6E5ABA END CHECKPOINT LRSN BF9C3B03EEA6 TIME OF CHECKPOINT 08:34:36 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B6D6662 END CHECKPOINT RBA 00002B6D8DC0 END CHECKPOINT LRSN BF9C2F539652 TIME OF CHECKPOINT 07:40:44 OCTOBER 26, 2006 BEGIN CHECKPOINT RBA 00002B6CA000 END CHECKPOINT RBA 00002B6CC55A END CHECKPOINT LRSN BF9C23487986 . . .
TIME OF CHECKPOINT 23:40:10 JULY 19, 2006 BEGIN CHECKPOINT RBA 000029CB7E8B END CHECKPOINT RBA 000029CBA65C END CHECKPOINT LRSN BF208117E71F DSNJ401I DSNJU104 ARCHIVE LOG COMMAND HISTORY RECORD NOT FOUND DSNJ401I DSNUPBHR BACKUP SYSTEM UTILITY HISTORY RECORD NOT FOUND SYSTEM CCSIDS 18:05:25 JANUARY 12, 2007 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 ...
- 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=GROUP LOG MAP OF BSDS DATA SET COPY 1, DSN=DSNC000.THIRD.BSDS01 LTIME INDICATES LOCAL TIME, ALL OTHER TIMES ARE GMT. DATA SHARING MODE IS ON SYSTEM TIMESTAMP - DATE=2011.049 LTIME=11:51:10.29 UTILITY TIMESTAMP - DATE=2011.048 LTIME=10:55:24.36 VSAM CATALOG NAME=DSNC000 HIGHEST RBA WRITTEN 00000013D130 0000.000 00:00:00.0 HIGHEST RBA OFFLOADED 000000000000 RBA WHEN CONVERTED TO V4 000000000000 MAX RBA FOR TORBA 000002000000 MIN RBA FOR TORBA 000000000000 STCK TO LRSN DELTA 000000000000 THIS BSDS HAS MEMBER RECORDS FOR THE FOLLOWING MEMBERS: HOST MEMBER NAME: VA1C MEMBER ID: 3 GROUP NAME: DSNCAT BSDS COPY 1 DATA SET NAME: DSNC000.THIRD.BSDS01 BSDS COPY 2 DATA SET NAME: DSNC000.THIRD.BSDS02 ENFM START RBA/LRSN: 000000000000 MEMBER NAME: DESTROYED MEMBER ID: 1 GROUP NAME: DSNCAT BSDS COPY 1 DATA SET NAME: BSDS COPY 2 DATA SET NAME: THIS MEMBER WAS DESTROYED ON 2011.049 AT 19:27:28.9 THIS MEMBER ID IS AVAILABLE FOR REUSE MEMBER NAME: VA1B MEMBER ID: 2 GROUP NAME: DSNCAT BSDS COPY 1 DATA SET NAME: DSNC008.BSDS01 BSDS COPY 2 DATA SET NAME: DSNC008.BSDS02 THIS MEMBER WAS DEACTIVATED ON 2011.049 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).
Figure 1 and Figure 2 show example output from the print log map utility. 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 that is shown in Figure 6:
- 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:
Archive log command history
The print log map utility output also displays the archive log command history, as shown in the following figure.
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 figure.
A sample description of a conditional restart control record is shown in the following figure.
System-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.
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.