Bookshelf Home | Contents | Index | Search | PDF

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

Sample Configuration 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, see Configuration File Parameters and Syntax. 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) 1997 - 2003 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\Repository directory, where
# SiebelAnalytics is the directory in which the
# Siebel Analytics Server software is installed.
#
##########################################################

[ REPOSITORY ]

Star = siebelanalytics.rpd, DEFAULT;

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

[ CACHE ]

ENABLE =YES;

// A comma separated list of <directory maxSize> pair(s)
// e.g. DATA_STORAGE_PATHS = "d:\SiebelAnalyticsData\nQSCache"
// 500 MB;

DATA_STORAGE_PATHS ="d:\SiebelAnalyticsData\Temp\Cache" 256 MB;

METADATA_FILE ="d:\SiebelAnalyticsData\Temp\Cache\MetaData";

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 = 1000;

POPULATE_AGGREGATE_ROLLUP_HITS = NO;

// 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 ="d:\SiebelAnalyticsData\Temp";

SORT_MEMORY_SIZE = 4 MB ;

SORT_BUFFER_INCREMENT_SIZE = 256 KB ;

VIRTUAL_TABLE_PAGE_SIZE = 128 KB ;

// Analytics Server 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;

UPPERCASE_USERNAME_FOR_INITBLOCK =YES;

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

[ SECURITY ]

DEFAULT_PRIVILEGES = READ;

PERFORM_OS_AUTHENTICATION = YES;

PROJECT_INACCESSIBLE_COLUMN_AS_NULL =YES;

MINIMUM_PASSWORD_LENGTH = 0;

# 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 ;

SESSION_TIME_OUT_SECONDS = 300 ;

MAX_SESSION_LIMIT = 2000 ;

MAX_REQUEST_PER_SESSION_LIMIT = 500 ;

SERVER_THREAD_RANGE = 40-100;

SERVER_THREAD_STACK_SIZE = 0; // default is 1 MB, 0 for default

DB_GATEWAY_THREAD_STACK_SIZE = 0; // default is 256 KB, 0 for default

MAX_EXPANDED_SUBQUERY_PREDICATES = 8192; // default is 8192

MAX_QUERY_PLAN_CACHE_ENTRIES = 1024; // default is 1024

MAX_DRILLDOWN_INFO_CACHE_ENTRIES = 1024; // default is 1024

MAX_DRILLDOWN_QUERY_CACHE_ENTRIES = 1024; // default is 1024

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; // default is yes

PREVENT_DIVIDE_BY_ZERO = YES;

CLUSTER_PARTICIPANT = NO;

// Following required if CLUSTER_PARTICIPANT = YES

#REPOSITORY_PUBLISHING_DIRECTORY = "<dirname>";

#REQUIRE_PUBLISHING_DIRECTORY = YES; // Don't join cluster if directory not accessible

DISCONNECTED = NO;

AUTOMATIC_RESTART = YES;

##########################################################
#
# 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;

XMLA = nqsdbgatewayxmla;

##########################################################
#
# User Log Section
#
# The user log NQQuery.log is kept in the SiebelAnalytics\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 the Siebel Analytics Server.
#
##########################################################

[ ACCOUNTING ]

ENABLE = NO;

//==============================================================
// Parameters used for writing data to a flat file
// (i.e. DIRECT_INSERT = NO).

STORAGE_DIRECTORY = "<full directory path>";

CHECKPOINT_INTERVAL_MINUTES = 5;

FILE_ROLLOVER_INTERVAL_MINUTES = 30;

CODE_PAGE = "ANSI"; // ANSI, UTF8, 1252, etc.
//

//=============================================================

DIRECT_INSERT = NO;

//=============================================================

// Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).

//

PHYSICAL_TABLE_NAME = "<Database>"."<Catalog>"."<Schema>"."<Table>" ;

CONNECTION_POOL = "<Database>"."<Connection Pool>" ;

BUFFER_SIZE = 1 MB ;

BUFFER_TIME_LIMIT_SECONDS = 5 ;

NUM_INSERT_THREADS = 5 ;

MAX_INSERTS_PER_TRANSACTION = 1 ;

//
//=================================================================

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

[ OPTIMIZATION_FLAGS ]

STRONG_DATETIME_TYPE_CHECKING = ON ;

Bookshelf Home | Contents | Index | Search | PDF