Specifying a JCL command stream
This topic describes a typical batch job that creates a detail report and a bpd file. The JCL command stream and the DD statements are described to enable you to write your customized batch job.
About this task
Note that you can use and modify the JCL sample provided in data set member prefix.TKO2SAMP(BPOQBTCH). It is usually more current than the example in this information.
In the following example the Buffer Pool Analyzer is installed under the high-level qualifier db2bpa. The batch job creates three different activity reports (using the REPORT subcommand with different options) and a trace data file (using the FILE subcommand without any option).
//*******************************************************************// //* *// //* MODULE NAME : BPOQBTCH *// //* *// //* DESCRIPTION : DB2 BPA Batch Sample Job *// //* *// //* COPYRIGHT : IBM DB2 Buffer Pool Analyzer for z/OS V5R4M0 *// //* Licensed Materials - Property of IBM *// //* 5655-W35 (C) Copyright IBM Corp. 2001, 2016 *// //* *// //* STATUS : Version 5.4.0 *// //* *// //* FUNCTION : Create Batch Reports and a File *// //* *// //* *// //* Notes = *// //* 1. ADD A VALID JOB CARD *// //* 2. Change the INPUTDD and BPFILDD1 DD statements *// //* The commands in the SYSIN DD file can be changed *// //* as described in the BPA User's Guide *// //*End of Specifications*********************************************// //* //DB2BP EXEC PGM=DB2BP //* CHANGE THE PREFIX OF THE LIBRARY db2bpa //STEPLIB DD DSN=db2bpa.RKANMOD,DISP=SHR //* DD statement for trace data set //INPUTDD DD DISP=SHR,DSN=bpa.trace.dataset //SYSPRINT DD SYSOUT=* //SYSOUT DD SYSOUT=* //* DD statement for messages referring to the trace data set //JOBSUMDD DD SYSOUT=* //* DD statement for messages referring to execution of the job phases //DPMLOG DD SYSOUT=* //* DD statement for second report //BPAREP2 DD SYSOUT=* //* DD statement for File, change parameters according to your needs //BPFILDD1 DD DISP=(NEW,CATLG),DSN=file.name, // DCB=(RECFM=VBS,BLKSIZE=9076,LRECL=32756),UNIT=SYSDA, // SPACE=(9096,(1000,500),RLSE) //* DD statement for BPA commands and parameters //SYSIN DD * * Global command to adjust reported GMT to local time GLOBAL timezone (-1:00) * Command with subcommands to create buffer pool activity Reports * and File with data to be loaded into a DB2 table or used on the * client for graphical display or for expert analysis BPACTIVITY * Default report, output goes to default DD name BPREPDD REPORT * Following report has data summarized by plan, buffer pool id, and * page set. The data are sorted by plan and number of getpages. * Only the first 5 combinations of buffer pool id and page set * per plan are reported and the remainder. REPORT level(detail) order(planname-bpid-qpageset sortby(planname,getpage) top(5)) * Output goes to DD name BPAREP2 ddname(bparep2) * The next is a summary report where only the 11 most * active page sets in terms of asynchronous page activity is * produced. Buffer pool activity is always there. REPORT level(summary) order( sortby(asyncpage) top(11)) * Output goes to the same DD name as the previous report. ddname(bparep2) * File, output goes to default DD name BPFILDD1 FILE * EXEC command terminates reading of command input and starts * processing of trace input. EXEC //
- Lists one or more input data sets that contain trace data to be
used to create activity reports and buffer pool data files. Usually,
this is the data that you collected with the Collect Report Data (CRD)
function of Buffer Pool Analyzer. The name of the input data set usually
has a low-level qualifier of TRACE, as explained
in Configuring a collect task.
The default ddname for the input data set is INPUTDD. If you specify a different ddname, use the INPUTDD option of the GLOBAL command. In this case, ensure that your JCL includes a valid DD statement for the new name.
You can also use DB2® trace data that is created by other means, such as data in GTF or SMF data sets, and it is generally possible to process multiple input data sets. See Concatenating trace data for activity reports and bpd files for more details.
- Contains messages from DFSORT. If SYSOUT is not specified, it is dynamically allocated to the SYSOUT message class of the job. The format of SYSOUT is RECFM=FBA, LRECL=133, BLKSIZE=6251.
- If specified, it contains the job summary log and the IFCID frequency distribution log. The format of JOBSUMDD is RECFM=FBA, LRECL=133, BLKSIZE= 6251.
- Contains messages from the Buffer Pool Analyzer command processor. If DPMLOG is not specified, it is dynamically allocated to the SYSOUT message class of the job. The format of DPMLOG is RECFM=FBA, LRECL=133, BLKSIZE=6251.
- Contains the output from the BPACTIVITY REPORT subcommand.
If BPRPTDD is not specified, it is dynamically allocated to the SYSOUT
message class of the job. The format of BPRPTDD is RECFM=FBA, LRECL=81,
If multiple REPORT subcommands are used, the resulting activity reports are written to BPRPTDD in corresponding sequence.
If you specify a different ddname with the DDNAME option of the REPORT subcommand, ensure that your JCL includes a valid DD statement for the new name.
- Contains the output from the BPACTIVITY FILE subcommand.
This is the bpd file that can be used on the client for viewing performance
data and optimizing object placements. Also, its content can be loaded
into Db2 tables. Ensure that your JCL contains a valid
DD statement for this ddname. The format of BPFILDD1 is RECFM=VB,
LRECL=9072, BLKSIZE=9076. The DD statement should specify a data set
name with a low-level qualifier of
BPD(for buffer pool data). After this data set is downloaded to the client, it must have a file name extension of bpd.
If you specify a different ddname with the DDNAME option of the FILE subcommand, ensure that your JCL includes a valid DD statement for the new name.
- If specified, it determines where Buffer Pool Analyzer stores
its temporary data, which can be up to 68 MB. Usually, this data set
is created on the MVS-defined work volumes and deleted by Buffer Pool
Analyzer. Use BPWORK if you want to control placement or size of the
data set, or if you receive a B37 abend. The format of BPWORK is RECFM=VBS,
Do not specify DUMMY or DISP=MOD for this data set.
- This DD statement is mandatory. It contains the commands to be
run by the job stream.
The format of SYSIN is RECFM=FB, LRECL=80, BLKSIZE=6160.