REPORT

The REPORT utility provides information about table spaces, tables, and indexes. You can use REPORT to find the names of related table spaces, such as referentially related table spaces and LOB table spaces. You can also use REPORT to find information that is necessary for recovery.

Output

The output from REPORT with the TABLESPACESET option consists of the names of all table spaces in the table space set that you specify. It also lists all tables in the table spaces and all tables that are dependent on those tables.

The output from REPORT with the RECOVERY option consists of the following items:

  • The recovery history from the SYSIBM.SYSCOPY catalog table
  • Log ranges from the SYSIBM.SYSLGRNX directory table
  • Volume serial numbers where archive log data sets from the BSDS exist.
  • Information about any indexes on the table space that are in the informational COPY-pending (ICOPY) status (This information affects the recoverability of an index.)
  • Start of changeInformation about any system-level backup copies that you can use for recovery if the BACKUP SYSTEM utility is used on your system

    If you use system-level backup copies as the base for object-level recoveries of individual table spaces or index spaces, the REPORT output also lists the system-level backup copies. These copies are listed in the SYSCOPY ROWS AND SYSTEM-LEVEL BACKUPS section of the report.

    End of change

If REPORT TABLESPACESET or REPORT RECOVERY is specified and the base objects have been cloned, information for both base and clone objects are included in the output.

In a data sharing environment, the REPORT output provides:

  • The RBA of when DB2® was migrated to DB2 10
  • The high and low RBA values of the migrated member
  • A list of any SYSLGRNX records from before data sharing was enabled that cannot be used to recover to any point in time after data sharing was enabled
  • For SYSCOPY, the member from which the image copy was deleted
  • Start of changeInformation about system-level backup copies that are retrieved from the bootstrap data sets of each member in the data sharing groupEnd of change
  • Start of changeThe status of deactivated members, and of destroyed members whose member IDs have not been reclaimedEnd of change

Authorization required:

To execute this utility, you must use a privilege set that includes one of the following authorities:

  • RECOVERDB privilege for the database
  • DBADM or DBCTRL authority for the database. If the object on which the utility operates is in an implicitly created database, DBADM authority on the implicitly created database or DSNDB04 is required.
  • Start of changeSystem DBADM authorityEnd of change
  • Start of changeDATAACCESS authorityEnd of change
  • SYSCTRL or SYSADM authority

Any of the following IDs can run the REPORT utility on any table space in DSNDB01 (the directory) or DSNDB06 (the catalog)

  • An ID with DBCTRL or DBADM authority over database DSNDB06
  • Any ID with installation SYSOPR, SYSCTRL, or SYSADM authority.

Execution phases of REPORT

The REPORT utility operates in these phases:

Phase
Description
UTILINIT
Performs initialization
REPORT
Collects information
UTILTERM
Performs cleanup