This table maintains a catalog of documents to holds.
Table 1. Hold mapping table (ARSHOLDMAP)
| Column Name |
Data Type |
Description |
| hid |
INTEGER |
Hold identifier |
| agid |
INTEGER |
Application group identifier |
| aid |
INTEGER |
Application identifier |
| hold_type |
CHAR(1) FOR BIT DATA (Db2®), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Hold type |
| name |
VARCHAR(11) |
Document object name |
| doc_off |
INTEGER |
Document offset |
| doc_len |
INTEGER |
Document length |
| comp_off |
INTEGER |
Document compression offset |
| comp_len |
INTEGER |
Document compression length |
| res_id |
INTEGER |
Document resource identifier |
Table 2. Indexes for hold mapping table
(ARSHOLDMAP)
| Index name |
Columns in index |
Type of index |
| arsholdmap_idx |
hid, agid, aid, name, doc_off, doc_len, comp_off, comp_len |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |