IBM Tivoli Netcool/OMNIbus, Version 7.4

Logging information to ObjectServer files (WRITE INTO command)

Use the WRITE INTO command to write logging information to ObjectServer files. For example, you can use the command to write output from a trigger to a log file. An ObjectServer file is a logical file, which has a corresponding file or set of files on the physical file system.

The files have a defined maximum size. When this size is reached, a new file is created. There is a maximum number of files. When the maximum size and maximum number of files are exceeded, the files are rotated. During file rotation, do not open the log files with exclusive write access (for example, by using Microsoft Excel), because the ObjectServer cannot rotate the files.

Syntax

WRITE INTO file_name [ VALUES ] (expression, ...);

A carriage return follows each message.

Example

The following command adds a message to the physical file associated with the ObjectServer file file1 each time a user connects to a database.

WRITE INTO file1 VALUES 
('User', %user.user_name, 'connected to the system at', getdate );

The %user.user_name user variable used in this example is only available in procedures and triggers.