Data Set List by database name report
The Data Set List by database name report lists the tracks used, extents, allocated units, primary quantity, secondary quantity, and volume for each data set that is in the specified database.
The report, as shown in the following figure, also shows the total tracks for table spaces, total tracks for indexes, and total tracks used in the database.
Data Set List by database name report
DASD MANAGER PLUS FOR DB2 vv.rr.mm - ASUZDSLI
Time . . . . . . . . : 01:14:05 dd mmm yyyy
DB2 ID . . . . . . . : DEMO
DB2 Version . . . . . : vvrr
Current Function Level: VvvRrMmmm Catalog Level . . . . .: VvvRrMmmm
Highest Active Level : VvvRrMmmm Previous Function Level: VvvRrMmmm
SPE Level . . . . . . :
User . . . . . . . . : MVSTYG
Database Name: AZUDAN
Data Set Name Trks Ext AU Pqty Sqty Volume
--------------------------------------------------------------------------------
DEMOCAT.DSNDBC.AZUDAN.AZUS02AN.I0001.A001 31 2 T 1 15 EMC37A
DEMOCAT.DSNDBC.AZUDAN.AZUS04AN.I0001.A001 30 1 C 2 1 EMC347
DEMOCAT.DSNDBC.AZUDAN.AZUS04AN.I0001.A002 30 1 C 2 1 EMC434
DEMOCAT.DSNDBC.AZUDAN.AZUS04AN.I0001.A003 30 1 C 2 1 EMC484
DEMOCAT.DSNDBC.AZUDAN.AZUS04AN.I0001.A004 30 1 C 2 1 EMC35C
*** Total Tracks for Tablespaces *** 151
DEMOCAT.DSNDBC.AZUDAN.AZUX01RD.I0001.A001 1 1 T 1 15 EMC366
DEMOCAT.DSNDBC.AZUDAN.AZUX1HMF.I0001.A001 30 1 C 2 1 EMC384
DEMOCAT.DSNDBC.AZUDAN.AZUX1HMF.I0001.A002 30 1 C 2 1 EMC424
DEMOCAT.DSNDBC.AZUDAN.AZUX1HMF.I0001.A003 1 1 T 1 15 EMC35D
DEMOCAT.DSNDBC.AZUDAN.AZUX1HMF.I0001.A004 30 1 C 2 1 EMC432
*** Total Tracks for Indexes *** 92
*** Total Tracks for Database *** 243
The Data Set List by database name report contains the following fields:
Field | Description |
|---|---|
Database Name | Name of the specified database |
Data Set Name | Name of each data set in the database |
Trks | Number of tracks used by the data set |
Ext | Number of extents on the data set |
AU | Allocation unit for the data set (T – tracks or C – cylinders) |
Pqty | Primary quantity allocated to the data set |
Sqty | Secondary quantity allocated to the data set |
Volume | Volume where the data set resides |
The Data Set List by database name report requires the following line of input parameters: