SCHBRDCST

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

Column Descriptions:

NameTypeDescription
JOBREFNUMBIGINT NOT NULLJob reference number.
JOBSTATECHAR (2) NOT NULLState of this broadcast job. Valid values are as follows:
  • R=running
  • C=complete
  • CF=complete fail
PREFSTARTTIMETIMESTAMP NOT NULLPreferred start time for this broadcast job.
ACTLSTARTTIMETIMESTAMPActual start time for the command for this clone.
ENDTIMETIMESTAMPCommand end time.
RESULTCHAR (1)Job result. Valid values are as follows:
  • S=successful
  • F=failed
EXCEPTIONCODEVARCHAR (254)Command exception code.
CLONEIDVARCHAR (256) NOT NULLClone ID. This is the instance name defined for Request Servlet initialization.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>JOBREFNUM+CLONEIDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_735JOBREFNUMSCHCONFIGSCCJOBREFNUMCascade