Determining archive log size reduction

Run a job such as that shown in the following figure to demonstrate the reduction in the size of the original archive log data sets that record filtering and subsequent compression can achieve.

The compressed logs are written to disk. The job runs in simulation mode, so no changes are made to the original log data sets. Message BMC93658I (written to the ALMPRINT data set) provides the percentage compression that was achieved by PACLOG for this job.

For clarity, all of the required processing in this example is specified by the appropriate keywords in the ALMIN data set. You can simplify the syntax shown in the following figure by omitting the keywords that specify defaults, as shown in the following syntax:

Related topics

Examples-of-PACLOG-JCL

System-requirements

Using-PACLOG-to-simulate-log-processing

LIMIT LOGS 3
SIMULATE NOKEEP
ARCHIVE1 REDO

For more syntax information, see Command-and-syntax-reference. For DD statement information, see Building-PACLOG-jobs.

//PACLOG1 JOB (5212),'EXAMPLE 1',CLASS=A,MSGCLASS=X
//***************************************************************
//*
//* THIS JOB CAN BE USED TO DETERMINE THE DATA COMPRESSION
//* PACLOG WILL PROVIDE ON A GIVEN DB2 SUBSYTEM, USING A
//* GIVEN NUMBER OF ARCHIVE LOG DATA SETS. IT WILL NOT
//* MAKE ANY MODIFICATIONS TO YOUR DB2 ARCHIVE LOGS!
//*
//* IT CAN BE RUN MULTIPLE TIMES AGAINST THE SAME DB2 SUBSYSTEM,
//* VARYING THE NUMBER OF LOGS PROCESSED TO DETERMINE HOW THE
//* REDUCTION PERCENTAGE IS AFFECTED.
//*
//* THE JOB AS SHOWN BELOW, WILL INPUT THE LAST THREE ARCHIVE LOG
//* DATA SETS AND CREATE THREE FILES PER ARCHIVE LOG. EACH FILE
//* NAME WILL BE BUILT USING THE ARCHIVE LOG DATA SET NAME AS
//* FOLLOWS:
//*
//*    <ARCLOG1PREFIX>.Y<DSNUMBER> FOR THE BSDS
//*    <ARCLOG1PREFIX>.Z<DSNUMBER> FOR THE ARCHIVE LOG DATA SET
//*    <ARCLOG1PREFIX>.H<DSNUMBER> FOR THE PACLOG HISTORY FILE
//*
//* IF YOU DO NOT RUN WITH SIMULATE, THESE FILES WILL BE RENAMED
//* TO REPLACE THE CURRENT ARCHIVE LOG DATA SET FILES!
//*
//* NOTE: THIS JOB DOES NOT UPDATE THE PACLOG HISTORY FILE, SO
//* IF IT IS RUN REPEATEDLY, IT WILL PROCESS THE SAME ARCHIVE LOGS
//* PROCESSED PREVIOUSLY.
//*
//***************************************************************
//COMP1 EXEC PGM=ALMMAIN,REGION=4M,
//            PARM='DECI'                        <=== DESIRED DB2 SSID
//STEPLIB DD DISP=SHR,DSN=BMCALM.TEST.OVERRIDE1
//         DD DISP=SHR,DSN=BMCALM.DBLINK         <=== PACLOG LOAD LIB
//         DD DISP=SHR,DSN=BMCALM.XXLINK         <=== INFRASTRUCTURE 1
//         DD DISP=SHR,DSN=BMCALM.BBLINK         <=== INFRASTRUCTURE 2
//         DD DISP=SHR,DSN=SYS3.DECI.DSNEXIT     <=== DB2 DSNEXIT LIB
//         DD DISP=SHR,DSN=SYS2.DB2V81M.DSNLOAD <=== DB2 DSNLOAD LIB
//SYSUT1   DD DISP=SHR,DSN=DECICAT.BSDS01        <=== DB2 BSDS
//ALMMSGS DD DISP=SHR,DSN=BMCALM.DBCNTL(ALMMSGS)   <=== MSGS DS
//ALMOPTS DD DISP=SHR,DSN=BMCALM.DBCNTL(ALM$OPTS) <=== OPTS DS
//*
//ALMPRINT DD SYSOUT=*    REQUIRED PRINT OUTPUT
//ALMXPIRE DD SYSOUT=*    REQUIRED EXPIRED ARCHIVE REPORT
//ALMLIST1 DD SYSOUT=*    REQUIRED LOCAL PRIMARY ARCHIVE LIST
//ALMLIST2 DD SYSOUT=*    REQUIRED LOCAL SECONDARY ARCHIVE LIST
//*
//ALMLIST3 DD SYSOUT=*    OPTIONAL OFFSITE PRIMARY ARCHIVE LIST
//ALMLIST4 DD SYSOUT=*    OPTIONAL OFFSITE SECONDARY ARCHIVE LIST
//ALMLSTAT DD SYSOUT=*    OPTIONAL RECORD TYPE REPORT
//ALMOSTAT DD SYSOUT=*    OPTIONAL DB2 OBJECT REPORT
//BMCERROR DD SYSOUT=*    OPTIONAL SAS/C ERROR MESSAGES
//ALMIN    DD *

  LIMIT LOGS 3

  SIMULATE NOKEEP

  ARCHIVE1
     DISK UNIT SYSALLDA
     COMPRESS YES
     FILTERIX ALL
     FILTERRECTYPE ALL
     REDO

Determining archive log size reduction

On this page