The staffo table holds information about
outstanding steps, that is, steps that have been delivered to work queues but not yet released (or otherwise removed).
The staffo table is structured as follows:
TABLE staffo(
ROWID NUMERIC(15) NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 50),
o_flags INTEGER ,
o_queuename VARCHAR(24) ,
o_locker VARCHAR(24) ,
o_username VARCHAR(49) ,
o_startname VARCHAR(49) ,
o_dirname VARCHAR(12) NOT NULL,
o_dirdesc VARCHAR(24) ,
o_procname VARCHAR(8) NOT NULL,
o_procdesc VARCHAR(24) ,
o_casedesc VARCHAR(24) ,
o_casenum NUMERIC(20) ,
o_placeno INTEGER ,
o_dirflags INTEGER ,
o_procflags INTEGER ,
o_host VARCHAR(24) NOT NULL,
o_pnum INTEGER NOT NULL,
o_pnumcount INTEGER NOT NULL,
o_caseptr NUMERIC(20) ,
o_reqidhost VARCHAR(24) NOT NULL,
o_reqid NUMERIC(20) NOT NULL,
o_deadline TIMESTAMP ,
o_reqstamp TIMESTAMP ,
o_qparam1 VARCHAR(24) ,
o_qparam2 VARCHAR(24) ,
o_qparam3 VARCHAR(12) ,
o_qparam4 VARCHAR(12) ,
o_itempriority VARCHAR(24) ,
o_priority_changed TIMESTAMP ,
o_majorvers INTEGER NOT NULL,
o_minorvers INTEGER NOT NULL)
|
|
|
|
|
|
|
Note: This column is not written to or updated unless the WIS_WRITELOCKS parameter in the SWDIR\etc\staffcfg file is set.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Nodename of the node where the o_reqid is generated, as defined in the nodes table.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
base: increment: number: period: type
•
|
base is the base priority value for this work item.
|
•
|
increment is the amount that will be added to the item’s priority value whenever the period expires.
|
•
|
number is the number of increments that will be added to the item’s priority value.
|
•
|
period is the time period, in the units specified in type, which must expire before the item’s priority value is incremented.
|
•
|
type is the unit of measure of the period, either “ M” or “ m” for minutes, “ H” or “ h” for hours or “ D” or “ d” for days.
|
|
|
|
|
|
|
|
The staffo table contains one row for every outstanding step on the system.