Operations database schema reference

The operations database stores the monitoring data that is displayed by the IBM® InfoSphere® DataStage® and QualityStage® Operations Console.

Operations database

The operations database stores information about all job runs on the systems being monitored. It also stores information about the system resource usage on those systems.

Column types

Because multiple database systems are supported by IBM InfoSphere Information Server, and because column types vary across database systems, column type codes are used to describe the columns in the tables in the operations database.

The column type codes used the table descriptions are explained in Table 1.

Table 1. Column types
Column type code Description DB2® Oracle Microsoft SQL Server
SK Surrogate Key BIGINT NUMBER (19, 0) BIGINT
Int Integer INTEGER NUMBER (11, 0) INT
Txt Large text string1 DBCLOB(512M) CLOB NTEXT
XML column held as an XML structure XML XMLTYPE XML
Ref Reference key2, 3 CHAR(3) CHAR(3) CHAR(3)
n Variable length string, maximum length n3 VARGRAPHIC(n) VARCHAR2(n) NVARCHAR(n)
p,s Decimal precision and scale DECIMAL(p,s) DECIMAL(p,s) DECIMAL(p,s)
Bool Boolean, held as an integer where 1 means TRUE, and 0 or null mean FALSE SMALLINT NUMBER(6,0) SMALLINT

1 Text strings use the LINEFEED (LF) character (U+001A) for line separators.

2 All timestamps are stored in Coordinated Universal Time (UTC) in the operations database. The HostDetail table stores information about the time zone setting for a particular system.

3 If text is longer than the maximum column length, it is shortened by replacing characters in the middle of the string by an ellipsis (...).