This table is a catalog of work between Content Manager OnDemand and CFS-CMOD.
Table 1. CFS-CMOD work table
Column Name |
Data Type |
Description |
agid |
INTEGER |
Application group identifier |
name |
VARCHAR(11) |
Load identifier |
type |
INTEGER |
Type of work |
status |
INTEGER |
Status of work |
time_stamp |
BIGINT (Db2®, SQL
Server), INT (Oracle) |
Timestamp of work (in old style) |
misc_comp_type |
CHAR(1) FOR BIT DATA (Db2), BINARY(1) (SQL Server), RAW(1) (Oracle) |
Compression type of misc |
misc_info |
BLOB(10485760) (Db2),
VARBINARY(MAX) (SQL Server), BLOB (Oracle) |
Work information |
time_stamp_dt |
TIMESTAMP (Db2,
Oracle), DATETIME2(6) (SQL Server) |
Timestamp of work |
Table 2. Indexes for CFS-CMOD work table
Index name |
Columns in index |
Type of index |
arscfsodwork_idx |
agid, name |
Cluster index for Db2; Index for Oracle and SQL Server |