Previous Topic: Using the AUXTRACE UtilityNext Topic: Using the DBAS Transaction to Test Multiple Environment Control Commands


AUXTRACE Utility Control Card

The batch AUXTRACE utility program uses a control statement to allow you to print ALL or selected records in the auxiliary trace data sets. The format of the control card is as follows:

Position

Data

1—3

ALL

Issues the instruction to print all records in the file.

1—4

Trans ID

Place a transaction ID here if all records for a specified ID are desired.

5—8

Terminal ID

Place a terminal ID here if all records for a specific ID are desired.

9—13

Task ID

Place the 6-digit CICS transaction ID here if all records for a specified task are desired.

14—15

MUF ID

Place the 2-digit number of the MUF here if all records for a specified MUF are desired.

16—23

SID name

Place the 8-character SID name associated with MUF here if all records for a specified MUF by SID name are desired.

z/OS JCL Example

In the following example, the data set names are samples only. Code your data set names as per your site's standards.

 //jobname  JOB    Job Statement Information
 //*-------------------------------------------------------------------*
 //*  PRINT DBC AUXILIARY TRACE FILE
 //*-------------------------------------------------------------------*
 //AUXP      EXEC PGM=DCTUPPR
 //STEPLIB   DD DSN=CAI.CHLQ.CUSLIB,DISP=SHR
 //          DD DSN=CAI.THLQ.CAB1LOAD.DISP=SHR
 //DCAUXTRC  DD DSN=CAI.CHLQ.DBAUXTA,DISP=SHR
 //SYSLST    DD SYSOUT=*,DCB=BLKSIZE=133
 //*-------------------------------------------------------------------*
 //*INPUT PARM FORMAT:
 //*CHAR 1-4, CHAR 5-8, CHAR 9-13, CHAR 14-15, CHAR 16-23
 //*ALL
 //*TRANSID   TERMID    TASKNO     MUFID       SIDNAME
 //*-------------------------------------------------------------------*
 //SYSIPT    DD *
 ALL
 //

z/VSE JCL

In the following example, the data set names are samples only. Code your names as per your site's standards.

 * $$ JOB JNM=DCTUPPR,CLASS=n
 * $$ LST CLASS=x
 // JOB     DCTUPPR
 // DLBL    BASE,'customer.designated.DBC.install.library'
 // EXTENT  SYS009,vvvvvv
 // ASSGN   SYS009,DISK.,VOL=vvvvvv,SHR
 // LIBDEF  *,SEARCH=BASE.DBC14
 // DLBL    AUXFILE,'customer.dbauxta.dbc14'
 // EXTENT  SYS050,vvvvvv
 // ASSGN   SYS050,DISK,VOL=vvvvvv,SHR
 // ASSGN   SYSLST,PRINTER
 // EXEC DCTUPPR
 ALL
 /*
 /&
 * $$ EOJ

Sample Report

For field descriptions, see the list following the sample.

DATE: 03/21/12 ******************************************************************************** PAGE: 1 * CA Datacom CICS Services * * A U X I L I A R Y T R A C E R E P O R T * ******************************************************************************** SEQ TIME TASK TERM TRAN PROGRAM TCB TCB COMMD TABLE KEY RETURN URT DBID MUF SIDNAME OPRID/ NR HH.MM.SS ID ID ID NAME NAME ID NAME NAME CODE ID ID USERID 0001 13:01:24 6 ???? CPLT DCCO4PR L8000 001 OPEN 0000 01 DBDVM5 0002 13:01:24 6 ???? CPLT DCCO4PR L8000 002 INQIN 0000 01 DBDVM5 0003 13:01:24 6 ???? CPLT DCCO4PR L8000 002 INQMU 0000 01 DBDVM5 0004 13:01:24 6 ???? CPLT DCCO4PR L8000 002 LOGCI 0000 01 DBDVM5 0005 13:01:24 6 ???? CPLT DCCO4PR L8000 001 OPEN 0002 01 DBDVM5 0006 13:01:26 6 ???? CPLT DCCO4PR L8000 001 OPEN 0000 04 PRODMU2 0007 13:01:26 6 ???? CPLT DCCO4PR L8000 002 INQIN 0000 04 PRODMU2 0008 13:01:26 6 ???? CPLT DCCO4PR L8000 002 INQMU 0000 04 PRODMU2 0009 13:01:26 6 ???? CPLT DCCO4PR L8000 002 LOGCI 0000 04 PRODMU2 0010 13:01:26 6 ???? CPLT DCCO4PR L8000 001 OPEN 0102 04 PRODMU2 0011 13:01:27 6 ???? CPLT DCCO4PR L8000 001 OPEN 0201 01 DBDVM5 0012 13:01:28 6 ???? CPLT DCCO4PR L8000 001 OPEN 0340 01 DBDVM5 0013 13:01:28 6 ???? CPLT DCCO4PR L8000 001 OPEN 0341 01 DBDVM5 0014 13:01:28 6 ???? CPLT DCCO4PR L8000 001 OPEN 0000 05 DBDVMR 0015 13:01:28 6 ???? CPLT DCCO4PR L8000 002 INQIN 0000 05 DBDVMR 0016 13:01:28 6 ???? CPLT DCCO4PR L8000 002 INQMU 0000 05 DBDVMR 0017 13:01:28 6 ???? CPLT DCCO4PR L8000 002 LOGCI 0000 05 DBDVMR 0018 13:01:30 6 ???? CPLT DCCO4PR L8000 001 OPEN 0351 05 DBDVMR 0019 13:01:31 6 ???? CPLT DCCO4PR L8000 001 OPEN 0354 04 PRODMU2 0020 11:25:48 205 ???? NXXU B4XXNTVU L8001 003 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0021 11:25:48 208 ???? NXXU B4XXNTVU L8002 005 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0022 11:25:49 214 ???? NXXU B4XXNTVU L8005 007 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0023 11:25:49 208 ???? NXXU B4XXNTVU L8002 005 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0024 11:25:49 215 ???? NXXU B4XXNTVU L8006 008 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0025 11:25:49 213 ???? NXXU B4XXNTVU L8004 006 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0026 11:25:48 209 ???? NXXU B4XXNTVU L8003 004 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0027 11:25:49 218 ???? NXXU B4XXNTVU L8009 011 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0028 11:25:49 214 ???? NXXU B4XXNTVU L8005 007 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0029 11:25:50 223 ???? NXXU B4XXNTVU L800E 016 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0030 11:25:49 220 ???? NXXU B4XXNTVU L800B 013 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0031 11:25:50 228 ???? NXXU B4XXNTVU L800I 019 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0032 11:25:50 206 ???? NXXU B4XXNTVU L800J 020 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0033 11:25:49 222 ???? NXXU B4XXNTVU L800D 014 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0034 11:25:49 219 ???? NXXU B4XXNTVU L800A 012 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0035 11:25:50 225 ???? NXXU B4XXNTVU L800G 018 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0036 11:25:50 224 ???? NXXU B4XXNTVU L800F 017 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0037 11:25:49 216 ???? NXXU B4XXNTVU L8007 009 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0038 11:25:50 213 ???? NXXU B4XXNTVU L8004 006 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0039 11:25:50 209 ???? NXXU B4XXNTVU L8003 004 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0040 11:25:50 228 ???? NXXU B4XXNTVU L800I 019 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0041 11:25:50 223 ???? NXXU B4XXNTVU L800E 016 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0042 11:25:44 112 ???? NXXU B4XXNTVU L8000 002 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0043 11:25:49 217 ???? NXXU B4XXNTVU L8008 010 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0044 11:25:59 205 ???? NXXU B4XXNTVU L8001 003 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0045 11:25:50 208 ???? NXXU B4XXNTVU L8002 002 RDUKY TEL SQ002 86.04 0354 00350 04 PRODMU2 0046 11:25:49 221 ???? NXXU B4XXNTVU L800C 015 RDUKY ACC SQ004 0340 00350 01 DBDVM5 0047 11:25:59 215 ???? NXXU B4XXNTVU L8006 008 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0048 11:25:59 218 ???? NXXU B4XXNTVU L8009 011 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0049 11:25:59 224 ???? NXXU B4XXNTVU L800F 017 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0050 11:25:59 225 ???? NXXU B4XXNTVU L800G 018 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0051 11:25:50 220 ???? NXXU B4XXNTVU L800B 013 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0052 11:25:50 223 ???? NXXU B4XXNTVU L800E 003 RDUKY TEL SQ002 86.BA 0354 00350 04 PRODMU2 0053 11:25:50 228 ???? NXXU B4XXNTVU L800I 004 RDUKY TEL SQ002 86.BA 0354 00350 04 PRODMU2 0054 11:26:00 112 ???? NXXU B4XXNTVU L8000 002 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0055 11:25:59 216 ???? NXXU B4XXNTVU L8007 009 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0056 11:25:59 206 ???? NXXU B4XXNTVU L800J 020 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0057 11:25:59 219 ???? NXXU B4XXNTVU L800A 012 UPDAT ACC SQ004 0340 00350 01 DBDVM5 0058 11:25:59 222 ???? NXXU B4XXNTVU L800D 014 UPDAT ACC SQ004 0340 00350 01 DBDVM5

Page 1,204

DATE: 03/21/12 ******************************************************************************** PAGE: 1,204 * CA Datacom CICS Services * * A U X I L I A R Y T R A C E R E P O R T * ******************************************************************************** SEQ TIME TASK TERM TRAN PROGRAM TCB TCB COMMD TABLE KEY RETURN URT DBID MUF SIDNAME OPRID/ NR HH.MM.SS ID ID ID NAME NAME ID NAME NAME CODE ID ID USERID 9775 11:33:44 5058 ???? NXXU B4XXNTVU L803R 013 REDKY ACC SQ004 0340 00350 01 DBDVM5 9776 11:33:44 5090 ???? NXXU L8045 014 LOGPR CIC 0000 01 DBDVM5 9777 11:33:44 5096 ???? NXXU B4XXNTVU L804U 010 RDUKY BRN SQ001 0341 00350 01 DBDVM5 9778 11:33:44 5090 ???? NXXU L8045 014 COMIT 0000 01 DBDVM5 9779 11:33:44 5096 ???? NXXU B4XXNTVU L804U 010 UPDAT BRN SQ001 0341 00350 01 DBDVM5 9780 11:33:44 5058 ???? NXXU L803R 005 LOGPR CIC 0000 04 PRODMU2 9781 11:33:44 5096 ???? NXXU B4XXNTVU L804U 004 ADDIT HST SQ005 0351 00350 05 DBDVMR 9782 11:33:44 5096 ???? NXXU B4XXNTVU L804U 010 REDKY ACC SQ004 0340 00350 01 DBDVM5 9783 11:33:44 5090 ???? NXXU L8045 009 COMIT 0000 04 PRODMU2 9784 11:33:44 5058 ???? NXXU L803R 003 LOGPR CIC 0000 05 DBDVMR 9785 11:33:44 5096 ???? NXXU L804U 008 LOGPR CIC 0000 04 PRODMU2 9786 11:33:44 5058 ???? NXXU L803R 013 LOGPR CIC 0000 01 DBDVM5 9787 11:33:44 5090 ???? NXXU L8045 002 COMIT 0000 05 DBDVMR 9788 11:33:44 5058 ???? NXXU L803R 013 COMIT 0000 01 DBDVM5 9789 11:33:44 5096 ???? NXXU L804U 004 LOGPR CIC 0000 05 DBDVMR 9790 11:33:44 5096 ???? NXXU L804U 010 LOGPR CIC 0000 01 DBDVM5 9791 11:33:44 5058 ???? NXXU L803R 005 COMIT 0000 04 PRODMU2 9792 11:33:44 5096 ???? NXXU L804U 010 COMIT 0000 01 DBDVM5 9793 11:33:44 5058 ???? NXXU L803R 003 COMIT 0000 05 DBDVMR 9794 11:33:44 5096 ???? NXXU L804U 008 COMIT 0000 04 PRODMU2 9795 11:33:44 5096 ???? NXXU L804U 004 COMIT 0000 05 DBDVMR ********* E N D O F A U X I L I A R Y T R A C E ***********

Field Descriptions

SEQ NR

The number of the trace entry within the trace table. This indicates where within the trace table the display is positioned.

TIME

The time of day to the second at which each CA Datacom/DB request occurred.

TASK ID

The CICS task number.

TERM ID

The ID of the terminal which initiated the listed command or ???? if no terminal was attached to the issue of the command.

TRAN ID

The CICS transaction ID associated with the listed task.

PROGRAM NAME

The name of the program which issued the listed command.

TCB NAME

The Task Control Block name used by CICS to run the transaction. The values can be QR for Quasi Reentrant, L8 or L9 for OTE TCBs (Open Transaction Environment). Where L8s are used in case the transaction is running with EXEC Key of "CICS" and L9s, where transaction is running with EXEC Key of "application". The three digits following the L8 or L9 are the Open TCB numbers within the L8 or L9 TCB type.

COMMD

The CA Datacom/DB command being traced.

TCB ID

The Task Control Block sequence number which identifies the thread being used by this request, if any, within a given MUF.

TABLE NAME

CA Datacom/DB table being accessed by the current event, if any.

KEY NAME

The name of the key for the listed CA Datacom/DB table.

RETURN CODE

Interpret the return code xx.yy as follows:

xx

CA Datacom/DB external return code (decimal).

yy

CA Datacom/DB internal return code (hexadecimal), 40 is a blank internal return code.

URT ID

The number of the User Requirements Table (URT) being accessed by the current event.

OPRID/USERID

The USERID of the user if USERID=YES was indicated in DBCVTPR. If USERID=NO was indicated in DBCVTPR, this is the ID of the operator (OPRID) initiating the current event, if any. Be aware that if the data in this field is three characters, it is the OPRID. If it is longer than three characters, usually eight characters, it is the USERID.

MUF ID

The identity by MUF ID nn (where nn can be 01 through 99) of the MUF on which the CA Datacom/DB request was serviced.

SIDNAME

The sub-identifier ID used to identify the specific MUF on which the request was serviced.

DBID

The ID nnnnn (where nnnnn can be 00001 through 05000) of the database being referenced in the request.