The HSURDLIC table is used for DB2 table information and is populated during the phase one of the Life Cycle. The following table describes the columns in the HSURDLIC table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| FILLIB | CHARACTER | 128 | 0 | file library |
| FILNAME | CHARACTER | 128 | 0 | file name |
| TSNAME | CHARACTER | 24 | 0 | tablespace name |
| DBNAME | CHARACTER | 24 | 0 | database name |
| OBID | SMALLINT | 4 | 0 | OBID |
| FILTXT | CHARACTER | 50 | 0 | text |
| NUMREC | INTEGER | 9 | 0 | number of records |
| RECLEN | INTEGER | 5 | 0 | length of record |
| MCRECID | SMALLINT | 4 | 0 | machine/company ID |
| FILRECID | INTEGER | 9 | 0 | file ID |
| ODBNAME | CHARACTER | 128 | 0 | ODBC entry |
| TYPNAME | CHARACTER | 128 | 0 | ODBC database type name |
| NEWLVLID | CHARACTER | 24 | 0 | new level number |