SYSIBM.SYSCOPY table
The SYSIBM.SYSCOPY table contains information needed for recovery.
Column name | Data type | Description | Use |
---|---|---|---|
DBNAME | CHAR(8)
NOT NULL |
Name of the database. | G |
TSNAME | CHAR(8)
NOT NULL |
Name of the target table space or index space. | G |
DSNUM | INTEGER
NOT NULL |
Data set number within the table space. For partitioned table spaces, this value corresponds to the partition number for a single partition copy, or 0 for a copy of an entire partitioned table space or index space. | G |
ICTYPE | CHAR(1)
NOT NULL |
Type of operation:
|
G |
CHAR(6)
NOT NULL |
Not used | N | |
START_RBA | CHAR(6)
NOT NULL FOR BIT DATA |
A 48-bit positive integer that contains the
LRSN of a point in the DB2® recovery
log. (The LRSN is the RBA in a non-data-sharing environment.)
|
G |
FILESEQNO | INTEGER
NOT NULL |
Tape file sequence number of the copy. | G |
DEVTYPE | CHAR(8)
NOT NULL |
Device type the copy is on. | G |
IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row came from the
basic machine-readable material (MRM) tape. For all other values,
see Release
dependency indicators. The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead. |
G |
DSNAME | CHAR(44)
NOT NULL |
For ICTYPE='P' (RECOVER TOCOPY only), ''I'', or 'F', DSNAME contains the data set name. Otherwise, DSNAME contains the name of the database and table space or index space in the form, database-name.space-name, or DSNAME is blank for any row migrated from a release prior to Version 4. | G |
CHAR(6)
NOT NULL |
Not used | N | |
SHRLEVEL | CHAR(1)
NOT NULL |
SHRLEVEL parameter value on COPY (for ICTYPE F
or I only):
|
G |
DSVOLSER | VARCHAR(1784)
NOT NULL |
One of the following values:
|
G |
TIMESTAMP | TIMESTAMP
NOT NULL WITH DEFAULT |
The date and time when the row was inserted. For the COPYTOCOPY utility, this value is the date and time when the row was inserted for the primary local site or primary recovery site copy. For an EXCHANGE DATA statement, this is the time that the statement is run. | G |
ICBACKUP | CHAR(2)
NOT NULL WITH DEFAULT |
Specifies the type of image copy contained in the
data set:
|
G |
ICUNIT | CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the media that the image copy data set
is stored on:
|
G |
STYPE | CHAR(1)
NOT NULL WITH DEFAULT |
When ICTYPE=A, the values are:
|
G |
STYPE (continued) | When ICTYPE=A, the values are (continued):
When ICTYPE=C, the values
are:
When ICTYPE=E,
the values are:
When ICTYPE=F, the values are:
|
||
STYPE (continued) | When ICTYPE=F, the values are (continued):
When ICTYPE=L, the value is:
The MERGECOPY utility, when used to merge an embedded copy with subsequent incremental copies, also
produces a record that contains ICTYPE=F and the STYPE of the original image copy (R, S, W, or X).
When ICTYPE = M and the MODIFY RECOVERY utility was executed to delete SYSCOPY and/or SYSLGRNX records, the value is R. When ICTYPE=O, the values are:
When ICTYPE=P, the values are:
When ICTYPE=Q and option WRITE(YES) is in effect when the quiesce point is taken, the value is W. When ICTYPE=R or S, the values are:
When ICTYPE=T, this field indicates which COPY utility was terminated by the TERM
UTILITY command or the START DATABASE command with the ACCESS(FORCE) option. The values are:
|
||
STYPE (continued) | When ICTYPE=T, the values are (continued):
When ICTYPE=W or X, the
values are:
For other values of ICTYPE, the value is blank. |
||
PIT_RBA | CHAR(6)
NOT NULL WITH DEFAULT FOR BIT DATA |
The
meaning of the value depends on the value of the ICTYPE column:
For other all other ICTYPE values, this field contains X'000000000000'. |
G |
GROUP_MEMBER | CHAR(8)
NOT NULL WITH DEFAULT |
The DB2 data sharing member name of the DB2 subsystem that performed the operation. This column is blank if the DB2 subsystem was not in a DB2 data sharing environment at the time the operation was performed. | G |
OTYPE | CHAR(1)
NOT NULL WITH DEFAULT 'T' |
Type of object that the recovery information is
for:
|
G |
LOWDSNUM | INTEGER
NOT NULL WITH DEFAULT |
Partition number of the lowest partition in the range for SYSCOPY records created for REORG and LOAD REPLACE for resetting a REORG pending status. Version number of an index for SYSCOPY records created for a COPY (ICTYPE=F) of an index space (OTYPE=I). (An index is versioned when a VARCHAR column in the index key is lengthened.) When ICTYPE = F or I, DSNUM = 0 and OTYPE is not equal to I, LOWDSNUM = 1. | G |
HIGHDSNUM | INTEGER
NOT NULL WITH DEFAULT |
Partition number of the highest partition in the range. This column is valid only for SYSCOPY records created for REORG and LOAD REPLACE for resetting REORG pending status.When ICTYPE = F or I, DSNUM = 0 and OTYPE is not equal to I, HIGHDSNUM is the number of the highest partition that is copied. | G |
COPYPAGESF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
Number of pages written to the copy data set. For inline copies, this number might include pages appearing more than once in the copy data set. | G |
NPAGESF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
The number of pages in the table space or index
at the time of COPY. This number might include pre-formatted pages
that are not actually copied. When ICTYPE=A, SYTPE=H, and TTYPE=S or D, this column contains the previous HASHDATAPAGES value. When ICTYPE=A, SYTPE=H, and TTYPE=A this column contains zero. |
G |
CPAGESF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
Total number of changed pages since last copy. | G |
JOBNAME | CHAR(8)
NOT NULL WITH DEFAULT |
Job name of the utility. | G |
AUTHID | CHAR(8)
NOT NULL WITH DEFAULT |
Authorization ID of the utility. | G |
OLDEST_VERSION | SMALLINT
NOT NULL WITH DEFAULT |
When ICTYPE= B, F, I, S, W, or X, the version number of the oldest format of
data for an object.
For other values of ICTYPE, the value is -1. The default value of this column is 0. |
G |
LOGICAL_PART | INTEGER
NOT NULL WITH DEFAULT |
Logical partition number. | G |
LOGGED | CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the logging attribute of the table space
at the time the SYSCOPY record is written:
|
G |
TTYPE | CHAR(8)
NOT NULL WITH DEFAULT |
When ICTYPE=A
and STYPE=B, this column indicates if the previous value for the
MEMBER CLUSTER attribute is being used:
When ICTYPE=A and STYPE=D, this column contains the previous DSSIZE attribute value for the table space in units of G, M, or K when the DSSIZE attribute is altered. This column is blank if the default value of a column of a table was altered. When ICTYPE=A and STYPE=F, this column indicates the previous page size attribute value for the table space in units of K. When ICTYPE=A and STYPE=H this column indicates
a change that was applied to the hash organization of the table:
|
G |
TTYPE (continued) | When ICTYPE=A
and STYPE=I, this column indicates that the inline length of a
LOB column was altered:
When ICTYPE=A
and STYPE=M, this column indicates either the previous value of
the MAXPARTITIONS attribute for the table space or the type of table
space conversion that was performed on the table space.
|
||
TTYPE (continued) | When ICTYPE=A
and STYPE=S, this column indicates either the previous value of
the SEGSIZE attribute for the table space or the type of table space
conversion that was performed on the table space.
When ICTYPE=E, this column
indicates if the full recovery reset the object:
When ICTYPE=F and OTYPE=I, TTYPE of S indicates that the directory pages for the index image copy are at the front of each partition and are indicated with a 'V' or '8'. When ICTYPE=F
and STYPE=N, Q, T, or U, this column indicates the utility that
made the FlashCopy:
When
ICTYPE=I, this column provides information about the system pages:
When ICTYPE=P, R, S, W, X, this column provides additional diagnostic information:
|
||
TTYPE (cont) | When ICTYPE=P, R, S, W, X, this column provides additional diagnostic information
(continued):
When ICTYPE=M
and STYPE=R, this column indicates whether the MODIFY RECOVERY
utility deleted rows from SYSIBM.SYSLGRNX.
When ICTYPE=T, TTYPE of B indicates that a broken page was detected during copy. When ICTYPE=W or X and STYPE=H, this column indicates the prior value of HASHDATAPAGES. When ICTYPE=Y or Z, this column indicates whether the object was loaded when the FORMAT INTERNAL option was specified.
|
||
INSTANCE | SMALLINT
NOT NULL WITH DEFAULT 1 |
When STYPE = E and ICTYPE = A, INSTANCE indicates
the data set instance number of a base object after an EXCHANGE statement
completes. The value of the INSTANCE column for the last data exchange
will match the value of the INSTANCE column for the SYSIBM.SYSTABLESPACE
table. For an image copy, INSTANCE indicates the instance number of the current base objects (table and index). |
G |
RELCREATED | CHAR(1)
NOT NULL WITH DEFAULT |
The release of DB2 that is used to create the object. Blank if created prior to Version 9. See Release dependency indicators for all other values. | G |