2. USAGE GUIDELINES › 2.2 CA MICS Product Interfaces › 2.2.2 Capacity Planner Interface › 2.2.2.1 Capacity Planning Elements

Previous Topic: 2.2.2 Capacity Planner Interface

Next Topic: 3. REPORTS

2.2.2.1 Capacity Planning Elements


The following data elements are available for capacity
planning analysis.

    A.  Data elements common to all CA MICS Capacity Planner
        database files:

        SYSID
        ZONE or HOUR
        YEAR
        MONTH or WEEK
        DATE

    B.  Data elements unique to the DB2 Planning Standard
        Application database file:

        1.  Numeric format data elements

            ALLBFEXP - Total Get Page Caused Buffer
                       Expansions
            ALLGETPG - Total Get Page 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
            DSDABBP0 - Active Buffers In Buffer Pool 0
            DSDABBP1 - Active Buffers In Buffer Pool 1
            DSDABBP2 - Active Buffers In Buffer Pool 2
            DSDABBP3 - Active Buffers In Buffer Pool 3
            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
            DSDRFXS0 - Read Pagefixed W/O Real Storage BP0
            DSDRFXS1 - Read Pagefixed W/O Real Storage BP1
            DSDRFXS2 - Read Pagefixed W/O Real Storage BP2
            DSDRFXS3 - Read Pagefixed W/O Real Storage BP3
            DSDWFXS0 - Write Pagefixed W/O Real Storage BP0
            DSDWFXS1 - Write Pagefixed W/O Real Storage BP1
            DSDWFXS2 - Write Pagefixed W/O Real Storage BP2
            DSDWFXS3 - Write Pagefixed W/O Real Storage BP3
            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

        2.  Time format data elements

            CPUINDB2 - Total Attributable DB2 TCB
            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