Storage set table (ARSSET)

This table maintains a catalog of storage sets.

Table 1. Storage set table (ARSSET)
Column Name Data Type Description
sid INTEGER Storage set identifier
name VARCHAR(60) Name of storage set
description VARCHAR(120) Description of storage set
load_type CHAR(1) FOR BIT DATA (DB2®), BINARY(1) (SQL Server), RAW(1) (Oracle) Type of load
upd_userid VARCHAR(128) Userid of last user to update storage set
upd_date BIGINT (DB2, SQL Server), INT (Oracle) Date and time storage set was last updated (in old style)
upd_dt TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) Date and time storage set was last updated
Table 2. Indexes for storage set table (ARSSET)
Index name Columns in index Type of index
arsset_name_idx name Unique index
arsset_sid_idx sid Unique cluster index for DB2; Unique index for Oracle and SQL Server