DB2 10.5 for Linux, UNIX, and Windows

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 catalogued 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.