CFS-CMOD work table (ARSCFSODWORK)

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