Database Table: SCHBRDCST

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035101130 JOBREFNUM, CLONEID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_735 JOBREFNUM SCHCONFIG SCCJOBREFNUM Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable