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.
Column type code | Description | DB2® | Oracle | Microsoft SQL Server |
---|---|---|---|---|
SK | Surrogate Key | BIGINT | NUMBER (19, 0) | BIGINT |
Int | Integer | INTEGER | NUMBER (11, 0) | INT |
Big | BigInt | BIGINT | NUMBER (19, 0) | BIGINT |
Txt | Large text string1 | DBCLOB(512M) | CLOB | NTEXT |
XML | column held as an XML structure | XML | XMLTYPE | XML |
Tim | Timestamp2 | TIMESTAMP | TIMESTAMP | DATETIME |
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 (...).