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 for Db2; Index for Oracle and SQL Server |
| arsload_name_idx |
agid, name |
Index |
| arsload_dt_idx |
agid, exp_dt |
Index |