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 PACLOG for DB2 13.1.

Sample jobs

This topic provides sample PACLOG JCL. For additional sample jobs, see Examples-of-PACLOG-JCL.

The following figure shows a sample of a PACLOG job that processes a primary archive log data set and writes the filtered output to disk. The job completes after creating and cataloging the processed data set.

The BSDS, PACLOG messages and options, print files, and listings of processed log data sets and expired log data sets are all specified in the JCL by the DD statements described in previous topics.

The ALMIN DD statement specifies log processing options. By default, PACLOG compresses the processed log data set before writing it to the disk.

    MVSVXV1.RMD.JCL121.ALMMAIN.DOCOUT(PACLOG02) - 01.05               
 ===>                                                         
//* *************************************************************** */
//ALMMAIN EXEC PGM=ALMMAIN,                                           
//             PARM='DEFQ,ALMOPTS=ALM$OPTS'                           
//             REGION=4M                                              
//*     INCLUDE MEMBER=ALMSTEP                                        
//STEPLIB  DD DSN=RMD.TEST1210.BMCPSWD.ALM,DISP=SHR                   
//         DD DSN=RMD.TEST1210.UDBLINK,DISP=SHR                       
//         DD DSN=SCC.TEST1210.SCCLINK,DISP=SHR                       
//         DD DSN=SCC.TEST1210.BMCLINK,DISP=SHR                       
//         DD DSN=RMD.TEST1210.BMCLINK,DISP=SHR                       
//         DD  DSN=&DB2EXIT,DISP=SHR                    
//         DD  DSN=&DB2LOAD,DISP=SHR                         
//      INCLUDE MEMBER=ALMMSGS                                        
//ALMOPTS   DD *                                                      
DEFQ.HIST=ARM.DEFQ.HIST.VVR1210A                              
/*                                                                    
//ARMPRINT  DD SYSOUT=*                                               
//ARMERROR  DD SYSOUT=*                                               
//ALMERROR DD SYSOUT=*                                                
//ALMPRINT DD SYSOUT=*                                                
//ALMLIST1 DD SYSOUT=*                                                
//ALMLIST2 DD SYSOUT=*                                                
//ALMXPIRE DD SYSOUT=*                                            
//ALMIN    DD *                                      
  ARCHIVE3 PREFIX ARM.DALM3.DEFQL3                          
     TAPE UNIT CARTVTS
     FILTERTS (DB001.TS001.DB001.TS002)
     FILTERIX ALL FILTERRECTYPE ALL
     STACK YES RETPD 2                                                 
     TRTCH NOCOMP                                                      
  ARCHIVE4 PREFIX ARM.DALM3.DEFQL4                                     
     TAPE UNIT CARTVTS
     FILTERTS (DB001.TS001.DB001.TS002)
     FILTERIX ALL FILTERRECTYPE ALL
     STACK YES RETPD 2                                                 
     TRTCH NOCOMP                                                      
   LIMIT RBARANGE 0D191306D000 FFFFFFFFFFFF                            
   ZIIP ENABLED                    
/*                                                                     
//* *************************************************************** *//
//

The following figure echoes the ALMIN control statement from the JCL, provides progress reports on the operations performed by PACLOG, and provides the following statistics:

  • The percentage of compression
  • The filtered byte count for each filter option that is specified
  • The total filtered byte count
  • The total unfiltered byte count
  • The total processed byte count
  • The unfiltered byte count for uncommitted transactions
  • The unfiltered byte count for records that are required by Db2

Important

In jobs that process more than one log data set, separate statistics are provided for each one.

Sample job's print output

   MVSVXV1.RMD.JCL121.ALMMAIN.DOCOUT(PPAC121A) - 01.00                            
===>                                                                              
**   PACLOG  - V12.1.00  *****  BMC SOFTWARE, INC. *****  06/09/2016 17:44:32 **  
(c) COPYRIGHT 1994-2016 BMC SOFTWARE, INC.                                        
PACLOG TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBER 5761676                      
                                                                                 
BMC93223I MAINT:  NO PACLOG PTFS APPLIED                                          
BMC93223I SOLUTION COMMON CODE V12.1.00                                           
BMC93223I MAINT:  NO SCC PTFS APPLIED                                             
                                                                                 
BMC93799I OPTION SET ALM$OPTS LAST UPDATED 06/03/2016 14:19:39 BY MVSJDP2         
BMC93799I DBC SSID = DCSN  STARTED TASK = DBCRI101  JOBID = 0872851               
                                                                                 
  ARCHIVE3 PREFIX ARM.DALM3.DEFQL3                                                
     TAPE UNIT CARTVTS                                                            
     STACK YES RETPD 2                                                            
     TRTCH NOCOMP                                                                 
  ARCHIVE4 PREFIX ARM.DALM3.DEFQL4                                                
     TAPE UNIT CARTVTS                                                            
     STACK YES RETPD 2                                                            
     TRTCH NOCOMP                                                                 
   LIMIT RBARANGE 0D191306D000 FFFFFFFFFFFF                                       
   ZIIP ENABLED
BMC93799I ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMN                          
                                                                             
 BMC93649I BSDS ANALYSIS COMPLETE 06/09/2016 17:44:36                         
                                                                             
 BMC93799I USING HISTORY FILE DSN:ARM.DEFQ.HIST.VVR1210A
                                                                             
 BMC93649I HIST ANALYSIS COMPLETE 06/09/2016 17:44:36                         
                                                                             
 BMC93649I CKPT ANALYSIS COMPLETE 06/09/2016 17:44:36                         
                                                                             
                                                                             
                                                                             
 BMC93650I ARM.DALM3.DEFQL3.B0007875 CREATED FROM DEFQCAT.ARCHLOG1.B0007875   
                                                                             
 BMC93650I ARM.DALM3.DEFQL4.B0007875 CREATED FROM DEFQCAT.ARCHLOG1.B0007875   
                                                                             
 BMC93650I ARM.DALM3.DEFQL3.A0007875 CREATED FROM DEFQCAT.ARCHLOG1.A0007875   
 BMC93655I           0 BYTES NOT FILTERED - UNCOMMITTED                       
 BMC93655I   117824806 BYTES NOT FILTERED - REQUIRED BY DB2                   
 BMC93655I    56051550 BYTES FILTERED - INDEX                                 
 BMC93655I     4996020 BYTES FILTERED - RECTYPE                               
 BMC93655I   117824806 BYTES NOT FILTERED - TOTAL                             
 BMC93655I    61047570 BYTES FILTERED - TOTAL                                 
 BMC93655I   178872376 BYTES PROCESSED - TOTAL                                
                                                                            
 BMC93650I ARM.DALM3.DEFQL4.A0007875 CREATED FROM DEFQCAT.ARCHLOG1.A0007875   
 BMC93655I           0 BYTES NOT FILTERED - UNCOMMITTED                       
 BMC93655I   117824806 BYTES NOT FILTERED - REQUIRED BY DB2                   
 BMC93655I    56051550 BYTES FILTERED - INDEX                                 
 BMC93655I     4996020 BYTES FILTERED - RECTYPE                               
 BMC93655I   117824806 BYTES NOT FILTERED - TOTAL                             
 BMC93655I    61047570 BYTES FILTERED - TOTAL                                 
 BMC93655I   178872376 BYTES PROCESSED - TOTAL                                
                                                                            
 BMC93650I ARM.DALM3.DEFQL3.H0007875 CREATED FROM UPDATED ARCHIVE HISTORY     
                                                                            
 BMC93650I ARM.DALM3.DEFQL4.H0007875 CREATED FROM UPDATED ARCHIVE HISTORY     
                                                                            
 BMC93649I ARCHIVE LOG PROCESS COMPLETE 06/09/2016 17:44:43                   
  
 ...

The following figure shows the total number of records in the log for each record type.

Important

The record type numbers are described in the IBM Db2 administration guide.

Total log records by type (ALMLSTAT)

**   PACLOG  - V1.4.00   *****  BMC SOFTWARE, INC. *****  05/17/2006 1300010000
                                                                        00020000
  DEB2CAT.ARCHLOG1.D06137.T1238038.A0001368                             00030000
 BMC93656I RECORD TYPE 00020001 -         25 RECORDS TOTALING       400000040000
 BMC93656I RECORD TYPE 00020002 -          9 RECORDS TOTALING        90000050000
 BMC93656I RECORD TYPE 00020003 -          9 RECORDS TOTALING        37800060000
 BMC93656I RECORD TYPE 00020004 -         12 RECORDS TOTALING        51600070000
 BMC93656I RECORD TYPE 00020007 -        702 RECORDS TOTALING     14866800080000
 BMC93656I RECORD TYPE 00020009 -         48 RECORDS TOTALING       489600090000
 BMC93656I RECORD TYPE 00080002 -          1 RECORDS TOTALING        13400100000
 BMC93656I RECORD TYPE 00080003 -          1 RECORDS TOTALING        13400110000
 BMC93656I RECORD TYPE 00100001 -          7 RECORDS TOTALING       127400120000
 BMC93656I RECORD TYPE 00100002 -          7 RECORDS TOTALING        77000130000
 BMC93656I RECORD TYPE 00200001 -         57 RECORDS TOTALING       820800140000
 BMC93656I RECORD TYPE 00200002 -         56 RECORDS TOTALING       515200150000
 BMC93656I RECORD TYPE 0020000C -         56 RECORDS TOTALING       291200160000
 BMC93656I RECORD TYPE 00200010 -         56 RECORDS TOTALING       291200170000
 BMC93656I RECORD TYPE 00200020 -          1 RECORDS TOTALING         5200180000
 BMC93656I RECORD TYPE 00200040 -          1 RECORDS TOTALING         5200190000
 BMC93656I RECORD TYPE 01000001 -        448 RECORDS TOTALING      1971200200000
 BMC93656I RECORD TYPE 01000010 -          7 RECORDS TOTALING        44800210000
 BMC93656I RECORD TYPE 01000017 -          7 RECORDS TOTALING        48200220000
 BMC93656I RECORD TYPE 01000031 -          7 RECORDS TOTALING        71400230000
 BMC93656I RECORD TYPE 01020005 -         97 RECORDS TOTALING      1670800240000
 BMC93656I RECORD TYPE 04000003 -         14 RECORDS TOTALING        85400250000
 BMC93656I RECORD TYPE 04000019 -          7 RECORDS TOTALING       107900260000
 BMC93656I RECORD TYPE 06000001 -     311048 RECORDS TOTALING   4426116400270000
 BMC93656I RECORD TYPE 06000003 -         14 RECORDS TOTALING        85400280000
 BMC93656I RECORD TYPE 06000019 -        152 RECORDS TOTALING      1517600290000
 BMC93656I RECORD TYPE 2100001D -       5201 RECORDS TOTALING     56410900300000
 BMC93656I RECORD TYPE 22000014 -         21 RECORDS TOTALING        98700310000
 BMC93656I RECORD TYPE 2600001D -         64 RECORDS TOTALING       972800320000
 BMC93656I RECORD TYPE Totals   -     318135 RECORDS TOTALING   4507297300330000

The following figure shows the total number of records in the log for each Db2 object

Total log records by Db2 object (ALMOSTAT)

**   PACLOG  - V1.4.00   *****  BMC SOFTWARE, INC. *****  05/17/2006 1300010000
                                                                        00020000
  DEB2CAT.ARCHLOG1.D06137.T1238038.A0001368                             00030000
   DBNAME   OBNAME   DBID/OBID  TYP     RECORDS       BYTES             00040000
  DSNDB01  DSNLUX01  00010044    X            2         180             00050000
  DSNDB01  DSNLUX02  00010046    X           10        1022             00060000
  DSNDB01  DSNLLX02  00010086    X           19        1596             00070000
  DSNDB01  DSNLLX01  00010087    X           19        1672             00080000
  DSNDB01  SYSUTILX  000100AF    T           28       56538             00090000
  DSNDB01  SYSLGRNX  000100CF    T           38        4230             00100000
  DSNDB06  SYSCOPY   00060010    T           17        3627             00110000
  DSNDB06  DSNUCH01  00060072    X           14        1484             00120000
  DSNDB06  DSNUCX01  00060076    X           14        1652             00130000
  BMCUTIL  BMCUTIL   01040002    T            4         586             00140000
  BMCUTIL  BMCSYNC   01040004    T           47       20795             00150000
  BMCUTIL  CUTX      01040036    X            2         180             00160000
  BMCUTIL  SYX1      01040038    X           26        3248             00170000
  BMCUTIL  SYX2      0104003A    X           26        2706             00180000
  BMCUTIL  CUTX2     0104005E    X            2         212             00190000
  BMCUTIL  SYX3      01040060    X           25        2303             00200000
  ARMLOGSP TS80N5    01120007    T        80000     8920000             00210000
  ARMLOGSP TS80P6    0112000C    T        40000     5480000             00220000
  ARMLOGSP TS80P9    01120013    T        60000     7200000             00230000
  ARMLOGSP TS80N10   0112001B    T        94199    15669412             00240000
  ARMLOGSP TS80N14   01120020    T        33697     6335036             00250000

Related topic

Building-PACLOG-jobs

 

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