ALZBATCH: IMS Problem Investigator report, extract, and CSV utility

IMS Problem Investigator batch commands are used to request reports, extracts, and CSV files. These commands are generated by the IMS Problem Investigator ISPF dialog when submitting batch requests.

The IMS Problem Investigator commands in the following list may appear in the SYSIN data set in the generated JCL, depending on the options you select in the ISPF dialog.

PAGELIM(nnnnn)
 
ZONE GMT|LOCAL|+hhmm|-hhmm

START date-time
 
STOP date-time

SCRUB
 
REXX EXEC(exec_name) [ARG(arguments)] [FILTER(filter)|CODE(logcode)]
 
CSV FORM(name) [OUTPUT(name)] [FILTER(name)] [DELIMITER(c)] [LABELS] 
[FIXEDWIDTH] [LENGTH(n)] [ISO8601]
 
REPORT [OUTPUT(ddname)] [FILTER(filter)] [LOGINFO]

EXTRACT [OUTPUT(ddname)] [FILTER(filter)]

ELAPSED [MICRO|NANO]
 
CODE(ALL) LEVEL(n)
COND fieldname|offset operator value
⋮

(logcode) LEVEL(n) [EXCLUDE]
COND fieldname|offset operator value
COND … 
CODE(logcode) [FORM(form)]
COND fieldname|offset operator value
⋮

FORMAT([FORM][,STD][,BRIEF][,DUMP][,HEX0][,HEX1]

CONNECT[(logcode)]
 
ATF[(logcode)]

TRACK
The following rules apply:
  1. If PAGELIM is not specified for a report, the report stops after 10,000 pages are written.
  2. ZONE, START, and STOP can only be specified once, and before all REPORT and EXTRACT requests.
  3. Multiple reports and extracts can be requested.
  4. Each OUTPUT ddname must be unique.
  5. CODE and FILTER are mutually exclusive, that is, CODEs cannot be specified when FILTER is used.
  6. The COND commands for CODE(ALL) or CODE(logtype,ALL) can specify global fields or explicit offsets.
  7. The COND commands for CODE(logtype,logcode) can specify any field for that log record type or explicit offsets.
  8. If you use more than one output command (for example, a REPORT and an EXTRACT command) you need to enter any CODE and CODE commands immediately after each. For example: 
    REPORT
CODE(A000)
COND CERE_00_VER# EQ 12
EXTRACT
CODE(A000)
COND CERE_00_VER# EQ 12
  9. TRACK will invoke Tracking only if the first CODE specified includes a COND.
  10. SCRUB ensures that output from all REPORT, EXTRACT, and CSV requests is scrubbed so that sensitive or confidential information is not disclosed. Use EXTRACT with SCRUB to prepare log files that do not contain sensitive data, such as when you want to send log files to users who do not have permission to see sensitive data, or you want to send the log file to IBM® or another external location.

Example

Figure 1. Example: IMS Problem Investigator report, extract, and CSV utility command syntax
PAGELIM(999)
ZONE(LOCAL)
START 2019-05-23-10.00
STOP  2019-05-23-11.00
REPORT OUTPUT(LOGRPT1)            
CONNECT(A0)
ATF(A2)
CODE(ALL)
COND  TRANCODE EQ 'STOCK' 
COND  USERID   EQ 'JOHN'         
CODE(01)                         
COND  MSGIDSTN EQ 'LTERM* '   
COND  MSGODSTN EQ  &BANKTRAN  
COND  USERID   EQ  'JOHN'
CODE(07) FORM(STAT07) 
SCRUB