| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| DBNAME |
CHAR(8) NOT NULL |
Name of the database. |
G |
| TSNAME |
CHAR(8) NOT NULL |
Name of the table 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. |
G |
| ICTYPE |
CHAR(1) NOT NULL |
Operation type:
A ALTER TABLE
F COPY FULL YES
I COPY FULL NO
P RECOVER TOCOPY or RECOVER
TORBA (partial recovery point)
Q QUIESCE
R LOAD REPLACE LOG(YES)
S LOAD REPLACE LOG(NO)
W REORG LOG(NO)
X REORG LOG(YES)
Y LOAD LOG(NO)
Z LOAD LOG(YES)
T TERM UTILITY command
(terminated utility) |
G |
| ICDATE |
CHAR(6) NOT NULL |
Date of the entry in the form yymmdd. |
G |
| START_RBA |
CHAR(6) NOT NULL
FOR BIT DATA |
A 48-bit positive integer containing the LRSN of a point in the DB2 recovery log. (The
LRSN is the RBA in a non-data-sharing environment.)
° For ICTYPE I or F, the starting point for all updates since the image copy was taken
° For ICTYPE P, the point after the log-apply phase of point-in-time recovery
° For ICTYPE Q, the point after all data sets have been successfully quiesced
° For ICTYPE R or S, the end of the log before the start of the LOAD utility and before
any data is changed
° For ICTYPE T, the end of the log when the utility is terminated
° For other values of ICTYPE, the end of the log before the start of the RELOAD phase
of the LOAD or REORGutility. |
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 |
Whether the row came from the basic machine-readable material (MRM) tape:
N No
Y Yes |
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 in the form,
database-nametable-space-name, or DSNAME is blank for any row migrated from a DB2
release prior to Version 5. |
G |
| ICTIME |
CHAR(6) NOT NULL |
The time at which this row was inserted, in the form hhmmss.
The insertion takes place after the completion of the operation that the row represents.
ICTIME is blank for any row which was migrated from Version 1 Release 1 of DB2. |
G |
| SHRLEVEL |
CHAR(1) NOT NULL |
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. |
G |
| TIMESTAMP |
TIMESTAMP NOT NULL
WITH DEFAULT |
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 may not be supported two columns may not be
supported in later DB2 releases. |
G |
| ICBACKUP |
CHAR(2) NOT NULL
WITH DEFAULT |
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) |
G |
| ICUNIT |
CHAR(1) NOT NULL
WITH DEFAULT |
Indicates the media that the image copy data set is stored on:
D DASD
T Tape
blank Medium is neither tape nor DASD, or the image copy is from a DB2
release prior to Version 2 Release 3, or ICTYPE is neither "I" nor "F" |
G |
| STYPE |
CHAR(1) NOT NULL
WITH DEFAULT |
When ICTYPE=A, the length of a VARCHAR column in a table was increased, the value
is V.
When ICTYPE=F, the values are:
C DFSMS concurrent copy
blank DB2 image copy
R LOAD REPLACE(YES)
S LOAD REPLACE(NO)
W REORG LOG(NO)
X REORG LOG(YES)
The MERGECOPY utility, when used to merge an embedded copy with subsequent
incremental copies, will also produce a record that will contain ICTYPE=F and the
STYPE of the original image copy (R, S, W, or X).
When ICTYPE=P and the operation is RECOVER TORBA LOGONLY, the value is L.
When ICTYPE=Q and option WRITE(YES) is in effect when the quiesce point is taken,
the value is W.
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:
F COPY FULL YES
I COPY FULL NO
For other values of ICTYPE, the value is blank. |
G |
| PIT_RBA |
CHAR(6) NOT NULL
WITH DEFAULT
FOR BIT DATA |
When ICTYPE=P, this field contains the LRSN for the point in the DB2 log. (The LRSN is
the RBA in a non-data-sharing environment). For other ICTYPEs, this field is
X'000000000000'.
When ICTYPE=P, this field indicates the stop location of a point-in-time recovery. If a
record contains ICTYPE=P and PIT_RBA=X'000000000000', the copy pending state is
active and a full image copy is required. If such a record is encountered during
fallback processing of RECOVER, the recover job fails, and a point-in-time recovery is
required. PIT_RBA can be zero if the point-in-time recovery is completed by the
fall- back processing of RECOVER, or if ICTYPE=P from a prior release of DB2. |
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 |
