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 for Db2; Unique index for Oracle and SQL Server |