SYSCAT.USAGELISTS catalog view

Each row represents a usage list for a table or index object.

Table 1. SYSCAT.USAGELISTS Catalog View
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.
  • I = Index
  • T = Table
STATUS CHAR (1)   The status of the usage list.
  • I = Invalid
  • V = Valid
MAXLISTSIZE INTEGER   The maximum number of entries in the usage list.
WHENFULL CHAR (1)   Action to be performed when the usage list is full.
  • D = Deactivate collection
  • W = Wrap
AUTOSTART CHAR (1)   Indicates whether this usage list is to be activated automatically when the database starts.
  • N = Manual start
  • Y = Autostart
ACTIVEDURATION INTEGER   Reserved for future use.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.