Reporting table space information
Use the Table Space Report window to get information about one or more table spaces. You can use the report to find the names of all the table spaces and tables in a referential structure. You can also use the report in planning for recovery since it provides information necessary for
recovering a table space. You can request report information for LOCALSITE or RECOVERYSITE,
or both. The report that is produced denotes entries added by non-COPY utilities in the SYSIBM.SYSCOPY catalog table with asterisks. The report can also be used on the DB2 catalog and directory table spaces.
Authorities
and privileges
To obtain a report on a table space:
- Open the Table Space Report window.
- Specify the Find all tablespaces in a referential structure radio button if you want to find all table spaces in a referential structure.
- Instead of reporting on table spaces in a referential structure, you can specify the Get recovery information for the tablespace radio button to get table space information that will help at table space recovery time.
- If you selected the Get recovery information for the table space radio button, then specify a radio button under Data set selected or for partitioned table spaces only, Partition selected to include all data set or partition information or information on only a particular data set or partition.
- Optional: If you selected the Get recovery information for the table space radio button,
specify one or more of the following options:
-
Start the report from the last recoverable point
- Get a summary of the volume serial numbers (for data sets) or partitions
(for partitioned table spaces)
- Use catalog table SYSIBM.SYSCOPY records from a local site
- Use catalog table SYSIBM.SYSCOPY records from a recovery site
-
Click OK to begin the report processing.
Related information