Bookshelf Home | Contents | Index | PDF |
Siebel Business Analytics Server Administration Guide > Administering the Query Environment > Administering the Query LogThe Analytics Server provides a facility for logging query activity at the individual user level. The query log file is named the NQQuery.log file. This file is in the Log subdirectory in the Siebel Analytics installation folder. Logging should be used for quality assurance testing, debugging, and troubleshooting by Oracle's Siebel Technical Support. In production mode, query logging is typically disabled. Analytics Server query logging is tracked at a user level. It will be a resource intensive process if you track the entire user community. For production systems, it is recommended that it be enabled for a very targeted user community only. Most users should have a log level of 0 (zero). It is recommended that you only test users when the user name clearly indicates it is a test user and have verified that query logging enabled. If logging is enabled for such users, it is recommended that they be given names such as sales_admin_with_logging, sales_dev_with_logging, or sales_test_with_logging, so that you can readily identify them. Even production administrator logins should not have query logging enabled because it could strain the available resources. You should also disable query logging for the following:
Configuring the Logging SystemThis section describes the logging system and includes information about setting the size of the query log, choosing a logging level, and enabling query logging for a user. Because query logging can produce very large log files, the logging system is turned off by default. It is sometimes useful, however, to enable logging to test that your repository is configured properly, to monitor activity on your system, to help solve performance problems, or to assist Technical Support. You need to enable logging on the system for each user whose queries you want logged. Controlling the Size of the Log FileThe parameter USER_LOG_FILE_SIZE in the User Log section of the NQSConfig.INI file determines the size of the NQQuery.log file. When the log file grows to one-half the size specified by the USER_LOG_FILE_SIZE parameter, the file is renamed to NQQuery.log.old, and a new log file is created automatically. (This helps to make sure that the disk space allocated for the log file does not exceed the size specified in the configuration file.) Only one copy of the old file is kept. You can set the file size as high as you like, limited only by the amount of space available on the device. If you change the value of the USER_LOG_FILE_SIZE parameter, you need to restart the Analytics Server (Siebel Analytics Server) for the change to take effect. For the syntax of the USER_LOG_FILE_SIZE parameter, see Siebel Business Analytics Platform Installation and Configuration Guide. Setting a Logging LevelYou can enable logging level for individual users; you cannot configure a logging level for a group. NOTE: A session variable overrides a user's logging level. For example, if the administrator has a logging level defined as 4 and a session variable logging level is defined as default 0 (zero) in the repository, the administrator's logging level will be 0. Set the logging level based on the amount of logging you want to do. In normal operations, logging is generally disabled (the logging level is set to 0). If you decide to enable logging, choose a logging level of 1 or 2. These two levels are designed for use by administrators. NOTE: Logging levels greater than 2 should be used only with the assistance of Technical Support. The logging levels are described in Table 31.
To disable a user's logging level Using the Log ViewerUse the Siebel Business Analytics log viewer utility nQLogViewer (or a text editor) to view the query log. Each entry in the query log is tagged with the user ID of the user who issued the query, the session ID of the session in which the query was initiated, and the request ID of the individual query. To run the nQlogViewer utility, open a Command window and type nqlogviewer [-u<user_ID>] [-f<log_input_filename>] You can also locate user IDs, session IDs and request IDs through the Session Manager. For more information, see Using the Session Manager. NOTE: Web administrators can view the query log using the Manage Sessions Web page. Interpreting the Log RecordsAfter you have logged some query information and started the log viewer, you can analyze the log. The log is divided into several sections, some of which are described in the next section. Log entries for levels 1 and 2 are generally self-explanatory. The log entries can provide insights to help DBAs in charge of the underlying databases tune them for optimum query performance. The query log can also help you check the accuracy of applications that use the Analytics Server. SQL RequestThis section lists the SQL issued from the client application. This can be used to rerun the query from the same application, or from a different application. General Query InformationThis section lists the repository, the business model, and the presentation catalog from which the query was run. You can use this information to provide statistics on query usage that could be used to set priorities for future application development and system management. Database QueryThis section of the log begins with an entry that reads Sending query to the database named <data_source_name>, where data_source_name is the name of the data source to which the Analytics Server is connecting. Multiple database queries can be sent to one or more data sources. Each query will have an entry in the log. The database query section has several uses. It records the SQL sent to the underlying databases; you can then use the logged SQL to run queries directly against the database for performance tuning, results verification, or other testing purposes. It allows you to examine the tables that are being queried to verify that aggregate navigation is working as you expect. If you understand the structure of the underlying database, it might also provide some insights into potential performance improvements, such as useful aggregate tables or indexes to build. Query StatusThe query success entry in the log indicates if the query completed successfully or if it failed. You can search through the log for failed queries to determine why they failed. For example, all the queries during a particular time period might have failed due to a database downtime. |
Siebel Business Analytics Server Administration Guide |