Object Allocation Summary

This panel shows allocation-related information at the database level.

It displays only databases that contain spaces that are currently allocated to the Db2 subsystem being monitored (if a database is stopped it will not be displayed in the panel).

You can use the default settings of the Object Allocation Summary, or you can limit the data that is displayed by modifying the Display options.

________________ ZOJAS    VTM     O2       V550.#P SE12 11/05/13 17:50:21   2 
> Help PF1      Back PF3      Up PF7      Down PF8     Sort PF10     Zoom PF11 
> O.A                                                                          
>       OBJECT ANALYSIS:  Enter a selection letter on the top line.            
>                                                                              
> *-OBJECT ALLOCATIONS         B-OBJECT ACTIVITY            C-VOLUME ACTIVITY  
> D-EXTEND ACTIVITY            E-DISPLAY OPTIONS            F-COLLECTOR CONTROL
===============================================================================
>                          OBJECT ALLOCATION SUMMARY                           
 OJAS                                                                          
+ Total Databases = 13       Total Spaces = 310         Total Datasets = 271   
+ *                                                                            
+ Database   Spaces   Tblsp    Indxs    DSNs    Extents   Exts/DSN    Max Exts 
+ --------   ------   ------   ------   ------  -------   --------    -------- 
+ DATBA8K         4        4        0        4        4        1.0           1 
+ DSNDB01        16        7        9       16       63        3.9          21 
+ DSNDB06       266       79      187      232      273        1.1           8 
+ DSN00182        2        0        0        0        0         .0           0 
+ DSN00183        1        0        0        0        0         .0           0 
+ DSN00184        1        0        0        0        0         .0           0 
+ DSN00185        1        0        0        0        0         .0           0 
+ DSN00186        1        0        0        0        0         .0           0 
+ DSN00187        2        0        0        0        0         .0           0 
+ DSN8D11A        4        2        2        9        9        1.0           1 
+ DSN8D11P        4        1        3        4        4        1.0           1 
+ DSQDBCTL        7        4        3        5        5        1.0           1 
+ WRKSE12         1        1        0        1        1        1.0           1 
===============================================================================

If you move the cursor to any entry in a column and press F10, OMEGAMONĀ® for Db2 PE will sort on that column.

Navigation

For additional information about
  • a particular database, move the cursor to the database line and press F11 (Zoom). For more information, see the description of panel Database Allocations.
  • related topics, select one of the options on the top of the panel.
  • other topics, use the PF keys.

Fields

Total Databases
The number of databases that are allocated to the monitored Db2.
Total Spaces
The number of spaces that are allocated to the monitored Db2.
Total Datasets
The number of data sets that are allocated to the monitored Db2.
Database
The name of a database.
Spaces
The number of spaces owned by the database and currently allocated to Db2.
Tblsp
The number of spaces that are tablespaces currently allocated to Db2.
Indxs
The number of spaces that are indexspaces currently allocated to Db2.
DSNs
The number of data sets that are allocated for the spaces owned by the database.
Extents
The number of data set extents allocated by the data sets.
Exts/DSN
The average number of extents per data set for the database.
Max Exts
The largest number of extents per data set for the database.