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 |