SYSCAT.USAGELISTS catalog view
Each row represents a usage list for a table or index object.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
USAGELISTSCHEMA | VARCHAR (128) | Schema of the usage list. | |
USAGELISTNAME | VARCHAR (128) | Name of the usage list. | |
USAGELISTID | INTEGER | Identifier for the usage list. | |
OBJECTSCHEMA | VARCHAR (128) | Schema name of the object for which the usage list is defined. | |
OBJECTNAME | VARCHAR (128) | Unqualified name of the object for which the usage list is defined. | |
OBJECTTYPE | CHAR (1) | The type of the object for which this usage list is defined.
|
|
STATUS | CHAR (1) | The status of the usage list.
|
|
MAXLISTSIZE | INTEGER | The maximum number of entries in the usage list. | |
WHENFULL | CHAR (1) | Action to be performed when the usage list is full.
|
|
AUTOSTART | CHAR (1) | Indicates whether this usage list is to be activated automatically
when the database starts.
|
|
ACTIVEDURATION | INTEGER | Reserved for future use. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |