Reserved for HCL internal use. This table is used
to log the status of broadcast commands for each of the clones
Column Descriptions:
Name | Type | Description |
SRCH_SCHBRDCST_ID | BIGINT NOT NULL | Primary key |
JOBREFNUM | BIGINT NOT NULL | Job reference number |
CLONEID | VARCHAR (256) NOT NULL | This is the instance name defined for Request
Servlet initialization |
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:
|
EXCEPTIONCODE | VARCHAR (256) | Command exception code |
TENANT_ID | BIGINT NOT NULL DEFAULT 0 | The ID of the tenant in the multi-tenant
environment |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
P_0046 | SRCH_SCHBRDCST_ID | Primary Key |
I0001541 | JOBREFNUM+CLONEID | Unique Index |