Selecting data sets from table spaces

Edit online

You can select a table space to move all the data sets from the space, or drill down to view specific data sets for the space.

About this task

To select data sets from the table space level, type 2 on the Specify Dataset Selection Type input line and press Enter. The Specify Tablespace Selection window appears.

The Specify Tablespace Selection window, shown in the following figure, lets you narrow the list of table spaces that appears on the next panel. Enter a table space name, table space creator, database name, or a combination of any of these fields. Selection criteria (*) are allowed.

Note: The Tablespace Creator field allows up to 128 bytes. To scroll this field, place the cursor in the field and use the PF11 key to scroll right and the PF10 key to scroll left.

Figure 1. Specify Tablespace Selection window

      Specify Tablespace Selection     
                                       
   Tablespace          *               
   Tablespace Creator  PDUSRA*  >     
   Database            *

When you press Enter, the panel shown in the following figure is displayed:

Figure 2. DSM Tablespaces panel

 AUTOXPRT V1R1   -----------  DSM Tablespaces  ----------  2023/10/21  19:49:06 
 Option  ===>                                                  Scroll ===> CSR  
 Line Commands: S - View Datasets  Q - Add to MoveQ               PF4 View MoveQ
                D - Del from MoveQ                                              
 -------------------------------------------------------------------------    > 
 SSID: SS1A            Tablespace: *              Creator: PDUSRA*  >           
 -------------------------------------------------------------------------------
 Cmd  TSname   Creator  DBname   Dsnct  AvgExt  MaxExt  SpcUse SpaceUse SpaceAlc
      CMP00102 PDUSRAA  PDUSRAX      1     0.0       0    0.0%       0K       0K
      CMP00502 PDUSRAA  PDUSRABP     1     0.0       0    0.0%       0K       0K
      DEPTREMP PDUSRAA  DSN01186     1     0.0       0    0.0%       0K       0K
      DEPTREXC PDUSRAA  DSN01185     1     0.0       0    0.0%       0K       0K
      EMPREXCP PDUSRAA  DSN01187     1     0.0       0    0.0%       0K       0K
      EXCPTS   PDUSRAA  EXCPDB       1     1.0       1  100.0%   576.0K   576.0K
      STMON41  PDUSRAA  DLCDB        1     1.0       1  100.0%   144.0K   144.0K
      TSDEPT   PDUSRAA  DBGPRI01     1     0.0       0    0.0%       0K       0K
      TSEMP    PDUSRAA  DBGPRI01     1     0.0       0    0.0%       0K       0K
      TSHIRE   PDUSRAA  DBGPRI01     1     0.0       0    0.0%       0K       0K
 ***************************** Bottom of Data **********************************

The DSM Tablespaces panel lists the table spaces that meet your selection criteria. On this panel, you can select a table space to move all data sets associated with the space, or you can drill down to select specific data sets.

The following section describes the fields on the DSM Tablespaces panel:

SSID: The Db2 subsystem ID.
Tablespace: The table space name or mask you specified appears here. This field is read only.
Creator: The table space creator name or mask you specified appears here. This field is read only.
TSname: The name of the table space. This field is highlighted if one or more data sets in the table space are in the move queue. If one or more data sets in the table space are in the move queue, this field is highlighted. If all data sets in the table space are in the move queue, an asterisk (*) appears next to the table space name. If some of the data sets in the table space are in the move queue, a plus sign (+) appears next to the table space name.
Creator: The user ID of the creator of the table space. If all data sets in the table space are in the move queue, this field is highlighted.
DBname: The database name that owns the table space.
DSNct: The total number of data sets allocated for the table space.
AvgExt: The average number of extents for a single data set owned by the table space.
MaxExt: The maximum number of extents for a single data set owned by the table space.
SpcUse: The percentage of space allocated that is currently used by data sets owned by the table space. The value is derived by totaling all space used for all data sets within the table 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 all data sets owned by the table space, in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T).
SpaceAlc: The amount of space allocated by all data sets owned by the table space, in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T).
UsrDef: The number of user-managed data sets in the database.
StgDef: The number of Db2-managed data sets in the database.
Type: The object type. TS is a simple table space. PTTS is a partitioned table space.
DBid: The database identifier of the data base owning the table space.
OBid: The table space object identifier.
PSid: The table space pageset object identifier.

The line commands that can be used on the DSM Tablespaces panel are shown in the following table:

Table 1. DSM Tablespaces panel line commands
Line command	Description
S	View the data sets owned by the selected table space.
Q	Add the table space to the move queue; all data sets associated with the table space will be selected. After you add a table space to the move queue, enter QEDIT in the command line (or press PF4) to view the list of data sets to be moved. This command may be used on multiple lines on the panel.
D	Delete all table space data sets in the data set move queue. This command may be used on multiple lines on the panel.