Column name
DBNAME
TSNAME
DSNUM
ICTYPE
| | |
Data type
CHAR(8) NOT NULL
CHAR(8) NOT NULL
INTEGER NOT NULL
CHAR(1) NOT NULL
Description Use
Name of the database. G
Name of the target table space or index space. G
Data set number within the table space. For partitioned G 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.
Type of operation: G
A ALTER
B REBUILD INDEX
C CREATE
D CHECK DATA LOG(NO) (no log records for the range are available for RECOVER utility)
E RECOVER (to current point)
F COPY FULL YES
I COPY FULL NO
M MODIFY RECOVERY utility
P RECOVER TOCOPY or RECOVER TORBA
(partial recovery point)
Q QUIESCE
R LOAD REPLACE LOG(YES)
S LOAD REPLACE LOG(NO)
T TERM UTILITY command
V REPAIR VERSIONS utility
W REORG LOG(NO)
X REORG LOG(YES)
Y LOAD LOG(NO)
Z LOAD LOG(YES)
Not used N
A 48-bit positive integer that contains the LRSN of a point G in the DB2 recovery log. (The LRSN is the RBA in a non-data-sharing environment.)
v For ICTYPE I or F, the starting point for all updates since the image copy was taken
v For ICTYPE P, the point after the log-apply phase of point-in-time recovery
v For ICTYPE Q, the point after all data sets have been successfully quiesced
v For ICTYPE R or S, the end of the log before the start of the LOAD utility and before any data is changed
v For ICTYPE T, the end of the log when the utility is terminated
v For other values of ICTYPE, the end of the log before the start of the RELOAD phase of the LOAD or REORG utility.
SYSIBM.SYSCOPY table
The SYSIBM.SYSCOPY table contains information needed for recovery.
START_RBA
CHAR(6) NOT NULL
CHAR(6)
NOT NULL DEFAULT
FOR BIT DATA
WITH
1740 SQL Reference
Column name
FILESEQNO
DEVTYPE
IBMREQD
DSNAME
SHRLEVEL
DSVOLSER
TIMESTAMP
| |
ICUNIT
Data type
Description
Tape file sequence number of the copy.
Device type the copy is on.
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.
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 DB2 release prior to Version 4.
Not used
SHRLEVEL parameter on COPY (for ICTYPE F or I only): C Change
R Reference
blank Does not describe an image copy or was
migrated from Version 1 Release 1 of DB2.
The volume serial numbers of the data set. A list of 6-byte numbers separated by commas. Blank if the data set is cataloged.
The date and time when the row was inserted. This is the date and time recorded in ICDATE and ICTIME. The use of TIMESTAMP is recommended over that of ICDATE and ICTIME, because the latter two columns might not be supported in later DB2 releases. 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.
Specifies the type of image copy contained in the data set: blank LOCALSITE primary copy (first data set named
with COPYDDN)
LB LOCALSITE backup copy (second data set
named with COPYDDN)
RP RECOVERYSITE primary copy (first data set
named with RECOVERYDDN)
RB RECOVERYSITE backup copy (second data set
named with RECOVERYDDN)
Indicates the media that the image copy data set is stored on:
D DASD
T Tape
blank Medium is neither tape nor DASD, the image copy is from a DB2 release prior to Version 2 Release 3, or ICTYPE is not ‘I’ or ‘F’.
Use
G
G
G
G
N
G
G
G
G
G
ICBACKUP
INTEGER NOT NULL
CHAR(8) NOT NULL
CHAR(1) NOT NULL
CHAR(44) NOT NULL
CHAR(6) NOT NULL
CHAR(1) NOT NULL
VARCHAR(1784) NOT NULL
TIMESTAMP
NOT NULL WITH DEFAULT
CHAR(2)
NOT NULL WITH DEFAULT
CHAR(1)
NOT NULL WITH DEFAULT
Appendix. Additional information for DB2 SQL
1741
Column name
GROUP_MEMBER
OTYPE
LOWDSNUM
HIGHDSNUM
COPYPAGESF
NPAGESF
CPAGESF
JOBNAME
AUTHID
OLDEST_VERSION
LOGICAL_PART
Data type
Description Use
The DB2 data sharing member name of the DB2 G 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.
Type of object that the recovery information is for: G I Index space
T Table space
Partition number of the lowest partition in the range for G 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.
Partition number of the highest partition in the range. G 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.
Number of pages written to the copy data set. For inline G copies, this number might include pages appearing more than once in the copy data set.
The number of pages in the table space or index at the G time of COPY. This number might include pre-formatted pages that are not actually copied.
Total number of changed pages. G
Job name of the utility. G
Authorization ID of the utility. G
When ICTYPE= B, F, I, S, W, or X, the version number of G the oldest format of data for an object. For other values of ICTYPE, the value is -1.
Logical partition number. G
CHAR(8)
NOT NULL WITH DEFAULT
CHAR(1)
NOT NULL WITH DEFAULT ‘T’
INTEGER
NOT NULL WITH DEFAULT
INTEGER
NOT NULL WITH DEFAULT
FLOAT(8)
NOT NULL WITH DEFAULT -1
FLOAT(8)
NOT NULL WITH DEFAULT -1
FLOAT(8)
NOT NULL WITH DEFAULT -1
CHAR(8)
NOT NULL WITH DEFAULT
CHAR(8)
NOT NULL WITH DEFAULT
SMALLINT
NOT NULL WITH DEFAULT
INTEGER
NOT NULL WITH DEFAULT
1744 SQL Reference