This table maintains a catalog of distributions that have
been scheduled for processing.
Table 1. Distribution request table (ARSDFDRT)
Column Name |
Data Type |
Description |
DRT_RECIPIENT |
VARCHAR(60) |
Recipient name |
DRT_DIST_NAME |
VARCHAR(60) |
Distribution name |
DRT_ORIGINATOR |
VARCHAR(8) |
Identifier who scheduled the distribution |
DRT_CREATE_DT |
TIMESTAMP |
Timestamp when the distribution request
was created |
DRT_PROCESS_DT |
TIMESTAMP |
Timestamp when the distribution request
was processed |
DRT_COMPLETE_DT |
TIMESTAMP |
Timestamp when the distribution request
completed |
DRT_STATUS |
INTEGER(4) |
Status of distribution request |
DRT_CONT_ATTEMPTS |
INTEGER(4) |
Number of continuation attempts made |
DRT_REPRINT |
INTEGER(4) |
Reprint indicator |
Table 2. Indexes for distribution request table (ARSDFDRT)
Index name |
Columns in index |
Type of index |
ARSDFDRT_IDX1 |
DRT_RECIPIENT, DRT_DIST_NAME |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |
ARSDFDRT_IDX2 |
DRT_DIST_NAME |
Unique index |