Load table (ARSLOAD)

Use this table to track loads for expiration by load. This table maintains a record of all successful loads to application groups with the "expire by load" expiration type.

Table 1. Load table (ARSLOAD)
Column Name	Data Type	Description
agid	INTEGER	Application group identifier
pri_nid	SMALLINT	Primary storage node identifier
sec_nid	SMALLINT	Secondary storage node identifier
name	VARCHAR(11)	Name of load
start	BIGINT (DB2®, SQL Server), INT (Oracle)	Start date in segment
stop	BIGINT (DB2, SQL Server), INT (Oracle)	Stop date in segment
exp_date	BIGINT (DB2, SQL Server), INT (Oracle)	Expiration date
aid	INTEGER	Application ID
total_docs	INTEGER	Number of documents in load
start_dt	TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server)	Start date
stop_dt	TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server)	Stop date
exp_dt	TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server)	Expire date

Table 2. Indexes for load table (ARSLOAD)
Index name	Columns in index	Type of index
arsload_idx	agid, exp_date	Cluster index
arsload_name_idx	agid, name	Index
arsload_dt_idx	agid, exp_dt	Index