Online Monitor field table

The tables in this section provide a list of the Online Monitor thread activity fields, statistics fields, and system parameters fields.

You can use these tables to cross-reference exception field names for display exception processing and for periodic exception processing, or to look up a field help panel name when customizing Online Monitor panels.

Table 1. Accounting - Buffer Pool Activity
Field name Field description Help panel name Exception
ABCLSPR Prefetch Reads DGO0231 Yes
ABCRWIO Synchronous I/O DGO0232  
ADRGPRIO Getpage/Synchronous Reads DGO0233 Yes
QBACDPF Dynamic Prefetch Requests DGO0222  
QBACGET Getpage Requests DGO0217 Yes
QBACIMW Synchronous Writes DGO0226 Yes
QBACLPF List Prefetch Requests DGO0221  
QBACPID Buffer Pool ID DGO0215  
QBACRIO Synchronous Read I/O DGO0219 Yes
QBACSEQ Sequential Prefetch Requests DGO0220  
QBACSIO Asynchronous Pages Read DGO0229  
QBACSWS Buffer Updates DGO0225 Yes
Table 2. Accounting - Data Capture Activity and Class 5 Times
Field name Field description Help panel name Exception
ADIFICAL IFI Calls DGO0775 Yes
QIFAAIET Class 5 Elapsed Time DGO0202 Yes
QIFAAITT Class 5 TCB Time DGO0203 Yes
QIFAAMBT Describe Time DGO0204  
QIFAAMLT Log Extraction Time DGO0205  
QIFAANDD Data Descriptions Returned DGO0211  
QIFAANDR Data Rows Returned DGO0210  
QIFAANLR Log Reads Performed DGO0207  
QIFAANMB Describes Performed DGO0212  
QIFAANRC Log Records Captured DGO0208  
QIFAANRR Log Records Returned DGO0209  
QIFAANTB Tables Returned DGO0213  
Table 3. Accounting - Data Sharing Locking Activity
Field name Field description Help panel name Exception
ABUFFRAT Buffer Pool Hit Ratio (%) DGO1769  
AGLOBRAT Global Contention Rate (%) DGO1767  
QTGACPLK Change Requests DGO1399  
QTGACSLM Change Requests - XES DGO1402  
QTGADRTA Incompatible Retained Lock DGO1408 Yes
QTGAFLSE Suspensions - False Contention DGO1407  
QTGAIGLO Suspensions - IRLM Global Contention DGO1403  
QTGALPLK Lock Requests DGO1397  
QTGALSLM Lock Requests - XES DGO1400  
QTGANTFY Notify Messages Sent DGO1409  
QTGASGLO Suspensions - XES Global Contention DGO1406  
QTGAUPLK Unlock Requests DGO1398  
QTGAUSLM Unlock Requests - XES DGO1401  
Table 4. Accounting - Distributed Data Facility Activity
Field name Field description Help panel name Exception
ADDSCNVC Current DDF Conversions DGO0270  
ADDSELSR Remote Elapsed DGO0263 Yes
ADDSSRSR Remote CPU DGO0264 Yes
ADPROTOC Method DGO0235  
QLACLOCN Remote Location DGO0234  
QW0148CT Type DGO0833  
QW0148EL Requester Elapsed DGO1195 Yes
QW0148MR Messages Received DGO0272  
QW0148MS Messages Sent DGO0271  
QW0148PT Product ID DGO0804  
QW0148PV Product Version DGO1556  
QW01488A Conversation Active Flag DGO0266  
QW01488C Conversation ID DGO0269  
QW01488L Remote Location DGO0836  
QW01488N Network Connection Type DGO1722  
QW01488S Connection ID DGO0268  
QW01488T Time of Last Message DGO0267  
QW01488U State DGO0265  
Table 5. Accounting - Group Buffer Pools Activity
Field name Field description Help panel name Exception
ABGAMR Read (Not Found)-No Data Returned DGO1832 Yes
ABGAXR Read (Cross Inval.)-No Data Returned DGO1833 Yes
QBGADG Unregister Page DGO1721  
QBGAGN Group Buffer Pool ID DGO1579  
QBGAMD Read (Not Found) - Data Returned DGO1413 Yes
QBGAMN Read Prefetch DGO1415 Yes
QBGASW Changed Pages Written DGO1418 Yes
QBGAWC Clean Pages Written DGO1417 Yes
QBGAXD Read (Cross Invalidation) - Data Returned DGO1410 Yes
Table 6. Accounting - Locking Activity
Field name Field description Help panel name Exception
ALCLKET Lock Escalations DGO0190 Yes
ALRSUSLL Number of Lock and Latch Suspensions DGO0179 Yes
ALRSUSP Total Suspensions DGO0178 Yes
QTXACHG Change Requests DGO0186  
QTXACLNO Claim Requests DGO0192  
QTXACLUN Unsuccessful Claim Requests DGO0193 Yes
QTXADEA Deadlocks DGO0176 Yes
QTXADRNO Drain Requests DGO0194  
QTXADRUN Unsuccessful Drain Requests DGO0195 Yes
QTXAIRLM Other IRLM Requests DGO0187  
QTXALES Lock Escalations - shared DGO0188 Yes
QTXALEX Lock Escalations - Exclusive DGO0189 Yes
QTXALOCK Lock Requests DGO0183  
QTXANPL Maximum Page or Row Locks Held DGO0191 Yes
QTXAQRY Query Requests DGO0185  
QTXASLAT Suspensions - Latch DGO0181  
QTXASLOC Suspensions - Lock DGO0180 Yes
QTXASOTH Suspensions - Other DGO0182  
QTXATIM Timeouts DGO0175 Yes
QTXAUNLK Unlock Requests DGO0184  
T3ANCHOR Anchor DGO1840  
T3BPID Buffer pool Id DGO1845  
T3COLL Collection ID DGO0842  
T3CONST Consistency Token DGO0843  
T3DBNAME Database DGO0844  
T3DURAT Duration DGO0845  
T3FUNCT Function DGO0846  
T3HASH Hash Class DGO1843  
T3LOCKS Count DGO0847  
T3OBNAME Object DGO0848  
T3PACK Package ID DGO0849  
T3PAGE Page DGO1837  
T3PART Partition DGO1844  
T3PLAN Plan ID DGO0850  
T3PLLCK Attribute DGO1792  
T3RMID Resource Manager Id DGO1842  
T3ROW Row DGO1839  
T3STATE Status DGO0851  
T3SUBP Subpage DGO1838  
T3SUSP Suspended DGO0852  
T3TYPE Type DGO0853  
T3UID Utility UID DGO1841  
T5SUBS Subsystem DGO1815  
Table 7. Accounting - Package Data
Field name Field description Help panel name Exception
ADALPSSC Archive Log (quiesce) DGO0720  
ADARPSSC Other Read I/O - Events DGO0711 Yes
ADAWPSSC Other Write I/O DGO0714 Yes
ADCMPSSC Claim Release DGO0726  
ADCPCL7T CPU Time (Class 7) - Par.Tasks - Tot.Exec. DGO1631  
ADCPCL8T Suspension Time (Class 8) - Parallel Tasks DGO1665  
ADCPUTP CPU Time (Class 7) - Total Execution DGO1432 Yes
ADDRPSSC Drain Lock DGO0723  
ADELCL7C Elapsed Time (Class 7) - Current Execution DGO0697  
ADGCPSSC Global Contention - Suspensions DGO1381  
ADIOPSSC Synchronous I/O - Events DGO0708 Yes
ADLLPSSC Locks and Latches - Events DGO0705 Yes
ADLRPSSC Archive Log Read DGO0732  
ADNACL7T Not Accounted DGO0738  
ADNOPSSC Notify Messages - Suspensions DGO1378  
ADPGPSSC Page Latch DGO0729  
ADSPPSSC Stored Procedures - Suspensions DGO1389  
ADSTPSSC Services Task Switch DGO0717 Yes
ADTCBCL8 Suspension Time (Class 8) - TCB DGO1664  
ADTCCL7L TCB Time Spent In DB2® DGO0700  
ADTSUSCP Suspensions (Class 8) - Events DGO0735 Yes
ADTSUSTP Suspension Time (Class 8) DGO0736 Yes
ADWTCL7T Waiting Time - Total Execution DGO1666 Yes
QPACALOG Archive Log (quiesce) DGO0721  
QPACARNA Db2 Entry/Exit Events DGO0810  
QPACAWAR Archive Log Read DGO0733  
QPACAWCL Claim Release DGO0727  
QPACAWDR Drain Lock DGO0724  
QPACAWTE Services Task Switch DGO0718 Yes
QPACAWTG Notify Messages - Time DGO1377  
QPACAWTI Synchronous I/O - Elapsed Time DGO0709 Yes
QPACAWTJ Global Contention - Time DGO1380  
QPACAWTL Locks and Latches - Elapsed Time DGO0706 Yes
QPACAWTP Page Latch DGO0730  
QPACAWTR Other Read I/O - Elapsed Time DGO0712 Yes
QPACAWTW Other Write I/O DGO0715 Yes
QPACCAST Stored Procedures - Time DGO1388  
QPACCOLN Collection ID DGO0696  
QPACCONT Consistency Token DGO0694  
QPACLOCN Location DGO0692  
QPACPKID Program Name DGO0693  
QPACSCT Elapsed Time (Class 7) - Total Execution DGO0699 Yes
QPACSQLC SQL Statements Issued DGO0695 Yes
QPACTJST CPU Time TCB - Class 7- Total Execution DGO0701  
Table 8. Accounting - Query Parallelism
Field name Field description Help panel name Exception
ADPARDIS Parallelism Disabled by RLF DGO1637  
ADPARLEV Parallelism DGO1596  
ADTOTPFL Fall Back To Sequential Mode DGO0684 Yes
AXXCRAT Member Skipped (%) DGO1783  
QXCOORNO One Db2 COORDINATOR Parm = NO DGO1680  
QXDEGBUF Fall Back To Sequential Mode - No Buffer DGO0683 Yes
QXDEGCUR Fall Back To Sequential Mode - Cursor DGO0774 Yes
QXDEGESA Fall Back To Sequential Mode - No ESA DGO0682 Yes
QXISORR One Db2 Isolation Level DGO1681  
QXMAXDEG Maximum Degree of Parallelism DGO0171 Yes
QXNORGRP Planned Parallel Degree DGO0174  
QXREDGRP Reduced Parallel Degree DGO0173 Yes
QXTOTGRP Parallel Groups Executed DGO0773  
Table 9. Accounting - RID List Processing
Field name Field description Help panel name Exception
ARTTERM Unsuccessful - Any Reason DGO0170 Yes
QXMIAP Successful DGO0167  
QXMRMIAP Not Used - Limit Exceeded DGO0169 Yes
QXNSMIAP Not Used - No Storage DGO0168 Yes
Table 10. Accounting - SQL Activity (DML, DCL, DDl)
Field name Field description Help panel name Exception
ADTDDL Total DDL DGO0166 Yes
ASCDCL Total DCL DGO0137 Yes
ASCDML Total DML DGO0122 Yes
ASRIUDCA Changes/Commit DGO0127 Yes
ASTOTALT Number of Alter Statements Executed DGO0165  
ASTOTCRT Total DGO0163  
ASTOTDRP Total DGO0164  
QW0124SP Stored Procedure DGO1846  
QW01482T SQL Statement DGO1863  
QXALDAB Alter Database DGO0155  
QXALOCC Allocate Cursor DGO1720  
QXALOCL Associate Locators DGO1719  
QXALTIX Alter Index DGO0149  
QXALTST Alter Stogroup DGO0152  
QXALTTA Alter Table DGO0143  
QXALTTS Alter Tablespace DGO0146  
QXCALLAB Procedure Abends DGO1392 Yes
QXCALLRJ Call Statements Rejected DGO1394 Yes
QXCALLTO Call Statement Timeouts DGO1393 Yes
QXCLOSE Close DGO0121  
QXCMTON Comment On DGO0139  
QXCON1 Connect Type 1 DGO0133  
QXCON2 Connect Type 2 DGO0134  
QXCRALS Create Alias DGO0160  
QXCRDAB Create Database DGO0153  
QXCRGTT Create Temp. Table DGO1654  
QXCRINX Create Index DGO0147  
QXCRSTG Create Stogroup DGO0150  
QXCRSYN Create Synonym DGO0156  
QXCRTAB Create Table DGO0141  
QXCTABS Create Tablespace DGO0144  
QXDEFVU Create View DGO0158  
QXDELET Delete DGO0115  
QXDESC Describe DGO0116  
QXDRPAL Drop Alias DGO0161  
QXDRPDB Drop Database DGO0154  
QXDRPIX Drop Index DGO0148  
QXDRPPKG Drop Package DGO0162  
QXDRPST Drop Stogroup DGO0151  
QXDRPSY Drop Synonym DGO0157  
QXDRPTA Drop Table DGO0142  
QXDRPTS Drop Tablespace DGO0145  
QXDRPVU Drop View DGO0159  
QXDSCRTB Describe Table DGO1626  
QXFETCH Fetch DGO0120  
QXGRANT Grant DGO0129  
QXINSRT Insert DGO0113  
QXLABON Label On DGO0140  
QXLOCK Lock Table DGO0128  
QXOPEN Open DGO0119  
QXPREP Prepare DGO0118  
QXREL Release DGO0135  
QXREVOK Revoke DGO0130  
QXRNTAB Rename Table DGO1851  
QXSELECT Select DGO0112  
QXSETCDG Set Current Degree DGO0772  
QXSETCON Set Connection DGO0136  
QXSETCRL Set Current Rules DGO1390  
QXSETHV Set Host Variable DGO0132  
QXSETSQL Set Current SQLID DGO1627  
QXUPDTE Update DGO0114  
RDISTNUM Statement Number DGO0837  
RDISTYPE Statement Type DGO0838  
TCONTOK Consistency Token DGO0839  
TPACKAGE Package Name DGO0840  
TPKGDBRM DBRM Being Executed DGO0841  
TVERSION Version DGO0855  
T4STMT SQL Statement DGO0854  
Table 11. Accounting - SQL Nested Activity
Field name Field description Help panel name Exception
QXCALL SQL Call DGO1391  
Table 12. Accounting - Termination Conditions, Commit/Rollback, Incremental Binds
Field name Field description Help panel name Exception
ADCICSIN CICS® Token Instance DGO0016  
ADCICSLU CICS Token LU Name DGO0015  
ADCICSNI CICS Token Network ID DGO0014  
ADCORNMB Correlation Number DGO0008  
ADCORNME Correlation Name DGO0007  
ADTHRSTA Thread Status DGO0033  
ADTHRTYP Thread Type DGO0050  
QMDAACCT MVS Accounting Token DGO0019  
QMDAAPPL Client Application Name DGO1552  
QMDAASTR Accounting String DGO0029  
QMDAATID Client Authid DGO1553  
QMDAAUTH Primauth DGO0024  
QMDACNAM Connection ID DGO0827  
QMDACORR Correlation ID DGO0028  
QMDACTYP Connection Type DGO0025  
QMDALOCN Location DGO0021  
QMDALUNM LU Name DGO0023  
QMDANETN Network ID DGO0022  
QMDAPLAN Plan Name DGO0828  
QMDAPLAT Client Platform DGO1551  
QMDAPTYP Product ID DGO0020  
QMDAPVER Product Version DGO1555  
QMDASUFX DDCS Accounting Suffix DGO1550  
QWACABRT Rollback DGO0058 Yes
QWACCOMM Commit DGO0057 Yes
QWACNID Recovery Token DGO0829  
QWHCAID Primauth DGO0006  
QWHCATYL Connection Type DGO0830  
QWHCATYP Conntype DGO0013  
QWHCATYS Connection Type DGO0831  
QWHCCN Connection ID DGO0010  
QWHCCV Correlation ID DGO0009  
QWHCOPID Origauth DGO0012  
QWHCPLAN Planname DGO0011  
QWHCTOKN RRSAF Accounting Token DGO1737  
QWHDPTYP Product ID DGO0018  
QWHDPVER Product Version DGO1554  
QWHDRQNM Requesting Location DGO0017  
QWHSLOCN Reporting Location DGO0001  
QWHSLUCC LUW Sequence Number DGO0800  
QWHSLUNM LUW LU Name DGO0798  
QWHSLUUV LUW Instance Number DGO0799  
QWHSNID LUW Network ID DGO0797  
QW0148RQ Request Count DGO0034  
QXINCRB Incremental Bind DGO0059 Yes
QXSTDEXP Cache Limit Exceeded DGO1806  
QXSTDINV Prepare Statement Purged DGO1807  
QXSTFND Prepare Statement Match DGO1802  
QXSTIPRP Implicit Prepare DGO1804  
QXSTNFND Prepare Statement No Match DGO1803  
QXSTNPRP Prepare from Cache DGO1805  
QXSTREOP Reoptimization DGO1801  
Table 13. Accounting - Timing Data (Elapsed, TCB. Suspensions, and so on)
Field name Field description Help panel name Exception
ADALSUSC Archive Log (Quiesce) - Event DGO0092  
ADARSUSC Other Read I/O - Event DGO0083 Yes
ADAWSUSC Other Write I/O - Event DGO0086 Yes
ADCMSUSC Claim Release - Event DGO0098  
ADCPCL3T Suspension Time Par. Tasks - Class 3 DGO1668  
ADCPUPLL CPU Time Parallel Tasks - Class 1 DGO1629  
ADCPUT CPU Time - Class 1 in Application DGO1425 Yes
ADDBCPC2 CPU Time Parallel Tasks - Class 2 DGO1636  
ADDBCPUT CPU Time - Class 2 in Db2 DGO1426 Yes
ADDBSRBT Class 2 SRB Time DGO0070  
ADDBTCBT CPU Time TCB - Class 2 in Db2 DGO0068  
ADDB2ETT Elapsed Time - Class 2 in Db2 DGO0066 Yes
ADDRSUSC Drain Lock - Event DGO0095  
ADDSTOTT Requester Elapsed Time DGO0825 Yes
ADGCSUSC Global Contention - Event DGO1376  
ADIOSUSC Synchronous I/O - Event DGO0079 Yes
ADLLSUSC Locks and Latches - Event DGO0076 Yes
ADLRSUSC Archive Log Read - Event DGO0688  
ADNOSUSC Notify Messages - Event DGO1374  
ADNOTACC Not Accounted - Class 2 in Db2 DGO0107  
ADPGSUSC Page Latch - Event DGO0803  
ADRECETT Elapsed Time - Class 1 in Application DGO0063 Yes
ADSPSUSC Stored Procedures - Event DGO1387  
ADSRBT Class 1 SRB Time DGO0065  
ADSTSUSC Services Task Switch - Event DGO0089 Yes
ADTCBCL3 Suspension Time TCB - Class 3 in Db2 DGO1667  
ADTCBT CPU Time TCB - Class 1 DGO1580  
ADTSRBOD SRB Time Outside Db2 DGO0071  
ADTSUSC Suspensions (Class 3) - Event DGO0104 Yes
ADTSUST Suspension Time (Class 3) DGO0105 Yes
ADTTCBOD CPU Time TCB - Outside Db2 DGO0069  
ADTTOTOD Elapsed Time - Outside Db2 DGO0067  
ADTWTAP Waiting Time - Class 1 in Application DGO0072 Yes
ADTWTDB Waiting Time - Class 2 in Db2 DGO0073 Yes
ADTWTODB Waiting Time - Outside Db2 DGO0074  
QWACALOG Archive Log (Quiesce) - Time DGO0093  
QWACARNA Db2 Entry/Exit - Non Stored Procedures DGO0075  
QWACAWAR Archive Log Read - Time DGO0689  
QWACAWCL Claim Release - Time DGO0099  
QWACAWDR Drain Lock - Time DGO0096  
QWACAWTE Services Task Switch - Time DGO0090 Yes
QWACAWTG Notify Messages - Time DGO1373  
QWACAWTI Synchronous I/O - Time DGO0081 Yes
QWACAWTJ Global Contention - Time DGO1375  
QWACAWTL Locks and Latches - Time DGO0077 Yes
QWACAWTP Page Latch - Time DGO0102  
QWACAWTR Other Read I/O - Time DGO0084 Yes
QWACAWTW Other Write I/O - Time DGO0087 Yes
QWACCAST Stored Procedures - Time DGO1386  
QWACSPCP CPU Time TCB Stored Proc - Class 1 in Applic. DGO1383  
QWACSPNE Db2 Entry/Exit - Stored Procedures DGO1385  
QWACSPTT CPU Time TCB Stored Proc - Class 2 in Db2 DGO1384  
Table 14. Statistics - Authorization Management
Field name Field description Help panel name Exception
QTAUCCH Authorization Succ. W/o Catalog Access DGO0460  
QTAUCHK Authorization Attempts DGO0458  
QTAUPUB Authorization Successful Public Plan DGO0461  
QTAUSUC Authorization Successful DGO0459  
QTPACAUT Package Authorization Management - Successful DGO1774  
QTPACNOT P. A. M. Unsuccessful - Catalog Required DGO1776  
QTPACOW1 P. A. M. - Overwritten Authid in Cache DGO1777  
QTPACOW2 P. A. M. - Overwritten in Cache DGO1778  
QTPACPUB P. A. M. - Successful Public DGO1775  
Table 15. Statistics - Buffer Pool Activity
Field name Field description Help panel name Exception
QBSTCBA Current Active Buffers DGO0331 Yes
QBSTDIO Dynamic Prefetch Reads DGO0359 Yes
QBSTDMC DM Critical Threshold Reached DGO0376 Yes
QBSTDPF Dynamic Prefetch Requested DGO0358 Yes
QBSTDPP Dynamic Prefetch Pages Read DGO0360 Yes
QBSTDSO Successful Data Set Opens DGO0335 Yes
QBSTDWT Deferred Write Threshold Reached DGO0373 Yes
QBSTDWV Thresholds Reached - Vertical Deferred Write DGO0374 Yes
QBSTGET Getpage Request Total DGO0343  
QBSTIMW Synchronous Writes DGO0370 Yes
QBSTJIS Pref. I/O Streams - Reduced - Buffer Shortage DGO0384 Yes
QBSTLIO List Prefetch Reads DGO0355 Yes
QBSTLPF List Prefetch Requested DGO0354 Yes
QBSTLPP List Prefetch Pages Read DGO0356 Yes
QBSTMAX Not Created - No Buffer DGO0394 Yes
QBSTMIG DFHSM Migrated Data Sets DGO0336 Yes
QBSTNGT Unsuccessful Page Requests DGO1862  
QBSTPID Buffer Pool ID DGO0330  
QBSTPIO Sequential Prefetch Reads DGO0351 Yes
QBSTPL1 Prefetch Quantity Reduced To 1/2 DGO0387 Yes
QBSTPL2 Prefetch Quantity Reduced To 1/4 DGO0388 Yes
QBSTPQF Reduced Parallel Query Requests DGO0386 Yes
QBSTPQO Parallel Query Requests DGO0385  
QBSTPWS Pages Written DGO0368 Yes
QBSTREE Prefetch Disabled No Read Engine DGO0363 Yes
QBSTRIO Synchronous Reads Total DGO0346 Yes
QBSTRPI Page-ins Required for Read I/O DGO0815 Yes
QBSTRTO DFHSM Recall Timeouts DGO0337 Yes
QBSTSEQ Sequential Prefetch Requested DGO0350 Yes
QBSTSGT Getpage Request Sequential Access Only DGO0344  
QBSTSIO Synchronous Reads Sequential Access Only DGO0347 Yes
QBSTSPD Prefetch Disabled No Buffer DGO0362 Yes
QBSTSPP Sequential Prefetch Pages Read DGO0352 Yes
QBSTSWS Buffer Updates DGO0367 Yes
QBSTVPA Alter Buffer Pool Expansions and Contractions DGO0341 Yes
QBSTVPL Buffers Allocated for Virtual Buffer Pool DGO0339  
QBSTWBVQ Pages Not Written DGO0398 Yes
QBSTWDRP Pages Marked To Destruct DGO0397 Yes
QBSTWFD Workfile Request Rejected - Low Buffers DGO0392 Yes
QBSTWFF Degraded - Low Buffers DGO0391 Yes
QBSTWFM Maximum Concurrent Work Files DGO0389 Yes
QBSTWFR Merge Passes Requested DGO0390  
QBSTWFT Requested for All Merge Pass DGO0393  
QBSTWIO Asynchronous Writes DGO0371 Yes
QBSTWKPD Prefetch Not Scheduled - Zero Quantity DGO0396 Yes
QBSTWPI Page-ins Required for Write I/O DGO0816 Yes
QBSTXFL Buffer Pool Full DGO0333 Yes
QBSTXFV Virtual Storage Unavailable DGO0334 Yes
QBSTXIS Prefetch I/O Streams, Concurrent Str. - HWM DGO0383 Yes
SBRBUPW Buffer Updates / Pages Written DGO0369  
SBRBUTP Virtual Buffer Pool Pages in Use (%) DGO0805 Yes
SBRGPRIO Getpage per Synchronous Read Random DGO0349  
SBRPPRIO Seq. Prefetch Pages Read / Seq. Prefetch Read DGO0353  
SBRPWWIO Pages Written per Write I/O DGO0372  
SDDPPPIO Dynamic Prefetch Pages Read / Dyn. Pref. Read DGO0361  
SDGETRAN Getpage Request - Random DGO0345  
SDLPPPIO List Prefetch Pages Read / List Prefetch Read DGO0357  
SDSTRAN Synchronous Reads - Random DGO0348 Yes
Table 16. Statistics - Data Capture Activity
Field name Field description Help panel name Exception
QWSDCDDD Data Descriptions Returned DGO0634  
QWSDCDDR Data Rows Returned DGO0632  
QWSDCDLC Log Records Captured DGO0629  
QWSDCDLR Log Reads Performed DGO0630  
QWSDCDMB Describes Performed DGO0633  
QWSDCDRR Log Records Returned DGO0631  
QWSDCDTB Tables Returned DGO0635  
Table 17. Statistics - Data Sharing Locking Activity
Field name Field description Help panel name Exception
QTGSCHNP P-lock Negotiation - Change DGO1335  
QTGSCPLK P-locks - Change Requests DGO1319  
QTGSCSLM Synchronous XES - Change Requests DGO1321  
QTGSDRTA Incompatible Retained Lock DGO1327 Yes
QTGSFLSE Suspensions - False Contention DGO1326  
QTGSIGLO Suspensions - IRLM Global Contention DGO1324  
QTGSKIDS Asynchronous XES - Resources DGO1323  
QTGSLPLK P-locks - Lock Requests DGO1317  
QTGSLSLM Synchronous XES - Lock Requests DGO1320  
QTGSNTFR Notify Messages Received DGO1329  
QTGSNTFY Notify Messages Sent DGO1328  
QTGSOTPE P-lock Negotiation - Other DGO1334  
QTGSPEMX P-Lock/Notify Exists - Maximum Engines DGO1330  
QTGSPEQW P-locks/Notify Exists - Engines Unavailable DGO1331 Yes
QTGSPGPE P-lock Negotiation - Page DGO1333  
QTGSPPPE P-lock Negotiation - Pageset/Partition DGO1332  
QTGSSGLO Suspensions - Global Contention DGO1325  
QTGSUPLK P-locks - Unlock Requests DGO1318  
QTGSUSLM Synchronous XES - Unlock Requests DGO1322  
SBUFFRAT Buffer Pool Hit Ratio (%) DGO1772  
SGLOBRAT Global Contention Rate (%) DGO1770  
Table 18. Statistics - Db2 Application Programming Interface
Field name Field description Help panel name Exception
QWSDSCA Abends DGO0583 Yes
QWSDSCCO Command Requests DGO0585  
QWSDSCRA READA Requests DGO0586  
QWSDSCRS READS Requests DGO0587  
QWSDSCU Unrecognized DGO0584  
QWSDSCWR WRITE Requests DGO0588  
SDIFITOT Total number of calls made to IFI DGO0589 Yes
Table 19. Statistics - Db2 Commands
Field name Field description Help panel name Exception
Q9STCTRA Stop Db2 DGO0552  
Q9STCTRB Term Utility DGO0557  
Q9STCTRC Display Trace DGO0539  
Q9STCTRD RESET GENERICLU DGO1545  
Q9STCTRE Start RLIMIT DGO0548  
Q9STCTRF Stop RLIMIT DGO0553  
Q9STCTRG DISPLAY RLIMIT DGO0540  
Q9STCTRH Modify Trace DGO0555  
Q9STCTRI Start DDF DGO0549  
Q9STCTRJ Stop DDF DGO0554  
Q9STCTRK Cancel DDF Thread DGO0556 Yes
Q9STCTRL Display Location DGO0541  
Q9STCTRM Archive Log DGO0561  
Q9STCTRN Alter Bufferpool DGO0544 Yes
Q9STCTRO Display Bufferpool DGO0543  
Q9STCTRP Set Archive DGO0562  
Q9STCTRQ Display Archive DGO0542  
Q9STCTRR Reset Indoubt DGO0560  
Q9STCTRS ALTER GROUPBUFFERPOOL DGO1361 Yes
Q9STCTRT DISPLAY GROUPBUFFERPOOL DGO1360  
Q9STCTRU DISPLAY PROCEDURE DGO1456  
Q9STCTRV START PROCEDURE DGO1457  
Q9STCTRW STOP PROCEDURE DGO1458  
Q9STCTRX DISPLAY GROUP DGO1544  
Q9STCTR0 Display Database DGO0536  
Q9STCTR1 Display Thread DGO0537  
Q9STCTR2 Display Utility DGO0538  
Q9STCTR3 Recover BSDS DGO0558  
Q9STCTR4 Recover Indoubt DGO0559  
Q9STCTR5 Start Database DGO0545  
Q9STCTR6 Start Trace DGO0546 Yes
Q9STCTR7 Start Db2 DGO0547  
Q9STCTR8 Stop Database DGO0550  
Q9STCTR9 Stop Trace DGO0551  
Q9STEROR Unrecognized Commands DGO0563  
SDSTTOTL Total number of Db2 commands issued DGO0564 Yes
Table 20. Statistics - Db2 Destination Data
Field name Field description Help panel name Exception
SDIGTFNW GTF Not Written DGO0596  
SDIGTFRA GTF Not Accepted DGO0597  
SDIGTFWF GTF Write Failure DGO0598  
SDIGTFWR GTF Written DGO0595  
SDIOP1NW OP1 Not Written DGO0600  
SDIOP1RA OP1 Not Accepted DGO0601  
SDIOP1WR OP1 Written DGO0599  
SDIOP2NW OP2 Not Written DGO0603  
SDIOP2RA OP2 Not Accepted DGO0604  
SDIOP2WR OP2 Written DGO0602  
SDIOP3NW OP3 Not Written DGO0606  
SDIOP3RA OP3 Not Accepted DGO0607  
SDIOP3WR OP3 Written DGO0605  
SDIOP4NW OP4 Not Written DGO0609  
SDIOP4RA OP4 Not Accepted DGO0610  
SDIOP4WR OP4 Written DGO0608  
SDIOP5NW OP5 Not Written DGO0612  
SDIOP5RA OP5 Not Accepted DGO0613  
SDIOP5WR OP5 Written DGO0611  
SDIOP6NW OP6 Not Written DGO0615  
SDIOP6RA OP6 Not Accepted DGO0616  
SDIOP6WR OP6 Written DGO0614  
SDIOP7NW OP7 Not Written DGO0618  
SDIOP7RA OP7 Not Accepted DGO0619  
SDIOP7WR OP7 Written DGO0617  
SDIOP8NW OP8 Not Written DGO0621  
SDIOP8RA OP8 Not Accepted DGO0622  
SDIOP8WR OP8 Written DGO0620  
SDIRTTWR RES Written DGO0623  
SDISMFBF SMF Buffer Overrun DGO0593 Yes
SDISMFNW SMF Not Written DGO0591  
SDISMFRA SMF Not Accepted DGO0592  
SDISMFWF SMF Write Failure DGO0594  
SDISMFWR SMF Written DGO0590  
SDTOTNA Total number of IFC records not accepted DGO0626 Yes
SDTOTNW Total number of IFC records not written DGO0625 Yes
SDTOTW Total number of IFC records succ. written DGO0624 Yes
SDTOTWF Total number of IFC write failures DGO0628 Yes
Table 21. Statistics - Db2 Instrumentation
Field name Field description Help panel name Exception
SDBSCRNW System Parameters - Buffer Pools DGO0578  
SDBSCRSW System Parameters - Buffer Pools DGO0577  
SDIACTN Accounting (not written) DGO0570  
SDIACTW Accounting (written) DGO0569  
SDIAUDN Audit (not written) DGO0580  
SDIAUDW Audit (written) DGO0579  
SDIDRRN Database Related (not written) DGO0568  
SDIDRRW Database Related (written) DGO0567  
SDISRRN System Related (not written) DGO0566  
SDISRRW System Related (written) DGO0565  
SDISTPN Stop Trace (not written) DGO0574  
SDISTPW Stop Trace (written) DGO0573  
SDISTRN Start Trace (not written) DGO0572  
SDISTRW Start Trace (written) DGO0571  
SDIZPMN Dsnzparm (not written) DGO0576  
SDIZPMW Dsnzparm (written) DGO0575  
SDTSCRNW Total count of all Db2 records not written DGO0582 Yes
SDTSCRSW Total count of all Db2 records written DGO0581 Yes
Table 22. Statistics - Distributed Data Facility - per Location
Field name Field description Help panel name Exception
QLSTABRR Rollbacks Received DGO0650  
QLSTABRS Rollbacks Sent DGO0649  
QLSTBRBF Blocks Received DGO0660 Yes
QLSTBTBF Blocks Sent DGO0659 Yes
QLSTBYTR Bytes Received DGO0656  
QLSTBYTS Bytes Sent DGO0655  
QLSTCNVQ Conversations Queued DGO0643 Yes
QLSTCNVR Conversations Received DGO0642  
QLSTCNVS Conversations Sent DGO0641  
QLSTCOMR Commits Received DGO0648  
QLSTCOMS Commits Sent DGO0647  
QLSTINDT Thread Went Indoubt DGO0675 Yes
QLSTLOCN Remote Location DGO0638  
QLSTMSGR Messages Received DGO0654  
QLSTMSGS Messages Sent DGO0653  
QLSTROWR Rows Received DGO0652  
QLSTROWS Rows Sent DGO0651  
QLSTSQLR SQL Statements Received DGO0646 Yes
QLSTSQLS SQL Statements Sent DGO0645 Yes
Table 23. Statistics - Distributed Data Facility - Global
Field name Field description Help panel name Exception
QDSTCNAT Active DBATs - Currently DGO1616  
QDSTCSTR Cold Start Connections DGO0762 Yes
QDSTHWAT Active DBATs - high water mark DGO1617 Yes
QDSTHWDT Total DBATs - high water mark DGO1618 Yes
QDSTQCIT Inactive DBATs - Currently DGO0760  
QDSTQCRT Conversions Deallocated-Maximum Connected DGO0759  
QDSTQDBT DBAT Queued-Maximum Active DGO0758 Yes
QDSTQMIT Inactive DBATs - HWM DGO0761 Yes
QDSTRSAT Resynchronization Attempted DGO0764 Yes
QDSTRSSU Resynchronization Succeeded DGO0765 Yes
QDSTWSTR Warm Start Connections DGO0763 Yes
Table 24. Statistics - EDM Pool Activity
Field name Field description Help panel name Exception
QISECT Pages Used for CT DGO0402  
QISECTG Requests for CT Sections DGO0408  
QISECTL CT Section Not Found In EDM Pool DGO0409 Yes
QISEDBD Pages Used for DBD DGO0403  
QISEDBDG Requests for DBD Sections DGO0414  
QISEDBDL DBD Section Not Found In EDM Pool DGO0415 Yes
QISEDYNI Inserts for Dynamic Cache DGO1825  
QISEDYNP Pages Used for Cache DGO1827  
QISEDYNR Requests for Dynamic Cache Section DGO1826  
QISEFAIL EDM Pool Full DGO0407 Yes
QISEFREE Free Pages In Free Chain DGO0401  
QISEKT Pages Used for PT DGO0405  
QISEKTG Requests for PT Sections DGO0411  
QISEKTL PT Sections Not Found In EDM Pool DGO0412 Yes
QISESKCT Pages Used for Skct DGO0404  
QISESKPT Pages Used for Skpt DGO0406  
QXSTDEXP Kept Dynamic Statement Discarded DGO1823  
QXSTDINV Dynamic Cache Statement Purged DGO1824  
QXSTFND Prepares Satisfied DGO1819  
QXSTIPRP Prepares Implicit DGO1821  
QXSTNFND Prepares Received DGO1820  
QXSTNPRP Prepares Avoided DGO1822  
SERBUTP EDM Pool Pages In Use (%) DGO0400  
SERCTLR CT Requests / CT Not In EDM Pool DGO0410 Yes
SERDBLR DBD Requests / DBD Not In EDM Pool DGO0416 Yes
SERPTLR PT Requests / PT Not In EDM DGO0413 Yes
Table 25. Statistics - Global Group Buffer Pool Statistics
Field name Field description Help panel name Exception
QBGBGCK Checkpoint Interval (Minutes) DGO1587  
QBGBGCT Class Castout Threshold (%) DGO1585  
QBGBGDR Actual Directory Entries DGO1588  
QBGBGDT Actual Data Entries DGO1589  
QBGBGGT Buffer Pool Castout Threshold (%) DGO1586  
QBGBGR1 Current Directory to Data Ratio DGO1584  
QBGBGR2 Pending Directory to Data Ratio DGO1590  
QBGBGSZ Allocated Buffer Pool Size (4k) DGO1583  
QW0254CC Castout DGO1575 Yes
QW0254DE Directory Entry DGO1576 Yes
QW0254DR Directory Entry Reclaim DGO1571 Yes
QW0254GN Group Buffer Pool Name DGO1562  
QW0254RD Read Miss Directory Hit DGO1565 Yes
QW0254RF Read Miss Cache Full DGO1567 Yes
QW0254RH Read Hit DGO1563 Yes
QW0254RN Read Miss Name Assignment DGO1566 Yes
QW0254RS Read Miss Assignment Suppressed DGO1564 Yes
QW0254TC Total Changed DGO1578 Yes
QW0254TE Data Entry DGO1577 Yes
QW0254TR Data Entry Reclaim DGO1570 Yes
QW0254WC Clean Page Write Hit DGO1569 Yes
QW0254WF Write Miss Cache Full DGO1572 Yes
QW0254WH Changed Page Write Hit DGO1568 Yes
QW0254XR XI Directory Entry Reclaim DGO1573 Yes
Table 26. Statistics - Group Buffer Pools Activity
Field name Field description Help panel name Exception
QBGLAC Clean Pages Written Asynchronously DGO1356 Yes
QBGLAD Asynchronous Reads - Data Returned DGO1342 Yes
QBGLAN Asynchronous reads - No read/write interest DGO1344  
QBGLAW Changed Pages Written Asynchronously DGO1346 Yes
QBGLAX Register page list request DGO1656 Yes
QBGLAY Changed pages - Read after register page list DGO1657 Yes
QBGLAZ Clean pages - Read after register page list DGO1658 Yes
QBGLCC Read Castout Class DGO1731  
QBGLCK GBP Checkpoints Triggered DGO1733  
QBGLCN Castout Engine Unavailable DGO1350 Yes
QBGLCS Read Castout Statistics DGO1732  
QBGLCT Castout Class Threshold DGO1348 Yes
QBGLDG Unregister Page DGO1729  
QBGLDN Delete Name DGO1726  
QBGLGN Group Bufferpool ID DGO1366  
QBGLGT Group Bufferpool Castout Threshold DGO1349 Yes
QBGLMD Synchronous Reads Not Found - Data Returned DGO1339 Yes
QBGLMN Synchr. Reads Not Found - No R/W Interest DGO1341  
QBGLMR Sync. Read (Not Found) - No Data Returned DGO1340  
QBGLOS Read Storage Statistics DGO1760  
QBGLRB Participation in GBP Rebuild DGO1734  
QBGLRC Pages Castout DGO1347 Yes
QBGLRD Read Directory Info DGO1727  
QBGLRF Read Failed - No Storage DGO1352 Yes
QBGLRG Register Page DGO1728  
QBGLSU Write Engine Unavailable DGO1351 Yes
QBGLSW Changed Pages Written Synchronously DGO1345 Yes
QBGLUN Unlock Castout DGO1730  
QBGLWC Clean Pages Written Synchronously DGO1355 Yes
QBGLWF Write Failed - No Storage DGO1353 Yes
QBGLXD Synchr. Reads Cross Valid. - Data Returned DGO1336 Yes
QBGLXN Synchr. Reads Cross Valid. - No R/W Interest DGO1338  
QBGLXR Synchronous Read (XI) - No Data Returned DGO1337  
Table 27. Statistics - Locking Activity
Field name Field description Help panel name Exception
QTXACHG Change Requests DGO0480  
QTXACLNO Claim Requests DGO0486  
QTXACLUN Unsuccessful Claim Requests DGO0487 Yes
QTXADEA Deadlocks DGO0476 Yes
QTXADRNO Drain Requests DGO0484  
QTXADRUN Unsuccessful Drain Requests DGO0485 Yes
QTXAIRLM Other Requests DGO0481  
QTXALES Lock Escalation (shared) DGO0482 Yes
QTXALEX Lock Escalation (exclusive) DGO0483 Yes
QTXALOCK Lock Requests DGO0477  
QTXAQRY Query Requests DGO0479  
QTXASLAT Suspensions (latch only) DGO0473  
QTXASLOC Suspensions (lock only) DGO0472 Yes
QTXASOTH Suspensions (other) DGO0474  
QTXATIM Timeouts DGO0475 Yes
QTXAUNLK Unlock Requests DGO0478  
SLCLKET Lock Escalations DGO0768 Yes
SLRLCRLS Lock and Change Requests per Lock Suspension DGO0808  
SLRSUSP Suspensions (all) DGO0471 Yes
Table 28. Statistics - Log Activity
Field name Field description Help panel name Exception
QJSTALR Archive Log Read Allocations DGO0519  
QJSTALW Archive Log - Write Allocations DGO0520  
QJSTBFFL Control Intervals Created DGO0518  
QJSTBFWR Write Output Log Buffers DGO0515  
QJSTBSDS Total BSDS Access Request DGO0516  
QJSTCIOF Archive Log - Control Intervals Offloaded DGO0807  
QJSTLAMA Look Ahead Mounts Attempted DGO0512  
QJSTLAMS Look Ahead Mount Successful DGO0513  
QJSTRACT Reads Satisfied - Active Log DGO0505 Yes
QJSTRARH Reads Satisfied - Archive Log DGO0507 Yes
QJSTRBUF Reads Satisfied - Output Buffer DGO0503 Yes
QJSTTVC Reads Delayed - Tape Volume Contention DGO0510 Yes
QJSTWRNW Write-no-wait DGO0514  
QJSTWTB Unavailable Output Log Buffers DGO0517 Yes
QJSTWUR Reads Delayed - Unavailable Resource DGO0511 Yes
SARLRACT Reads Satisfied - Active Log(%) DGO0506  
SARLRARC Reads Satisfied - Archive Log(%) DGO0508  
SARLRBUF Reads Satisfied - Output Buffer(%) DGO0504  
SARWBAC Out Log Buf Writes / Act. Log Cntl I'val DGO0806 Yes
Table 29. Statistics - Miscellaneous
Field name Field description Help panel name Exception
QISTCOLS Columns Bypassed DGO0770  
QWSDLR Log RBA DGO0636  
QWSDRINV Reason Invoke DGO0637  
Table 30. Statistics - Open/Close Activity
Field name Field description Help panel name Exception
QTDSDRN Data Sets Closed Threshold Reached DGO0426 Yes
QTDSOPN Open Data Sets - Current DGO0418 Yes
QTMAXDS Open Data Sets - HWM DGO0417 Yes
QTMAXPB Open Data Sets - Not In Use, Not Closed (HWM) DGO0422 Yes
QTPCCT Data Sets Converted R/W To R/O DGO0755 Yes
QTREOPN Successful Logical Reopens DGO0429  
QTSLWDD Open DSs - Not In Use, Not Closed (current) DGO0420 Yes
SDINUSEC Open Data Sets In Use DGO0757 Yes
Table 31. Statistics - Plan/Package Processing
Field name Field description Help panel name Exception
QTABIND Autobind Plan Successful DGO0442 Yes
QTABINDA Autobind Plan Attempts DGO0441 Yes
QTALLOC Plan Allocation Successful DGO0431  
QTALLOCA Plan Allocation Attempts DGO0430  
QTAUTOBA Auto Bind Package Attempts DGO0444 Yes
QTBINDA Bind Plan Add Subcommands DGO0435  
QTBINDPA Bind Package Add Subcommand DGO0439  
QTBINDPR Bind Package Replace Subcommand DGO0440  
QTBINDR Bind Plan Replace Subcommands DGO0436  
QTFREE Free Plan Subcommands DGO0452  
QTFREEA Free Plan Attempts DGO0453  
QTFREEAP Free Package Attempts DGO0456  
QTFREEP Free Package Subcommands DGO0455  
QTINVRID Autobind Plan Invalid Resource ID DGO0443 Yes
QTPKABND Auto Bind Packages Successful DGO0445 Yes
QTPKALL Package Allocation Successful DGO0433  
QTPKALLA Package Allocation Attempts DGO0432  
QTPKGBD Packages Bound DGO0438  
QTPKGFRD Free Package Successful DGO0457  
QTPKGRBD Rebind Package Successful DGO0451  
QTPLNBD Plans Bound DGO0434  
QTPLNFRD Free Plan Successful DGO0454  
QTPLNRBD Rebind Plan Successful DGO0448  
QTRBINDA Rebind Plan Attempts DGO0447  
QTRBINDP Rebind Package Subcommands DGO0449  
QTRBNDPA Rebind Package Attempts DGO0450  
QTREBIND Rebind Plan Subcommands DGO0446  
QTTESTB Test Binds No Plan-ID DGO0437  
Table 32. Statistics - Query Parallelism
Field name Field description Help panel name Exception
QXCOORNO One Db2 - COORDINATOR Parm = NO DGO1672  
QXDEGBUF Fall To Sequential Mode (no buffer) DGO0327 Yes
QXDEGCUR Fall To Sequential Mode Cursor DGO0748 Yes
QXDEGESA Fall To Sequential Mode No ESA DGO0747 Yes
QXISORR One Db2 - Isolation Level DGO1673  
QXMAXDEG Maximum Degree of Parallelism DGO0326  
QXNORGRP Planned Parallel Degree DGO0329  
QXREDGRP Reduced Parallel Degree DGO0328 Yes
QXTOTGRP Parallel Groups Executed DGO0749  
SDTOTPFL Parallel Fall To Sequential DGO0746 Yes
SXXCRAT Member Skipped (%) DGO1798  
Table 33. Statistics - RID List Processing
Field name Field description Help panel name Exception
QISTRCUR RID Blocks Allocated - Current DGO0466  
QISTRHIG RID Blocks Allocated - Maximum DGO0465 Yes
QISTRLLM Terminated - RDS Limit Exceeded DGO0468 Yes
QISTRMAX Terminated - Process Limit Exceeded DGO0470 Yes
QISTRPLM Terminated - DM Limit Exceeded DGO0469 Yes
QISTRSTG Terminated - No Storage DGO0467 Yes
SRTTERM Number of Times RID List Processing Not Used DGO0767 Yes
Table 34. Statistics - SQL Activity (DCL)
Field name Field description Help panel name Exception
QXALOCC Allocate Cursor DGO1740  
QXALOCL Associate Locators DGO1739  
QXCON1 Connect Type 1 DGO0296  
QXCON2 Connect Type 2 DGO0297  
QXGRANT Grant DGO0292  
QXLOCK Lock Table DGO0291  
QXREL Release DGO0298  
QXREVOK Revoke DGO0293  
QXSETCDG Set Current Degree DGO0742  
QXSETCON Set Connection DGO0299  
QXSETCRL Set Current Rules DGO1357  
QXSETHV Set Host Variable DGO0295  
QXSETSQL Set Current SQLID DGO0294  
SSCDCL Total DCL DGO0300 Yes
Table 35. Statistics - SQL Activity (DDL)
Field name Field description Help panel name Exception
QXALDAB Alter Database DGO0312  
QXALTIX Alter Index DGO0310  
QXALTST Alter Stogroup DGO0313  
QXALTTA Alter Table DGO0309  
QXALTTS Alter Tablespace DGO0311  
QXCMTON Comment On DGO0323  
QXCRALS Create Alias DGO0308  
QXCRDAB Create Database DGO0306  
QXCRGTT Temp. Table DGO1671  
QXCRINX Create Index DGO0302  
QXCRSTG Create Stogroup DGO0307  
QXCRSYN Create Synonym DGO0304  
QXCRTAB Create Table DGO0301  
QXCTABS Create Tablespace DGO0305  
QXDEFVU Create View DGO0303  
QXDRPAL Drop Alias DGO0321  
QXDRPDB Drop Database DGO0319  
QXDRPIX Drop Index DGO0315  
QXDRPPKG Drop Package DGO0322  
QXDRPST Drop Stogroup DGO0320  
QXDRPSY Drop Synonym DGO0317  
QXDRPTA Drop Table DGO0314  
QXDRPTS Drop Tablespace DGO0318  
QXDRPVU Drop View DGO0316  
QXLABON Label On DGO0324  
QXRNTAB Rename Table DGO1828  
SDTOTALT Alters DGO0743  
SDTOTCRT Creates DGO0745  
SDTOTDRP Drops DGO0744  
SSCDDL Total DDL DGO0325 Yes
Table 36. Statistics - SQL Activity (DML)
Field name Field description Help panel name Exception
QXCLOSE Close Cursor DGO0288  
QXDELET Delete DGO0283  
QXDESC Describe DGO0285  
QXDSCRTB Describe Table DGO0286  
QXFETCH Fetch DGO0289  
QXINSRT Insert DGO0281  
QXOPEN Open Cursor DGO0287  
QXPREP Prepare DGO0284  
QXSELECT Select DGO0280  
QXUPDTE Update DGO0282  
SSCDML Total DML DGO0290 Yes
Table 37. Statistics - SQL Nested Activity
Field name Field description Help panel name Exception
QXCALL Call Statements Executed DGO1358  
QXCALLAB Procedure Abends DGO1363 Yes
QXCALLRJ Call Statement Rejected DGO1365 Yes
QXCALLTO CALL Statement Timeouts DGO1364 Yes
Table 38. Statistics - Subsystem Services
Field name Field description Help panel name Exception
QWSDCKPT System Event Checkpoint DGO0535 Yes
Q3STABRT Rollback DGO0525 Yes
Q3STCOMM Commits Phase 2 DGO0527  
Q3STCTHD Create Thread DGO0522 Yes
Q3STCTHW Queued At Create Thread DGO0532 Yes
Q3STIDEN Identify DGO0521  
Q3STINDT Units of Recovery Gone Indoubt DGO0529 Yes
Q3STMEOM Subsystem Allied Memory End of Memory DGO0534 Yes
Q3STMEOT Subsystem Allied Memory End of Task DGO0533 Yes
Q3STPREP Commits Phase 1 DGO0526  
Q3STRDON Commits Read Only DGO0528  
Q3STRIUR Units of Recovery Indoubt Resolved DGO0530  
Q3STSIGN Signon DGO0523 Yes
Q3STSYNC Synchs (single phase commit) DGO0531  
Q3STTERM Terminate DGO0524  
Table 39. Statistics - Times
Field name Field description Help panel name Exception
SDDFSRBT DDF Address Space SRB Time DGO0498  
SDDFTCBT DDF Address Space TCB Time DGO0497  
SDDFTOTT DDF Address Space Total Time DGO0499 Yes
SDISRBT IRLM SRB Time DGO0495  
SDITCBT IRLM TCB Time DGO0494  
SDITOTT IRLM Total Time DGO0496 Yes
SDSRBT Database Services SRB Time DGO0492  
SDTCBT Database Services TCB Time DGO0491  
SDTLSRBT Total DGO0501  
SDTLTCBT Total DGO0500  
SDTLTOTT Total DGO0502  
SDTOTT Database Services Total Time DGO0493 Yes
SSSRBT System Services SRB Time DGO0489  
SSTCBT System Services TCB Time DGO0488  
SSTOTT System Services Total Time DGO0490 Yes
Table 40. System Parameters - Application Programming Defaults
Field name Field description Help panel name
QWPBAGID ASCII GBCS CCSID DGO1741
QWPBAMID ASCII MBCS CCSID DGO1742
QWPBAR Default Decimal Arithmetic DGO1748
QWPBASID ASCII SBCS CCSID DGO1743
QWPBCHAR Default Character Set DGO1763
QWPBDATE Date Format DGO1755
QWPBDE Decimal Point Option DGO1747
QWPBDL Default Delimiter DGO1749
QWPBDLEN Local Date Length DGO1757
QWPBDSD Distributed SQL String Delimiter DGO1754
QWPBENS Default Encoding Scheme DGO1750
QWPBGID EBCDIC GBCS CCSID DGO1744
QWPBGRA Default Mixed Graphic DGO1752
QWPBLANG Default Host Language DGO1751
QWPBMID EBCDIC MBCS CCSID DGO1745
QWPBSDL Default SQL Delimiter DGO1753
QWPBSID EBCDIC SBCS CCSID DGO1746
QWPBSQL SQL Language Support Level DGO1759
QWPBTIME Time Format DGO1756
QWPBTLEN Local Time Length DGO1758
QWP4CDEG Current Degree (CDSSRDEF) DGO1659
QWP4CDYN Cache Dynamic SQL Statements DGO1809
QWP4RCHL Release Cursor Hold Locks DGO1814
Table 41. System Parameters - Archive Log Installation Parameters
Field name Field description Help panel name
QWP2ADL Number of Copies DGO1416
QWP2ARCL Maximum Data Sets Recorded In BSDS DGO1242
QWP2MRTU Maximum Read Tape Units DGO1248
QWP3BKSZ Archive Log Block Size DGO1251
QWP3COMP Compact Data DGO1252
QWP3CTLG Catalog Archive Data Sets DGO1253
QWP3CYL Space Allocation Method DGO1420
QWP3DTIM Timestamp Archive Log Data Sets DGO1254
QWP3MQP Quiesce Period (seconds) DGO1255
QWP3MSV1 Archive Copy 1 Mass Storage Group Name DGO1256
QWP3MSV2 Archive Copy 2 Mass Storage Group Name DGO1257
QWP3RETN Days To Retain Archive Log Data Sets DGO1258
QWP3RE1N Copy 1 Prefix DGO1259
QWP3RE2N Copy 2 Prefix DGO1260
QWP3RISP Primary Space DGO1261
QWP3SECS Secondary Space DGO1263
QWP3UNT1 Copy 1 Archive Log Device Type DGO1264
QWP3UNT2 Copy 2 Archive Log Device Type DGO1419
QWP3WTOR Issue WTOR Before Mount for Archive Volume DGO1265
ZWP2TIME Tape Unit Deallocation Period DGO1424
Table 42. System Parameters - Buffer Pool Information Page
Field name Field description Help panel name
QDBPCAST Castout Attribute DGO1210
QDBPDWQT Deferred Write Threshold DGO1211
QDBPNM Buffer Pool Name DGO1214
QDBPPSQT Parallel Sequential Threshold DGO1215
QDBPVDQT Vertical Deferred Write Threshold DGO1216
QDBPVPSH Virtual Sequential Threshold DGO1217
QDBPVPSZ Virtual Pool Size DGO1218
QDBPXSQT Assisting Parallel Sequential Threshold DGO1660
Table 43. System Parameters - Data Definition Control Support
Field name Field description Help panel name
QWP4ESC Escape Character DGO1273
QWP4REGA Application Registration Table DGO1286
QWP4REGC Register Table Owner DGO1287
QWP4REGD Control All Applications DGO1288
QWP4REGI Install DD Control DGO1289
QWP4REGN DDL Registration Database Name DGO1290
QWP4REGO Object Registration Table DGO1291
QWP4REGQ Require Full Names DGO1292
QWP4REGU Unregistered DDL Default DGO1293
Table 44. System Parameters - Data Installation Parameters
Field name Field description Help panel name
QWP6CATN Icf Catalog Qualifier DGO1303
Table 45. System Parameters - Data-Sharing Parameters
Field name Field description Help panel name
QWPAASST Parallelism Assistant DGO1780
QWPACOOR Query coordinator DGO1675
QWPAGRPN Group name DGO1455
QWPAIOPT Data sharing enabled DGO1548
QWPAMAXM Maximum number of members DGO1549
QWPAMBRN Member name DGO1547
QWPASUCV SU conversion factor DGO1676
Table 46. System Parameters - Distributed Data Facility Parameters
Field name Field description Help panel name
QWP1SCER Extended Security DGO1674
QWP4HOP Hop Site Authorization DGO1274
QWP9CMST DBAT Status DGO1304
QWP9RLFN Resource Limit Spec. Table Error Action (DDF) DGO1305
QWP9RYC Resynchronization Interval (minutes) DGO1306
QWP9STRT Db2 Startup Option DGO1307
QWP9TTO Idle Thread Timeout Interval DGO1435
Table 47. System Parameters - Group Buffer Pools Parameters Page
Field name Field description Help panel name
QBGBGAS AUTOREC (automatic recovery) DGO1725
QBGBGDR Actual Directory Entry DGO1559
QBGBGDT Actual Data Entry DGO1560
QBGBGR2 Pending Directory to Data Ratio DGO1561
QBGBGSZ Allocated Buffer Pool Size (4K) DGO1558
Table 48. System Parameters - IRLM Installation Parameters
Field name Field description Help panel name
QWP4IAUT Automatic Start DGO1405
QWP4IPRC Start Procedure Name DGO1276
QWP4ISID Subsystem Name DGO1277
QWP4ISWT Time Db2 Will Wait for Start (seconds) DGO1278
QWP4TOUT Resource Timeout (seconds) DGO1299
QWP4UTO Utility Timeout Factor DGO1300
Table 49. System Parameters - Lock Escalation Parameters
Field name Field description Help panel name
QWP4LKTS Maximum Locks per Table Space DGO1279
QWP4LKUS Maximum Locks per User DGO1280
QWP4WAIT Wait For Retained Locks DGO1738
Table 50. System Parameters - Log Installation Parameters
Field name Field description Help panel name
QWP2DUAL Number of Copies DGO1431
QWP2IBPS Input Buffer Size (KB) DGO1246
QWP2OBPS Output Buffer Size (KB) DGO1249
QWP2WRTH Write Threshold On Filled Buffers DGO1250
Table 51. System Parameters - Operator Functions Installation Parameters
Field name Field description Help panel name
QWP1RLF Resource Limit Facility Automatic Start DGO1228
QWP1RLFN Resource Limit Spec. Table Error Action DGO1230
QWP1RLFT Resource Limit Specification Table Suffix DGO1231
QWP1SMRC WTO Route Codes DGO1236
QWP4ABN Allow Autobind Operations DGO1266
QWP4ABX Allow Explain At Autobind DGO1267
QWP4ENF DPROP Support DGO1404
QWP4SIT Site Type DGO1296
QWP9TCPA TCP/IP Already Verified DGO1761
Table 52. System Parameters - Other System Parameters
Field name Field description Help panel name
MZDBSTRT Databases and Table Spaces DGO1208
QWP1DFRQ Checkpoints Level ID Updates DGO1434
QWP2DBSD Dual BSDS Mode DGO1243
QWP4DSMX Maximum Open Data Sets (DSMAX) DGO1271
QWP4DSST Static describe (DESCSTAT) DGO1701
QWP4ISWI IRLM Initial Inquiry by Db2 DGO1433
QWP4MDDN Asynchronous Drain Stop (%DSMAX) DGO1281
QWP4TDDN Asynchronous Drain Start (%DSMAX) DGO1298
QWP4WBMP IMS/BMP time-out factor (BMPTOUT) DGO1669
QWP4WDLI IMS/DLI time-out factor (DLITOUT) DGO1670
XWP4CDEG Current Degree (CDSSRDEF) DGO1859
Table 53. System Parameters - Protection Installation Parameters
Field name Field description Help panel name
QWP1RLFA Resource Limit Table Creator Authid DGO1229
QWP3RTCT RACF® Protect Archive Log DGO1262
QWP4ADM2 System Administrator 2 Authid DGO1268
QWP4AUCA Plan Authorization Cache Size DGO1428
QWP4AUTH Db2 Authorization Enabled DGO1269
QWP4BNVA Bind New Version DGO1430
QWP4DFID Default (unknown) User Authid DGO1270
QWP4OPR1 System Operator 1 Authid DGO1283
QWP4OPR2 System Operator 2 Authid DGO1284
QWP4PAC Package Authorization Cache Size DGO1779
QWP4SADM System Administrator 1 Authid DGO1294
Table 54. System Parameters - Storage Sizes Installation Parameters
Field name Field description Help panel name
QWP1CDB Maximum Remote DGO1220
QWP1CT Maximum Concurrent Threads DGO1221
QWP1IDB Maximum Batch DGO1223
QWP1IDF Maximum TSO DGO1224
QWP1RMT Maximum Remote Active DGO1232
QWP4EDPL Maximum Size of EDM Pool DGO1272
QWP4IXTP Default Index Type DGO1546
QWP4MXKD Maximum Kept Dynamic Statements DGO1810
QWP4PST Utility Cache Option DGO1766
QWP4RMAX Maximum Size of RID Pool DGO1396
QWP4SCAC 3990 Cache DGO1295
QWP4SPOL Maximum Size of Sort Pool DGO1297
Table 55. System Parameters - Stored Procedures Parameters
Field name Field description Help panel name
QWP1SPAB Abends Allowed DGO1437
QWP1SPPN MVS Procedure Name DGO1436
QWP1SPTO Timeout Value DGO1438
Table 56. System Parameters - Tracing, Checkpoint and Pseudo-Close Parameters
Field name Field description Help panel name
QWP1AUDT Start Audit Trace DGO1219
QWP1FREQ Pseudo-Close Frequency DGO1222
QWP1LOGL Checkpoint Frequency DGO1225
QWP1MON Start Monitor Trace DGO1226
QWP1MONS Monitor Buffer Size (bytes) DGO1227
QWP1SMFA Start SMF Accounting DGO1234
QWP1SMFS Start SMF Statistics Trace DGO1235
QWP1STIM Statistics Interval (minutes) DGO1237
QWP1TMR Pseudo-Close Timer DGO1238
QWP1TRST Start Global Trace DGO1239
QWP1TRSZ Trace Table Size (4 KB multiple) DGO1240
QWP1URCK UR Check Frequency DGO1712