DATALOADER_HEALTH
The DATALOADER_HEALTH table is used to store the data loader's health information.
| Column name | Data type | Null (Y or N) | Key (PK or FK) | Comment |
|---|---|---|---|---|
| DATALOADER_NAME | VARCHAR(128) | N | PK | The name of data loader. |
| DATALOADER_TYPE | VARCHAR(20) | N | PK | Normal loader or data loader recovery type. |
| HOST_NAME | VARCHAR(128) | N | PK | The name of the host name on which the loader controller runs. |
| INSERT_SEQ | BIGINT | N | Not applicable | The order of sequence in which this record is inserted into the table. This field is auto-incremented whenever a new record is inserted into the table. |
| LAST_UPDATED_TIME | NUMERIC(13) | Y | Not applicable | Last running time obtained from the data loader. |
| PLC_ID | VARCHAR(20) | N | PK | The loader controller instance ID. |
| READ_COUNT | NUMERIC(15) | Y | Not applicable | Reserved for future use. |
| SAMPLE_INTERVAL | NUMERIC(15) | Y | Not applicable | Sampling interval of the data loader in milliseconds. |
| TIME_STAMP | TIMESTAMP | N | Not applicable | The record sample time in the local cluster time zone. |
| TIME_STAMP_GMT | NUMERIC(13) | N | PK | The record sample time in the GMT time zone. This is the number of milliseconds from midnight, 1 January, 1970. |
| WRITTEN_COUNT | NUMERIC(15) | Y | Not applicable | Reserved for future use. |