DSNU1567I csect-name - DEFINITION OF TARGET object-type target-object-qualifier.target-object-name DIFFERS FROM SOURCE source-object-qualifier.source-object-name: mismatch-information

Explanation

The RECOVER utility was invoked for redirected recovery. However, the definition of the target table space, index space, table or index does not match the definition of the source table space, index space, table or index.

csect-name

The name of the control section that issued the message.

object-type

The type of object. Possible values are:

TABLESPACE

Table space

INDEXSPACE

Index space

INDEX

Index

target-object-qualifier.target-object-name

The name of the target table space, index space, table, or index, as a qualified name.

source-object-qualifier.source-object-name

The name of the source table space, index space, table, or index, as a qualified name.

mismatch-information

Information about the mismatched definitions. Possible values are:

TARGET SEGMENT SIZE IS target-segment-size-value, SOURCE SEGMENT SIZE IS source-segment-size-value

The segment size of the target and source table spaces differ.

target-segment-size-value

The segment size for the target table space.

source-segment-size-value

The segment size for the source table space.

TARGET TYPE IS target-space-type, SOURCE TYPE IS source-space-type

The table space or index space organization of the target and source differ.

target-space-type

The table space or index space type of the target.

source-space-type

The table space or index space type of the source.

TARGET XML TYPE IS target-xml-type-value, SOURCE XML TYPE IS source-xml-type-value

The XML version of the target and source XML table spaces differ.

target-xml-type-value

The XML version of the target table space.

source-xml-type-value

The XML version of the source table space.

TARGET PAGE SIZE IS target-page-size-value, SOURCE PAGE SIZE IS source-page-size-value

The page size of the target and source objects differ.

target-page-size-value

The page size of the target object.

source-page-size-value

The page size of the source object.

TARGET NUMBER OF PARTITIONS IS target-partition-count, SOURCE NUMBER OF PARTITIONS IS source-partition-count

The number of partitions of the target and source objects differ.

target-partition-count

The number of partitions in the target object.

source-partition-count

The number of partitions in the source object.

TARGET DSSIZE IS target-dssize-valueG, SOURCE DSSIZE IS source-dssize-valueG

The data set size of the target and source objects differ.

target-dssize-value

The data set size (in gigabytes) for the target object.

source-dssize-value

The data set size (in gigabytes) for the source object.

TARGET MAXPARTITIONS IS target-max-partitions-value, SOURCE ACTIVE PARTITIONS IS source-active-partition-value

The MAXPARTITIONS attribute of the target partition-by-growth (PBG) table space is less than the active number of partitions for the source PBG table space.

target-max-partitions-value

The MAXPARTITIONS attribute of the target PBG table space.

source-active-partition-value

The number of active partitions of the source PBG table space.

TARGET NUMBER OF CHUNKS IS target-integer, SOURCE NUMBER OF CHUNKS IS source-integer

The number of LOB data pages that are processed as a group for the target and source LOB table spaces differ. This error is usually caused by a mismatch in page size. To help resolve this issue, look for a previous DSNU1567I message about page size.

target-integer

The number of LOB data pages that are processed as a group for the target.

source-integer

The number of LOB data pages that are processed as a group for the source.

TARGET LOW LEVEL SPACE MAP RANGE IS target-number-of-pages, SOURCE RANGE IS source-number-of-pages

The number of pages mapped by the low-level space map pages for the target and source LOB table spaces differ. This error is usually caused by a mismatch in page size. To help resolve this issue, look for a previous DSNU1567I message about page size.

target-number-of-pages

The number of pages in the target.

source-number-of-pages

The number of pages in the source.

PARTITION partition-number TARGET DSSIZE IS target-dssize-valueG, SOURCE DSSIZE IS source-dssize-valueG

The data set size for the identified partition in the source and target objects differ.

partition-number

The partition number.

target-dssize-value

The data set size (in gigabytes) for the partition in the target.

source-dssize-value

The data set size (in gigabytes) for the partition in the source.

TABLE SPACE TYPE NOT SUPPORTED

Partitioned (non UTS), simple, or segmented table spaces are not supported.

TARGET TABLE DOES NOT EXIST

The corresponding target table is not created for an existing source table.

SOURCE TABLE DOES NOT EXIST

A target table exists for which no source table is created.

PARTITION physical-partition-number LIMIT KEY MISMATCH BETWEEN TARGET AND SOURCE

The limit key for the identified partition of the target and source object differs.

physical-partition-number

The physical partition number.

TABLE ENCODING SCHEME

The encoding scheme of the target and source tables differ.

NUMBER OF COLUMNS FOR TARGET TABLE IS target-column-count, SOURCE TABLE IS source-column-count

The number of columns in the target and source tables differs.

target-column-count

The number of columns in the target table.

source-column-count

The number of columns in the source table.

TARGET TABLE COLUMN column-number DEFINITION IS target-nullable-information, SOURCE TABLE DEFINITION IS source-nullable-information

The nullable attribute of the identified column of the target and source tables differs.

column-number

The column number of the target table as recorded in SYSIBM.SYSCOLUMNS

target-nullable-information

The nullable attribute of the column in the target table.

source-nullable-information

The nullable attribute of the column in the source table.

TARGET TABLE COLUMN column-number DATA TYPE IS target-data-type, SOURCE TABLE DATA TYPE IS source-data-type

The data type of the identified column of the target and source tables differs.

column-number

The column number of the target table as recorded in SYSIBM.SYSCOLUMNS

target-data-type

The data type of the column in the target table.

source-data-type

The data type of the column in the source table.

TARGET TABLE COLUMN column-number ENCODING SCHEME IS target-encoding-scheme, SOURCE TABLE ENCODING SCHEME IS source-encoding-scheme

The encoding scheme of the identified column of the target and source tables differs.

column-number

The column number of the target table as recorded in SYSIBM.SYSCOLUMNS

target-encoding-scheme

The encoding scheme of the column in the target table.

source-encoding-scheme

The encoding scheme of the column in the source table.

TARGET TABLE COLUMN column-number LENGTH IS target-column-length, SOURCE TABLE LENGTH IS source-column-length

The column length of the identified column of the target and source tables differs.

column-number

The column number of the target table as recorded in SYSIBM.SYSCOLUMNS

target-column-length

The length of the column in the target table.

source-column-length

The length of the column in the source table.

TARGET TABLE COLUMN column-number PRECISION IS target-column-precision, SOURCE TABLE PRECISION IS source-column-precision

The precision of the identified column of the target and source tables differs.

column-number

The column number of the target table as recorded in SYSIBM.SYSCOLUMNS

target-column-precision

The precision of the column in the target table.

source-column-precision

The precision of the column in the source table.

TARGET TABLE COLUMN column-number SCALE IS target-column-scale, SOURCE TABLE SCALE IS source-column-scale

The scale of the identified column of the target and source tables differs.

column-number

The column number of the target table as recorded in SYSIBM.SYSCOLUMNS

target-column-scale

The column scale in the target table.

source-column-scale

The column scale in the source table.

TABLE COLUMN column-number PRECISION AND SCALE MISMATCH

The precision and scale of the identified column of the target and source tables differ.

column-number

The column number of the target table as recorded in SYSIBM.SYSCOLUMNS

UNIDENTIFIED TABLE SCHEMA MISMATCH

An unexpected error occurred.

INDEX PIECE SIZE – TARGET: target piece-size-value G, SOURCE: source-piece-size-value G

The index piece size for a nonpartitioned index (NPI) differs between the source and target.

target-piece-size-value

The index piece size of the target in gigabytes.

source-piece-size-value

The index piece size of the source in gigabytes.

SOURCE OR TARGET INDEX DOES NOT EXIST

Either the source or target index does not exist.

NUMBER OF INDEX KEY COLUMNS - TARGET: target-number-of-columns, SOURCE: source-number-of-columns

The number of columns in the index key of the target and source indexes differ.

target-number-of-columns

The number of index key columns for the target index.

source-number-of-columns

The number of index key columns for the source index.

NUMBER OF INDEX ORDER KEY COLUMNS - TARGET: target-number-of-ordering-columns, SOURCE: source-number-of-ordering-columns

The number of ordering columns of the target and source indexes differ. These columns are specified in the CREATE INDEX or ALTER INDEX statement and determine the order of the index keys. Columns that are added to the index key with the INCLUDE option are not ordering columns.

target-number-of-ordering-columns

The number of ordering columns for the target index.

source-number-of-ordering-columns

The number of ordering columns for the source index.

INDEX ENCODING SCHEME - TARGET: target-encoding-scheme, SOURCE: source-encoding-scheme

The encoding scheme of target and source indexes differ.

target-encoding-scheme

The encoding scheme of the target index.

source-encoding-scheme

The encoding scheme of the source index.

INDEX KEY COLUMN key-column-number TABLE COLUMN NUMBER – TARGET: target-table-column-number, SOURCE: source-table-column-number

The table column for the index key column has a different column number in the target and source tables. The table column number identifies the order of the column in a table.

key-column-number

The key column number of the target index as recorded in SYSIBM.SYSINDEXKEYS.

target-table-column-number

The column number in the target table.

source-table-column-number

The column number in the source table.

INDEX KEY COLUMN key-column-number DATA TYPE – TARGET: target-column-type, SOURCE: source-column-type

For the index key column number, the data type of the column in the target and source tables differ.

key-column-number

The key column number of the target index as recorded in SYSIBM.SYSINDEXKEYS.

target-column-type

The data type of the column in the target table.

source-column-type

The data type of the column in the source table.

INDEX KEY COLUMN key-column-number LENGTH – TARGET: target-column-length, SOURCE: source-column-length

For the index key column number, the data column length of the target and source tables differ.

key-column-number

The key column number of the target index as recorded in SYSIBM.SYSINDEXKEYS.

target-column-length

The column length in the target table.

source-column-length

The column length in the source table.

INDEX KEY COLUMN key-column-number PRECISION – TARGET: target-column-precision, SOURCE: source-column-precision

For the index key column number, the data column precision of the target and source tables differ.

key-column-number

The key column number of the target index as recorded in SYSIBM.SYSINDEXKEYS.

target-column-precision

The column precision in the target table.

source-column-precision

The column precision in the source table.

INDEX KEY COLUMN key-column-number SCALE – TARGET: target-column-scale, SOURCE: source-column-scale

For the index key column number, the data column scale of the target and source tables differ.

key-column-number

The key column number of the target index as recorded in SYSIBM.SYSINDEXKEYS.

target-column-scale

The column scale in the target table.

source-column-scale

The column scale in the source table.

INDEX KEY COLUMN key-column-number PRECISION AND SCALE – TARGET: target-column-precision-scale, SOURCE: source-column-precision-scale

For the index key column number, the precision and scale of the data column of the target and source tables differ. The column-precision-scale value is calculated by subtracting the scale from the precision.

key-column-number

The key column number of the target index as recorded in SYSIBM.SYSINDEXKEYS.

target-column-precision-scale

The column precision and scale in the target table.

source-column-precision-scale

The column precision and scale in the target table.

INDEX ORDER – TARGET: target-key-column-order, SOURCE: source-key-column-order

The key column order (ASCENDING, DESCENDING or RANDOM) of the target and source indexes differ.

target-key-column-order

The key column order of the target.

source-key-column-order

The key column order of the source.

INDEX KEY COLUMN key-column-number ENCODING SCHEME – TARGET: target-column-encoding-scheme, SOURCE: source-column-encoding-scheme

For the index key column number, the data column encoding scheme of the target and source tables differ.

key-column-number

The key column number of the target index as recorded in SYSIBM.SYSINDEXKEYS.

target-column-encoding-scheme

The column encoding scheme in the target.

source-column-encoding-scheme

The column encoding scheme in the source.

INDEX KEY COLUMN key-column-number DEFINITION – TARGET: target-nullable-information, SOURCE: source- nullable-information

For the index key column number, the data column nullable attribute of the target and source tables differ.

key-column-number

The key column number of the target index as recorded in SYSIBM.SYSINDEXKEYS.

target-column-encoding-scheme

The nullable attribute of the column in the target.

source-column-encoding-scheme

The nullable attribute of the column in the source.