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

Sample Initialization File

The following is a sample NQSConfig.ini file. The NQSConfig.ini file is located in the Config subdirectory in the Siebel Analytics software installation directory. For detailed explanations of the parameters, read Parameter and Syntax Descriptions. This sample shows the file as it appears in the Windows environment. All parameter explanations are targeted towards the Windows environment.

###############################################################
#
# NQSConfig.ini
#
# Copyright (c) 2002 Siebel Systems, Inc.
#
# INI file parser rules are:
# If values are in literals, digits or _, they can be
# given as such. If values contain characters other than
# literals, digits or _, values must be given in quotes.
#

###############################################################
#
# Repository Section
#
# Repositories are defined as logical repository
# name - file name pairs. ODBC drivers use logical
# repository name defined in this section.
#
# All repositories must reside in
# SiebelAnalytics_dir\Repository directory, where
# SiebelAnalytics_dir is the directory in which the Siebel Analytics
# software is installed.
#

###############################################################

[ REPOSITORY ]

Star = SiebelAnalytics.rpd, DEFAULT ;

###############################################################
#
# Cache Section
#

###############################################################

[ CACHE ]

ENABLE = NO;
// A comma separated list of <directory maxSize> pair(s)
// e.g. DATA_STORAGE_PATHS = "d:\siebel\data\nqscache" 300 MB;
DATA_STORAGE_PATHS = "<full directory path>" 0;
METADATA_FILE = "<full file path>";
REPLACE_ALGORITHM = LRU;
BUFFER_POOL_SIZE = 1 MB;
MAX_ROWS_PER_CACHE_ENTRY = 100000; // 0 is unlimited size
MAX_CACHE_ENTRY_SIZE = 1 MB;
MAX_CACHE_ENTRIES = 5000;

// 0 indicates that periodic metadata backups are not done

METADATA_BACKUP_FREQUENCY_MINUTES = 1440; // 24 Hours

################################################################
# General Section
#
# Contains general server default parameters, including
# localization and internationalization, temporary space
# and memory allocation, and other default parameters
# used to determine how data is returned from the Siebel Analytics
# server to a client.
#

###############################################################

[ GENERAL ]

// Localization/Internationalization parameters.
LOCALE = "english-usa";
SORT_ORDER_LOCALE = "english-usa";
SORT_TYPE = BINARY;

// Case sensitivity should be set to match the remote
// target database.
CASE_SENSITIVE_CHARACTER_COMPARISON = OFF ;
// SQLServer65 sorts nulls first, whereas Oracle sorts
// nulls last. This ini file property should conform to
// that of the remote target database, if there is a
// single remote database. Otherwise, choose the order
// that matches the predominant database (i.e. on the
// basis of data volume, frequency of access, sort
// performance, network bandwidth).

NULL_VALUES_SORT_FIRST = OFF

DATE_TIME_DISPLAY_FORMAT = "yyyy/mm/dd hh:mi:ss" ;
DATE_DISPLAY_FORMAT = "yyyy/mm/dd" ;
TIME_DISPLAY_FORMAT = "hh:mi:ss" ;

// Temporary space, memory, and resource allocation
// parameters.
// You may use KB, MB for memory size.

WORK_DIRECTORY_PATHS = "C:\Temp" ;
SORT_MEMORY_SIZE = 4 MB ;
SORT_BUFFER_INCREMENT_SIZE = 256 KB ;
VIRTUAL_TABLE_PAGE_SIZE = 128 KB ;
DATA_SOURCE_BULK_FETCH_SIZE = 128 KB ;

// Siebel will return all month and day names as three
// letter abbreviations (e.g., "Jan", "Feb", "Sat", "Sun").
// To use complete names, set the following values to YES.
USE_LONG_MONTH_NAMES = NO;
USE_LONG_DAY_NAMES = NO;

###############################################################
#
# Security Section
#
# Legal values for DEFAULT_PRIVILEGES are:
# NONE READ
#

###############################################################

[ SECURITY ]

DEFAULT_PRIVILEGES = READ;
PERFORM_OS_AUTHENTICATION = YES;
PROJECT_INACCESSIBLE_COLUMN_AS_NULL = NO;

# There are 3 types of authentication. The default is NQS
# You can select only one of them
#
#----- 1 -----
#AUTHENTICATION_TYPE = NQS;      // optional and default
#
#----- 2 -----
#AUTHENTICATION_TYPE = DATABASE;
#           [ DATABASE ]
#                   DATABASE = "some_data_base";
#
#----- 3 -----
#AUTHENTICATION_TYPE = BYPASS_NQS;

###############################################################
#
# Server Section
#

###############################################################

[ SERVER ]

SERVER_NAME = Siebel_Analytics_Server ;
CLIENT_SERVER_SHARED_MEMORY_SIZE = 0 KB ;
// the need for shared memory has been eliminated;
// therefore shared memory is not allocated
SESSION_TIME_OUT_SECONDS = 300 ;
MAX_SESSION_LIMIT = 100 ;
MAX_REQUEST_PER_SESSION_LIMIT = 100 ;
SERVER_THREAD_RANGE = 40-40 ;
SERVER_THREAD_STACK_SIZE = 0 ;
DB_GATEWAY_THREAD_STACK_SIZE = 0 ;
MAX_EXPANDED_SUBQUERY_PREDICATES = 8192 ; // Default is 8192
MAX_QUERY_PLAN_CACHE_ENTRIES = 10240 ; // default is 10240
MAX_DRILLDOWN_INFO_CACHE_ENTRIES = 10240 ; // Default is 10420
MAX_DRILLDOWN_QUERY_CACHE_ENTRIES = 10240 ; // Default is 10420
CLUSTER_PARTICIPANT = NO ;
INIT_BLOCK_CACHE_ENTRIES = 20 ; // default is 20

CLIENT_MGMT_THREADS_MAX = 5 ; //default is 5
RPC_SERVICE_OR_PORT = 9703 ; //default is 9703

ENABLE_DB_HINTS = YES;
PREVENT_DIVIDE_BY_ZERO = YES;

// Following required if CLUSTER_PARTICIPANT = YES
#REPOSITORY_PUBLISHING_DIRECTORY = "<dirname>" ;
#REQUIRE_PUBLISHING_DIRECTORY = YES ; // Don't join cluster if
// directory not accessible

###############################################################
#
# Dynamic Library Section
#
# The dynamic libraries specified in this section
# are categorized by the CLI they support.
#

###############################################################

[ DB_DYNAMIC_LIBRARY ]

ODBC200 = nqsdbgatewayodbc;
ODBC350 = nqsdbgatewayodbc35;
OCI7 = nqsdbgatewayoci7;
OCI8 = nqsdbgatewayoci8;
OCI8i = nqsdbgatewayoci8i;
DB2CLI = nqsdbgatewaydb2cli;
DB2CLI35 = nqsdbgatewaydb2cli35;
NQSXML = nqsdbgatewayxml;

################################################################
# User Log Section
#
#  The user log NQQuery.log is kept in the SiebelAnalytics_dir\log
#  directory. It logs activity about queries when enabled
#  for a user. Entries can be viewed using a text editor
#  or the nQLogViewer executable.
#

###############################################################

[ USER_LOG ]

USER_LOG_FILE_SIZE = 10 MB; // default size
CODE_PAGE = "UTF8";  // ANSI, UTF8, 1252, etc.

###############################################################
#
# Usage Tracking Section
#
# Collect usage statistics on each logical query
# submitted to Siebel Analytics Server.
#

###############################################################

[ ACCOUNTING ]

ENABLE = OFF;
STORAGE_DIRECTORY = "<full directory path>";
CHECKPOINT_INTERVAL_MINUTES = 5;
FILE_ROLLOVER_INTERVAL_MINUTES = 240;
CODE_PAGE = "ANSI"; // ANSI, UTF8, 1252, etc.

##########################################################
#
# Server Query Statistics Section
#
# Collect detailed statistical data for logical
# queries, as well as physical queries issued by
# the Siebel Analytics Server to backend database systems.
#
# The statistical information is a superset of the
# information gathered by ACCOUNTING.
#
# The default storage file is:
# SiebelAnalytics_dir\QueryStats\NQQueryStats.log
#

##########################################################

[ SERVER_QUERY_STATISTICS ]

#STORAGE_DIRECTORY = "<full directory path>" ;
// default: SiebelAnalytics_dir\QueryStats
FILE_NAME = "NQQueryStats.log" ;
FILE_SIZE = 100 MB ;
DATE_TIME_OUTPUT_FORMAT = "yyyy-mm-dd hh:mi:ss" ;
// Settings for SYSTEM_LEVEL_CONTROL
// OFF - No statistics for any queries
// ON - Statistics for all queries
// IGNORE - Statistics for some queries depending
// on user/group setting
SYSTEM_LEVEL_CONTROL = IGNORE; // On/Off/Ignore
CODE_PAGE = "ANSI"; // ANSI, UTF8, 1252, etc.

##########################################################
#
# Query Optimization Flags
#

##########################################################

[ OPTIMIZATION_FLAGS ]
STRONG_DATETIME_TYPE_CHECKING = ON ;


 Siebel Analytics Installation and Configuration Guide, Version 7.5, Rev. C 
 Published: 18 April 2003