HSURDSYC

The HSURDSYC table is used for SYSTABLESPACE views. The following table describes the columns in the HSURDSYC table:

Column Type Length Decimal Domain
DBNAME CHAR 24 0 Name of the database
TSNAME CHAR 24 0 Name of the target table space or index space
DSNUM INTEGER 4 0 Data set number within the table space
ICTYPE CHAR 1 0 Type of operation
ICDATE CHAR 6 0
START_RBA CHAR 6 0 A 48-bit positive integer that contains the LRSN of a point in the DB2 recovery log
FILESEQNO INTEGER 4 0 Tape file sequence number of the copy
DEVTYPE CHAR 8 0 Tape file sequence number of the copy
IBMREQD CHAR 1 0
DSNAME CHAR 44 0 Contains the data set name. Otherwise, DSNAME contains the name of the database and table space or index space in the form
ICTIME CHAR 6 0
SHRLEVEL CHAR 1 0 SHRLEVEL parameter on COPY
DSVOLSER VARCHAR 1784 0 The volume serial numbers of the data set
TIMESTAMP TIMESTAMP 26 0 The date and time when the row was inserted
ICBACKUP CHAR 2 0 Specifies the type of image copy contained in the data set
ICUNIT CHAR 8 0 Indicates the media that the image copy data set is stored on
STYPE CHAR 1 0
PIT_RBA CHAR 6 0
GROUP_MEMBER CHAR 8 0 The DB2 data sharing member name of the DB2 subsystem that performed the operation
OTYPE CHAR 1 0 Type of object that the recovery information is for
LOWDSNUM INTEGER 4 0 Partition number of the lowest partition in the range for SYSCOPY records created for REORG and LOAD REPLACE for resetting a REORG pending status
HIGHDSNUM INTEGER 4 0 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