You can select a table space or index space to move all
the data sets from the space, or drill down to view specific data
sets to select.
The DSM Database Spacenames screen, shown in the following figure, lists the table spaces and index spaces for the selected database. You can select a space to move all data sets associated with the space, or you can drill down to select specific data sets or index space data sets. Figure 1. DSM Database Spacenames screen
AUTOXPRT V1R1 ------- DSM Database Spacenames ------- 2023/10/21 19:42:18
Option ===> Scroll ===> CSR
Line Commands: S - View Spacename Q - Add to MoveQ D - Del from Moveq
------------------------------------------------------------------------- >
SSID: SS1A Database: DBGPRI01 Creator: PDUSRAA >
-------------------------------------------------------------------------------
Cmd Spacenam Creator Type DSNct AvgExt MaxExt SpcUse SpaceUse SpaceAlc
TSDEPT PDUSRAA TS 1 0.0 0 0.0% 0K 0K
TSEMP PDUSRAA TS 1 0.0 0 0.0% 0K 0K
TSHIRE PDUSRAA TS 1 0.0 0 0.0% 0K 0K
DEPT PDUSRAA IS 1 0.0 0 0.0% 0K 0K
DEPTX PDUSRAA IS 1 0.0 0 0.0% 0K 0K
EMPX PDUSRAA IS 1 0.0 0 0.0% 0K 0K
SSRNUMBE PDUSRAA IS 1 0.0 0 0.0% 0K 0K
***************************** Bottom of Data **********************************
PF4 View MoveQ PF17 Prev DB PF18 Next DB PF19 First DB PF20 Last DB
The following section describes the fields on DSM Database
Spacenames screen.
SSID
The Db2 subsystem ID.
Database
The database name or mask you specified appears here. This field
is read only.
Creator
The database creator name or mask you specified appears here.
This field is read only.
Spacenam
The name of the space. If one or more data sets in the space are
in the move queue, this field is highlighted. If all data sets in
the space are in the move queue, an asterisk (*) appears next to the
space name. If some of the data sets in the space are in the move
queue, a plus sign (+) appears next to the space name.
Creator
The user ID of the creator of the space. If all data sets in the
space are in the move queue, this field is highlighted.
Type
The object type: TS for simple table space, PTTS for partitioned
table space, IS for index space, or PTIS for partitioned index space.
DSNct
The total number of data sets allocated for the space.
AvgExt
The average number of extents taken per data set.
MaxExt
The highest number of extents taken to date by a data set in the
space.
SpcUse
The percentage of space allocated that is currently used by data
sets owned by the index space. The value is derived by totaling all
space used for all data sets within the index space and dividing it
by all space allocated for the data sets. Space used is derived from
data set high used RBA. Space allocated is derived from data set high
allocated RBA.
SpaceUse
The amount of space in use by the data sets in the space, in kilobytes
(K), megabytes (M), gigabytes (G), or terabytes (T).
SpaceAlc
The amount of space allocated by all the data sets in the space,
in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T).
UsrDef
The number of user-managed data sets in the space.
StgDef
The number of Db2-managed data sets in the space
OBid
The data object identifier.
PSid
The page set ID.
The line commands that can be used on the DSM Database
Spacenames screen are described in the following table:
Table 1. DSM Database Spacenames
screen line commands
Line command
Description
S
View the data sets for the space.
Q
Add the space to the move queue; all data sets
associated with the space will be selected. After you add a space
to the move queue, enter QEDIT in the command line to view the list
of data sets to be moved.
D
Delete all the space's data sets from the
data set move queue. This command may be used on multiple lines on
the screen.