Table 40. Default Siebel Analytics Configuration File Settings
|
|
|
Other Valid Values (if not binary) or Notes |
Repository |
Star |
siebelanalytics.rpd |
|
Cache |
ENABLE |
YES |
|
DATA_STORAGE_PATHS |
\SiebelAnalyticsData\ Temp\Cache
|
|
METADATA_FILE |
\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 |
NOTE: Read Release Notes before setting to YES.
|
METADATA_BACKUP_ FREQUENCY_MINUTES |
1440 |
|
General |
LOCALE |
English-usa |
|
SORT_ORDER_LOCALE |
english-usa |
|
SORT_TYPE |
binary |
|
CASE_SENSITIVE_ CHARACTER_COMPARISON |
OFF |
Must match the remote target database. |
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 |
|
WORK_DIRECTORY_PATHS |
\SiebelAnalyticsData \Temp
|
|
SORT_MEMORY_SIZE |
4 MB |
|
SORT_BUFFER_ INCREMENT_SIZE |
256 KB |
|
VIRTUAL_TABLE_PAGE_ SIZE |
128 KB |
|
USE_LONG_MONTH_ NAMES |
NO |
|
USE_LONG_DAY_NAMES |
NO |
|
UPPERCASE_USERNAME_ FOR_INITBLOCK |
YES |
|
Security |
DEFAULT_PRIVILEGES |
READ |
NONE |
PERFORM_OS_ AUTHENTICATION |
YES |
|
PROJECT_INACCESSIBLE_ COLUMN_AS_NULL |
YES |
|
MINIMUM_PASSWORD_ LENGTH |
0 |
|
AUTHENTICATION_TYPE |
NQS |
|
Server |
SERVER_NAME |
Siebel_Analytics_Server |
|
MAX_SESSION_LIMIT |
2000 |
|
MAX_REQUEST_PER_ SESSION_LIMIT |
500 |
|
SERVER_THREAD_RANGE |
40-100 |
|
SERVER_THREAD_STACK_ SIZE |
0 |
|
DB_GATEWAY_THREAD_ STACK_SIZE |
0 |
|
MAX_EXPANDED_ SUBQUERY_PREDICATES |
8192 |
|
MAX_QUERY_PLAN_ CACHE_ENTRIES |
1024 |
|
MAX_DRILLDOWN_INFO_ CACHE_ENTRIES |
1024 |
|
MAX_DRILLDOWN_QUERY_ CACHE_ENTRIES |
1024 |
|
INIT_BLOCK_CACHE_ ENTRIES |
20 |
|
CLIENT_MGMT_THREADS_MAX |
5 |
|
RPC_SERVICE_OR_PORT |
9703 |
|
ENABLE_DB_HINTS |
YES |
|
PREVENT_DIVIDE_BY_ ZERO |
YES |
|
Server (continued) |
CLUSTER_PARTICIPANT |
NO |
If value is YES, add the following parameters:
- REPOSITORY_PUBLISHING_DIRECTORY
- REQUIRE_PUBLISHING_DIRECTORY
|
REPOSITORY_PUBLISHING_DIRECTORY |
<dirname> |
Use when CLUSTER_PARTICIPANT = YES |
REQUIRE_PUBLISHING_ DIRECTORY |
YES |
Use when CLUSTER_PARTICIPANT = YES |
DISCONNECTED |
NO |
|
AUTOMATIC_RESTART |
YES |
|
Dynamic Library |
ODBC200 |
nqsdbgatewayodbc |
The dynamic libraries are categorized by the CLI they support. |
ODBC350 |
nqsdbgatewayodbc35 |
|
OCI7 |
nqsdbgatewayoci7 |
|
OCI8 |
nqsdbgatewayoci8 |
|
OCI8i |
nqsdbgatewayoci8i |
|
DB2CLI |
nqsdbgatewaydb2cli |
|
DB2CLI35 |
nqsdbgatewaydb2cli35 |
|
NQSXML |
nqsdbgatewayxml |
|
XMLA |
nqsdbgatewayxmla |
|
User Log |
USER_LOG_FILE_SIZE |
10 MB |
Logs query activity when enabled for a user. |
CODE_PAGE |
UTF8 |
ANSI, 1252, and others. |
Usage Tracking |
ENABLE |
NO |
Collects usage statistics on each logical query submitted to the Analytics Server. |
DIRECT_INSERT |
YES |
Inserts data into a table. If value is YES, also use the parameter PHYSICAL_TABLE_NAME. |
PHYSICAL_TABLE_NAME |
<Database>.<Catalog>.<Schema>.<Table> |
SQL Server databases use <Database>.<Catalog>.<Schema>.<Table> Oracle databases use <Database>.<Schema>.<Table> |
DIRECT_INSERT |
NO |
Writes data to a flat file. If value is NO, also use the parameter STORAGE_DIRECTORY. |
STORAGE_DIRECTORY |
<full directory path> |
Use when STORAGE_DIRECTORY = NO. |
CHECKPOINT_INTERVAL_ MINUTES |
5 |
|
FILE_ROLLOVER_ INTERVAL_MINUTES |
30 |
|
CODE_PAGE |
UTF8 |
ANSI, 1252, and others. |
Optimization Flags |
STRONG_DATETIME_TYPE_CHECKING |
ON |
|
Cluster (found in NQCluster Confg.INI file) |
ENABLE_CONTROLLER |
NO |
Analytics Server clustering is enabled via NQSConfig.INI. |
PRIMARY_CONTROLLER |
<machine_name> |
DNS name of Primary Cluster Controller. |
SECONDARY_CONTROLLER |
<machine_name> |
Secondary Cluster Controller; must be distinct from PRIMARY_CONTROLLER. |
SERVERS |
<analytics_server_name01> |
<analytics_server_name02> List up to 16 unique Siebel Analytics Server machines. |
MASTER_SERVER |
<analytics_server_name> |
DNS of the Analytics Server machine holding master copies of repositories. NOTE: Must be in SERVERS list.
|
SERVER_POLL_SECONDS |
5 |
Polling frequency: Analytics Server to Cluster Controller. |
CONTROLLER_POLL_ SECONDS |
5 |
Polling frequency: Cluster Controller to Cluster Controller. |
Cluster (continued) |
CLIENT_SERVER_PORT |
9703 |
Outfacing port for ODBC connections on the Analytics servers (called RCP_SERVICE_OR_PORT in the NQSConfig.INI file). Replaces SERVER_PORT. NOTE: Not registered with IANA; must be verified.
|
CLIENT_CONTROLLER_ PORT |
9706 |
Outfacing port for clustered ODBC connections on the Cluster Controllers. Replaces CONTROLLER_PORT. NOTE: Not registered with IANA; must be verified.
|
MONITOR_CONTROLLER_ PORT |
9700 |
TCP/UDP port for intracluster communication with clustered Analytics Servers. NOTE: Not registered with IANA; must be verified.
|
MONITOR_SERVER_PORT |
9701 |
SERVER_MANAGER_PORT |
9702 |
Port used by the Server Manager. NOTE: Needed only on UNIX.
|