Database Allocations
This panel provides allocation information for all spacenames owned by a particular database.
OMEGAMON® XE for Db2 PE will sort on that column.
________________ ZOJA1 VTM O2 V540.#P SE12 11/05/13 17:52:15 2
> Help PF1 Back PF3 Up PF7 Down PF8 Sort PF10 Zoom PF11
>
> OBJECT ANALYSIS: Enter a selection letter on the top line.
>
> *-DATABASE ALLOCS B-DATABASE ACTIVITY C-DISPLAY OPTIONS
===============================================================================
> DATABASE ALLOCATIONS
OJA1
+ Database = DSNDB01 Total Spaces = 16 Total Datasets = 16
+ *
+ Spacenam Type BP Vols DSNs Exts Exts/DSN Max Exts
+ -------- ---- ---- ---- ---- ---- -------- --------
+ DBD01 TSPG 0 1 1 1 1.0 1
+ DSNDB01X INDX 0 1 1 1 1.0 1
+ DSNDB1XA INDX 0 1 1 1 1.0 1
+ DSNLLX01 INDX 0 1 1 1 1.0 1
+ DSNLLX02 INDX 0 1 1 1 1.0 1
+ DSNSCT02 INDX 0 1 1 1 1.0 1
+ DSNSPDXA INDX 0 1 1 1 1.0 1
+ DSNSPEXA INDX 0 1 1 2 2.0 2
+ DSNSPT01 INDX 0 1 1 2 2.0 2
+ DSNSPT02 INDX 0 1 1 2 2.0 2
+ SCT02 TBLS 0 1 1 1 1.0 1
+ SPT01 TSPG 32K 6 1 21 21.0 21
+ SYSDBDXA LBTS 0 1 1 2 2.0 2
+ SYSLGRNX TSPG 0 1 1 1 1.0 1
+ SYSSPUXA LBTS 0 2 1 9 9.0 9
+ SYSSPUXB LBTS 0 4 1 16 16.0 16
=============================================================================== Navigation
For additional
information about
- a particular space, move the cursor to the spacename line and press F11 (Zoom). For more information, see the description of panel Spacename Allocations.
- related display options, select option C-Display Options. For more information, see the description of panel Display Options For Database Allocations And Database Activity Displays.
- 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 spacenames in the display.
- Total Spaces
- The number of spaces in this database.
- Total Datasets
- The number of data sets in this database.
- Spacename
- The name of a space that is owned by the database and allocated to Db2.
- 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.
- BP
- The identifier of the buffer pool in use by the spacename.
- Vols
- The number of volumes in use by the spacename.
- DSNs
- The number of data sets that are allocated for the spacename.
- Exts
- The number of data set extents allocated by the data sets.
- Exts/DSN
- The average number of extents per data set for the spacename.
- Max Exts
- The largest number of extents per data set for the spacename.