Working with data sets for a selected space

Edit online

You can select specific data sets to move or view extents for a data set.

The DSM Spacename Datasets screen, shown in the following figure, lists all the data sets that make up the selected space. You can select one or more data sets to move, or you can drill down to see extent information for the data set.

Figure 1. DSM Spacename Datasets screen
 AUTOXPRT V1R1   --------  DSM Spacename Datasets -------  2023/10/21  19:44:53 
 Option  ===>                                                  Scroll ===> CSR  
 Line Commands: S - View Dataset  Q - Add to MoveQ  D - Del from MoveQ          
 -------------------------------------------------------------------------    > 
 SSID: SS1A             Database: DBGPRI01         Spacename: TSDEPT            
 -------------------------------------------------------------------------------
 Cmd  Dsn  Vcatname Stogroup Exts VLct Volume SpcUse SpaceUse SpaceAlc Qty  Pqty
      0001 SS1A     SYSDEFLT    0    0 MIGRAT   0.0%       0K       0K CYL    -1
 ***************************** Bottom of Data **********************************
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
 PF4 View MoveQ    PF17 Prev SP    PF18 Next SP    PF19 First SP    PF20 Last SP

The following section describes the fields on the DSM Spacename Datasets screen.

SSID
The Db2 subsystem ID.
Database
The database name or mask you specified appears here. This field is read only.
Spacename
The name of the space.
Dsn
The data set number. This field is highlighted and an asterisk (*) appears next to the Dsn if the data set is in the move queue.
Vcatname
The volume catalog name.
Stogroup
The storage group, if the data set is Db2-managed.
Exts
The number of extents that the data set has taken.
VLct
The number of volumes on which the data set resides.
Volume
The volume serial number on which the data set resides.
SpcUse
The percentage of space allocated that is currently used the data set. The value is derived by dividing space used by space allocated. Space used is obtained from data set high used RBA. Space allocated is obtained from data set high allocated RBA.
SpaceUse
The amount of space in use by the data set, in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T).
SpaceAlc
The amount of space allocated by the data set, in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T).
Qty
The unit of space allocation. TRK is tracks, CYL is cylinders.
Pqty
The primary space allocation amount, in the specified units.
Sqty
The secondary space allocation amount, in the specified units.
TrksAlc
The number of tracks allocated for the data set.
HURBA_Dec
The high used RBA for the data set, in decimal format.
HARBA_Dec
The high allocated RBA for the data set, in decimal format.
HURBA_Hex
The high used RBA for the data set, in hexadecimal format.
HARBA_Hex
The high allocated RBA for the data set, in hexadecimal format.

The line commands that can be used on the DSM Spacename Datasets screen are described in the following table:

Table 1. DSM Spacename Datasets screen line commands
Line command Description
S View data set extent information.
Q Add the data set to the move queue. After you add a data set to the move queue, enter QEDIT in the command line to view the list of data sets to be moved.
D Delete the data set from the data set move queue. This command may be used on multiple lines on the screen.