Spacename Allocations

This panel provides allocation-related information at the spacename level.

It displays only data sets that are currently allocated to Db2 and are owned by the spacename displayed.


________________ ZOJA2    VTM     O2       V540.#P SE12 11/05/13 17:52:34   2 
> Help PF1      Back PF3      Up PF7      Down PF8     Sort PF10     Zoom PF11 
>                                                                              
>       OBJECT ANALYSIS:  Enter a selection letter on the top line.            
>                                                                              
> *-SPACENAME ALLOCS                                      B-SPACENAME ACTIVITY 
===============================================================================
>                            SPACENAME ALLOCATIONS                             
 OJA2                                                                          
+ Database = DSNDB01         Spacename = SPT01         Type = PART BY GROWTH TS
+ Datasets = 1               Volumes   = 6             Exts = 21               
+ Space    = 5910 Trks                                                         
+ *                                                                            
+                             High         High       %                        
+ DSN       Vols     Exts     Fmt Pg       Alloc Pg   In Use      Dataset Space
+ ----      ----     ----     --------     --------   ------      -------------
+  001         6       21       0021DB       0021DB   100.0%          5910 Trks
===============================================================================

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

Navigation

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

Fields

Database
The name of the database that owns the spacename.
Spacename
The name of the space about which information is displayed.
Type
The spacename type. Possible values:
INDX
An index
IXCL
A clone of an index
LBTS
A LOB tablespace
PTIX
A partitioned index
PTTS
A partitioned tablespace
SEGM
A segmented tablespace
TBLS
A simple tablespace
TSCL
A clone of an universal tablespace
TSPG
A partition by growth universal tablespace
TSPR
A partition by range universal tablespace
XMTS
An XML tablespace
UNDT
Undetermined

This can occur if the database DBD is currently not loaded in the EDM pool.

Datasets
The number of data sets in use by the spacename.
Volumes
The number of volumes in use by the data set.
Exts
The number of data set extents allocated by all data sets in use by the spacename.
Space
The total amount of space allocated by the spacename.
DSN
The sequence number of the data set.
Vols
The number of volumes that the data set resides on.
Exts
The number of extents allocated by the data set.
High Fmt Pg
The highest page number formatted in the data set. This value is displayed in hexadecimal.
High Alloc Pg
The highest page number allocated in the data set. This value is displayed in hexadecimal.
% In Use
The percentage of pages in use for the data set. This value is computed by dividing High Fmt Pg by High Alloc Pg.
Dataset Space
The total amount of space allocated by the data set. This value is expressed in tracks.