This table maintains a catalog of FTI work.
Table 1. FTI work table (ARSFTIWORK)
| Column Name |
Data Type |
Description |
| agid |
INTEGER |
Application group identifier |
| name |
VARCHAR(11) |
Load name |
| type |
INTEGER |
Work type |
| status |
INTEGER |
Work status |
| time_stamp_dt |
TIMESTAMP (Db2®, Oracle), DATETIME2(6) (SQL Server) |
Timestamp of work |
| 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 |
Table 2. Indexes for FTI work table
(ARSFTIWORK)
| Index name |
Columns in index |
Type of index |
| arsftiwork_idx |
agid, name |
Index |