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 |