Previous Topic: #PMPGMDSNext Topic: #PMSMHDS


#PMRUSDS

                        COPY #PMRUSDS
               *********************************************************************
               ***                                                               ***
               ***      #PMRUS - INTERVAL RUNUNITS INFORMATION RECORD            ***
               ***                                                               ***
               ***      COPYRIGHT (C) 2007 CA technologies. ALL RIGHTS RESERVED.              ***
               ***                                                               ***
               ***                                                               ***
               ***                                                               ***
               *********************************************************************
               *
               *        ONE PER INTERVAL
               *
               *--------------------------------------------------------------------
               *

Offset  Value

000000         #PMRUS   DSECT
               *
               *--------------------------------------------------------------------
               *
000000         RUSHDR   DS   0H                   RECORD HEADER
               *
000000         RUSLEN   DS    H                   RECORD LENGTH         (INCLUSIVE)
000002         RUSRTYPE DS    X                   RECORD TYPE
        00009  RUS$TYPE EQU       9               ..PMIM RUNUNIT WAIT RECORD
000003         RUSSEQ#  DS    X                   SEQUENCE NUMBER       (ALWAYS 1)
000004         RUSVER#  DS    X                   RECORD VERSION
        00001  RUS$VER  EQU       1               ..CURRENT VERSION
000005                  DS    XL3                 ** RESERVED **
               *
000008                  DS    F                   ** RESERVED **
00000C         RUSSDATE DS    PL4                 INTERVAL START DATE   (00YYYDDF)
000010         RUSSTIME DS    F                   INTERVAL START TIME   (10**-4 SEC)
000014         RUSEDATE DS    PL4                 INTERVAL END DATE     (00YYYDDF)
000018         RUSETIME DS    F                   INTERVAL END TIME     (10**-4 SEC)
               *
        0001C  RUSHDRLN EQU   *-RUSHDR            HEADER LENGTH
               *
               *--------------------------------------------------------------------
               *
        0001C  RUSDATA  EQU   *                   START OF RUNUNIT DATA
               *
00001C         RUS#RU   DS    F                   # RUNUNITS STARTED DURING INTVL
000020         RUS#EXRU DS    F                   # EXT. RUS STARTED DURING INTVL
000024         RUS#RUNM DS    F                   # RUNUNITS ENDED NORMAL IN INTVL
000028         RUS#EXNM DS    F                   # EXT. RUS ENDED NORMAL IN INTVL
00002C         RUS#MXRU DS    F                   # MAX CONCURRENT RUNUNITS
000030         RUS#MXEX DS    F                   # MAX CONCURRENT EXT. RUS
000034         RUS#DBKL DS    F                   # DBKEY LOCKS
000038         RUS#EXDB DS    F                   # EXTERNAL RUS WITH DB RUS
00003C         RUS#RACS DS    F                   # RUNUNITS ACTIVE AT INTVL START
000040         RUS#XACS DS    F                   # EXT. RUS ACTIVE AT INTVL START
000044         RUS#RACE DS    F                   # RUNUNITS ACTIVE AT INTVL END
000048         RUS#XACE DS    F                   # EXT. RUS ACTIVE AT INTVL END
00004C         RUS#SLOK DS    F                   # SYSTEM LOCKS
000050         RUSNXTRU DS    F                   # NEXT RUNUNIT ID TO ASSIGN
000054                  DS    F                   ** RESERVED **
               *
               *--------------------------------
               *
               * DB STATISTICS FOR INTERVAL
Offset  Value

               *
000058         RUSPAGRD DS    F                   # DB PAGES READ         (STBPAGRD)
00005C         RUSPAGWR DS    F                   # DB PAGES WRITTEN      (STBPAGWR)
000060         RUSPAGRQ DS    F                   # DB PAGES REQUESTED    (STBPAGRQ)
000064         RUSCALNO DS    F                   # DB CALC RECS NO OFLOW (STBCALNO)
000068         RUSCALOV DS    F                   # DB CALC RECS W/ OFLOW (STBCALOV)
00006C         RUSVIANO DS    F                   # DB VIA RECS NO OFLOW  (STBVIANO)
000070         RUSVIAOV DS    F                   # DB VIA RECS W/ OFLOW  (STBVIAOV)
000074         RUSRECRQ DS    F                   # DB RECORDS REQUESTED  (STBRECRQ)
000078         RUSRECCU DS    F                   # DB RECORDS CURR OF RU (STBRECCU)
00007C         RUSDBRQS DS    F                   # DB DBMS CALLS         (STBDBRQS)
000080         RUSFRAGS DS    F                   # DB FRAGMENTS STORED   (STBFRAGS)
000084         RUSUPCNT DS    F                   # DB RECORDS UPDATED    (STBUPCNT)
000088         RUSCACHE DS    F                   # DB RECS FND IN CACHE  (STBCACHE)
00008C         RUSPRFET DS    F                   # DB RECS FND IN PREFET (STBPRFET)
               *
               *--------------------------------
               *
               * JRNL BLOCK % FULL STATISTICS FOR INTERVAL
               *
000090         RUSPERC  DS  10H                   JRNL BLK % FULL BUCKETS (JBCPERC)
               *
               *--------------------------------
               *
               * SQL STATISTICS FOR INTERVAL
               *
0000A4         RUS#CMD  DS    F                   # OF SQL COMMANDS EXECUTED
0000A8         RUS#FET  DS    F                   # OF ROWS FETCHED
0000AC         RUS#INS  DS    F                   # OF ROWS INSERTED
0000B0         RUS#UPD  DS    F                   # OF ROWS UPDATED
0000B4         RUS#DEL  DS    F                   # OF ROWS DELETED
0000B8         RUS#SRT  DS    F                   # OF SORTS PERFORMED
0000BC         RUS#SRR  DS    F                   # OF ROWS SORTED
0000C0         RUS#SMI  DS    F                   # OF MINIMUM ROWS
0000C4         RUS#SMX  DS    F                   # OF MAXIMUM ROWS
0000C8         RUS#AMC  DS    F                   # OF AM RECOMPILES
               *
0000CC                  DS   3F                   ** RESERVED **
               *
               *--------------------------------------------------------------------
               *
        000D8  RUSDSLEN EQU   ((*-#PMRUS+3)/4)*4  LENGTH OF LOG RECORD
               *
               *--------------------------------------------------------------------
               *
        000BC  RUSDTLEN EQU   RUSDSLEN-RUSHDRLN   LENGTH OF RECORD DATA
               *
               *--------------------------------------------------------------------