Resources table (ARSRES)

This table maintains a catalog of AFP resources.

Table 1. Resources table (ARSRES)
Column Name	Data Type	Description
rid	INTEGER	Resource identifier
agid	INTEGER	Application group identifier
pri_nid	SMALLINT	Primary storage node identifier
sec_nid	SMALLINT	Secondary storage node identifier
comp_type	CHAR(1) FOR BIT DATA (DB2®), BINARY(1) (SQL Server), RAW(1) (Oracle)	Method of compression
add_date	BIGINT	Date and time (in old style) that the resource was loaded into the system
comp_size	INTEGER	Compressed size
decomp_size	INTEGER	Decompressed size
exp_date	BIGINT (DB2, SQL Server), INT (Oracle)	Expiration date (in old style)
hold	SMALLINT	Whether or not on hold
add_dt	TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server)	Date and time that the resource was loaded into the system
exp_dt	TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server)	Expiration date

Table 2. Indexes for resources table (ARSRES)
Index name	Columns in index	Type of index
arsres_idx	agid, rid	Unique cluster index