Sun Microsystems iPlanet Integration Server 3.0, Process System Manual

Page: 331 / 368

Database Schema Reference
Appendix B Engine Database Schema 331
Database Schema Reference
This section provides an annotated description of all the tables created and
maintained by an iIS process engine. The iIS process engine automatically creates
these tables when the engine is cold started and maintain their contents during
normal operations. You can use the information provided here to write queries
against the tables for management information on current and past process
instances. However, you should avoid altering the rows in the tables (with the
exception of periodically flushing history tables of rows that are no longer needed).
Some tables are for internal use only, and are unlikely to be useful for any
management queries. The documentation on these tables is limited.
The data type description for each entry in a table is based on the representation
used in Oracle databases. The actual data type may differ, depending on the
database vendor you are using.
WFHSessionRole page 344 Current client sessions and their roles. If a
session has multiple roles, this table has a
separate row for each role.
WFHTerminatedProcs page 344 Internal use only. Managed by the engine to
track aborted synchronous subprocesses.
WFHTermProcParas page 345 Internal use only. Managed by the engine to
track output parameters from aborted
synchronous subprocesses.
WFHTimer page 345 Timer instances currently instantiated in the
engine.
WFHTimerLog page 355 Log of timer instances that have been
instantiated in the engine.
WFHTimerStateLog page 356 Log of the state of timer instances for the engine.
NOTE The schema presented here may differ from the schema for previous
versions of iIS. Also, the schema is subject to further change in
future versions.
Table B-1
Engine Database Tables (Continued)
Database Table See… Description