Displaying Extract Options During Batch Submission

The procedures contain many processing options. The extract map displays these processing options for an extract procedure, report procedure, or execution procedure when the procedure is submitted in batch mode.
cadadb220
The procedures contain many processing options. The extract map displays these processing options for an extract procedure, report procedure, or execution procedure when the procedure is submitted in batch mode.
Action procedures are not submitted as stand-alone procedures. However, the options that are used for action procedures are included in the display when the procedure is tied to an extract procedure.
The extract map provides centralized output information about your procedures that are executed in batch. This information helps the support and development teams understand your procedure environment.
Overriding Parmlib Values
Some of the product parameters in the PDA parmlib member control the display of certain sections of the extract map. These keywords are used when the procedure is submitted. However, the keyword to expand the extract procedure PTIMSG messages (EXT_MSG_EXPAND) can be used for batch submission.
The following parmlib parameters control the display of different sections of the extract map:
  • EMAP_JOBLOG
  • EMAP_BANNER
  • EMAP_PARMS
  • EMAP_SUBMIT
  • EMAP_INPUT
  • EXT_MSG_EXPAND
The %PKGNAMET and %PKGST symbolic variables are not supported in pre- and post-action models.
You can override the parmlib settings for the extract map by supplying a JCL step parameter value of EMAP=ALL. This value automatically selects the default settings for all extract map parameters. The exception is the EMAP_INPUT parameter, which is set to ALL.
Overriding the extract map parameters is useful when
Broadcom Support
requests a rerun of the problem job. By overriding the parameters, you do not have to change the parmlib. All you do is add the EMAP=ALL parameter to the EXEC PARM step.
If EMAP_JOBLOG is set to ALSO or ONLY, the extract map does not appear in the job log because the default value (NO) is used. This default requests only the batch extract processing messages (PTIMSG).
Examples of the Extract Map Parameters
This section illustrates the results of selecting the Extract Map parameters.
This parameter shows the introductory information. For the current operating environment, the DFSMS or DFP version appears.
Current Operating Environment DATE : YYYY/MM/DD MVS : SP7.1.2 DB2 : 1.0.1 TIME : 14:36:35 DFSMS: 01.12.0 SYSID: DB0G USERID: USERxx CPUs : 10 Local Environment DAS: rxx SPx GEN: rxx SPx RIO: rxx SPx COM: rxx SPx
The following parameter displays the parmlib settings and the EXEC PARM statement when YES is specified:
Parmlib Member PDA has the following settings: (Use EMAP_PARMS (ABBRV) to remove comment lines) /* =============================================================== */ 00010 /* General and Miscellaneous Options */ 00020 /* =============================================================== */ 00030 00040 /* The following two parms control processing in these three areas:*/ 00050 /* 1) INSERTs into the PDA statistic history tables */ 00060 /* 2) SELECTs when determining if an Action Condition is meet */ 00070 /* 3) DELETEs when doing statistics maintenance on PTLOG_MAIN_1500 */ 00080 /* */ 00090 RETRY# (000010) /* Number of times to retry */ 00100 00110 RETRYINT (000010) /* Interval in 1/100 of a sec */ 00120 00130 EXTRACT_JOBNAME (NONE) /* Don't use Ext. for JOB name */ 00140 00150 DEF_PROC_CREATOR (USERID) /* Indicates what to use as */ 00160 /* the default 'creator' for */ 00170 /* Execution, Extract, Action */ 00180 /* or Report Procedures. */ 00190 /* Keywords: */ 00200 /* USERID (DEFAULT) */ 00210 /* = Will use TSO logon ID */ 00220 /* SQLID = Will use the */ 00230 /* current value of SQLID*/ 00240 /* ACEEGRPN = Will use the */ 00250 /* users default RACF grp*/ 00260 /* XXXXX = Any alphanumeric */ 00270 /* string 1 - 8 Chars. */ 00280 /* Also, see keyword below: */ 00290 /* ALLOW_DPC_PROFILE_OVERRIDE */ 00300 00310 ALLOW_DPC_PROFILE_OVERRIDE (N) /* Indicates if the Default */ 00320 /* Procedure Creator (DPC) */ 00330 /* is allowed to be overridden */ 00340 /* in the users PDA profile. */ 00350 /* See DEF_PROC_CREATOR above. */ 00360 00370 REGION_INFO (Y) /* Determines whether region */ 00380 /* (a.k.a. virtual storage) */ 00390 /* information will be put in */ 00400 /* in the PTIMSG output. */ 00410
The following parameter displays the PROC SUBMIT options when YES is specified. If statistics are collected, the collection information appears. If a submit option was not selected, NOT-REQUESTED appears.
Options specified when procedure was SUBMITted: COLLECTION - REGULAR Statistics Subsystem: ssid VSAM Buffers: 0360 WTOR Code: 00 Audit Errors Allowed: 0010 Nbr of Scans: 00 REPORTS - NOT-REQUESTED Redirection: x Lib: ACTIONS - YES Action JCL Destination: D Member: PEXTMAPB Action JCL Library: PDMAC.PDA#EMAP.ACTJCL Related Models: Jobcard: MJJOBCD Pre: Post: Related Models Library: 'CA.DB2.CDBAMDL'
The following parameter displays the PTIIPT '00' control cards when YES or 00 is specified. If ALL is specified, all control cards appear.
PTIIPT input control cards: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7-- 00PEXTMAP USERXX ssid FFDCEEDCD4DCDCCC44CFFC00060000A20044444444444444444444444400000000444444 00757341707441320042310518000008000000000000000000000000000A000000000000 00 ssid- N FF0000000000CFFC6AD00000000000000000000000000000000000000000000000000000 000000000001423100500000000000000000000000000000000000000000000000000000 00 DPDMAC.PDA#EMAP.ACTJCL PDMAC PEXTMAPB FF00CDCDCC4DCC7CDCD4CCEDCD4444444444444444444444444DCDCC444DCEEDCDC44444 0000474413B741B5417B1331330000000000000000000000000744130007573417200000 00'CA.DB2.CDBAMDL' FF7DECDDDC4DDFFFCC4DDCCD744444444444444444444444004444444444444444444444 00D7397964B9731011B46453D00000000000000000000000000000000000000000000000 ----+----1----+----2----+----3----+----4----+----5----+----6----+----7-- Remaining control cards are printed as is: 01//PDMAC#AJ JOB (PD20-200-PDA),'PDA JCL - CM',CLASS=A, 01// MSGCLASS=X,NOTIFY=USERXX 01//***************** 01//* JOB DESC: SAMPLE DESCRIPTION 01//***************** ***************************************************************************** ******************* Copyright 1987,2010 CA, Inc. *************** *****************************************************************************
This parameter displays the expanded extract procedure messages in PTIMSG when YES is specified and useful in determining which Job Generation Parms are used. Each extract procedure can have its own Job Generation Parms, but only one set of Job Generation Parms can be used. The expanded message from EXT_MSG_EXPAND describes the Final Job Generation Parms.
The Column Stats and Auto-Catalog Update messages appear only if you requested statistics collection during the procedure submission. The Job Generation Parms messages appear only if you specified Actions during the procedure submission. The following sample illustrates these messages:
EXTRACTING EXTRACT PROCEDURE - USERXX.PEXTMAP 17:59:04 EXTRACT PROCEDURE - USERXX.PEXTMAP PROCESSED - SUBSYSTEM - ssid 17:59:06 COLUMN STATS: N AUTO-CATALOG UPDATE: NO 17:59:06 JOB GENERATION PARMS: 17:59:06 ONEJOB/OBJECT; 0010 JOBS; JOBMASK PDAUT; ONESTEP/UTIL 17:59:06 EXTRACTING CATALOG INFORMATION - SUBSYSTEM - ssid 17:59:06 ==> LEVEL: ALL - DATABASE=MIJDB, TABLESPACE=MIJTSP 17:59:07 ==> SELECTING TABLE - TSMIJ.PART_TB.0001 17:59:07 ==> SELECTING INDEX - TSMIJ.PART2_IDX 17:59:07 ==> SELECTING INDEX - TSMIJ.PARTIDX.0001 17:59:07 ==> SELECTING INDEX - TSMIJ.PARTIDX.0002 17:59:07 ==> SELECTING INDEX - TSMIJ.PARTIDX.0003 17:59:07 ==> SELECTING INDEX - TSMIJ.PARTIDX.0004 17:59:07 ==> SELECTING TABLE - TSMIJ.PART_TB.0002 17:59:07 ==> SELECTING TABLE - TSMIJ.PART_TB.0003 17:59:07 ==> SELECTING TABLE - TSMIJ.PART_TB.0004 17:59:07 ==> LEVEL: ALL IXS - DATABASE=MIJDB, TABLESPACE=MIJTSS2 17:59:07 CATALOG EXTRACT CONSOLIDATION COMPLETE 17:59:08
The following sample illustrates the Final Job Generation Parms from EXT_MSG_EXPAND:
ACTION PROCEDURE - PDMACA.RO PROCESSED - SUBSYSTEM - ssid 17:59:08 FINAL JOB GENERATION PARMS: 17:59:08 ONEJOB/OBJECT; 0010 JOBS; JOBMASK PDAUT; ONESTEP/UTIL 17:59:08 COLLECTION OF DATA STATISTICS STARTED - SUBSYSTEM - ssid 17:59:08 ACCESS: DIV BUFFERS: 0360 SCANS: 0005 SCANTYPE: REGULAR 17:59:08 COLLECTION OF TS - MIJDB .MIJTSP.0001 - STARTED 17:59:09 COLLECTION OF TS - MIJDB .MIJTSP.0002 - STARTED 17:59:10 COLLECTION OF TS - MIJDB .MIJTSP.0003 - STARTED 17:59:10 COLLECTION OF TS - MIJDB .MIJTSP.0001 - ENDED 17:59:10 COLLECTION OF TS - MIJDB .MIJTSP.0004 - STARTED 17:59:11 COLLECTION OF TS - MIJDB .MIJTSP.0002 - ENDED 17:59:11 COLLECTION OF IX - TSMIJ .PART2_IDX - STARTED 17:59:12 COLLECTION OF TS - MIJDB .MIJTSP.0003 - ENDED 17:59:12 COLLECTION OF TS - MIJDB .MIJTSP.0004 - ENDED 17:59:12 COLLECTION OF IX - TSMIJ .PARTIDX.0001 - STARTED 17:59:14 COLLECTION OF IX - TSMIJ .PARTIDX.0002 - STARTED 17:59:15 COLLECTION OF IX - TSMIJ .PART2_IDX - ENDED 17:59:15 COLLECTION OF IX - TSMIJ .PARTIDX.0003 - STARTED 17:59:15 COLLECTION OF IX - TSMIJ .PARTIDX.0003 - STARTED 17:59:15 COLLECTION OF IX - TSMIJ .PARTIDX.0001 - ENDED 17:59:15 COLLECTION OF IX - TSMIJ .PARTIDX.0004 - STARTED 17:59:16 COLLECTION OF IX - TSMIJ .PARTIDX.0002 - ENDED 17:59:16 COLLECTION OF IX - TSMIJ .PARTIDX.0003 - ENDED 17:59:16 COLLECTION OF IX - TSMIJ .PARTIDX.0004 - ENDED 17:59:17 COLLECTION OF DATA STATISTICS ENDED - SUBSYSTEM - ssid 17:59:33