Default language.

Virtual storage status report (BSTATSTM)


The following figure shows a sample of the Virtual storage status report (BSTATSTM).

The individual sections and field descriptions of this report are listed under Statistics-report-fields.

Related topic

1                       BSTATSTM: VIRTUAL STORAGE STATUS REPORT                          05/05/16 15:58:43    PAGE     1

     DB2 SSID: CM03 11.1
 +   LOCATION: CM03
 .
     DBM1 STORAGE STATISTICS (MB)                             QUANTITY
     ----------------------------                            ------------
     INTERVAL  : 16:00:00
     DBM1 STORAGE SUMMARY BELOW 2 GB
      STORAGE AVAILABLE TO DBM1                                1078.72 MB

      MAXIMUM NUMBER OF THREADS POSSIBLE                           N/P

      AVERAGE THREAD FOOTPRINT                                    0.00 MB
      TOTAL NUMBER OF ACTIVE USER THREADS                            0
      TOTAL STORAGE FOR ALL THREADS                               0.73 MB

      TOTAL DBM1 STORAGE                                          0.83 MB
         TOTAL GETMAINED STORAGE                                  0.00 MB
           COMPRESSION DICTIONARY STORAGE                         0.00 MB
         TOTAL VARIABLE STORAGE                                   0.01 MB
           TOTAL AGENT SYSTEM STORAGE                             0.00 MB
           TOTAL AGENT LOCAL STORAGE                              0.00 MB
           RDS OPERATION STORAGE                                  0.00 MB
           RID POOL CURRENT STORAGE                               0.00 MB
           PIPE MANAGER STORAGE                                   0.00 MB
           LOCAL DYNAMIC STMT CACHE CNTL BLKS                     0.00 MB
           LOCAL DYNAMIC STMT CACHE STMT POOL                     0.00 MB
           BUFFER AND DATA MANAGER TRC TABLE                      0.00 MB
        TOTAL FIXED STORAGE                                       0.08 MB
        TOTAL GETMAINED STACK STORAGE                             0.73 MB

      STORAGE CUSHION                                           218.89 MB

     NUMBER OF PREFETCH ENGINES                                    N/P
     NUMBER OF DEFERRED WRITE ENGINES                              N/P
     NUMBER OF CASTOUT ENGINES                                     N/P
     NUMBER OF GBP WRITE ENGINES                                   N/P
     NUMBER OF P-LOCK/NOTIFY EXIT ENGINES                          N/P

     NUMBER OF REAL (4K) PAGES                                     239
     NUMBER OF AUX (4K) PAGES                                        0

     HWM FOR MAX CONCURENTLY ALLOCATED ALLIED THREADS                1
     TOTAL NUMBER OF ACIVE DBAT'S                                    0
     HWM FOR MAX NUMBER OF ACTIVE DBATS                              0

     NUMBER OF CACHED SQL STATEMENTS POOL                          N/P
     TOTAL STATEMENT CACHE STORAGE                                0.00 MB
     ALLOCATED STORAGE FOR CACHED STMTS                           0.00 MB
     HWM FOR ALLOCATED CACHED STATEMENT STORAGE                   0.00 MB
     HWM NUMBER OF COPIES IN CACHE                                 N/P
     DATE OF HWM                                                   N/P
     TIME OF HWM                                                   N/P

     STORAGE RESERVED TO ALLOW DB2 TO COMPLETE CRIT FUNCTION   229520K

     TOTAL NUMBER OF THREADS                                         0


1                       BSTATSTM: VIRTUAL STORAGE STATUS REPORT                          05/05/16 15:58:43    PAGE     2

     DB2 SSID: CM03 11.1

    TOTAL MVS STORAGE BELOW 2GB
     24 BIT LOW PRIVATE                                           0.07 MB
     24 BIT HIGH PRIVATE                                          0.24 MB
     31 BIT EXTENDED LOW PRIVATE                                  4.05 MB
     31 BIT EXTENDED HIGH PRIVATE                                10.40 MB
     EXTENDED REGION SIZE (MAX)                                1093.00 MB
     EXTENDED CSA SIZE                                            0.00 MB


     DBM1 STORAGE ABOVE 2 GB
      TOTAL FIXED STORAGE                                         0.00 MB
      TOTAL GETMAINED STORAGE                                     0.00 MB
            COMPRESSION DICTIONARY                                 N/A MB
            IN USE EDM DBD POOL                                      0 MB
            IN USE EDM STATEMENT POOL                                0 MB
            IN USE EDM SKELETON  POOL                             0.04 MB
       SHARED MEMORY STORAGE                                         0 MB
         TOTAL FIXED VIRTUAL 64 BIT SHARED                        0.00 MB
         TOTAL GETMAINED VIRT 64 BIT SHARED                       0.00 MB
         TOTAL VARIABLE VIRTUAL 64 BIT SHARED                     0.00 MB
      TOTAL VARIABLE STORAGE                                      0.02 MB
         TOTAL STATEMENT CACHE STORAGE                               0 MB
         ALLOCATED STORAGE FOR CACHED STATEMENTS                     0 MB
         HWM FOR ALLOCATED CACHED STATEMENT STORAGE                  0 MB
      TOTAL SJ OP POOL STORAGE                                    0.00 MB

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1