SRCH_SCHBRDCST

Reserved for HCL internal use. This table is used to log the status of broadcast commands for each of the clones

Column Descriptions:

NameTypeDescription
SRCH_SCHBRDCST_IDBIGINT NOT NULLPrimary key
JOBREFNUMBIGINT NOT NULLJob reference number
CLONEIDVARCHAR (256) NOT NULLThis is the instance name defined for Request Servlet initialization
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 (256)Command exception code
TENANT_IDBIGINT NOT NULL DEFAULT 0The ID of the tenant in the multi-tenant environment
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
P_0046SRCH_SCHBRDCST_IDPrimary Key
I0001541JOBREFNUM+CLONEIDUnique Index