You can set the log level in Integration Services by using the -L startup switch.
You can set minimum and maximum log file sizes.
For information about Integration Services startup switches, see the Oracle Essbase Integration Services System Administrator's Guide.
To set the level of message in Integration Services logs:
On Windows, add -Llevel to startup.bat.
On UNIX, enter -Llevel when you start Integration Server.
On any platform, add -Llevel to ais.cfg.
The default level is 2. You can specify these levels:
Table 15 provides a list and description of the different log levels you can specify.
Table 15. Possible Log Levels
| Level | Description |
|---|---|
| 0 | To log all debug messages and the ODBC SQL generated by Integration Server: Generate dataloadrecord.txt, listing the first 1,000 records, which may include successfully loaded records and rejected records; and create hisdld.rul, consisting of the names of the dimensions loaded followed by the leaf node number of each dimension or member. |
| 2 | Log all informational messages and some of the ODBC SQL generated by Integration Server. |
| 3 | Log all warnings. |
| 4 | Log all noncritical errors. |
| 7 | Log all critical errors where Integration Server terminates the command. |
| 8 | Log all critical server errors. |
The recommended level setting is 2 or 3.
After changing log levels, you must restart the Integration Services server for the log settings to take effect.