* copyright (C) 1984-2019 merrill consultants dallas texas usa

S8CPUTTM='USER TASK*S8 MODE*CPU TCB*TIME'

SOBYDECT='BYTES*DECRYPTED'

SOBYENCT='BYTES*ENCRYPTED'

SOIOWTCN='SOCKET*IO*WAIT*COUNT'

SOIOWTTM='SOCKET*IO*WAIT*TIME'

SRVSYWCN='SERVER*SYNCPOINT*WAIT*COUNT'

SRVSYWTM='SERVER*SYNCPOINT*WAIT*TIME'

SYNCDLCN='SYNCPOINT*DELAY*COUNT'

SYNCDLTM='SYNCPOINT*DELAY*TIME'

TCBATTCT='CICS*DISPATCHER*TCB*ATTACHES'

WBCHRIN ='WEB*CHARACTERS*RECEIVED'

WBCHROUT='WEB*CHARACTERS*SENT'

WBRCVCT ='WEB*RECEIVE*REQUESTS'

WBREPRCT='REPOSITORY*READS'

WBREPWCT='REPOSITORY*WRITES'

WBSENDCT='WEB*SEND*REQUESTS'

WBTOTCT ='TOTAL*WEB*REQUESTS'

The type 110 subtype 1 (CICSEXCE dataset) adds variables:

EXCMNBTR='BRIDGE*TRANSACTION*ID'

EXCMNCPN='CURRENT*PROGRAM*NAME'

EXCMNFCN='TRANSACTION*FACILITY*NAME'

EXCMNNPX='NETWORK*UNIT-OF-WORK*PREFIX'

EXCMNNSX='NETWORK*UNIT-OF-WORK*PREFIX'

EXCMNRIL='EXCEPTION*RESOURCE*ID*LENGTH'

EXCMNRIX='EXCEPTION*RESOURCE*ID'

EXCMNTRF='TRANSACTION*FLAGS'

EXCMNURI='RRMS/MVS*UNIT OF RECOVERY*ID'

-Statistics STID=55 now creates CICDS Dispatcher Stats

dataset (replacing STID=56 or STID=57). There are now

eleven TCBs separately reported in CICDS dataset:

TCB Var Prefix Abbreviation Description

1 DSG QR Quasi Reentrant

2 DS2 RO Resource Owning

3 DS3 CO Concurrent

4 DS4 SZ Secondary LU

5 DS5 RP ONC/RPC

6 DS6 FO File Owning

7 DS7 SL Sockets Owning SL

8 DS8 SO Sockets Owning SO

9 DS9 J8 J8 Open

10 DSA L8 L8 Open

11 DSB S8 S8 Open

The CICDS labels now conain the TCB abbreviation.

-Statistics STID=67 (CICFCR dataset) has new variables:

A17DTCFP='CF*DATA*TABLE*POOL NAME'

A17DTCON='CHANGED*RESPONSES*FOR CFDT'

A17DTLDS='LOADING*RESPONSES'

-Statistics STID=42 (CICTQR dataset) has new variable:

TQRPDSMN='PDS*MEMBER*NAME'

-Statistics STID=52 (CICCONSR dataset) has new field:

A14ESTPC='PROGRAM*CONTROL*FUNCTION*SHIP*REQUESTS'

-Statistics STID=97 now creates CICNQG ENQ Manager data;

it was previously in STID=96, but not only was the STID

changed, there are four new variables:

NQGGNQSW='TOTAL*SYSPLEX*ENQUES*WAITED'

NQGGNQWT='TOTAL*SYSPLEX*ENQ*WAITING TIME'

NQGSNQSW='CURRENT*SYSPLEX*ENQUEUE*WAITING'

NQGSNQWT='CURRENT*SYSPLEX*ENQ*WAITING TIME'

-New Statistics segments and new Subtypes create seven new

datasets, but I have no test data to validate the code,

so no deaccumulation (if needed) has been written. The

contents of these new datasets are impressive:

MXG DATASET STID DSECT Subtype Description

CICTCPIP 108 SOR 2 TCP/IP Statistics

CICNCS4D 124 NCS4D 5 NC Server List Structure

CICNCS5D 125 NCS5D 5 NC Server Storage Stats

CICCFS6D 126 CFS6D 4 CFTD Server List

CICCFS7D 127 CFS7D 4 CFTD Buffer Statistics

CICCFS8D 128 CFS8D 4 CFTD Request Statistics

CICCFS9D 129 CFS9D 4 CFTD Storage Statistics

Contents of CICTCPIP - TCP/IP Statistics

SORBACKL='TCP/IP*SERVICE*BACKLOG'

SORBYTRC='BYTES*RECEIVED*(ALL SOCKETS)'

SORBYTSN='BYTES*SENT*(ALL SOCKETS)'

SORCLOSG='GMT SERVICE*CLOSE TIME*(GMT)'

SORCLOSL='LOCAL SERVICE*CLOSE TIME*(LOCAL)'

SORCUCON='CURRENT*NUMBER OF*CONNECTIONS'

SORIPADR='TCP/IP*SERVICE*IP ADDRESS'

SOROPENG='GMT SERVICE*OPEN TIME*(GMT)'

SOROPENL='LOCAL SERVICE*OPEN TIME*(LOCAL)'

SORPKCON='PEAK*NUMBER OF*CONNECTIONS'

SORPORTN='TCP/IP*SERVICE*PORT*NUMBER'

SORRECVS='RECEIVES*(ALL SOCKETS)'

SORSENDS='SENDS*(ALL SOCKETS)'

SORSERVN='TCP/IP*SERVICE*NAME'

SORSSLFL='TCP/IP*SERVICE*SSL*SUPPORT'

SORTRANA='TRANSACTIONS*ATTACHED'

Contents of CICNCS4D - NC Server List Structure

S4ASYCT ='NUMBER OF*ASYNCHRONOUS*REQUESTS'

S4CNPREF='PREFIX FOR*CONNECTION*NAME'

S4CNSYSN='OWN MVS*SYSTEM NAME*FROM*CVTSNAME'

S4CRECT ='CREATE*COUNTER'

S4DELCT ='DELETE*COUNTER'

S4ENTRCT='CURRENT*NUMBER*OF ENTRIES*IN USE'

S4ENTRHI='HIGHEST*NUMBER*OF ENTRIES*IN USE'

S4ENTRLO='LOWEST*NUMBER*OF FREE*ENTRIES'

S4ENTRMX='MAX ENTRIES*RETURNED*BY IXLCONN'

S4GETCT ='GET AND*INCREMENT*COUNTER'

S4KEQCT ='INQUIRE*KEQ'

S4KGECT ='INQUIRE*KGE'

S4POOL ='POOL NAME*PART OF*STRUCTURE NAME'

S4PREF ='FIRST*PART OF*STRUCTURE*NAME'

S4RSP1CT='NORMAL RESPONSE EVERYTHING OK'

S4RSP2CT='NO MATCHING*ENTRY*WAS FOUND'

S4RSP3CT='ENTRY*VERSION*DID NOT*MATCH'

S4RSP4CT='LIST*AUTHORITY*COMPARISON*MISMATCH'

S4RSP5CT='THE LIST*STRUCTURE*IS OUT*OF SPACE'

S4RSP6CT='IXLLIST*RETURN*CODE*OCCURRED*OTHER'

S4SETCT ='SET*COUNTER'

S4SIZE ='STRUCTURE*SIZE*(UNSIGNED*FULLWORD)'

S4SIZEMX='MAXIMUM*STRUCTURE*SIZE'

Contents of CICNCS5D - NC Server Storage Statistics

S5ANYFR ='NUMBER OF*FREE PAGES*IN THE POOL'

S5ANYLO ='LOWEST*FREE*PAGES*(SINCE RESET)'

S5ANYMX ='TOTAL PAGES*IN THE*STORAGE*POOL'

S5ANYNAM='POOL NAME*AXMPGANY'

S5ANYPTR='ADDRESS OF*STORAGE*POOL*AREA'

S5ANYRQC='COMPRESS*(DEFRAGMENTATION)*ATTEMPTS'

S5ANYRQF='GETS*WHICH FAILED*TO OBTAIN*STORAGE'

S5ANYRQG='STORAGE*GET*REQUESTS'

S5ANYRQS='STORAGE*FREE*REQUESTS'

S5ANYSIZ='SIZE OF*STORAGE*POOL*AREA'

S5ANYUS ='NUMBER OF*USED PAGES*IN THE POOL'

S5LOWFR ='NUMBER OF*FREE PAGES*IN THE POOL'

S5LOWLO ='LOWEST*FREE*PAGES*(SINCE RESET)'

S5LOWMX ='TOTAL PAGES*IN THE*STORAGE*POOL'

S5LOWNAM='POOL NAME*AXMPGLOW'

S5LOWPTR='ADDRESS OF*STORAGE*POOL*AREA'

S5LOWRQC='COMPRESS*(DEFRAGMENTATION)*ATTEMPTS'

S5LOWRQF='GETS*WHICH FAILED*TO OBTAIN*STORAGE'

S5LOWRQG='STORAGE*GET*REQUESTS'

S5LOWRQS='STORAGE*FREE*REQUESTS'

S5LOWSIZ='SIZE OF*STORAGE*POOL*AREA'

S5LOWUS ='NUMBER OF*USED PAGES*IN THE POOL'

Contents of CICCSF6D - CFTD Server List

S6CNPREF='PREFIX*FOR*CONNECTION*NAME'

S6CNSYSN='OWN MVS*SYSTEM NAME*FROM CVTSNAME'

S6ELEMCT='CURRENT*NUMBER OF*ELEMENTS*IN USE'

S6ELEMHI='HIGHEST*NUMBER OF*ELEMENTS*IN USE'

S6ELEMLN='DATA*ELEMENT*SIZE'

S6ELEMLO='LOWEST*NUMBER OF*FREE*ELEMENTS'

S6ELEMMX='MAX ELEMENTS*RETURNED*BY IXLCONN'

S6ELEMPE='MAX ELEMENTS*PER ENTRY*(FOR 32K)'

S6ELEMPW='DATA*ELEMENT*SIZE*AS POWER OF 2'

S6ELEMRT='ELEMENT SIDE*OF ENTRY*ELEMENT RATIO'

S6ENTRCT='CURRENT*NUMBER OF*ENTRIES*IN USE'

S6ENTRHI='HIGHEST*NUMBER OF*ENTRIES*IN USE'

S6ENTRLO='LOWEST*NUMBER OF*FREE*ENTRIES'

S6ENTRMX='MAX ENTRIES*RETURNED*BY IXLCONN'

S6ENTRRT='ENTRY SIDE*OF ENTRY*ELEMENT RATIO'

S6FREECT='NUMBER OF*ENTRIES*ON FREE LIST'

S6FREEHI='HIGHEST*ENTRIES*ON FREE LIST'

S6HDRS ='MAXIMUM*NUMBER OF*LIST*HEADERS'

S6HDRSCT='HEADERS*USED FOR*CONTROL*LISTS'

S6HDRSTD='HEADERS*AVAILABLE FOR*TABLE DATA'

S6INDXCT='NUMBER OF*ENTRIES*IN TABLE INDEX'

S6POOL ='POOL NAME*PART OF*STRUCTURE*NAME'

S6PREF ='FIRST PART*OF*STRUCTURE*NAME'

S6RSP8CT='AN IXLLIST*RETURN*CODE*OCCURRED*OTHER'

S6SIZE ='STRUCTURE*SIZE*'

S6SIZEMX='MAXIMUM*STRUCTURE*SIZE'

S6USEDCT='NUMBER OF*ENTRIES*ON USED LIST'

S6INDXHI='HIGHEST*ENTRIES*IN TABLE INDEX'

S6APPLCT='NUMBER OF*ENTRIES*IN APPLID LIST'

S6APPLHI='HIGHEST*ENTRIES*IN APPLID LIST'

S6UOWLCT='NUMBER OF*ENTRIES*IN UOW LIST'

S6UOWLHI='HIGHEST*ENTRIES*IN UOW LIST'

S6RDICT ='READ*TABLE*INDEX*ENTRY'

S6WRICT ='WRITE*TABLE*INDEX*ENTRY'

S6RWICT ='REWRITE*TABLE*INDEX*ENTRY'

S6DLICT ='DELETE*TABLE*INDEX*ENTRY'

S6CRLCT ='CREATE*LIST'

S6MDLCT ='MODIFY*LIST'

S6DLLCT ='DELETE*LIST'

S6RDDCT ='READ*DATA*ITEM'

S6WRDCT ='WRITE*DATA*ITEM'

S6RWDCT ='REWRITE*DATA*ITEM'

S6DLDCT ='DELETE*DATA*ITEM'

S6INLCT ='INQUIRE*ON*DATA LIST'

S6RDMCT ='READ*MESSAGE*QUEUE'

S6WRMCT ='WRITE TO*MESSAGE*QUEUE'

S6RDUCT ='READ*UOW*ENTRY'

S6WRUCT ='WRITE*UOW*ENTRY'

S6RWUCT ='REWRITE*UOW*ENTRY'

S6DLUCT ='DELETE*UOW*ENTRY'

S6RDACT ='READ*APPLID*ENTRY'

S6WRACT ='WRITE*APPLID*ENTRY'

S6RWACT ='REWRITE*APPLID*ENTRY'

S6DLACT ='DELETE*APPLID*ENTRY'

S6RRLCT ='REREAD*ENTRY FOR*FULL DATA*LENGTH'

S6ASYCT ='NUMBER OF*ASYNCHRONOUS*REQUESTS'

S6RSP1CT='NORMAL*RESPONSE*EVERYTHING*OK'

S6RSP2CT='BUFFER LEN*TOO SHORT*FULL LENGTH*REREAD'

S6RSP3CT='NO MATCHING*ENTRY*WAS FOUND'

S6RSP4CT='ENTRY VERSION*DID NOT*MATCH'

S6RSP5CT='LIST*AUTHORITY*COMPARISON*MISMATCH'

S6RSP6CT='MAXIMUM*LIST*KEY*REACHED'

S6RSP7CT='THE LIST*STRUCTURE*IS OUT OF*SPACE'

S6USEDHI='HIGHEST*ENTRIES*ON USED LIST'

Contents of CICCSF7D - CFTD Buffer Statistics

S7OCCLOS='CLOSE*TABLE'

S7OCDELE='DELETE*TABLE'

S7OCOPEN='OPEN*TABLE'

S7OCSET ='SET TABLE*ATTRIBUTES'

S7OCSTAT='EXTRACT*TABLE*STATISTICS'

S7RQHIGH='RETURN*HIGHEST*KEY'

S7RQLOAD='LOAD '

S7RQPOIN='POINT '

S7RQRDDL='READ*AND*DELETE'

S7RQREAD='READ*(INCLUDING READ*FOR UPDATE)'

S7RQREWR='REWRITE'

S7RQUNLK='UNLOCK'

S7RQWRIT='WRITE*(NEW RECORD)'

S7TABLE ='TABLE*NAME'

Contents of CICCSF8D - CFTD Request Statistics

S8IQINQU='INQUIRE*TABLE'

S8OCCLOS='CLOSE*TABLE'

S8OCDELE='DELETE*TABLE'

S8OCOPEN='OPEN*TABLE'

S8OCSET ='SET TABLE*ATTRIBUTES'

S8OCSTAT='EXTRACT*TABLE*STATISTICS'

S8RQDELE='DELETE*RECORD'

S8RQDELM='DELETE*MULTIPLE*RECORDS'

S8RQHIGH='RETURN*HIGHEST*KEY'

S8RQLOAD='LOAD*RECORD*AT INITIAL*LOAD TIME'

S8RQPOIN='POINT*TO*RECORD'

S8RQRDDL='READ*AND*DELETE*RECORD'

S8RQREAD='READ*RECORD*(INCLUDES*FOR UPDATE)'

S8RQREWR='REWRITE*EXISTING*RECORD'

S8RQUNLK='UNLOCK*RECORD'

S8RQWRIT='WRITE*NEW*RECORD'

S8SPBACK='BACK OUT*UNIT OF WORK'

S8SPCOMM='COMMIT*UNIT OF WORK'

S8SPINQU='INQUIRE*ABOUT*UNIT OF WORK'

S8SPPREP='PREPARE*TO COMMIT*UNIT OF WORK'

S8SPREST='RESTART*RECOVERABLE*CONNECTION'

S8SPRETA='RETAIN*LOCKS FOR*UNIT OF WORK'

Contents of CICCSF9D - CFTD Storage Statistics

S9ANYFR ='NUMBER OF*FREE PAGES*IN THE POOL'

S9ANYLO ='LOWEST*FREE*PAGES*(SINCE RESET)'

S9ANYMX ='TOTAL PAGES*IN THE*STORAGE*POOL'

S9ANYNAM='POOL NAME*AXMPGANY'

S9ANYPTR='ADDRESS OF*STORAGE*POOL*AREA'

S9ANYRQC='COMPRESS*(DEFRAGMENTATION)*ATTEMPTS'

S9ANYRQF='GETS WHICH*FAILED TO*OBTAIN STORAGE'

S9ANYRQG='STORAGE*GET*REQUESTS'

S9ANYRQS='STORAGE*FREE*REQUESTS'

S9ANYSIZ='SIZE OF*STORAGE*POOL*AREA'

S9ANYUS ='NUMBER OF*USED PAGES*IN THE POOL'

S9LOWFR ='NUMBER OF*FREE PAGES*IN THE POOL'

S9LOWLO ='LOWEST FREE PAGES (SINCE RESET)'

S9LOWMX ='TOTAL PAGES*IN THE*STORAGE POOL'

S9LOWNAM='POOL NAME*AXMPGLOW'

S9LOWPTR='ADDRESS OF*STORAGE*POOL*AREA'

S9LOWRQC='COMPRESS*(DEFRAGMENTATION)*ATTEMPTS'

S9LOWRQF='GETS WHICH*FAILED TO*OBTAIN STORAGE'

S9LOWRQG='STORAGE*GET*REQUESTS'

S9LOWRQS='STORAGE*FREE*REQUESTS'

S9LOWSIZ='SIZE OF*STORAGE*POOL*AREA'

S9LOWUS ='NUMBER OF*USED PAGES*IN THE POOL'

Change 16.321 If the last structure in a type 74 subtype 4 record had

VMAC74 an extension, the extension was not input, so variables

Jan 12, 1999 R774CRHC thru R744CWUC were missing TYPE74ST dataset for

that observation. My existence test for the extension:

IF R744CDSI GT 0 AND CDSILOC+200 LE LENGTH THEN DO;

INPUT @(SMF744CO+(R744CDSI-1)*SMF744CL)

should have been:

IF R744CDSI GT 0 AND CDSILOC+200 LE LENGTH-1 THEN DO;

but clearer/safer logic is to use R744CDNE to validate

the existence of the extension, so the test now is:

IF R744CDSI GT 0 AND R744CDNE GE 1 THEN DO;

INPUT @CDSILOC

Thanks to Bruce Widlund, Merrill Consultants, USA.
Change 16.320 This test member had hex strings that caused FTP to gag

ZTIMECHK when the MXG Source Library was FTP'd from MVS; as it was

Jan 10, 1999 only for my internal testing, the member was deleted.

Thanks to Freddie Arie, Lone Star Gas, USA.

Change 16.319 Using the new TYPSAIM0 member (for FACOM operating sys)

VMACAIM0 failed, as the MACRO _SAIM0 _SAIM0 % syntax failed. As

Jan 10, 1999 it was not really needed, it was deleted. This was the

only instance in which a dataset sort macro name was the

same as the member sort macro name, and the only place

that that syntax was used in a VMAC member.

Thanks to Chuck Hopf, MBNA, USA.
Change 16.318 Support for DB2 Version 6.1 (COMPATIBLE):

EX102230 It appears that all of the changes in 6.1 were added at

EX102233 the end of segments, so MXG 15.15+ will not fail with the

EX102242 DB2 6.1 records, but none of the new information will be

EX102243 decoded by MXG until you install MXG 16.09 or later.

EX102247 -The QWHA Data Sharing Header (new in Version 5.1) is now

EX102248 decoded, creating new variables in Accounting datasets

EX102249 DB2ACCT,DB2ACCTP, DB2ACCTB and DB2ACCTG:

EX102250 QWHAMEMN='DB2*MEMBER*NAME'

EX102251 QWHADSGN='DB2*DATA SHARING*GROUP*NAME'

EX102252 -The QWHC Correlation Header was extended and contains new

EX102254 End User information added to DB2ACCT,DB2ACCTP,DB2ACCTB

EX102255 and DB2ACCTG Accounting datasets.

EX102256 QWHCEUID='END USERS*USERID*AT WORKSTATION'

EX102257 QWHCEUTX='END USERS*TRANSACTION*NAME'

EX102258 QWHCEUWN='END USERS*WORKSTATION*NAME'

EX102259 -New QWAX segment contains waits and counts, some of which

EX102260 were previously QWACxxxx fields in the DB2ACCT datasets:

EX102261 QWAXALCT='ARCHIVES*LOG MODE*(QUIESCE)'

EX102262 QWAXALOG='WAIT TIME*DUE TO PROCESSING*OF ARCH LOG'

EX102263 QWAXANAR='WAITS FOR*ARCHIVE READS'

EX102265 QWAXARNC='WAITS FOR*SUSPENSIONS*FOR CLAIMS'

EX102266 QWAXARND='WAITS FOR*A DRAIN LOCK'

EX102267 QWAXAWAR='WAIT TIME FOR ARCHIVE READS (TAPE)'

EX102268 QWAXAWCL='WAIT TIME FOR A DRAIN FOR CLAIMS'

EX102272 QWAXAWDR='WAIT TIME FOR A DRAIN LOCK'

EX102273 QWAXDSNS='WAITS FOR*DATASPACE MGR*TASKS'

EX102305 QWAXDSSE='WAIT TIME*FOR DATASPACE SERVICE'

EX102306 QWAXOCNS='WAITS FOR*OPEN/CLOSE OR*HSM RECALL'

EX102311 QWAXOCSE='WAIT TIME*FOR OPEN/CLOSE OR*HSM RECALL'

EX102312 QWAXOTNS='WAITS FOR*SWITCH TO OTHER*DB2 SERV TASKS'

EX102313 QWAXOTSE='WAIT TIME*SWITCH TO OTHER*DB2 SERV TASKS'

EX102314 QWAXSLNS='WAITS FOR*SYSLGRNG*RECORDING'

FORMATS QWAXSLSE='WAIT TIME*FOR SYSLGRNG*RECORDING'

VMACDB2 -The QWAC segment was extended with SIGNIFICANT NEW DATA!!

VMACDB2H for DB2's interaction with Workload Manager's new Enclave

Jan 9, 1999 architecture, as well as new measurements of the elapsed

Jan 12, 1999 and TCB CPU time spent in Stored Procedures and in User

Defined Functions, and with SQL time separated as well:

QWACLRAB='BYTES*LOGGED'

QWACLRN ='LOG*RECORDS*WRITTEN'

QWACPECT='TCB TIME*BEFORE*ENCLAVE*CREATION'

QWACSPEA='ET EXECUTING*STORED PROCS*INCLUDES SQL'

QWACSPEB='ET EXECUTING*STORED PROCS*SQL TIME'

QWACTREE='ET*EXECUTING*TRIGGERS*UNDER AN*ENCLAVE'

QWACTRET='ET EXECUTING*TRIGGERS*NOT UNDER ENCLAVE'

QWACTRTE='TCB TIME*EX TRIGGERS*UNDER AN*ENCLAVE'

QWACTRTT='TCB TIME*EX TRIGGERS*NOT UNDER ENCLAVE'

QWACUDCP='TCB TIME*USRDEFUN*STORED PROC*OR WLM AS'

QWACUDEA='ET USRDEFUN*TOTAL INCLUDES*SQL TIME'

QWACUDEB='ET USRDEFUN*ONLY*SQL TIME'

QWACUDNE='SQL ENTRY/EXIT*EVENTS*USER DEF FUNCTION'

QWACUDST='ET WAITNG FOR AVAIL TCB*TO SKED*USRDEFUN'

QWACUDTT='TCB TIME*USRDEFUN*SQL TIME*(IN QWACUDCP)'

QWACWLME='SERVICE*CLASS*NAME'

-The first QWDA segment is now decoded creating variable

QWDAXCQO='MEMBER NAME OF*PARALLELISM*COORDINATOR'

for child tasks. There can be multiple segments for the

coordinating task, but only the first is read now, until

test data and a need presents itself.

-For packages, the QPAC segment that created DB2ACCTP has

been enhanced with new variables:

QPACAAFG='ACTIVITY*TYPE*FLAG'

(decoded with new format $MGDB2PK with values of

01-stored proc,02-userdefun,03-trigger executing)

QPACAANM='NAME*OF*ACTIVITY'

QPACASCH='NESTED*ACTIVITY*SCHEMA*NAME'

QPACSPNS='STORED*PROCEDURES EXECUTED'

QPACUDST='ET WAITING*FOR TCB*BEFORE SKED*USRDEFUN'

QPACUDNU='USER-DEFINED*FUNCTIONS*SCHEDULED'

-The QXST segment was extended with new variables in both

the DB2ACCT and DB2STATS datasets:

QXALOCC ='ALLOCATE*CURSOR*STATEMENTS*EXECUTED'

QXALOCL ='ASSOCIATE*LOCATOR*STATEMENTS*EXECUTED'

QXALPRO ='ALTER*PROCEDURE*STATEMENTS'

QXALUDF ='ALTER*FUNCTION*STATEMENTS'

QXCASCDP='MAX LEVEL*OF NESTED*SQL CASCADING'

(includes cascading due to triggers, udfs,

and stored procedures).

QXCAUD ='USER*DEFINED*FUNCTIONS*EXECUTED'

QXCAUDAB='TIMES*USERDEFUN*ABENDED'

QXCAUDRJ='TIMES USERDEFUN*WAS REJECTED'

QXCAUDTO='TIMES*UDF*TIMED OUT*WAITING TO BE SKED'

QXCDIST ='CREATE*DISTINCT*TYPE*STATEMENTS'

QXCRATB ='CREATE*AUX TABLE*STATEMENTS'

QXCRPRO ='CREATE*PROCEDURE*STATEMENTS'

QXCRUDF ='CREATE*FUNCTION*STATEMENTS'

QXCTRIG ='CREATE*TRIGGER'

QXDDIST ='DROP *DISTINCT*TYPE*STATEMENTS'

QXDRPFN ='DROP*USER*DEFINED*FUNCTION'

QXDRPPR ='DROP*STORED*PROCEDURE'

QXDRPTR ='DROP*TRIGGER'

QXFREEL ='FREE*LOCATOR*STATEMENTS'

QXHOLDL ='HOLD*LOCATOR*STATEMENTS'

QXREPOP1='PARALLEL*GROUPS*REFORMULATED*SYSPLEX'

QXREPOP2='PARALLEL*GROUPS*REFORMULATED*BUFFERS'

QXRNTAB ='RENAME*TABLE'

QXROIIDX='DIRECT ROW*REVERTED*USED*AN INDEX'

QXROIMAT='DIRECT ROW*ACCESS*WAS SUCCESSFUL'

QXROITS ='DIRECT ROW*REVERTED*USED*TABLESPACE SCAN'

QXROWTRG='ROW TRIGGER*WAS ACTIVATED'

QXSETPTH='SET*CURRENT PATH*STATEMENTS'

QXSTDEXP='EX COPY*DISCARDED*DUE TO*MAXKEEPD LIMIT'

QXSTDINV='EX COPY*PURGED*DUE TO*DEPENDENT OBJECT'

QXSTFND ='PREPARE REQUESTS*SAT BY*COPY FROM CACHE'

QXSTIPRP='IMPLICIT PREPARE*BUT DB2*HAD NO VALID'

QXSTLOBV='MAX STORAGE*BYTES USED*FOR LOB VALUES'

QXSTNFND='PREPARE REQUEST*BUT NO*MATCH IN CACHE'

QXSTNPRP='PREPARE AVOIDED*DB2 HAD*VALID KEEPDYNAM'

QXSTTRG ='STATEMENT TRIGGER*WAS ACTIVATED'

QXTRGERR='SQL ERRORS*DURING EX*OF TRIGGERED ACTION'

-The QBGL segment added new variables to DB2STATS:

QBGL2F ='CHANGED*PAGE WRITES*FAILED*STORAGE'

QBGL2D ='DELETE*NAME*LIST*REQUESTS'

QBGL2N ='DELETE*NAME*REQUESTS'

QBGL2R ='READ*CASTOUT*STATS*REQUESTS'

QBGL2S ='COMPLETION*CHECKS*SUSPENDED'

QBGL2W ='CHANGED*PAGE WRITES*FOR DUPLEXING'

DB2 Trace Records:
-IFCID 106 added these new variables to T102S106:

QWP1BDUR='RESTART*BACKOUT*LIMIT*(0-255)'

QWP1DBPR='DATABASE*PROTOCOL*FOR 3-PART*NAMES'

QWP1DTIM='TIME*BETWEEN*RESET OF*DSET STATS'

QWP1EXBR='MAX EXTRA*DRDA QUERY BLKS*REQUESTER'

QWP1EXBS='MAX EXTRA*DRDA QUERY BLKS*SERVER'

QWP1FLBZ='MAX DSN1DBM1 STORAGE*FAST LOG APPLY'

QWP1IXPL='DEFAULT*BUFFER POOL*FOR USER INDEXES'

QWP1LMBO='LIMIT*RESTART*BACKOUT*(NO,YES,AUTO)'

QWP1LVA ='KILOBYTES*FOR LOB VALUES*PER AGENT'

QWP1LVLC='QWP1LVLC*(S)'

QWP1LVS ='MEGABYTES*FOR LOB VALUES*PER SYSTEM'

QWP1SCER='EXTENDED*SECURITY'

QWP1TBPL='DEFAULT*BUFFER POOL*FOR USER DATA'

QWP1URCK='UR*CHECKPOINT*THRESHOLD'

QWP1WLME='DEFAULT*WLM*ENVIRONMENT'

QWP4AURT='QWP4AURT*(S)'

QWP4FLBS='QWP4FLBS*(S)'

QWP4FLMT='QWP4FLMT*(S)'

QWP4MXKD='MAXIMUM*KEPT*DYNAMIC*STATEMENTS'

QWP4PAC ='PACKAGE*AUTHORIZATION*CACHE'

QWP4RHTI='QWP4RHTI*(S)'

QWP4SREC='QWPRSREC*(S)'

QWP4UBS ='QWP4UBS*(S)'

QWP4UMD ='QWPRUMD*(S)'

QWP4WBMP='IMS/BMP*TIMEOUT*FACTOR'

QWP4WDLI='IMS/DLI*TIMEOUT*FACTOR'

QWP4XCTH='QWP4XCTH*(S)'

QWP9MAX1='MAXIMUM*TYPE 1*INACTIVE*THREADS'

QWPBAGID='ASCII GBCS CCSID'

QWPBAMID='ASCII MBCS CCSID'

QWPBAR ='DECIMAL ARITHMETIC DEFAULT'

QWPBASID='ASCII SBCS CCSID'

QWPBCHAR='CHARSET DEFAULT'

QWPBCMP ='COMPATIBILITY OPTION'

QWPBDATE='DATE FORMAT (ISO,JIS,EUR,LOCAL,USA)'

QWPBDE ='PERIOD/COMMA DEFAULT'

QWPBDL ='DELIMITER DEFAULT'

QWPBDLEN='LOCAL (ONLY) DATE LENGTH DEFAULT'

QWPBDSD ='DISTRIBUTED SQL STRING DELIMITER'

QWPBENS ='DEFAULT ENCODING SCHEME'

QWPBGID ='GBCS CCSID'

QWPBGRA ='YES/NO MIXED GRAPHIC DEFAULT'

QWPBLANG='LANGUAGE DEFAULT'

QWPBLVL ='QWPBLVL*(S)'

QWPBMID ='MBCS CCSID'

QWPBREL ='VERSION*RELEASE*MOD LEVEL'

QWPBRIB ='POINTER TO RELEASE INFO BLOCK'

QWPBSDL ='SQL DELIMITER DEFAULT'

QWPBSID ='SBCS CCSID'

QWPBSQL ='LEVEL OF SQL LANGUAGE SUPPORT'

QWPBSSID='SUBSYSTEM DEFAULT'

QWPBTIME='TIME FORMAT (ISO,JIS,EUR.LOCAL,USA)'

QWPBTLEN='LOCAL (ONLY) TIME LENGTH DEFAULT'

-IFCID 0258 was added by APAR PQ17544 for 5.1 and 6.1. It

is decoded (even though I have no test data) as it may be

very useful: dataset T102S258 tracks when any of your DB2

databases are expanded in size. You can use it to track

database growth and avoid the catastrophy of exceeding

the maximum size of a DB2 table! These variables are

in the new T102S258 (DB2 DATASET EXTEND SPACE) dataset:

QW0258DB='DATABASE*ID*(DBID)'

QW0258DN='DATABASE*NAME'

QW0258DS='DATASET*NAME'

QW0258HA='HIGH*ALLOCATED*AFTER*EXTEND,BYTES'

QW0258HB='HIGH*ALLOCATED*BEFORE*EXTEND*BYTES'

QW0258MS='MAXIMUM*DATA*SET*SIZE,BYTES'

QW0258PQ='PRIMARY*QUANTITY*BYTES'

QW0258PS='PAGESET*ID*(OBID)'

QW0258SQ='CURRENT*SECONDARY*QUANTITY,BYTES'

QW0258TN='TABLE/INDEX*SPACE*NAME'

QW0258TS='TIMESTAMP*AFTER*EXTEND*COMPLETED'

QW0258VA='NUMBER OF*VOLUMES*AFTER'

QW0258VB='NUMBER OF*VOLUMES*BEFORE'

QW0258VM='MAXIMUM*VOLUMES'

QW0258XA='NUMBER OF*EXTENTS*AFTER'

QW0258XB='NUMBER OF*EXTENTS*BEFORE'

QW0258XM='MAXIMUM*EXTENTS'

The storage measures labeled "bytes" are formatted with

MGBYTES so they will print as MB, GB, etc.

The QW0258TS timestamp is a blind guess as to format, so

it may be wrong until I get test data for validation.

-Trace IFCIDs thru 314 now exist, although many IFCIDs are

skipped. MXG defines a set of macro names for all 314 of

the possible IFCIDs, thru dataset T102S314, so that IFCID

ranges can be selected in READDB2 and ANALDB2R logic, but

there are only 32 new IFCIDs (some of which were added by

DB2 5.1) that can have any observations. I have created

the DB2 header variables in the new datasets for these

new subtypes of type 102 records, but I need test SMF

data records before I can decode their innards.
Dataset Description
T102S230 DATA SHARING GLOBAL STATS'

T102S233 START/END CALL TO STORED PROC'

T102S242 BEGIN WAIT FOR SKED STORED PROC'

T102S243 END WAIT FOR SKED STORED PROC'

T102S247 INPUT HOST VARIABLE'

T102S248 INPUT HOST VARIABLE'

T102S249 INPUT HOST VARIABLE'

T102S250 CONNECT/DISCONNECT GROUP BUFPOOL'

T102S251 INTEREST CHANGES DATA SHARING'

T102S252 BEGIN XES REQUEST'

T102S254 CACHE STRUCTS FOR GROUP BUFPOOL'