This table maintains a catalog of OnDemand documents that
are available for distribution.
Table 1. Document status table (ARSDFDST)
| Column Name |
Data Type |
Description |
| DST_RECIPIENT |
VARCHAR(60) |
Recipient name |
| DST_DIST_NAME |
VARCHAR(60) |
Distribution name |
| DST_REPORTID |
VARCHAR(60) |
Report ID |
| DST_APPLGRP_NAME |
VARCHAR(60) |
Application group name |
| DST_APPL_NAME |
VARCHAR(60) |
Application name |
| DST_AGID |
INTEGER(4) |
Application group ID |
| DST_AID |
INTEGER(4) |
Application ID |
| DST_LOADID |
VARCHAR(128) |
Load ID |
| DST_LOAD_SIZE |
BIGINT(8) |
Number of bytes loaded |
| DST_RID |
INTEGER(4) |
Resource ID |
| DST_RES_SIZE |
BIGINT(8) |
Resource size |
| DST_CREATE_DT |
TIMESTAMP |
Timestamp when the document entry was created |
| DST_PROCESS_DT |
TIMESTAMP |
Timestamp when the document distribution
was processed |
| DST_COMPLETE_DT |
TIMESTAMP |
Timestamp when the document distribution
completed |
| DST_STATUS |
INTEGER(4) |
Status |
Table 2. Indexes for document status table (ARSDFDST)
| Index name |
Columns in index |
Type of index |
| ARSDFDST_IDX1 |
DST_RECIPIENT, DST_DIST_NAME, DST_REPORTID |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |