Previous Topic: When to UseNext Topic: Full Directory Report


How to Use

You can execute this command in either Single User or Multi-User mode. Use the following control statement to request this report:

                     ┌──────────────────┐
►►─ REPORT AREA=CXX ─▼─┬──────────────┬─┴─┬───────────────┬───────────────────►◄
                       └─ ,DBID=nnnn ─┘   └─┬─ ,TYPE=A ─┬─┘
                                            ├─ ,TYPE=B ─┤
                                            └─ ,TYPE=I ─┘

Command

REPORT

Invokes the function to produce a report.

Required Keywords

AREA=CXX

Requests the Directory Report.

Optional Keywords

,DBID=

DBID= is optional and may repeat. Each occurrence may specify one valid database ID or a range of DBIDs nnnn-mmmm (a range, for example, such as 100-250).

If DBID= is not specified, all databases are processed. That is, if a report is done without a DBID, the first page of the CXX report (not TYPE=A) has information about the full CXX.

If you use TYPE=I, you must also use a DBID= specification, that is, either one or more than one DBID, or a range of DBIDs. For TYPE=I the valid DBID specifications are from 1 through 5000.

Every database specified by a DBID keyword is processed. Each database that is not defined generates an error and fails the function after all the databases are processed, except that a database in a range not defined is ignored.

Valid Entries:

One or more valid database IDs or a range of DBIDs as already described.

Default Value:

Omission of this keyword generates a report for all databases identified in the Directory.

,TYPE=A

Specifies the Space Utilization Report be generated. Omitting this parameter produces a full Directory report. For more information on the TYPE=A report, see Type A - Directory Space Utilization.

,TYPE=B

Specifies a full report without key, element, and special fields. For more information on the TYPE=B report, see Type B - CXX Report.

,TYPE=I

Specifies the Impact Report be generated. Omitting this parameter produces a full Directory report. For more information on the TYPE=I report, see Type I - Impact Report.