DSNU674I csect-name - mismatched-information-type FOR DBID=X'dbid' PSID=X'psid' IN THE DB2 CATALOG IS catalog-format-type, BUT IN THE PAGE SET IS pageset-format-type.
Explanation
The REPAIR utility with the CATALOG option detected that information in the catalog table is different from the data from the page set.
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.
- mismatched-information-type
- The type of information that did not match. mismatched-information-type can
have one of the following values:
- PBG TABLESPACE (for a partition-by-growth table (UTS) spaces)
- PBR TABLESPACE (for a partition-by-range table spaces)
- ROW FORMAT
- RBA FORMAT
- TABLESPACE TYPE
- PBG TABLESPACE
- PBR TABLESPACE
- PAGE FORMAT
- FL 509 COMPRESSION USED
- dbid
- The database identifier (DBID) for the database in which mismatched information was detected.
- psid
- The page set identifier (PSID) for the page set for which mismatched information was detected.
- catalog-format-type
- The value in the catalog for mismatched-information-type.
Possible values depend on the value of mismatched-information-type, as follows:
Value of mismatched-information-type Possible values of catalog-format-type PBG TABLESPACE - HASHED
- The table space is organized by hash
- NOT HASHED
- The table space is not organized by hash
PBR TABLESPACE - HASHED
- The table space is organized by hash
- NOT HASHED
- The table space is not organized by hash
ROW FORMAT - BRF
- Basic row format
- RRF
- Reorder row format
RBA FORMAT - BASIC
- 6-byte RBA format
- EXPANDED
- 10-byte RBA format
TABLESPACE TYPE - PART
- Partitioned (non-UTS) table space
- PBR
- Partition-by-range table space
- PBG
- Partition-by-growth table space
- SEG
- Segmented table space (nonUTS)
- NON-SEGMENTED
- Non-segmented or simple table space.
- MC
- Universal table space with the MEMBER CLUSTER attribute.
- NOT MC
- Universal table space without the MEMBER CLUSTER attribute
- PBG Hash
- Partition-by-growth table space that is organized for hash access
- PBR Hash
- partition-by-range table space that is organized for hash access
PBG TABLESPACE or PBR TABLESPACE - Hashed
- Table space has hash organization
- Not Hashed
- Table space does not have hash organization
PAGE FORMAT - ABSOLUTE
- The table space uses absolute page numbering (PAGENUM has a value of A)
- RELATIVE
- The table space uses relative page numbering (PAGENUM has a value of R)
FL 509 COMPRESSION USED - FIXED-LENGTH
- The table space or partition is compressed with fixed-length compression
- HUFFMAN
- The table space or partition is compressed with Huffman compression
- UNCOMPRESSED
- The table space or partition is not compressed
- pageset-format-type
- The value from the page set for mismatched-information-type.
Possible values are the same as catalog-format-type.
System action
Depending on the type of mismatch, and whether the TEST keyword is specified, REPAIR ends with return code 0, 4, or 8. Messages DSNU667I, DSNU690I, or DSNU695I are displayed to provide more information.
User response
Examine messages DSNU667I, DSNU690I, or DSNU695I to learn more about the mismatch.
If the utility completion code is 8, find the DSN1COPY or redirected recovery job that might have caused this error. Ensure that the correct object name is specified and that the target and the source have the same table space type. If you made any changes, rerun DSN1COPY or redirected recovery.
If the utility completion code is 4, rerun the REPAIR utility without the TEST keyword to fix the catalog.
