SYSCAT.MEMBERSUBSETS catalog view

Each row represents a member subset.

Table 1. SYSCAT.MEMBERSUBSETS Catalog View
Column Name Data Type Nullable Description
SUBSETNAME VARCHAR(128)   Name of subset.
SUBSETID INTEGER   Subset identifier.
CREATE_TIME TIMESTAMP   Time at which subset was defined.
ALTER_TIME TIMESTAMP   Time at which subset was last altered.
ENABLED CHAR(1)   State of the member subset.
  • N = subset is currently disabled
  • Y = subset is currently enabled
MEMBERPRIORITYBASIS CHAR(1)   Basis for member priorities:
  • E = Equal priorities
  • L = Member load
INCLUSIVESUBSET CHAR(1)   Inclusiveness of member subset:
  • N = The member subset is not inclusive
  • Y = The member subset is inclusive
ALTERNATESERVER CHAR(1)   Alternate server's inclusion in the member subsets server list:
  • N = The alternate server is not included in the member subsets server list
  • Y = The alternate server is included in the member subsets server list
CATALOGDATABASEALIAS CHAR(1)   Database alias cataloged for member subset:
  • N = No database alias cataloged explicitly for this member subset
  • Y = Database alias cataloged explicitly for this member subset
REMARKS VARCHAR(254) Y User provided comments, or the null value.