This topic explains how to select user-defined data sets
using the VCAT name.
About this task
To select user-defined Db2 data sets from a VCAT name, type 5 on the Specify Dataset Selection
Type input line and press Enter. The Specify User Defined Selection window appears.
The Specify User Defined Selection window, shown in the following figure, lets you narrow the list of VCAT names that appears on the next panel. Enter a VCAT group in the Using Vcat name field. Selection criteria (*) are allowed. Figure 1. Specify User Defined Selection window
Specify User Defined Selection
Using Vcat name D*
When you press Enter, the panel shown in the following
figure is displayed:
Figure 2. DSM User Defined Summary panel
AUTOXPRT V1R1 ------ DSM User Defined Summary ------ 2023/10/21 20:03:47
Option ===> Scroll ===> CSR
Line Commands: S - View Database PF4 View MoveQ
-------------------------------------------------------------------------
SSID: SS1A Using Vcat: D*
-------------------------------------------------------------------------------
Cmd Vcat DBct TSct ISct DSNct SpcUse SpaceUse SpaceAlc AvgExt MaxExt
SS1A 2 21 164 185 64.1% 606.0M 944.7M 1.6 6
***************************** Bottom of Data **********************************
The DSM User Defined Summary panel lists the VCATs that
meet your selection criteria. On this panel, you can select a VCAT
to view all the databases on the VCAT.
The following section
describes the fields on the DSM User Defined Summary panel.
SSID
The Db2 subsystem ID.
Using Vcat
This header field shows the VCAT name you entered on the previous
window.
Vcat
The volume catalog on which the user-defined data sets reside.
DBct
The number of databases with user-defined data sets using the
VCAT.
TSct
The number of table spaces with user-defined data sets using the
VCAT.
ISct
The number of index spaces with user-defined data sets using the
VCAT.
DSNct
The total number of data sets allocated for the databases on the
VCAT.
SpcUse
The percentage of space allocated that is currently used by user-defined
data sets using the VCAT. The value is derived by totaling all space
used for applicable data sets 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 user-defined data sets on the
VCAT, in kilobytes (K), megabytes (M), gigabytes (G), or terabytes
(T).
SpaceAlc
The amount of space allocated by user-defined data sets on the
VCAT, in kilobytes (K), megabytes (M), gigabytes (G), or terabytes
(T).
AvgExt
The average number of extents taken for a single user-defined
data set on the VCAT.
MaxExt
The maximum number of extents taken for a single user-defined
data set on the VCAT.
The line command that can be used on the DSM User
Defined Summary panel is described in the following table:
Table 1. DSM User Defined Summary
panel line command
Line command
Description
S
View the databases with user-defined data sets
on this VCAT.