Log Details window -- Read-only fields

General information

Step name

Step type

Process name

Run ID

Record number

Date/Time

Message type

Server host name

Detail information

Host site

EXE name

Method name

Error domain

SQL state

Error return code 1

Error return code 2

General information

Read-only area shows the information that is contained in the selected log record in the Log window:

Step name

Shows the name of the step edition. If an action is not directly related to edition processing, such as for logging on to the Data Warehouse Center, then the field is empty.

Step type

Shows the step type for the step edition: DB2 programs, DB2 OLAP Server programs, File programs, SQL, Statistical transformers, User-defined programs, and Warehouse transformers.

Process name

Shows the process name that the step belongs to.

Run ID

Shows the identifier for the step edition.

Record number

Shows the record number of the log record.

Date/Time

Shows the date and time at which the log record was written to the log.

Message type

Shows the log message type, which identifies the event or error that occurred.

Server host name

Shows the TCP/IP host name of the workstation on which the server is installed.

Detail information

Read-only area shows additional data about the event that is represented by the message type.

The fields that are displayed vary according to the message type. The following sections are examples of the fields for the most common message types.

Host site

Shows the the TCP/IP host name of the workstation where the executable program ran.

EXE name

Shows the name of the program that encountered the error, the full path name of the program, and any other command-line arguments that were passed to the program.

Method name

Shows the name of the program class and method that encountered the error. This field is primarily for the use of IBM Software Support.

Error domain

Shows the subsystem that originally encountered the error, such as Windows 32, Sockets, ODBC, or the Data Warehouse Center.

SQL state

If an error occurred during execution of an SQL statement, this read-only field shows SQLSTATE code that corresponds to the SQL statement.

Error return code 1 (Error RC1)

Shows the unique Data Warehouse Center return code for the error. Each message is documented in the form IWH0nnnn, where nnnn is the number that is displayed in the Error RC1 field. See the messages book in the BOOKS directory of the CD-ROM for a description of the error.

Error return code 2 (Error RC2)

Shows the return code that is issued by the subsystem (displayed in Error Domain) that originally encountered the error. Each message is documented in the form IWH0nnnn, where nnnn is the number that is displayed in the Error RC2 field.