REPORT (Generate Reports) › Index Area (IXX) Reports › How to Use

How to Use

You can execute this command in either Single User or Multi-User mode. To generate an Index Area (IXX) Report, execute the REPORT function with the following command format:

                     ┌─ , ──────────┐
►►─ REPORT AREA=IXX ─▼─ ,DBID=nnnn ─┴─────────────────────────────────────────►

 ►─┬─ ,TYPE=A ───────────────────────────┬────────────────────────────────────►◄
   ├─ ,TYPE=B ───────────────────────────┤
   └─ ,TYPE=G ─┬───────────────────────┬─┘
               └─ ,UPDATE= ─┬─ NO ◄ ─┬─┘
                            └─ YES ──┘
►►─ REPORT AREA=IXX,DBID=nnnn ─┬─ ,TYPE=D,KEYID=n ─┬─┬───────────────┬────────►◄
                               └─ ,TYPE=E,KEYID=n ─┘ └─ IXXAREA=aaa ─┘

Command

REPORT

Invokes the function to produce a report.

Required Keywords

AREA=IXX

Requests the Index Area Report.

DBID=

Identifies the database to be reported.

For Types A, B, and G, DBID= may repeat, in which case each occurrence may specify one or more valid database IDs or a range of DBIDs nnnn-mmmm (a range, for example, such as 100-250).

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:

For Types A, B, and G, one or more valid database IDs or a range of DBIDs as already described.

For Types D and E, the DATACOM-ID of the database

Default Value:

(No default)

,TYPE=

Specifies the type of Index Report to be generated.

A

Specifies a sequence by table name.

B

Specifies a sequence by key ID.

D

Specifies a full dump of the Index Area (IXX).

E

Specifies a dump of the high-level portion of the Index Area (IXX).

G

Specifies a report of the number of records with unique key values.

Valid Entries:

A, B, D, E, G

Default Value:

(No default)

,KEYID=n

For TYPE=D,KEYID=n, the n identifies the specific key with which the dump of the Index Area is to be associated.

For TYPE=E,KEYID=n, the n identifies the specific key with which the dump of the high-level portion of the Index Area is to be associated.

Note: Use TYPE=D and TYPE=E only at the request of Technical Support.

Valid Entries:

DATACOM-ID of the key

Default Value:

(No default)

Optional Keywords

,UPDATE=

For type G, requests that the entire Index be read to generate current statistics. The report executes in the Multi-User Facility and can occur while any other other Multi-User Facility activity is occurring to this database, including update activity.

Valid Entries:

NO or YES

Default Value:

NO

IXXAREA=aaa

IXXAREA= is for types D and E only. For a database that has only the IXX Index Area, the keyword is optional, but if set it must specify IXXAREA=IXX. For a database that has Multi-Dataset Index areas, the keyword is required and must provide the name of one of the index areas (IXX or Inn, where nn can be 00 to 99).

Valid Entries:

IXX or I00 to I99

Default Value:

(No default)