There are situations when a Tablespace Space Detail report can list a subset of datasets that the tablespace has.
4. Reports - Generate
3 - Space Allocation Reports
1 - Tablespace Space Detail
While a list of datasets for a tablespace might show 4 datasets, the Space Detailed report will only show 2.
DEJM-R --------------------------------------------------- DATASET LIST ---
Command ===>
CMD will show commands for this list. Type command and press ENTER
Lists: ?
QUALIFIER: TABLESPACE=QZUDCT.QZUS03CT
Cmd DSNAME VOLUME
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v--
DEJMCAT.DSNDBD.QZUDCT.QZUS03CT.I0001.A001 PLU009
DEJMCAT.DSNDBD.QZUDCT.QZUS03CT.I0001.A002 PLU054
DEJMCAT.DSNDBD.QZUDCT.QZUS03CT.I0002.A001 PLU093
DEJMCAT.DSNDBD.QZUDCT.QZUS03CT.I0002.A002 PLU038
***************************************************** BOTTOM OF DATA
Tablespace Space Detail (DB2 Catalog) MORE DATA ==>
Data set numbers reflect totals of all volumes and extents
Volume name followed by a '+' sign indicates the data set exists on more than one volume
DSN=DEJMCAT.DSNDBD.QZUDCT.QZUS03CT.I0001.A001 | OBJECT NAME:QZUDCT.QZUS03CT
VOLSER........ PLU009 TRACKS ALLOC.. 21855 | OBJECT TYPE:Tablespace PRIMARY...... 125000 COMPRESS... N
DEVTYPE....... 3390 TRACKS USED... 21846 | PART....... 1 SECONDARY.... 32767 SEGSIZE.... 4
EXTENTS....... 2 ALLOC UNIT.... Cyls | CARD....... 0 FREEPAGE..... 3 DSNUM ..... 1
KBYTES ALLOC.. 1049040 PRIM ALLOC.... 695 | PAGE SIZE.. 4 PERCENT FREE 75 DSSIZE .... 1G
KBYTES USED... 1048572 SEC ALLOC..... 278 | TS TYPE.... G-A LOB........ N MEMBER CLUSTER N
| STORNAME...QZUSGALL
DSN=DEJMCAT.DSNDBD.QZUDCT.QZUS03CT.I0001.A002 | OBJECT NAME:QZUDCT.QZUS03CT
VOLSER........ PLU054 TRACKS ALLOC.. 10425 | OBJECT TYPE:Tablespace PRIMARY...... 125000 COMPRESS... N
DEVTYPE....... 3390 TRACKS USED... 8185 | PART....... 2 SECONDARY.... 32767 SEGSIZE.... 4
EXTENTS....... 1 ALLOC UNIT.... Cyls | CARD....... 0 FREEPAGE..... 3 DSNUM ..... 1
KBYTES ALLOC.. 500400 PRIM ALLOC.... 695 | PAGE SIZE.. 4 PERCENT FREE 75 DSSIZE .... 1G
KBYTES USED... 392876 SEC ALLOC..... 278 | TS TYPE.... G-A LOB........ N MEMBER CLUSTER N
| STORNAME...QZUSGALL
********************************************************* Bottom of Data ***********************************************
This difference can occur if the tablespace contains a cloned table.
Run an SQL query against the tablespace:
SELECT
INSTANCE,
"CLONE"
FROM "SYSIBM".SYSTABLESPACE
WHERE DBNAME = 'QZUDCT'
AND NAME = 'QZUS03CT'
---------+---------+
INSTANCE CLONE
---------+----
2 Y
If the CLONE column is found to be 'Y', the tablespace actually has an additional clone table.
The Space Detailed report will only list the datasets for the primary table, not the clone table.