This table is used to log the status of broadcast commands for each of the clones.
Column Name | Column Type | Column Description |
---|---|---|
ACTLSTARTTIME | TIMESTAMP NULL |
Actual start time for the command for this clone. |
CLONEID | CHARACTER (32) NOT NULL |
Clone ID. This is the instance name defined for Request Servlet initialization. |
ENDTIME | TIMESTAMP NULL |
Command end time. |
EXCEPTIONCODE | VARCHAR (254) NULL |
Command exception code. |
JOBREFNUM | BIGINT NOT NULL |
Job reference number. |
JOBSTATE | CHARACTER (2) NOT NULL |
State of this broadcast job. Valid values: R=running, C=complete, CF=complete fail. |
PREFSTARTTIME | TIMESTAMP NOT NULL |
Preferred start time for this broadcast job. |
RESULT | CHARACTER (1) NULL |
Job result. Valid values: S=success, F=fail. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035101130 | JOBREFNUM, CLONEID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_735 | JOBREFNUM | SCHCONFIG | SCCJOBREFNUM | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|