DB2COPYI - DB2 copy information from SYSIBM.SYSCOPY

DB2 copy information from SYSIBM.SYSCOPY information is stored in SAP table DB2COPYI.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".

Fields for table DB2COPYI

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
INFOTYPEAll copy information vs. only latest copy informationXCHAR10
DBNAMEColumn DBNAME of table SYSIBM.SYSCOPY (DB2 on OS/390)XD2DBNAMECHAR8
TSNAMEColumn TSNAME of table SYSIBM.SYSCOPY (DB2 on OS/390)XD2TSNAMECHAR8
DSNUMColumn DSNUM of table SYSIBM.SYSCOPY (DB2 on OS/390)XD2DSNUMINT44
LOCAL_IDLocally generated ID to make copy entries uniqueXINT44
START_RBAColumn START_RBA of table SYSIBM.SYSCOPY (DB2 on OS/390)D2STRT_RBACHAR20
TIMESTAMPColumn TIMESTAMP of table SYSIBM.SYSCOPY (DB2 on OS/390)D2TIMESTMPCHAR26
ICTYPEColumn ICTYPE of table SYSIBM.SYSCOPY (DB2 on OS/390)D2ICTYPECHAR1
FILESEQNOColumn FILESEQNO of table SYSIBM.SYSCOPY (DB2 on OS/390)D2FLSEQNOINT44
DEVTYPEColumn DEVTYPE of table SYSIBM.SYSCOPY (DB2 on OS/390)D2DEVTYPECHAR8
IBMREQDColumn IBMREQD of table SYSIBM.SYSCOPY (DB2 on OS/390)D2IBMREQDCHAR1
DSNAMEColumn DSNAME of table SYSIBM.SYSCOPY (DB2 on OS/390)D2DSNAMECHAR44
SHRLEVELColumn SHRLEVEL of table SYSIBM.SYSCOPY (DB2 on OS/390)D2SHRLEVELCHAR1
ICBACKUPColumn ICBACKUP of table SYSIBM.SYSCOPY (DB2 on OS/390)D2ICBACKUPCHAR2
ICUNITColumn ICUNIT of table SYSIBM.SYSCOPY (DB2 on OS/390)D2ICUNITCHAR1
STYPEColumn STYPE of table SYSIBM.SYSCOPY (DB2 on OS/390)D2STYPECHAR1
PIT_RBAColumn PIT_RBA of table SYSIBM.SYSCOPY (DB2 on OS/390)D2PIT_RBACHAR20
GRP_MEMBERColumn GROUP_MEMBER of table SYSIBM.SYSCOPY (DB2 on OS/390)D2GRP_MBRCHAR8
LENGTHINT22
DSVOLSERColumn DSVOLSER of table SYSIBM.SYSCOPY (DB2 on OS/390)D2DSVOLSERLCHR1784
Privacy Policy