WebSphere Commerce database table: SCHBRDCST

This table is used to log the status of broadcast commands for each of the clones.


Column Description(s):
Column NameColumn TypeDescription
JOBREFNUM BIGINT NOT NULL Job reference number.
JOBSTATE CHAR(2) NOT NULL State of this broadcast job. Valid values are as follows:
  • R=running
  • C=complete
  • CF=complete fail
PREFSTARTTIME TIMESTAMP NOT NULL Preferred start time for this broadcast job.
ACTLSTARTTIME TIMESTAMP Actual start time for the command for this clone.
ENDTIME TIMESTAMP Command end time.
RESULT CHAR(1) Job result. Valid values are as follows:
  • S=successful
  • F=failed
EXCEPTIONCODE VARCHAR(254) Command exception code.
CLONEID CHAR(32) NOT NULL Clone ID. This is the instance name defined for Request Servlet initialization.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031309700 JOBREFNUM+CLONEID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_735 JOBREFNUM SCHCONFIG SCCJOBREFNUM Cascade

Feedback