Hold mapping table (ARSHOLDMAP)

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