Previous Topic: EXTDATA Record Type - OHFS

Next Topic: EXTDATA Record Type - CMCC


EXTDATA Record Type - S101

For a description of the source fields listed in the third column, see these IBM guides: DB2 Administration Guide and DB2 Application Programming and SQL Guide. For a field-by-field breakdown, see the DSNDQxxx macros in the dataset &DB2prefix...DB2810.ADSNMACS.

The MRXT101 and MZXT101 record definitions define the EXTDATA records created by CA JARS from SMF record 101, DATABASE 2 Accounting.

CA JARS EXTDATA Variable Name

SMF Data Field

Notes

EXT101_AID

QWHCAID

 

EXT101_SID

SM101SID

 

EXT101_BSCD

QWACBSC

 

EXT101_BSCT

QWACBSC

 

EXT101_CCN

QWHCCN

 

EXT101_PLAN

QWHCPLAN

 

EXT101_CCV

QWHCCV

 

EXT101_NID

QWACNID

 

EXT101_SSSID

QWHSSSID

 

EXT101_SRN

QWHSRN

 

EXT101_RINV

QWACRINV

 

EXT101_SISEQ

QWHSISEQ

 

EXT101_SWSEQ

QWHSWSEQ

 

EXT101_SMTN

QWHSWMTN

 

EXT101_COMM

QWACCOMM

 

EXT101_ABRT

QWACABRT

 

EXT101_ASC

QWACESC

 

EXT101_JST

QWACBJST

 

EXT101_SRB

QWACBSRB

 

EXT101_AWTI

QWACAWTI

 

EXT101_AWTL

QWACAWTL

 

EXT101_ARNE

QWACARNE

 

EXT101_ARNA

QWACARNA

 

EXT101_0GET

QBACGET

 

EXT101_0BPX

QBACBPX

QBACBPX is obsolete. After DB2 4.1, it is overlaid with QBACSWS.

EXT101_0SWS

QBACSWS

 

EXT101_0SWU

QBACSWU

QBACSWU is obsolete. After DB2 4.1, it is overlaid with QBACRIO.

EXT101_0RIO

QBACRIO

 

EXT101_0SEQ

QBACSEQ

 

EXT101_1GET

QBACGET

 

EXT101_1BPX

QBACBPX

QBACBPX is obsolete. After DB2 4.1, it is overlaid with QBACSWS.

EXT101_1SWS

QBACSWS

 

EXT101_1SWU

QBACSWU

QBACSWU is obsolete. After DB2 4.1, it is overlaid with QBACRIO.

EXT101_1RIO

QBACRIO

 

EXT101_1SEQ

QBACSEQ

 

EXT101_2GET

QBACGET

 

EXT101_2BPX

QBACBPX

QBACBPX is obsolete. After DB2 4.1, it is overlaid with QBACSWS.

EXT101_2SWS

QBACSWS

 

EXT101_2SWU

QBACSWU

QBACSWU is obsolete. After DB2 4.1, it is overlaid with QBACRIO.

EXT101_2RIO

QBACRIO

 

EXT101_2SEQ

QBACSEQ

 

EXT101_3GET

QBACGET

 

EXT101_3BPX

QBACBPX

 

EXT101_3SWS

QBACSWS

 

EXT101_3SWU

QBACSWU

 

EXT101_3RIO

QBACRIO

 

EXT101_3SEQ

QBACSEQ

 

EXT101_DEA

QTXADEA

 

EXT101_SUS

QTXASLOC

 

EXT101_TIM

QTXATIM

 

EXT101_LES

QTXALES

 

EXT101_LEX

QTXALEX

 

EXT101_NPL

QTXANPL

 

EXT101_SELCT

QXSELECT

 

EXT101_INSRT

QXINSRT

 

EXT101_UPDTE

QXUPDTE

 

EXT101_DELET

QXDELET

 

EXT101_DESC

QXDESC

 

EXT101_PREP

QXPREP

 

EXT101_OPEN

QXOPEN

 

EXT101_CLOSE

QXCLOSE

 

EXT101_CRTAB

QXCRTAB

 

EXT101_CRINF

QXCRINX

 

EXT101_CTABS

QXCTABS

 

EXT101_CRSYN

QXCRSYN

 

EXT101_CRDAB

QXCRDAB

 

EXT101_CRSTG

QXCRSTG

 

EXT101_DEFVU

QXDEFVU

 

EXT101_DRPIX

QXDRPIX

 

EXT101_DRPTA

QXDRPTA

 

EXT101_DRPTS

QXDRPTS

 

EXT101_DRPDB

QXDRPDB

 

EXT101_DRPSY

QXDRPSY

 

EXT101_DRPST

QXDRPST

 

EXT101_DRPVU

QXDRPVU

 

EXT101_ALTST

QXALTST

 

EXT101_FETCH

QXFETCH

 

EXT101_ALTTS

QXALTTS

 

EXT101_ALTTA

QXALTTA

 

EXT101_ALTIX

QXALTIX

 

EXT101_CMTON

QXCMTON

 

EXT101_LOCK

QXLOCK

 

EXT101_GRANT

QXGRANT

 

EXT101_REVOK

QXREVOK

 

EXT101_INCRB

QXINCRB

 

EXT101_LABON

QXLABON

 

EXT101_4KGET

QBACGET

 

EXT101_4KBPX

QBACBPX

QBACBPX is obsolete. After DB2 4.1, it is overlaid with QBACSWS.

EXT101_4KSWS

QBACSWS

 

EXT101_4KSWU

QBACSWU

QBACSWU is obsolete. After DB2 4.1, it is overlaid with QBACRIO.

EXT101_4KRES

Reserved

 

EXT101_4KRIO

QBACRIO

 

EXT101_4KSEQ

QBACSEQ

 

EXT101_4KIMW

QBACIMW

 

EXT101_4KLPF

QBACLPF

 

EXT101_4KDPF

QBACDPF

 

EXT101_4KHRE

QBACHRE

QBACHRE is obsolete. In DB2 8.1, it is reserved.

EXT101_4KHRF

QBACHRF

QBACHRF is obsolete. In DB2 8.1, it is reserved.

EXT101_4KHWR

QBACHWR

QBACHWR is obsolete. In DB2 8.1, it is reserved.

EXT101_4KHWF

QBACHWF

QBACHWF is obsolete. In DB2 8.1, it is reserved.

EXT101_4KNGT

QBACNGT

 

EXT101_4KSIO

QBACSIO

 

EXT101_4KHPG

QBACHPG

QBACHPG is obsolete. In DB2 8.1, it is reserved.

EXT101_32KGET

QBACGET

 

EXT101_32KBPX

QBACBPX

QBACBPX is obsolete. After DB2 4.1, it is overlaid with QBACSWS.

EXT101_32KSWS

QBACSWS

 

EXT101_32KSWU

QBACSWU

QBACSWU is obsolete. After DB2 4.1, it is overlaid with QBACRIO.

EXT101_32KRES

Reserved

 

EXT101_32KRIO

QBACRIO

 

EXT101_32KSEQ

QBACSEQ

 

EXT101_32KIMW

QBACIMW

 

EXT101_32KLPF

QBACLPF

 

EXT101_32KDPF

QBACDPF

 

EXT101_32KHRE

QBACHRE

QBACHRE is obsolete. In DB2 8.1, it is reserved.

EXT101_32KHRF

QBACHRF

QBACHRF is obsolete. In DB2 8.1, it is reserved.

EXT101_32KHWR

QBACHWR

QBACHWR is obsolete. In DB2 8.1, it is reserved.

EXT101_32KHWF

QBACHWF

QBACHWF is obsolete. In DB2 8.1, it is reserved.

EXT101_32KNGT

QBACNGT

 

EXT101_32KSIO

QBACSIO

 

EXT101_32KHPG

QBACHPG

QBACHPG is obsolete. In DB2 8.1, it is reserved.

EXT101_HSLCN

QWHSLOCN

 

EXT101_HSNID

QWHSNID

 

EXT101_HSLUN

QWHSLUNM

 

EXT101_HSLUV

QWHSLUUV

 

EXT101_HSLUC

QWHSLUCC

 

EXT101_HCOPD

QWHCOPID

 

EXT101_HCTYP

QWHCATYP

 

EXT101_HCTOK

QWHCTOKN

 

EXT101_HCRES

Reserved

 

EXT101_STSQL

QXSETSQL

 

EXT101_STALS

QXCRALS

 

EXT101_STDRA

QXDRPAL

 

EXT101_STMIA

QXMIAP

 

EXT101_STSMI

QXNSMIAP

 

EXT101_STRMI

QXMRMIAP

 

EXT101_STTHV

QXSETHV

 

EXT101_STDAB

QXALDAB

 

EXT101_STPKG

QXDRPPKG

 

EXT101_STRTB

QXDSCRTB

 

EXT101_STDEG

QXMAXDEG

 

EXT101_STGRP

QXTOTGRP

 

EXT101_STCUR

QXDEGCUR

 

EXT101_STESA

QXDEGESA

 

EXT101_STBUF

QXDEGBUF

 

EXT101_STDGR

QXREDGRP

 

EXT101_STORG

QXNORGRP

 

EXT101_STON1

QXCON1

 

EXT101_STON2

QXCON2

 

EXT101_STREL

QXREL

 

EXT101_STSTC

QXSETCON

 

EXT101_STCDG

QXSETCDG

 

EXT101_STCRL

QXSETCRL

 

EXT101_STCAL

QXCALL

 

EXT101_STLAB

QXCALLAB

 

EXT101_STLTO

QXCALLTO

 

EXT101_STLRJ

QXCALLRJ

 

EXT101_STENC

QXDEGENC

 

EXT101_ACASC

QWACASC

 

EXT101_ACJST

QWACAJST

 

EXT101_ACSRB

QWACASRB

 

EXT101_ACWTR

QWACAWTR

 

EXT101_ACWTW

QWACAWTW

 

EXT101_ACWTE

QWACAWTE

 

EXT101_ACLOG

QWACALOG

 

EXT101_ACRNL

QWACARNL

 

EXT101_ACRNR

QWACARNR

 

EXT101_ACRNW

QWACARNW

 

EXT101_ACRNS

QWACARNS

 

EXT101_ACLCT

QWACALCT

 

EXT101_ACRND

QWACARND

 

EXT101_ACWDR

QWACAWDR

 

EXT101_ACWCL

QWACAWCL

 

EXT101_ACRNC

QWACARNC

 

EXT101_ACWAR

QWACAWAR

 

EXT101_ACNAR

QWACANAR

 

EXT101_ACWTP

QWACAWTP

 

EXT101_ACRNH

QWACARNH

 

EXT101_ACFLG

QWACFLGS

 

EXT101_ACKGN

QWACPKGN

 

EXT101_ACWTG

QWACAWTG

 

EXT101_ACWTJ

QWACAWTJ

 

EXT101_ACRNG

QWACARNG

 

EXT101_ACRNJ

QWACARNJ

 

EXT101_ACPCP

QWACSPCP

 

EXT101_ACPTT

QWACSPTT

 

EXT101_ACPNE

QWACSPNE

 

EXT101_ACAST

QWACCAST

 

EXT101_ACANM

QWACCANM

 

EXT101_ACCNT

QWACPCNT

 

EXT101_ACACE

QWACPACE

 

EXT101_ACSR2

QWACPSRB

 

EXT101_XAFLG

QTXAFLG1

 

EXT101_XARES

Reserved

 

EXT101_XALID

QTXARLID

 

EXT101_XAREC

QTXAPREC

 

EXT101_XALMT

QTXASLMT

 

EXT101_XACLM

QTXACCMT

 

EXT101_XAHUS

QTXACHUS

 

EXT101_XALAT

QTXASLAT

 

EXT101_XAOTH

QTXASOTH

 

EXT101_XAOCK

QTXALOCK

 

EXT101_XANLK

QTXAUNLK

 

EXT101_XAQRY

QTXAQRY

 

EXT101_XACHG

QTXACHG

 

EXT101_XARLM

QTXAIRLM

 

EXT101_XALNO

QTXACLNO

 

EXT101_XALUN

QTXACLUN

 

EXT101_XARNO

QTXADRNO

 

EXT101_XARUN

QTXADRUN

 

EXT101_DASLN

QMDAASLN

 

EXT101_DATYP

QMDAPTYP

 

EXT101_DAVER

QMDAPVER

 

EXT101_DAREL

QMDAPREL

 

EXT101_DAMOD

QMDAPMOD

 

EXT101_DALOC

QMDALOCN

 

EXT101_DANET

QMDANETN

 

EXT101_DALUN

QMDALUNM

 

EXT101_DANAM

QMDACNAM

 

EXT101_DATPE

QMDACTYP

 

EXT101_DACOR

QMDACORR

 

EXT101_DAATH

QMDAAUTH

 

EXT101_DAPLN

QMDAPLAN

 

EXT101_DAPLT

QMDAPLAT

 

EXT101_DAPPL

QMDAAPPL

 

EXT101_DATID

QMDAATID

 

EXT101_DAFLN

QMDASFLN

 

EXT101_DAACT

QMDAACCT

 

EXT101_COORNO

QXCOORNO

 

EXT101_ISORR

QXISORR

 

EXT101_CRGTT

QXCRGTT

 

EXT101_STREOP

QXSTREOP

 

EXT101_XCBPNK

QXXCBPNK

 

EXT101_XCSKIP

QXXCSKIP

 

EXT101_ALOCL

QXALOCL

 

EXT101_ALOCC

QXALOCC

 

EXT101_STFND

QXSTFND

 

EXT101_STNFND

QXSTNFND

 

EXT101_STIPRP

QXSTIPRP

 

EXT101_STNPRP

QXSTNPRP

 

EXT101_STDEXP

QXSTDEXP

 

EXT101_STDINV

QXSTDINV

 

EXT101_RNTAB

QXRNTAB

 

EXT101_CTRIG

QXCTRIG

 

EXT101_DRPTR

QXDRPTR

 

EXT101_SETPTH

QXSETPTH

 

EXT101_DRPFN

QXDRPFN

 

EXT101_DRPPR

QXDRPPR

 

EXT101_CDIST

QXCDIST

 

EXT101_DDIST

QXDDIST

 

EXT101_CRUDF

QXCRUDF

 

EXT101_CRPRO

QXCRPRO

 

EXT101_HOLDL

QXHOLDL

 

EXT101_FREEL

QXFREEL

 

EXT101_REPOP1

QXREPOP1

 

EXT101_REPOP2

QXREPOP2

 

EXT101_CRATB

QXCRATB

 

EXT101_STLOBV

QXSTLOBV

 

EXT101_ALUDF

QXALUDF

 

EXT101_ALPRO

QXALPRO

 

EXT101_ROIMAT

QXROIMAT

 

EXT101_ROIIDX

QXROIIDX

 

EXT101_ROITS

QXROITS

 

EXT101_STTRG

QXSTTRG

 

EXT101_ROWTRG

QXROWTRG

 

EXT101_TRGERR

QXTRGERR

 

EXT101_CASCDP

QXCASCDP

 

EXT101_CAUD

QXCAUD

 

EXT101_CAUDAB

QXCAUDAB

 

EXT101_CAUDTO

QXCAUDTO

 

EXT101_CAUDRJ

QXCAUDRJ

 

EXT101_SETCPR

QXSETCPR

 

EXT101_DCLGTT

QXDCLGTT

 

EXT101_DEGDTT

QXDEGDTT

 

EXT101_CRESEQ

QXCRESEQ

 

EXT101_ALTSEQ

QXALTSEQ

 

EXT101_DROSEQ

QXDROSEQ

 

EXT101_PRRESI

QXPRRESI

 

EXT101_ALTVW

QXALTVW

 

EXT101_HCEUID

QWHCEUID

 

EXT101_HCEUTX

QWHCEUTX

 

EXT101_HCEUWN

QWHCEUWN

 

EXT101_ACARLG

QWACARLG

 

EXT101_ACAWLG

QWACAWLG

 

EXT101_ACSUCV

QWACSUCV

 

EXT101_ACWLME

QWACWLME

 

EXT101_ACLRN

QWACLRN

 

EXT101_ACLRAB

QWACLRAB

 

EXT101_ACLRA2

QWACLRA2

 

EXT101_ACLRA4

QWACLRA4

 

EXT101_ACUDCP

QWACUDCP

 

EXT101_ACUDTT

QWACUDTT

 

EXT101_ACUDNE

QWACUDNE

 

EXT101_ACUDST

QWACUDST

 

EXT101_ACUDEA

QWACUDEA

 

EXT101_ACUDEB

QWACUDEB

 

EXT101_ACTRTT

QWACTRTT

 

EXT101_ACTRET

QWACTRET

 

EXT101_ACPECT

QWACPECT

 

EXT101_ACPECD

QWACPECD

 

EXT101_ACSPEA

QWACSPE

 

EXT101_ACSPEB

QWACSPEB

 

EXT101_ACTRTE

QWACTRTE

 

EXT101_ACTREE

QWACTREE

 

EXT101_ACSVPT

QWACSVPT

 

EXT101_ACRLSV

QWACRLSV

 

EXT101_ACRBSV

QWACRBSV

 

EXT101_ACAWTK

QWACAWTK

 

EXT101_ACAWTM

QWACAWTM

 

EXT101_ACAWTN

QWACAWTN

 

EXT101_ACAWTO

QWACAWTO

 

EXT101_ACAWTQ

QWACAWTQ

 

EXT101_ACARNK

QWACARNK

 

EXT101_ACARNM

QWACARNM

 

EXT101_ACARNN

QWACARNN

 

EXT101_ACARNO

QWACARNO

 

EXT101_ACARNQ

QWACARNQ

 

EXT101_6ACASC

QWACASC

See note 1 below.

EXT101_6ACAJST

QWACAJST

See note 1 below.

EXT101_6ACASRB

QWACASRB

See note 1 below.

EXT101_6ACAWTI

QWACAWTI

See note 1 below.

EXT101_6ACAWTL

QWACAWTL

See note 1 below.

EXT101_6ACAWTR

QWACAWTR

See note 1 below.

EXT101_6ACAWTW

QWACAWTW

See note 1 below.

EXT101_6ACAWTE

QWACAWTE

See note 1 below.

EXT101_6ACALOG

QWACAWLG

See note 1 below.

EXT101_6ACAWDR

QWACAWDR

See note 1 below.

EXT101_6ACAWCL

QWACAWCL

See note 1 below.

EXT101_6ACAWAR

QWACAWAR

See note 1 below.

EXT101_6ACAWTP

QWACAWTP

See note 1 below.

EXT101_6ACAWTG

QWACAWTG

See note 1 below.

EXT101_6ACAWTJ

QWACAWTJ

See note 1 below.

EXT101_6ACSPCP

QWACSPCP

See note 1 below.

EXT101_6ACSPTT

QWACSPTT

See note 1 below.

EXT101_6ACCAST

QWACCAST

See note 1 below.

EXT101_6ACPSRB

QWACSUCV

See note 1 below.

EXT101_6ACJST

QWACBJST

See note 1 below.

EXT101_6ACESC

QWACESC

See note 1 below.

EXT101_ALTJR

QXALTJR

 

EXT101_MERGE

QXMERGE

 

EXT101_TRTBL

QXTRTBL

 

EXT101_CRROL

QXCRROL

 

EXT101_DRPROL

QXDRPROL

 

EXT101_CRCTX

QXCRCTX

 

EXT101_ALTCTX

QXALTCTX

 

EXT101_DRPCTX

QXDRPCTX

 

EXT101_RNIX

QXRNIX

 

EXT101_ACALBC

QWACALBC

 

EXT101_ACALBW

QWACALBW

See note 2 below.

EXT101_ACCLS1_ZIIP

QWACCLS1_ZIIP

See note 2 below.

EXT101_ACCLS2_ZIIP

QWACCLS2_ZIIP

See note 2 below.

EXT101_ACTRTT_ZIIP

QWACTRTT_ZIIP

See note 2 below.

EXT101_ACZIIP_ELIG

QWACZIIP_ELIGIBLE

See note 2 below.

EXT101_ACSPNF_ZIIP

QWACSPNF_ZIIP

See note 2 below.

EXT101_ACUDFNF_ZIIP

QWACUDFNF_ZIIP

See note 3 below.

EXT101_ACSPNF_ELAP

QWACSPNF_ELAP

See note 2 below.

EXT101_ACSPNF_CP

QWACSPNF_CP

See note 2 below.

EXT101_ACUDFNF_ELAP

QWACUDFNF_ELAP

See note 3 below.

EXT101_ACUDFNF_CP

QWACUDFNF_CP

See note 3 below.

EXT101_SELCTX

QXSELECT

See note 4 below.

EXT101_INSRTX

QXINSRT

See note 4 below.

EXT101_UPDTEX

QXUPDTE

See note 4 below.

EXT101_DELETX

QXDELET

See note 4 below.

EXT101_DESCX

QXDESC

See note 4 below.

EXT101_PREPX

QXPREP

See note 4 below.

EXT101_OPENX

QXOPEN

See note 4 below.

EXT101_CLOSEX

QXCLOSE

See note 4 below.

EXT101_CRTABX

QXCRTAB

See note 4 below.

EXT101_CRINFX

QXCRINX

See note 4 below.

EXT101_CTABSX

QXCTABS

See note 4 below.

EXT101_CRSYNX

QXCRSYN

See note 4 below.

EXT101_CRDABX

QXCRDAB

See note 4 below.

EXT101_CRSTGX

QXCRSTG

See note 4 below.

EXT101_DEFVUX

QXDEFVU

See note 4 below.

EXT101_DRPIXX

QXDRPIX

See note 4 below.

EXT101_DRPTAX

QXDRPTA

See note 4 below.

EXT101_DRPTSX

QXDRPTS

See note 4 below.

EXT101_DRPDBX

QXDRPDB

See note 4 below.

EXT101_DRPSYX

QXDRPSY

See note 4 below.

EXT101_DRPSTX

QXDRPST

See note 4 below.

EXT101_DRPVUX

QXDRPVU

See note 4 below.

EXT101_ALTSTX

QXALTST

See note 4 below.

EXT101_FETCHX

QXFETCH

See note 4 below.

EXT101_ALTTSX

QXALTTS

See note 4 below.

EXT101_ALTTAX

QXALTTA

See note 4 below.

EXT101_ALTIXX

QXALTIX

See note 4 below.

EXT101_CMTONX

QXCMTON

See note 4 below.

EXT101_LOCKX

QXLOCK

See note 4 below.

EXT101_GRANTX

QXGRANT

See note 4 below.

EXT101_REVOKX

QXREVOK

See note 4 below.

EXT101_INCRBX

QXINCRB

See note 4 below.

EXT101_LABONX

QXLABON

See note 4 below.

EXT101_STSQLX

QXSETSQL

See note 4 below.

EXT101_STALSX

QXCRALS

See note 4 below.

EXT101_STDRAX

QXTDRPAL

See note 4 below.

EXT101_STMIAX

QXTMIAP

See note 4 below.

EXT101_STSMIX

QXTNSMIAP

See note 4 below.

EXT101_STRMIX

QXTMRMIAP

See note 4 below.

EXT101_STTHVX

QXSETHV

See note 4 below.

EXT101_STDABX

QXALDAB

See note 4 below.

EXT101_STPKGX

QXSDRPPKG

See note 4 below.

EXT101_STRTBX

QXDSCRTB

See note 4 below.

EXT101_STDEGX

QXMAXDEG

See note 4 below.

EXT101_STGRPX

QXTOTGRP

See note 4 below.

EXT101_STCURX

QXDEGCUR

See note 4 below.

EXT101_STESAX

QXDEGESA

See note 4 below.

EXT101_STBUFX

QXDEGBUF

See note 4 below.

EXT101_STDGRX

QXREDGRP

See note 4 below.

EXT101_STORGX

QXNORGRP

See note 4 below.

EXT101_STON1X

QXCON1

See note 4 below.

EXT101_STON2X

QXCON2

See note 4 below.

EXT101_STRELX

QXREL

See note 4 below.

EXT101_STSTCX

QXSETCON

See note 4 below.

EXT101_STCDGX

QXSETCDG

See note 4 below.

EXT101_STCRLX

QXSETCRL

See note 4 below.

EXT101_STCALX

QXCALL

See note 4 below.

EXT101_STLABX

QXCALLAB

See note 4 below.

EXT101_STLTOX

QXCALLTO

See note 4 below.

EXT101_STLRJX

QXCALLRJ

See note 4 below.

EXT101_STENCX

QXDEGENC

See note 4 below.

EXT101_COORNOX

QXCOORNO

See note 4 below.

EXT101_ISORRX

QXISOFRR

See note 4 below.

EXT101_CRGTTX

QXCRGTT

See note 4 below.

EXT101_STREOPX

QXSTREOP

See note 4 below.

EXT101_XCBPNXX

QXXCBPNX

See note 4 below.

EXT101_XCSKIPX

QXXCSKIP

See note 4 below.

EXT101_ALOCLX

QXALOCL

See note 4 below.

EXT101_ALOCCX

QXALOCC

See note 4 below.

EXT101_STFNDX

QXSTFND

See note 4 below.

EXT101_STNFNDX

QXSTNFND

See note 4 below.

EXT101_STIPRPX

QXSTIPRP

See note 4 below.

EXT101_STNPRPX

QXSTNPRP

See note 4 below.

EXT101_STDEXPX

QXSTDEXP

See note 4 below.

EXT101_STDINVX

QXSTDINV

See note 4 below.

EXT101_RNTABX

QXRNTAB

See note 4 below.

EXT101_CTRIGX

QXCTRIG

See note 4 below.

EXT101_DRPTRX

QXDRPTR

See note 4 below.

EXT101_SETPTHX

QXSETPTH

See note 4 below.

EXT101_DRPFNX

QXDRPFN

See note 4 below.

EXT101_DRPPRX

QXDRPPR

See note 4 below.

EXT101_CDISTX

QXCDIST

See note 4 below.

EXT101_DDISTX

QXDDIST

See note 4 below.

EXT101_CRUDFX

QXCRUDF

See note 4 below.

EXT101_CRPROX

QXCRPRO

See note 4 below.

EXT101_HOLDLX

QXHOLDL

See note 4 below.

EXT101_FREELX

QXFREEL

See note 4 below.

EXT101_REPOP1X

QXREPOP1

See note 4 below.

EXT101_REPOP2X

QXREPOP2

See note 4 below.

EXT101_CRATBX

QXCRATB

See note 4 below.

EXT101_STLOBVX

QXSTLOBV

See note 4 below.

EXT101_ALUDFX

QXALUDF

See note 4 below.

EXT101_ALPROX

QXALPRO

See note 4 below.

EXT101_ROIMATX

QXROIMAT

See note 4 below.

EXT101_ROIIDXX

QXROIIDX

See note 4 below.

EXT101_ROITSX

QXROITS

See note 4 below.

EXT101_STTRGX

QXSTTRG

See note 4 below.

EXT101_ROWTRGX

QXROWTRG

See note 4 below.

EXT101_TRGERRX

QXTRGERR

See note 4 below.

EXT101_CASCDPX

QXCASCDP

See note 4 below.

EXT101_CAUDX

QXCAUD

See note 4 below.

EXT101_CAUDABX

QXCAUDAB

See note 4 below.

EXT101_CAUDTOX

QXCAUDTO

See note 4 below.

EXT101_CAUDRJX

QXCAUDRJ

See note 4 below.

EXT101_SETCPRX

QXSETCPR

See note 4 below.

EXT101_DCLGTTX

QXDCLGTT

See note 4 below.

EXT101_DEGDTTX

QXDEGDTT

See note 4 below.

EXT101_CRESEQX

QXCRESEQ

See note 4 below.

EXT101_ALTSEQX

QXALTSEQ

See note 4 below.

EXT101_DROSEQX

QXDROSEQ

See note 4 below.

EXT101_PRRESIX

QXPRRESI

See note 4 below.

EXT101_ALTVWX

QXALTVW

See note 4 below.

EXT101_ALTJRX

QXALTJR

See note 4 below.

EXT101_MERGEX

QXMERGE

See note 4 below.

EXT101_TRTBLX

QXTRTBL

See note 4 below.

EXT101_CRROLX

QXRROL

See note 4 below.

EXT101_DRPROLX

QXDRPROL

See note 4 below.

EXT101_CRCTXX

QXCRCTX

See note 4 below.

EXT101_ALTCTXX

QXALTCTX

See note 4 below.

EXT101_DRPCTXX

QXDRPCTX

See note 4 below.

EXT101_RNIXX

QXRNIX

See note 4 below.

Notes:

  1. The fields named EXT101_6xxxx are duplicates of time fields stored in EXTDATA. These fields are stored as microseconds instead of the usual practice of storing 1/100th seconds. See sample report MZXT0331 for a field comparison.
  2. These fields are stored as microseconds.
  3. These fields are reserved by IBM for future use.
  4. IBM enlarged the SQL Data Statement fields from 4 to 8 bytes beginning at DB2 Version 10 Release 1, but did not retain the original 4 byte fields. These S101 EXTDATA fields have been added to support DB2 10.1, but the corresponding pre-10.1 fields have been retained for compatibility.