IBM Informix SQL Warehousing Tool, Version 11.70

Setting up the system logging service

You can specify the location and settings for the system log file in the Warehouse Administration Console. You can also then use the Warehouse Administration Console to view the system log files.

Before you begin

Log in to the Warehouse Administration Console. For example, from a Web browser, type: http://host_name:9080/ibm/warehouse.
Tip: If port number 9080 is already taken, you can find the default port number in the portdef.props file in the following location: WebSphere\AppServer\profiles\AppSrv01\properties. The default port number for the Warehouse Administration Console is specified by the WC_defaulthost property.

Procedure

To set up the system logging service:

  1. Navigate to Configuration and select System Logging Service. The Configure the System Logging Service window opens.
  2. Specify a directory and a file name for the system log file. You can use or modify the default log file (DS_System.log) and path.
  3. Specify the amount of detail that you want in the log by choosing a logging level:
    Logging level Description
    Error Runtime errors of considerable importance
    Warning Runtime events that are potential problems
    Information Runtime events of interest
    Debug Detailed information for debugging
    Trace Highly detailed information for debugging (uses a lot of system resources)
    Tip: The logging level that you select includes all higher-severity messages. For example, if you specify Information as your logging level, the system will write Information, Warning, and Error messages to the system log. If you specify Error, the system logging service will log only error messages.
  4. Enable a rolling file if you want the system logger to write to a rotating set of system log files rather than to write to a single file. If you specify a rolling file, you can also specify the size of the log and the number of files to use.
    Note: Log files that do not yet exist are not listed on the Manage Logs page. For example, if you specify a rolling log of three files, the system creates the first file and lists that first file on the Manage Logs page. When that file reaches the length limit, the system creates the second file and lists the first file and the second file on the Manage Logs page. And so on.

    Also, if you change the location of a log file and then restart the computer, the system lists only the active version of the file that is in the new location. To see the version of the file that is in the old location, you must open it from the directory in which it is stored.

What to do next

You can view the system log files in the Warehouse Administration Console from the Manage Logs page. You can specify the number of rows that you want to view from the file (the default view is the last 200 rows).


Feedback | Information roadmap | Examples exchange