Example 13: Using the LOGSCAN command


Example 13 illustrates the use of the LOGSCAN command. LOGSCAN gathers information about log records that you can use to determine your recovery strategy.

The LOGSCAN command uses the SYSSCAN DD statement included in this example to designate output for the report that the LOGSCAN command generates.

JCL using the LOGSCAN command

//AFREX13 JOB (PAFR),'EXAMPLE 13',
//        CLASS=Q,NOTIFY=&SYSUID,
//        MSGCLASS=X
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
//             PARM='DEJM,EXAMPLE13,NEW/RESTART,MSGLEVEL(2)'
//STEPLIB  DD DISP=SHR,DSN=product.libraries
//         DD DISP=SHR,DSN=DB2.DSNEXIT
//         DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN    DD *
 OPTIONS INDEXLOG YES
 LOGSCAN TABLESPACE BMCDBSMP.BMCTS011
         INDEXSPACE BMCDBSMP.BMCIX011
   TOLOGPOINT LASTQUIESCE  
/*
//SYSSCAN  DD SYSOUT=*
//

The SYSSCAN output produced by running this JCL is shown in the following figure. AFRPRINT and AFRPR001 are shown in the figure, AFRPRINT, and AFRPR001, below. See the table in, BMC-AMI-Recover-data-sets-and-BMC-AMI-Recover-DD-statements, for a description of each of these files.


SYSSCAN for the LOGSCAN command

BMC40018I BMC AMI Recover for Db2 V13.1.00    (SYSSCAN)                             
BMC40860I                            LOG SORT STATISTICS (LOGSCAN)                  
BMC40861I                                03/04/2022 20:13:41                        
                                                                                   
BMC40512I LOG FILE RESOURCES:                                                       
BMC40302I    DSN = DEJMCAT.ARCHLOG1.A0103673                                        
                                                                                   
BMC40566I    USING LOG DEJMCAT.ARCHLOG1.A0103673 FOR PROCESSING                     
BMC40555I       FROMRBA  = X'0000000024D423601000'  TORBA  = X'0000000024D42365E3A4'
                                                                                   
                                                                                   
BMC40850I OBJECT                      TYPE PART      #RECS     #BYTES               
                                                                                   
BMC40851I BMCDBSMP.BMCTS011            TS   001        698      54475               
BMC40851I BMCDBSMP.BMCIX011            IX   000        256      34816               
                                                                                   
BMC40852I TOTAL                                        954      89291               
                                                                                   
BMC40853I NUMREC EST 954 AVGRECSZ 93                                                

AFRPRINT and AFRPR001

BMC40018I BMC AMI Recover for Db2 V13.1.00    (RECOVER  AFRPR001)                                                                  
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2023                                                                                    
BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 7,933,927 8,161,001 8,671,076 8,818,949      
          8,843,449 9,152,659 9,753,811 10,366,074 AND 10,565,070                                                                  
BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM                                                        
                                                                                                                                  
                                                                                                                                  
                                                                                                                                  
BMC40016I LOGSCAN PHASE STARTING 03/04/2022 20:13:41                                                                               
BMC96304I THIS PHASE WILL RUN IN EXECUTION SUBTASK 1                                                                               
BMC40020I ZIIP SRB SCHEDULED                                                                                                       
BMC40954I AVAILABLE MEMORY BELOW THE LINE = 8680K, TOTAL AVAILABLE MEMORY (AT LEAST) = 1033088K                                    
BMC40441I BMCSORT PRODUCT LOCATED AND WILL BE USED                                                                                 
BMC40020I ORG-TOT:23658308, 49411548, 49411548;ITER: 1; RC:4                                                                       
BMC40020I SYSEVENT STGTEST STORAGE AVAILABLE = 49411548                                                                            
BMC40020I MEMLIMIT = 0 ATB USED = 21 ATB AVAIL (MB) = 4342                                                                         
BMC40020I OPT-SOPT:SBEL:262144; ABOV:1051967488; HYPR:2147482624; REAS:0; MMEM:0;  NUMS:1; SEAD:40D14008; RSV1:0;                  
BMC40020I OPT-SENT:AVGR:1000; FSZ:       385; SBEL:262144; ABOV:1052229632; HYPR:124;  DATA:0; KEYL:21; RSRV:0; FLG1:80; FLG2:40   
BMC40020I SORT FILE SIZE = 385, SORT MEMORY = 2000000 (262144,2262144,124(0M),0(0M))                                               
BMC40725I PROCESSING LOG RANGE:                                                                                                    
BMC40302I          DSN = DEJMCAT.ARCHLOG1.A0103673                                                                                 
BMC40555I          FROMRBA  = X'0000000024D423601000'  TORBA  = X'0000000024D42365E3A4'                                            
BMC40193I 3 LOG DATASET BUFFERS OF 1032192 BYTES EACH WERE ALLOCATED                                                               
BMC40302I          DSN = DEJMCAT.ARCHLOG1.A0103673                                                                                 
BMC40352I DDNAME SYS00004 (DSN DEJMCAT.ARCHLOG1.A0103673) WAS SUCCESSFULLY UNALLOCATED                                             
                                                                                                                                  
                                                                                                                                  
BMC40117I **********     PERFORMANCE STATISTICS FROM LOG READ STEP     **********                                                  
                                                                                                                                  
BMC40120I      1 FILES READ     12282 I/O WAITS        I/O WAIT TIME = 00:00:00                                                    
BMC40175I                       197 WAITS FOR THREAD     WAIT TIME = 00:00:01                                                      
BMC40172I                       954 LOG RECORDS AND 89291 BYTES OF LOG DATA PROCESSED                                              
                                                                                                                                  
BMC40302I          DSN = DEJMCAT.ARCHLOG1.A0103673                                                                                 
BMC40173I                       TIME SPENT IN DATASET ALLOCATION = 00:00:00                                                        
BMC40174I                       12282 I/O WAITS    I/O WAIT TIME = 00:00:00                                                        
BMC40172I                       954 LOG RECORDS AND 89291 BYTES OF LOG DATA PROCESSED  
BMC40484I MESSAGES FROM PHASE SUBTASK:                                                                          
                                                                                                               
BMC40350I DATA SET DEJMCAT.ARCHLOG1.A0103673 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00004 ELAPSED = 00:00:00   
                                                                                                               
BMC40485I END OF PHASE SUBTASK MESSAGES                                                                         


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*