COGIPF_RUNREPORT Table

Stores information about report runs.

Table 1. COGIPF_RUNREPORT 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.

The values include:

  • Report ReportService is an interactive report
  • PromptForward ReportService is a report generated after a prompt
  • PromptBackward ReportService is a report generated after the user moved to the previous prompt page
  • Report BatchReportService is a batch or scheduled run report

    Note: The value of this column is expressed in two parts: the object type of execution and from which service the report is run, for example "Report ReportService" and "Query BatchReportService".

VARCHAR (255)

COGIPF_REPORTPATH

The report path

VARCHAR (1024)

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 report to run

INTEGER

COGIPF_REPORTNAME

The name of the report that was run

VARCHAR (512)

COGIPF_PACKAGE

The package that the report is associated with

VARCHAR (1024)

COGIPF_MODEL

The model that the report is associated with

VARCHAR (512)