DSNU667I csect-name additional-information

Explanation

The REPAIR utility with the CATALOG option detected a mismatch between the information in the page set and the information in the catalog. The mismatch type is identified by mismatched-information-type in message DSNU671I, DSNU674I, or DSNU675I. This message provides additional information about the mismatch.

This problem might occur after copying data by using DSN1COPY or after using redirected recovery (RECOVER with the FROM option).

csect-name

The name of the control section that issued the message.

additional-information

Additional information about the mismatch. Possible values are:

REPAIR CANNOT FIX THE ERROR

REPAIR cannot reconcile a difference between the definition of a table or table space in the catalog and the table data or table space data in the page set.

MISSING SYSTEM PAGE IN THE PAGE SET

The page set does not contain a system page. REPAIR does not have enough information about the object from the page set.

A SYSTEM PAGE FOR AT LEAST ONE TABLE IN THE PAGE SET IS MISSING

The page set does not contain a system page for one or more tables in the page set.

TABLE IS DROPPED IN THE PAGE SET

The page set contains a table that was marked as dropped in the database descriptor. REPAIR cannot check table attributes.

NUMBER OF COLUMNS IS catalog-column-count IN THE CATALOG, BUT page-set-column-count IN THE PAGE SET

The number of columns in a table differs in the catalog and in the page set. If there are m columns in the page set, and n columns are defined in the catalog, and m<n, REPAIR reports on m columns.

catalog-column-count

The number of columns in the catalog definition of the table.

page-set-column-count

The number of columns in the table data in the page set.

COLUMN catalog-column-number DIFFERENCE:

A column definition differs in the catalog and in the page set. This string is followed by one of the following strings:

TYPE IS catalog-column-data-type IN THE CATALOG, BUT page-set-column-data-type IN THE PAGE SET.

The column data type differs in the catalog and the page set.

catalog-column-data-type

The data type of the column in the catalog definition of the table.

page-set-column-data-type

The data type of the column in the table data in the page set.

LENGTH IS catalog-column-length IN THE CATALOG, BUT page-set-column-length IN THE PAGE SET.

The column length differs in catalog and the page set.

catalog-column-length

The length of the column in the catalog definition of the table. If the column is nullable, the length is the length of the column, plus one byte for the null indicator.

page-set-column-length

The length of the column in the table data in the page set. If the column is nullable, the length is the length of the column, plus one byte for the null indicator.

PRECISION IS catalog-column-precision IN THE CATALOG, BUT page-set-column-precision IN THE PAGE SET.

The precision of a decimal column or a TIMESTAMP WITH TIME ZONE column differs in the catalog and in the page set.

catalog-column-precision

The precision of the column in the catalog definition of the table.

page-set-column-precision

The precision of the column in the table data in the page set.

SCALE IS catalog-column-scale IN THE CATALOG, BUT page-set-column-scale IN THE PAGE SET.

The scale of a decimal column differs in catalog and the page set.

catalog-column-scale

The scale of the column in the catalog definition of the table.

page-set-column-scale

The scale of the column in the table data in the page set.

ENCODING SCHEME IS catalog-column-scheme IN THE CATALOG, BUT page-set-column-scheme IN THE PAGE SET.

The column-level encoding scheme differs in catalog and the page set.

IS NULLABLE IN THE CATALOG, BUT NOT NULLABLE IN THE PAGE SET.

A column has the NOT NULL attribute in the page set, but does not have the NOT NULL attribute in the catalog.

IS NOT NULLABLE IN THE CATALOG, BUT NULLABLE IN THE PAGE SET.

A column has the NOT NULL attribute in the page set, but does not have the NOT NULL attribute in the catalog.

THE PRECISION AND SCALE COMBINATIONS IN THE CATALOG AND THE PAGE SET ARE INCOMPATIBLE.

A DECIMAL column cannot be altered from the page set format to the catalog format because the number of digits to the left of the decimal point (precision minus scale) is greater in the page set definition than in the catalog definition. Performing such an operation yields an invalid result, and is not permitted by ALTER SET DATA TYPE.

TABLE DEFINITION ERROR CANNOT BE FIXED

The definition of one or more columns of a table differs in the catalog and in the page set. REPAIR cannot reconcile the differences between the catalog and the page set.

THE MAXIMUM NUMBER OF VERSIONS ALLOWED HAS BEEN EXCEEDED

REPAIR cannot modify the table version number in the page set because doing so would result in a version number greater than 255.

SOME PARTITIONS IN THE PAGE SET WERE COPIED WITH DSN1COPY, AND SOME WERE NOT.

The REPAIR utility detected that at least one of the partition in the page set was copied using DSN1COPY, but at least one other was not.

TABLE SCHEMA CHECKING IS NOT DONE

Schema checking cannot be performed. See the previous DSNU667I message for the cause.

SOME PARTITIONS WERE RECOVERED WITH THE RECOVER UTILITY AND SOME WERE NOT

The REPAIR utility detected that at least one of the partitions in the page set was the target of a redirected recovery, but at least one other partition was not. Redirected recovery is a RECOVER utility operation with the FROM option specified.