Virtual storage status report (BSTATSTX)

1                       BSTATSTX: VIRT STORAGE STATUS REPORT V10                         11/18/10 15:54:12    PAGE     1

     DB2 SSID: DEFF 10.1
   13:35:00
 .   Storage Statistics                                        Quantity
     ----------------------------                            ------------
     Address Space name                                       DBM1
        MVS extended Region size                                  1407 MB
        MVS 24 BIT LOW PRIVATE                                       0 MB
        MVS 24 BIT HIGH PRIVATE                                      1 MB
        MVS 31-bit extended low private                             68 MB
        MVS 31 BIT EXTENDED HI PVT                                  66 MB
        Curr high addr 24bit private                          0003C000
        Curr high addr 31 bit private                         2CE35000
        31-bit storage reserved for must complete                  141 MB
        31-bit storage reserved for MVS                             11 MB
        Strg cushion warning contract                              141 MB
        Total 31-bit getmained stack                                14 MB
        Total 31-bit stack in use                                   13 MB
        Total 31-bit variable pool storage                          16 MB
        Total 31-bit fixed pool storage                              0 MB
        Total 31-bit getmained storage                               5 MB
        Amount of available 31-bit storage                        1273
        Total 64-bit private variable pool storage                  49 MB
        Total 64-bit private fixed pool storage                     68 MB
        Total 64-bit private getmained storage                     309 MB
        Total 64-bit private storage for storage mgr ctrl-st         7 MB
        Number of real 4K frames in use for 31,64 bit private    66593
        Number of Aux(4K) FRAMES in use for 31,64 bit private   246964
        # of 4K frames in use for 64 bit private(Z11)            50828
        # of 4K aux slots in use for 64 bit private(Z11)        227813
        High Water Mark for number of Real4K fames,64bitPrv     170352
        High Water Mark Aux slots 64BIT PRIV                    227813

 .   Storage Statistics                                        Quantity
     ----------------------------                            ------------
     Address Space name                                       DIST
        MVS extended Region size                                  1407 MB
        MVS 24 BIT LOW PRIVATE                                       0 MB
        MVS 24 BIT HIGH PRIVATE                                      0 MB
        MVS 31-bit extended low private                              5 MB
        MVS 31 BIT EXTENDED HI PVT                                  13 MB
        Curr high addr 24bit private                          00042000
        Curr high addr 31 bit private                         2861C000
        31-bit storage reserved for must complete                  141 MB
        31-bit storage reserved for MVS                             12 MB
        Strg cushion warning contract                              141 MB
        Total 31-bit getmained stack                                 1 MB
        Total 31-bit stack in use                                    1 MB
        Total 31-bit variable pool storage                           0 MB
        Total 31-bit fixed pool storage                              0 MB
        Total 31-bit getmained storage                               0 MB
        Amount of available 31-bit storage                        1389
        Total 64-bit private variable pool storage                   0 MB
        Total 64-bit private fixed pool storage                      0 MB
        Total 64-bit private getmained storage                       0 MB
        Total 64-bit private storage for storage mgr ctrl-st         1 MB
        Number of real 4K frames in use for 31,64 bit private      327
        Number of Aux(4K) FRAMES in use for 31,64 bit private     1749
        # of 4K frames in use for 64 bit private(Z11)               10
1                       BSTATSTX: VIRT STORAGE STATUS REPORT V10                         11/18/10 15:54:12    PAGE     2

     DB2 SSID: DEFF 10.1
   13:35:00
        # of 4K aux slots in use for 64 bit private(Z11)           299
        High Water Mark for number of Real4K fames,64bitPrv        299
        High Water Mark Aux slots 64BIT PRIV                       299

 .   Thread Information

       Number of active threads                                     16
       Number of active and disconnected DBATS                       0
       Number of Castout Engines                                     0
       Number of Deferred Write Engines                            300
       Number of GBP Write Engines                                   0
       Number of Prefetch Engines                                  341
       Number of P-lock/notify exit engine                           0

 .   Shared and Common Storage summary

       MVS Extended CSA size                                       500 MB
       Total 31-bit common fixed pool Storage                        3 MB
       Total 31-bit variable pool Storage                            1 MB
       Total 31-bit common getmained storage                         0 MB
       Total 64-bit common fixed pool Storage                        4 MB
       Total 64-bit variable pool Storage                           12 MB
       Total 64-bit common getmained storage                         0 MB
       Total 64-bit common storage for stor mgr control strc         1 MB
       Total 64-bit shared variable pool storage                   309 MB
       Total 64-bit shared fixed    pool storage                     4 MB
       Total 64-bit shared getmained     storage                     4 MB
       Total 64-bit shared storage for stor mgr control strc        13 MB
       Total 64-bit shared system agent stack                      256 MB
       Total 64-bit shared system agent stack in use               185 MB
       Total 64-bit shared non-system agent stack                  768 MB
       Total 64-bit shared non-system agent stack in use             8 MB
       Number of Shared Memory objects on this LPAR                 28
       Number of Shared Memory pages   on this LPAR            704643K
       High Water Mark of 64bit shared bytes on LPAR          3161097M
       Number if 64bit shared pages backed in real strg          85218
       Number of aux slots used for 64bit shred strg LPAR       127119
       Number of 64bit Shared pages paged in aux strg           119531
       Number of 64bit Shared pages paged out aux strg          178783

 .  Statement Cache and XPROC Detail

      Total 31-bit xPROC for Dyn SQl active threads                  0 MB
      Alloc 31-bit XProc strg for Dyn SQl active thds                0 MB
      Total 31-bit XPROC strg for static SQL stmts                   1 MB
      HWM # of Stmt in 64bit agnt local pools                        0
      Number of statements 64bit agent local pools                   0
      HWM of # Stmt in 64bit  agent local pool at high Strg          0
      Allocated statement cache strg in 64 bit agent local           0 MB
      HWM Alloc stmt cache strg 64 bit local pools                   0 MB
      Time Stamp of HWM for Stor alloc in 64 bit Pools        13:35:10
      Total 64 bit STMT Cache blks 2G Storage                      216 MB

1                       BSTATSTX: VIRT STORAGE STATUS REPORT V10                         11/18/10 15:54:12    PAGE     3

     DB2 SSID: DEFF 10.1
   13:35:00
 .  Pool Details

      Total agent local storage(31-bit DBM1 prv var)                 9 MB
      Total system local storage(31-bit DBM1 prv var)                8 MB
      Total agent local storage(64-bit DBM1 prv var)                92 MB
      Total system local storage(64-bit DBM1 prv var)               65 MB
      Total buffer-mgr  storage(31-bit DBM1 prv var)                 1 MB
      Total RID pool storage                                         1 MB
      Total compression dictionary storage                           1 MB