Job run audit data tables and views
The audit data tables for job runs contain information about the IBM® InfoSphere® DataStage® and QualityStage® jobs that are currently running or that have finished running.
- JobRun table
The JobRun table contains details of all job runs. - JobExec table
The JobExec table contains details of the job versions used by the job runs in the JobRun table. - Host table
The Host table contains details of engine systems where jobs are started, and of remote nodes used by an engine system to distribute parallel jobs. - JobRunParams table
The JobRunParams table contains the parameters used for each job runs in the JobRun table, stored as an XML fragment. - JobRunParamsView view
The JobRunParamsView view expands the ParamList column of the JobRunParams table. The JobRunParamsView view expands the parameter names and values individually, for all job runs in the JobRun table. - JobRunLog table
The JobRunLog table contains all the events that are emitted by the job runs in the JobRun table that match the monitoring configuration settings. - ParallelConfig table
The ParallelConfig table contains details of every engine in each parallel job configuration file that has been used in a job run and that contains a unique set of physical and logical nodes, stored as an XML fragment. - ParallelConfigNodes view
The ParallelConfigNodes view expands the NodeList column of the ParellelConfig table. The ParallelConfigNodes view shows details of every engine in each parallel job configuration file that has been used in a job run and that contains a unique set of physical and logical nodes, shown as individual physical nodes.
Parent topic: Operations database schema reference