COGIPF_NATIVEQUERY Table

Stores information about queries that IBM® Cognos® software makes to other components.
Table 1. COGIPF_NATIVEQUERY 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

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)

VARCHAR2 (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_REQUESTSTRING

The query request string made to other components

NTEXT (1G)