2. SAMPLE PLANNING APPLICATIONS › 2.11 DB2 Resource Planning › 2.11.3 Standard Output
2.11.3 Standard Output
The capacity planning database file generated by the DB2
Resource Planning Sample Application contains the following
data elements:
o Data elements common to all CA MICS Capacity Planner
database files:
SYSID
ZONE or HOUR or DAYNAME
YEAR
MONTH or WEEK or MNTHDAY
DATE
o Data elements unique to the DB2 Resource Planning Sample
Application database file:
- Character format data elements
CAPAPU - DB2 Workload Group
- Numeric format data elements
ALLBFEXP - Total Getpage Caused Buffer Expansions
ALLGETPG - Total Getpage Requests
ALLPRFET - Total Prefetch Read Requests
ALLSYCIO - Total Synchronous Read I/Os
ALLWRKUP - Total Units of Work Updated
CPUOVRHD - Ratio of DB2 CPU Time to Attributable
DSDSABBP - Active Buffers In Buffer Pool
DSDMNRPG - Min Free Pages in Free Chain
DSDMXCTU - Max Pages Used for Cursor Table
DSDMXDBD - Max Pages Used for DBD
DSDMXDSO - Max Data Sets Open Concurrently
DSDMXPGE - Max Pages in EDM Pool
DSDMXRPG - Max Free Pages in Free Chain
DSDMXSKC - Max Pages Used for SKCT Table
DSDPAGE - No. Pages in EDM Pool
DSDSRFXS - Read Pagefixed W/O Real Storage
DSDSWFXS - Write Pagefixed W/O Real Storage
DSULEEM - No. Lock Escalations to Exclusive Mode
DSULESM - No. Lock Escalations to Shared Mode
DSUMXPL - Max. No. Page Locks Held
DSUSUSP - Suspend Count
DSUTIMO - Timeout Count
DSUWATTR - NO. Wait Trace Events Processed
TOTSTMTS - Total Statements Executed
- Time format data elements
CPUINDB2 - Total Attributable DB2 TCB
DURATION - Recording Interval Time
DSUALLTM - Lock & Latch Time
DSUCPUTM - Accumulated CPU Time
DSUELPTM - Elapsed Time
DSUET2TM - Class 2 Accum. Elapsed Time in DB2
DSUIOETM - DB2 I/O Time
DSUTCBTM - TCB Time
DSUTC2TM - Class 2 Accumulated TCB Time in DB2
DSYSRTM0 - Accumulated SRB Time Addr0
DSYSRTM1 - Accumulated SRB Time Addr1
DSYSRTM2 - Accumulated SRB Time Addr2
DSYTCTM0 - Accumulated TCB Time Addr0
DSYTCTM1 - Accumulated TCB Time Addr1
DSYTCTM2 - Accumulated TCB Time Addr2
TOTCPSTM - Total DB2 System CPU Time
TOTTCSTM - Total DB2 System TCB Time
TOTSRSTM - Total DB2 System SRB Time
The following data elements used in the DB2 Planning Resource
Sample Application database file have the same meaning and
derivation as their identically named counterparts in the
CA MICS files from which they are obtained.
DB2DSD: DSDSABBP, DSDMNRPG, DSDMXCTU, DSDMXDBD, DSDMXDSO,
DSDMXPGE, DSDMXRPG, DSDMXSKC, DSDPAGE, DSDSRFXS
DSDSWFXS
DB2DSU: DSUALLTM, DSUCPUTM, DSUELPTM, DSUET2TM, DSUIOETM,
DSULEEM, DSULESM, DSUMXPL, DSUSUSP, DSUTCBTM,
DSUTC2TM, DSUTIMO, DSUWATTR
DB2DSY: DSYSRTM0, DSYSRTM1, DSYSRTM2, DSYTCTM0, DSYTCTM1,
DSYTCTM2
The following data elements are derived from the CA MICS
database and used by the DB2 Resource Planning Sample
Application:
ALLGETPG: The total number of GETPAGE requests issued by
users to all buffer pools. It is calculated
using the following formula:
ALLGETPG = DSUSGPGR
where DSUSGPGR is a summarized data element from
the DB2DSU file quantifying the number of
GETPAGE requests issued for all buffer pools.
ALLPRFET: The total number of Media Manager pre-fetch read
requests to all buffer pools. It is calculated
using the following formula:
ALLPRFET = DSUSPRFH
where DSUSPRFH is a summarized data element from
the DB2DSU file quantifying the number of
pre-fetch read requests issued for all buffer
pools.
ALLSYCIO: The total number of DB2 Media Manager synchronous
read requests performed for all users by all
buffer pools. It is calculated using the
following formula:
ALLSYCIO = DSUSSRIO
where DSUSSRIO is a summarized data element from
the DB2DSU file quantifying the number of
synchronous read requests performed by all buffer
pools.
CPUINDB2: The total CPU time attributable to users of DB2.
It is the Class 2 TCB time obtained from the
DSUTC2TM data elements.
CPUOVRHD: The ratio of total DB2 system CPU time to the CPU
time that is attributable to users of DB2. It is
calculated using the following formula:
CPUOVRHD = TOTCPSTM / CPUINDB2
TOTCPSTM: The total DB2 system CPU time. It is the sum of
the CPU time recorded for each address space: 0,
1, and 2, representing the Systems Service,
Database Services, and the IMS Resource Lock
Manager address spaces respectively. It is
calculated using the following formula:
TOTCPSTM = SUM(TOTTCSTM, TOTSRSTM)
TOTSRSTM: The total DB2 system SRB time. It is the sum of
the SRB time recorded for each address space: 0,
1, and 2, representing the Systems Service,
Database Services, and the IMS Resource Lock
Manager address spaces respectively. It is
calculated using the following formula:
TOTSRSTM = SUM(DSYSRTM0, DSYSRTM1, DSYSRTM2)
TOTTCSTM: The total DB2 system TCB time. It is the sum of
the TCB time recorded for each address space: 0,
1, and 2, representing the Systems Service,
Database Services, and the IMS Resource Lock
Manager address spaces respectively. It is
calculated using the following formula:
TOTTCSTM = SUM(DSYTCTM0, DSYTCTM1, DSYTCTM2)
TOTSTMTS: The total number of DB2 statements executed. It
is the sum of the data elements in the DSU file
containing statement counts (for example,
DSUALTIX - Alter Index Statements,
DSUALTST - Alter Stogroup Statements, and so on.)
It is calculated using the following formula:
TOTSTMTS = SUM(DSUINSRT, DSUUPDTE, DSUDELET,
DSUDESC, DSUPREP, DSUOPEN,
DSUCLOSE, DSUCRTAB, DSUCRINX,
DSUCTABS, DSUCRSYN, DSUCRDAB,
DSUCRSTG, DSUDEFVU, DSUDRPIX,
DSUDRPTA, DSUDRPTS, DSUDRPDB,
DSUDRPSY, DSUDRPST, DSUDRPVU,
DSUALTST, DSUALTTS, DSUALTTA,
DSUALTIX, DSUCMTON, DSULOCK,
DSUFETCH, DSULABEL, DSUSELCT,
DSUGRANT, DSUREVOK);
Copyright © 2014 CA.
All rights reserved.
|
|