Home | Previous Page | Next Page   System Catalog Tables >

SYSCOLATTRIBS (IDS)

The syscolattribs system catalog table describes the characteristics of smart large objects, namely CLOB and BLOB data types. It contains one row for each sbspace listed in the PUT clause of the CREATE TABLE statement.

Column Type Explanation
tabid INTEGER Code uniquely identifying the table
colno SMALLINT Number of the column that contains the smart large object
extentsize INTEGER Pages in smart-large-object extent, expressed in kilobytes
flags INTEGER Integer representation of the combination (by addition) of hexadecimal values of the following parameters:
LO_NOLOG
( 0x00000001 = 1)
The smart large object is not logged.
LO_LOG
( 0x00000010 = 2)
Logging of smart large objects conforms to current log mode of the database.
LO_KEEP_LASTACCESS_TIME
( 0x00000100 = 4)
A record is kept of the most recent access of this smart-large-object column by a user.
LO_NOKEEP_LASTACCESS_TIME
( 0x00001000 = 8)
No record is kept of the most recent access of this smart-large-object column by a user.
HI_INTEG
( 0x00010000= 16)
Data pages have headers and footers to detect incomplete writes and data corruption.
MODERATE_INTEG
(Not available at this time)
Data pages do not have headers and footers.
flags1 INTEGER Reserved for future use
sbspace VARCHAR(128) Name of the sbspace

A composite index on the tabid, colno, and sbspace columns allows only unique combinations of these values.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]