1. Home
  2. Resources
  3. SAP Tables
  4. DB2COPYI - DB2 copy information from SYSIBM.SYSCOPY

SAP Table DB2COPYI

DB2 copy information from SYSIBM.SYSCOPY

DB2COPYI (DB2 copy information from SYSIBM.SYSCOPY) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DB2COPYI to other SAP tables.

DB2COPYI table fields

Field Data element Checktable Datatype Length Decimals
INFOTYPE CHAR 10 0
DBNAME Column DBNAME of table SYSIBM.SYSCOPY (DB2 on OS/390) D2DBNAME CHAR 8 0
TSNAME Column TSNAME of table SYSIBM.SYSCOPY (DB2 on OS/390) D2TSNAME CHAR 8 0
DSNUM Column DSNUM of table SYSIBM.SYSCOPY (DB2 on OS/390) D2DSNUM INT4 10 0
LOCAL_ID INT4 10 0
START_RBA Column START_RBA of table SYSIBM.SYSCOPY (DB2 on OS/390) D2STRT_RBA CHAR 12 0
TIMESTAMP Column TIMESTAMP of table SYSIBM.SYSCOPY (DB2 on OS/390) D2TIMESTMP CHAR 26 0
ICTYPE Column ICTYPE of table SYSIBM.SYSCOPY (DB2 on OS/390) D2ICTYPE CHAR 1 0
F FULL COPY
I INCREMENTAL COPY
P PARTIAL RECOVERY (to RBA or to COPY)
T TERMINATED UTILITY (COPY)
FILESEQNO Column FILESEQNO of table SYSIBM.SYSCOPY (DB2 on OS/390) D2FLSEQNO INT4 10 0
DEVTYPE Column DEVTYPE of table SYSIBM.SYSCOPY (DB2 on OS/390) D2DEVTYPE CHAR 8 0
IBMREQD Column IBMREQD of table SYSIBM.SYSCOPY (DB2 on OS/390) D2IBMREQD CHAR 1 0
Y Yes
N No
DSNAME Column DSNAME of table SYSIBM.SYSCOPY (DB2 on OS/390) D2DSNAME CHAR 44 0
SHRLEVEL Column SHRLEVEL of table SYSIBM.SYSCOPY (DB2 on OS/390) D2SHRLEVEL CHAR 1 0
C Change (updates on tablespace possible)
R Reference (tablespace access is read-only)
NULL
ICBACKUP Column ICBACKUP of table SYSIBM.SYSCOPY (DB2 on OS/390) D2ICBACKUP CHAR 2 0
NULL LOCAL SITE - primary copy
LB LOCAL SITE - backup copy
RP RECOVERY SITE - primary copy
RB RECOVERY SITE - backup copy
ICUNIT Column ICUNIT of table SYSIBM.SYSCOPY (DB2 on OS/390) D2ICUNIT CHAR 1 0
D DASD (direct access storage device)
T Tape
NULL Other
STYPE Column STYPE of table SYSIBM.SYSCOPY (DB2 on OS/390) D2STYPE CHAR 1 0
F Full copy
I Incremental copy
C DFSMS concurrent copy
NULL DB2 image copy or otherwise
L Recover to RBA log only
Q Quiesce with WRITE(YES)
PIT_RBA Column PIT_RBA of table SYSIBM.SYSCOPY (DB2 on OS/390) D2PIT_RBA CHAR 12 0
GRP_MEMBER Column GROUP_MEMBER of table SYSIBM.SYSCOPY (DB2 on OS/390) D2GRP_MBR CHAR 8 0
LENGTH INT2 5 0
DSVOLSER Column DSVOLSER of table SYSIBM.SYSCOPY (DB2 on OS/390) D2DSVOLSER LCHR 1784 0