Selecting databases in a storage group

You can select a data base in a storage group and move all the data sets from the database, or drill down to view specific data sets.

The DSM Stogroup DB Summary panel, shown in the following figure, lists the databases in the selected storage group. You can select a database to move all data sets associated with the database, or you can drill down to select specific data sets or index space data sets.

Figure 1. DSM Stogroup DB Summary panel

 AUTOTOOL V4R3   -------  DSM Stogroup DB Summary  ------  2011/08/30  15:13:01 
 Option  ===>                                                  Scroll ===> CSR  
 Line Commands: S - View Spacenames  Q - Add to MoveQ  D - Del from MoveQ       
 -------------------------------------------------------------------------    > 
 SSID: SS1A             Stogroup: SGAINLAB >                                    
 -------------------------------------------------------------------------------
 Cmd  DBname   Creator   TSct  ISct DSNct AvgExt MaxExt SpcUse SpaceUse SpaceAlc
      DBAINLAB CSKUAN       3     2     5             0   0.0%       0K       0K
 ***************************** Bottom of Data **********************************
                                                                                
 PF4 View MoveQ   PF17 Prev STG   PF18 Next STG   PF19 First STG   PF20 Last STG

The following section describes the fields on the DSM Stogroup DB Summary panel.

SSID: The Db2 subsystem ID.
Stogroup: This header field shows the storage group name you selected on the previous panel.
DBname: The name of the database. If one or more data sets in the database are in the move queue, this field is highlighted. If all data sets in the database are in the move queue, an asterisk (*) appears next to the database name. If some of the data sets in the database are in the move queue, a plus sign (+) appears next to the database name.
Creator: The user ID of the database creator. If all data sets in the database are in the move queue, this field is highlighted.
TSct: The number of table spaces in the database.
ISct: The number of index spaces in the database.
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 database.
SpcUse: The percentage of space allocated that is currently used by data sets owned by the database. The value is derived by totaling all space used for all data sets within the database and dividing it by all space allocated for the database. 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 database, in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T).
SpaceAlc: The amount of space allocated by all the data sets in the database, 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
DBid: The database identifier.

The line commands that can be used on DSM Stogroup DB Summary panel are described in the following table:

Table 1. DSM Stogroup DB Summary panel line commands
Line command	Description
S	View the spaces in the database.
Q	Add the database to the move queue; all data sets associated with the database will be selected. After you add a database 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 of the database data sets from the data set move queue. This command may be used on multiple lines on the panel.