DSNU556I csect-name RECOVER CANNOT PROCEED FOR object-type object-qualifier.object-name BECAUSE A SYSCOPY RECORD HAS BEEN ENCOUNTERED WHICH HAS DBNAME= dbname TSNAME= tsname DSNUM= dsnum ICTYPE= ictype STYPE= stype STARTRBA=X'rba' LOWDSNUM= low-dsnum HIGHDSNUM=high-dsnum.

Explanation

Db2 encountered an event that is recorded in a SYSCOPY record that prohibits recovery processing.

csect-name

The name of the control section that issued the message.

object-type

The type of object.

object-qualifier.object-name

The name of the object, as a qualified name.

database-name

Name of the database.

tablespace-name

Name of the table space.

ictype and stype

The type of event is recorded in the ictype and stype columns.

ICTYPE=A (ALTER)

STYPE=C

An ALTER took place that performed one of the following actions:

• Added a column to a table and the column was not added to the index in the same commit scope. Rebuild the index instead of recovering it.
• Dropped a column from a table.

A TTYPE value of blank indicates that the column was added and a TTYPE value of 'D' indicates that the column was dropped.

STYPE=D

One of the following situations occurred:

• If the TTYPE value is blank, ALTER TABLE ALTER COLUMN SET DEFAULT was executed on a column that was added (with ALTER TABLE ADD COLUMN), and point-in-time recovery before the ALTER COLUMN SET DEFAULT is not allowed. For this case, the TTYPE value is blank.
• If the TTYPE value is non-blank, the TTYPE value is the data set size. The DSSIZE attribute of the table space was updated by an ALTER statement.

STYPE=E

An ALTER TABLE EXCHANGE occurred and a point-in-time recovery before the exchange is not allowed. If the object that is being recovered is an index, the index cannot be recovered before the rotation of its underlying table.

STYPE=F

The buffer pool attribute of the object was updated by an ALTER statement and a point-in-time recovery before the update is not allowed.

STYPE=G

An ALTER INDEX REGENERATE was done. Rebuild the index instead of recovering it.

STYPE=I

A SYSCOPY record for a REORG with TTYPE=I or TTYPE=D indicates that a REORG to materialize an ALTER COLUMN INLINE LENGTH was found. However, not all related objects (base table space and LOB table space) were recovered as a set to the same point in time. The point-in-time recovery is not allowed unless both the related base and LOB objects are recovered as a set.

STYPE=M

The MAXPARTITIONS attribute of the table space was updated by an ALTER statement and a point-in-time recovery before the update is not allowed.

STYPE=N

The index was updated by an ALTER statement to have the NOT PADDED attribute. Rebuild the index instead of recovering it.

STYPE=P

The index was updated by an ALTER statement to have the PADDED attribute. Rebuild the index instead of recovering it.

STYPE=R

A table space partition was rotated and a point-in-time recovery before the rotation is not allowed. If the object that is being recovered is one of the following objects, it cannot be recovered to a point in time before the rotation:

• An index partition
• A LOB table space that belongs to the rotated partition

STYPE=S

The SEGSIZE attribute of the table space was updated by an ALTER statement and a point-in-time recovery before the update is not allowed.

STYPE=T (TABLESPACE), TTYPE=M (MOVE)

FL 508 An ALTER TABLESPACE MOVE TABLE operation occurred. One or more tables were moved from this source table space by the REORG utility. A point-in-time recovery before this event is not allowed.

STYPE=U

ALTER TABLE ALTER COLUMN DROP DEFAULT was executed on a column that was added (with ALTER TABLE ADD COLUMN), and point-in-time recovery before the ALTER COLUMN DROP DEFAULT is not allowed.

STYPE=V

An ALTER TABLE COLUMN occurred on an indexed column for a numeric data type change. Rebuild the index instead of recovering it

STYPE=X

A REORG dropped one or more empty partitions from the related table space. A partition cannot be recovered to a point before it was dropped by the REORG utility.

Recovery to the current state at the table space level is not allowed after one or more empty partitions are dropped during REORG TABLESPACE on a partition-by-growth table space. Until a full image copy at the table space level has been performed, partition-level recoveries (DSNUM integer) need to be done instead.

STYPE=Z

A column that is in the key of an index that was versioned before DB2® version 8 was updated by an ALTER statement. Rebuild the index instead of recovering it

ICTYPE=C (CREATE)

STYPE=L

Indicates that the object was created with the LOGGED attribute.

STYPE=O

Indicates that the object was created with the NOT LOGGED attribute.

ICTYPE=F (full image copy)

One of the following situations occurred:

• An attempt was made to recover an index to a prior point-in-time and more than 16 versions of the index exist. (ALTER TABLE COLUMN was done more than 16 times to alter the index key). The point-in-time recovery is not allowed.
• An attempt was made to recover a compressed, versioned index, but the format of the image copy of the index is not correct. This situation occurs when the image copy was taken before Db2 code was applied to allow recovery of compressed, versioned indexes.

In both cases, rebuild the index.

ICTYPE=L (SQL)

STYPE=M

Indicates that an SQL mass DELETE, TRUNCATE TABLE, DROP TABLE, or ALTER TABLE ROTATE PARTITION occurred on a segmented table space or universal table space. The LOWDSNUM column contains the OBID of the affected table. The BACKOUT YES option for RECOVER is not supported.

ICTYPE=M (MODIFY RECOVERY)

STYPE=R

Indicates that the MODIFY RECOVERY utility deleted recovery information that is required for this recovery.

ICTYPE=P (point-in-time recovery)

An index is being recovered to a point in time that is different than the point in time of its underlying table space. The recover of the index is not allowed. Use the REBUILD INDEX utility instead.

ICTYPE=P (point-in-time recovery) or E (recovery to the current state)

If the DSNU1528I message was previously issued for this object, then see that message for details.

ICTYPE=P (point-in-time recovery)

STYPE=F (from)

A SYSCOPY record was found for a redirected recovery. Redirected recovery is a RECOVER utility operation with the FROM option specified where an image copy or copies and logs from another object were used for the recovery.

Recovery to a point in time before the redirected recovery is not allowed.

Recovery to the current state or to a point in time after the redirected recovery is allowed only after a full image copy has been created.

ICTYPE=R,S,W, or X (REORG, LOAD REPLACE, CATENFM)

STYPE=A

A SYSCOPY record for a REORG or LOAD REPLACE operation that redistributed data across partitions was found. The partitions that were affected by the ALTER INDEX that changed the limit keys must be recovered in the same list.

STYPE=S

The CATENFM utility was run. A point-in-time recovery before the CATENFM process is not allowed unless the entire system (including the Db2 catalog and directory) are recovered to the same point.

STYPE= "blank"

A SYSCOPY record was found for a REORG operation with the LOG(YES) option in the recovery period. Recovery to a prior point in time is not possible.

ICTYPE=T (TERM UTIL command)

STYPE=R, TTYPE=F V (from version)

A SYSCOPY record was found for termination of a redirected recovery on an index space or index by using the TERM UTIL command. Recovery of the index or index partition to the current state or to any point in time is not allowed. Another redirected recovery or the REBUILD INDEX, REORG TABLESPACE (with the SORTDATA option) or the LOAD REPLACE utilities can be run instead.

For more information about redirected recovery, see Running a redirected recovery.