COGIPF_RUNJOB Table

Stores information about job runs.
Table 1. COGIPF_RUNJOB table columns, descriptions, and data types

Column name

Description

Data type

COGIPF_HOST_IPADDR

The host IP address where the log message is generated

VARCHAR (128)

COGIPF_HOST_PORT

The host port number

INTEGER

COGIPF_PROC_ID

The process ID assigned by the operating system

INTEGER

COGIPF_LOCALTIMESTAMP

The local date and time when the log message was generated

While the report is executing, this is the time that the report execution started. After the report execution is complete, this is the end time of report execution.

To check if execution is complete, see COGIPF_STATUS. A blank entry means an incomplete execution. A filled entry means execution completed.

To calculate the execution start time for a report that has already completed execution, subtract COGIPF_RUNTIME from COGIPF_LOCALTIMESTAMP.

TIMESTAMP

COGIPF_TIMEZONE_OFFSET

The time zone, offset from GMT

INTEGER

COGIPF_SESSIONID

The alphanumeric identification of the user session

VARCHAR (255)

COGIPF_REQUESTID

The alphanumeric identification of the request

VARCHAR (255)

NOT NULL

COGIPF_STEPID

The alphanumeric identification for the step within a job run (empty if there is none)

VARCHAR (255)

COGIPF_SUBREQUESTID

The alphanumeric identification of the component subrequest

VARCHAR (255)

COGIPF_THREADID

The alphanumeric identification of the thread where the request is run

VARCHAR (255)

COGIPF_COMPONENTID

The name of the component that generates the indication

VARCHAR (64)

COGIPF_BUILDNUMBER

The major build number for the component that generates the indication

INTEGER

COGIPF_LOG_LEVEL

The level of the indication

INTEGER

COGIPF_TARGET_TYPE

The object on which the operation is run

VARCHAR (255)

COGIPF_JOBPATH

The job path

VARCHAR (512)

COGIPF_STATUS

The status of the operation: blank, success, warning, or failure

VARCHAR (255)

COGIPF_ERRORDETAILS

Error details

VARCHAR (2000)

COGIPF_RUNTIME

The number of milliseconds it took the job to run

INTEGER