Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Installation and Configuration Guide > NQSConfig.ini File Reference > Parameter and Syntax Descriptions >

Parameters in the Server Query Statistics Section

---

When usage tracking is enabled, the server query statistics parameters define default values for the collection of more detailed statistics for logical queries, as well as for physical queries issued by the Siebel Analytics Server to back-end databases. Some of this information is collected when usage tracking is enabled; the server query statistics provide more detailed information.

The name of the file that holds the server query statistics is NQQueryStats.log, located in the QueryStats subdirectory in the Siebel Analytics software installation directory. Entries in the NQQueryStats.log file can be viewed using a text editor such as Windows Notepad.

For more information about usage tracking, see the chapter on administering the query environment in Siebel Analytics Server Administration Guide.

STORAGE_DIRECTORY

Specifies the full path to the directory used to store server query statistics log files. The directory listed needs to be a valid fully-qualified, writable directory pathname, with double quotes ( " ) surrounding the pathname. Specify mapped directories only. UNC path names and network mapped drives are allowed only if the service runs under a qualified user account. To change the account under which the service is running, see To change the account under which a Windows service runs. Valid values are any fully qualified pathname to an existing, writable directory.

NOTE:  Do not specify the same directory used to store usage tracking statistics.

Example: STORAGE_DIRECTORY = "C:\SiebelAnalytics\QueryStats";

FILE_NAME

This specifies the name of the file used to hold server query statistics. The default isNQQueryStats.log.

Example: FILE_NAME = NQQueryStats.log;

FILE_SIZE

Specifies the size to which the NQQueryStats.log file is allowed to grow. When this limit is reached, the log file closes and logging ceases. Specify KB for kilobytes, MB for megabytes, and no units for bytes. The default is 100 MB.

Example: FILE_SIZE = 100 MB;

DATE_TIME_OUTPUT_FORMAT

Specifies the output format for timestamps. The default value is
yyyy-mm-dd-hh-mi-ss. Enclose the value in double quotes.

Example: DATE_TIME_OUTPUT_FORMAT = "yyyy-mm-dd hh:mi:ss";

SYSTEM_LEVEL_CONTROL

This parameter determines whether and what kind of server query statistics will be collected.

Valid values are:

OFF	No statistics are collected for any queries. This is the default value.
ON	Statistics are collected for all queries.
IGNORE	Statistics are collected for some queries, depending on user or group settings.

Example: SYSTEM_LEVEL_CONTROL = OFF ;

CODE_PAGE

For multilingual repositories, this specifies the type of output code page to use when writing statistics to disk. The type depends upon the database loader being used. For example, to support multilingual repositories for database loaders used by Oracle and DB2, specify UTF-8. SQL Server uses the Microsoft BCP loader utility, which accepts UCS-2 data. Valid values include ANSI, UTF-8, UCS-2, 1252, and other globally recognized output code page types. Enclose the value in double quotes. The default value is ANSI.

Example: CODE_PAGE = "ANSI";

Bookshelf Home | Contents | Index | Search | PDF