Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Recover for Db2 13.1.

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

//AFREX15 JOB (PAFR),'EXAMPLE 13',
//        CLASS=Q,NOTIFY=&SYSUID,
//        MSGCLASS=X
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
//             PARM='DGE,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.BMCTS013
         INDEXSPACE BMCDBSMP.BMCIX013
   TOLOGPOINT LASTQUIESCE BACKOUT
/*
//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 V12.1.00
 BMC40860I                            LOG SORT STATISTICS (LOGSCAN)
 BMC40861I                                08/21/2014 17:45:41

 BMC40512I LOG FILE RESOURCES:
 BMC40302I    DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40302I    DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40302I    DSN = DSNDXW.DXW4.LOGCOPY1.DS03.DATA
 BMC40302I    DSN = DSNDXW.DXW2.LOGCOPY1.DS06.DATA

 BMC40566I    USING LOG DSNDXW.DXW1.LOGCOPY1.DS02.DATA FOR PROCESSING
 BMC40555I       FROMRBA  = X'000000000222C08A8000'  TORBA  = X'000000000222CB86FFFF'
 BMC40566I    USING LOG DSNDXW.DXW3.LOGCOPY1.DS02.DATA FOR PROCESSING
 BMC40555I       FROMRBA  = X'00000000018770CA3000'  TORBA  = X'0000000001877BC6AFFF'
 BMC40566I    USING LOG DSNDXW.DXW4.LOGCOPY1.DS03.DATA FOR PROCESSING
 BMC40555I       FROMRBA  = X'00000000015BA0F0D000'  TORBA  = X'00000000015BABED4FFF'
 BMC40566I    USING LOG DSNDXW.DXW2.LOGCOPY1.DS06.DATA FOR PROCESSING
 BMC40555I       FROMRBA  = X'0000000001C91E5FB000'  TORBA  = X'0000000001C9DFBBAFFF'
 BMC40189I THE 0 TAPE AND 4 DISK LOG FILES WILL BE READ IN 2 LOG READING STEPS BECAUSE MAXDRIVES = 0 AND MAXLOGS = 3


 BMC40850I OBJECT                      TYPE PART      #RECS     #BYTES

 BMC40851I BMCDBSMP.BMCTS014            TS   000          0          0
 BMC40851I BMCDBSMP.BMCIX014            IX   000          0          0

 BMC40852I TOTAL                                          0          0

 BMC40853I NUMREC EST 0 AVGRECSZ 0

AFRPRINT and AFRPR001

 BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2020
 BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 AND 8,161,001
 BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM

 BMC40018I BMC AMI Reover for Db2 V12.1.00
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2020
 BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 AND 8,161,001
 BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM



 BMC40016I LOGSCAN PHASE STARTING 08/21/2014 17:45:44
 BMC40725I PROCESSING LOG RANGE:
 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS06.DATA
 BMC40555I          FROMRBA  = X'0000000001C91E5FB000'  TORBA  = X'0000000001C9DFBBAFFF'
 BMC40724I          DATA SHARING MEMBERID IS 4
 BMC40725I PROCESSING LOG RANGE:
 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS03.DATA
 BMC40555I          FROMRBA  = X'00000000015BA0F0D000'  TORBA  = X'00000000015BABED4FFF'
 BMC40724I          DATA SHARING MEMBERID IS 3
 BMC40725I PROCESSING LOG RANGE:
 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40555I          FROMRBA  = X'000000000222C08A8000'  TORBA  = X'000000000222CB86FFFF'
 BMC40724I          DATA SHARING MEMBERID IS 1
 BMC40193I 3 LOG DATASET BUFFERS OF 348160 BYTES EACH WERE ALLOCATED
 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS03.DATA
 BMC40193I 3 LOG DATASET BUFFERS OF 348160 BYTES EACH WERE ALLOCATED
 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40193I 3 LOG DATASET BUFFERS OF 348160 BYTES EACH WERE ALLOCATED
 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS06.DATA
 BMC40352I DDNAME SYS00012 (DSN DSNDXW.DXW1.LOGCOPY1.DS02.DATA) WAS SUCCESSFULLY UNALLOCATED
 BMC40352I DDNAME SYS00010 (DSN DSNDXW.DXW4.LOGCOPY1.DS03.DATA) WAS SUCCESSFULLY UNALLOCATED
 BMC40352I DDNAME SYS00011 (DSN DSNDXW.DXW2.LOGCOPY1.DS06.DATA) WAS SUCCESSFULLY UNALLOCATED


 BMC40117I **********     PERFORMANCE STATISTICS FROM LOG READ STEP     **********

 BMC40120I      3 FILES READ     21542 I/O WAITS        I/O WAIT TIME = 00:00:30
 BMC40175I                       4 WAITS FOR THREAD     WAIT TIME = 00:00:00
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED

 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS06.DATA
 BMC40173I                       TIME SPENT IN DATASET ALLOCATION = 00:00:00
 BMC40174I                       21237 I/O WAITS    I/O WAIT TIME = 00:00:30
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED

 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS03.DATA
 BMC40173I                       TIME SPENT IN DATASET ALLOCATION = 00:00:00
 BMC40174I                       13 I/O WAITS    I/O WAIT TIME = 00:00:00
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED

 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40173I                       TIME SPENT IN DATASET ALLOCATION = 00:00:00
 BMC40174I                       292 I/O WAITS    I/O WAIT TIME = 00:00:00
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED

 BMC40725I PROCESSING LOG RANGE:
 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40555I          FROMRBA  = X'00000000018770CA3000'  TORBA  = X'0000000001877BC6AFFF'
 BMC40724I          DATA SHARING MEMBERID IS 2
 BMC40193I 3 LOG DATASET BUFFERS OF 348160 BYTES EACH WERE ALLOCATED
 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40352I DDNAME SYS00013 (DSN DSNDXW.DXW3.LOGCOPY1.DS02.DATA) WAS SUCCESSFULLY UNALLOCATED


 BMC40117I **********     PERFORMANCE STATISTICS FROM LOG READ STEP     **********

 BMC40120I      1 FILES READ     387 I/O WAITS        I/O WAIT TIME = 00:00:00
 BMC40175I                       9 WAITS FOR THREAD     WAIT TIME = 00:00:00
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED

 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40173I                       TIME SPENT IN DATASET ALLOCATION = 00:00:00
 BMC40174I                       387 I/O WAITS    I/O WAIT TIME = 00:00:00
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED


Related topics

Examples-of-BMC-AMI-Recover-jobs

Using-LOGSCAN-for-estimates



 

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