This table maintains a catalog of hold work.
Table 1. Hold work table (ARSHOLDWORK)
| Column Name |
Data Type |
Description |
| agid |
INTEGER |
Application group identifier |
| aid |
INTEGER |
Application identifier |
| name |
VARCHAR(11) |
Load name |
| type |
INTEGER |
Work type |
| status |
INTEGER |
Work status |
| time_stamp |
BIGINT (Db2®, SQL Server), INT (Oracle) |
Timestamp of work (in old style) |
| time_stamp_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Timestamp of work |
Table 2. Indexes for hold work table
(ARSHOLDWORK)
| Index name |
Columns in index |
Type of index |
| arsholdwork_idx |
agid, aid, name |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |