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.
  • Start of changeInformation about members of a data sharing group, including deactivated members and destroyed members whose slots were reclaimed.End of change

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.
Figure 1. Sample print log map utility output 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.
Figure 2. Sample print log map utility output for members 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                                                        
 

...
Start of changeExample DSNJU004 output for deactivated and destroyed membersEnd of change
Start of changeThe sample print log map utility output in the following figure is for a deactivated member and a destroyed member of a data sharing group.Start of change
Figure 3. Sample print log map utility output for deactivated and destroyed members of a data sharing group
End of change Start of change
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 
End of change End of change

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.

Table 1. Statuses of active log data sets
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:
  • An I/O error occurred, and DB2 stopped writing to this data set. The active log data set is offloaded, beginning with the starting RBA and continuing to the last valid record segment in the truncated active log data set. (The RBA of the last valid record segment is less than the ending RBA of the active log data set.) Logging is switched to the next available active log data set and continues uninterrupted.
  • The log was truncated by a conditional restart at a point within the data set RBA range.
  • The DB2 ARCHIVE LOG command was issued while this data set was the current active log data set.

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:

Figure 4. Portion of print log map utility output that shows active log data set status
ACTIVE LOG COPY 1 DATA SETS
    START RBA/TIME         END RBA/TIME        DATE    LTIME DATA SET INFORMATION
 --------------------  --------------------  --------  ----- --------------------
   00000316C000           0000031ABFFF       2001.045  14:39 DSN=DSNC810.LOGCOPY1.DS02
 2003.346  16:20:49.6  2003.346  16:21:23.7  PASSWORD=(NULL) STATUS=TRUNCATED, REUSABLE
   0000031AC000           0000031B1FFF       2001.045  14:39 DSN=DSNC810.LOGCOPY1.DS03
 2003.346  16:21:23.7  2003.346  16:21:23.8  PASSWORD=(NULL) STATUS=TRUNCATED, REUSABLE
   0000031B2000           000003535FFF       2001.045  14:39 DSN=DSNC810.LOGCOPY1.DS01
 2003.346  16:21:23.8  ........  ..........  PASSWORD=(NULL) STATUS=NOTREUSABLE

Archive log command history

The print log map utility output also displays the archive log command history, as shown in the following figure.

Figure 5. Portion of print log map utility output that shows archive log command history
                     ARCHIVE LOG COMMAND HISTORY
                      16:36:54 DECEMBER 12, 2003
   DATE          TIME          RBA         MODE   WAIT   TIME
------------  ----------  ------------   -------  ----   -----
DEC 12, 2003  16:35:47.8  000004FC89E5   QUIESCE  YES    999
DEC 12, 2003  16:31:49.5  00000453F379
DEC 12, 2003  16:21:23.8  0000031B1388
DEC 12, 2003  16:21:23.7  0000031AB392
DEC 12, 2003  16:20:49.6  00000316B000
DEC 12, 2003  16:20:49.5  000003167000
                

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.

Figure 6. Sample print log map description of checkpoints
                          CHECKPOINT QUEUE                  
                      15:54:57 FEBRUARY 04, 2003            
      TIME OF CHECKPOINT       15:54:37 FEBRUARY 04, 2003   
      BEGIN CHECKPOINT RBA            0000400000EC
      END CHECKPOINT RBA              00004000229A            
      TIME OF CHECKPOINT       15:53:44 FEBRUARY 04, 2003     
      BEGIN CHECKPOINT RBA            00000B39E1EC            
      END CHECKPOINT RBA              00000B3A80A6            
      SHUTDOWN CHECKPOINT                                     
      TIME OF CHECKPOINT       15:49:40 FEBRUARY 04, 2003     
      BEGIN CHECKPOINT RBA            00000B2E33E5            
      END CHECKPOINT RBA              00000B2E9C88            
      ...       
      TIME OF CHECKPOINT       21:06:01 FEBRUARY 03, 2003     
      BEGIN CHECKPOINT RBA            00000A7AA19C            
      END CHECKPOINT RBA              00000A82C998 

A sample description of a conditional restart control record is shown in the following figure.

Figure 7. Sample print log map description of a CRCR
  CRCR IDENTIFIER  0001                               
      USE COUNT   1                                  
      RECORD STATUS                                  
          CRCR NOT ACTIVE                            
          SUCCESSFUL RESTART                         
      PROCESSING STATUS                              
          COLD START (STARTRBA = ENDRBA)             
          FORWARD =  NO                              
          BACKOUT =  NO                              
      STARTRBA                        000040000000   
      ENDRBA                          000040000000   
      ENDLRSN                         NOT SPECIFIED  
      EARLIEST REQUESTED RBA          000000000000           
      FIRST LOG RECORD RBA            000000000000           
      ORIGINAL CHECKPOINT RBA         000000000000          
      NEW CHECKPOINT RBA (CHKPTRBA)   NOT SPECIFIED          
      CRCR CREATED             15:54:13 FEBRUARY 04, 2003    
      BEGIN RESTART            15:54:26 FEBRUARY 04, 2003    
      END RESTART              15:54:37 FEBRUARY 04, 2003    
      RESTART PROGRESS                 STARTED     ENDED     
                                       =======     =====     
          CURRENT STATUS REBUILD         YES        YES      
          FORWARD RECOVERY PHASE         YES        YES      
          BACKOUT RECOVERY PHASE         YES        YES      

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.

Figure 8. System-level backup information
Start of change
                    BACKUP SYSTEM UTILITY HISTORY                               
                          SUBSYSTEM ID VA1A                                     
                      21:14:06 APRIL 09, 2010                                   
            START STCK                            DATA COMPLETE   DATA/LOG COMPLETE
     DATA               LOG             RBLP          LRSN         DATE      LTIME    LOCATION NAME
----------------  ----------------  ------------  ------------  --------------------  ----------------
C5CE48D1DAAC867B  0000000000000000  1000000000EC  100000002672  2010/04/09  14:13:32  STLEC1
                 TOKEN = E5C1F1C1C5CE48D1DAAC867B1000000000EC                   
                 Z/OS 1.11  CAT=YES                                             
C5CE46CE5CE85B79  0000000000000000  00006C782090  00006C784AE0  2010/04/09  14:04:33  STLEC1
                 TOKEN = E5C1F1C1C5CE46CE5CE85B7900006C782090                   
                 Z/OS 1.11  CAT=YES
End of change

Start of changeWhen 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.End of change

The following figure shows an example of an incremental system-level backup. TYPE applies to only the database copy pool history entries.

Figure 9. System-level backup information as an incremental copy
Start of change
                    BACKUP SYSTEM UTILITY HISTORY    
                          SUBSYSTEM ID DJ1G      
                      18:30:01 SEPTEMBER 24, 2006   
            START STCK                            DATA COMPLETE
     DATA               LOG             RBLP          LRSN
----------------  ----------------  ------------  ------------  
BA11432778C9156E  0000000000000000  BA1142E6B5BA  BA1142E6B5BA
                 TOKEN = C4D1F1C7BA11432778C9156EBA1142E6B5BA
                 Z/OS 1.11  CAT=YES
BA11359200B23C4E  0000000000000000  BA1133661984  BA113392C3CE
                 TOKEN = C4D1F1C7BA11432778C9156EBA1142E6B5BA   TYPE=I
                 Z/OS 1.11  CAT=YES
End of change