|Bookshelf Home | Contents | Index | PDF|
The parameters in the 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.
NOTE: The settings for the parameters LOCALE, SORT_ORDER_LOCALE, SORT_TYPE and CASE_SENSITIVE_CHARACTER_COMPARISON, described in the following topics, are interrelated. They help determine how the Siebel Analytics Server sorts data.
Specifies the locale in which data is returned from the server. This parameter also determines the localized names of days and months. For example, if the LOCALE="dutch," then names of days and months are returned from the server in Dutch. The localized message strings are written to various log files as well as returned to the user as error messages. See also the topic area Localizing Siebel Analytics Deployments.
NOTE: Do not confuse these two-letter Siebel Analytics language extensions with the Siebel operational applications three-letter language codes shown in Siebel System Requirements and Supported Platforms on the Siebel SupportWeb Knowledge Base.
The supported languages and language extension values are shown in Table 39.
Every database defined in the Physical Layer in the Server Administration Tool has a features table associated with it. If you want to override the default value in the Features table for a particular type of relational database, you need to do it for all occurrences of it in the Physical Layer.
In the Server Administration Tool, the Database dialog > Features tab > Features table specifies the features and functions that the relational database supports. The settings for SORT_ORDER_LOCALE in the Features table and in the NQSConfig.INI file should match only if the database and the Siebel Analytics Server sort data in the same way.
For the relational database and the Siebel Analytics Server to sort data the same way, they must be in agreement on the parameters shown in Table 40.
The SORT_ORDER_LOCALE entries in the Features table and in the NQSConfig.INI file match only if the database and the Siebel Analytics Server have matching settings in these areas. If the settings do not match, wrong answers can result when using multidatabase joins, or errors can result when using the Union, Intersect and Except operators, which all rely on consistent sorting between the back-end server and the Siebel Analytics Server.
The Analytics Server sets the C-runtime locale during server startup. A value for the setting is specified using the SORT_ORDER_LOCALE entry in the NQSConfig.INI file. See the topic Setting SORT_ORDER_LOCALE Under UNIX.
Valid values are ON and OFF. When set to OFF, case is ignored. When set to ON, case is considered for comparisons. For binary sorts, case sensitivity for the server and for the relational database should set the same way.
CASE_SENSITIVE_CHARACTER_COMPARISON should be set to correspond with how the back-end database deals with case. For example, if the back-end database is case-insensitive, then Siebel Analytics Server should be configured to be case-insensitive. If Siebel Analytics Server and the back-end database are not similarly case-sensitive, some subtle problems can result.
Specifies if NULL values sort before other values (ON) or after (OFF). ON and OFF are the only valid values. The value of NULL_VALUES_SORT_FIRST should conform to the underlying database. If there are multiple underlying databases that sort NULL values differently, set the value to correspond to the database that is used the most in queries.
Each directory listed needs to be an existing 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 the topic Changing the Account Under Which a Windows Service Runs.
NOTE: Specifying more than one directory per drive does not improve performance because file I/O takes place through the same I/O controller. In general, specify only one directory per disk drive. Specifying multiple directories on different drives improves the overall I/O throughput of the Siebel Analytics Server because internally, the processing files are allocated using a round-robin algorithm that balances the /O load across the given disk drives.
Specifies the maximum amount of memory to be used for each sort operation. Multiple operations can each use memory up to the value specified. The limit for SORT_MEMORY_SIZE is determined by the physical memory of the server machine and on the number of sort operations that might occur simultaneously. Specify KB for kilobytes, MB for megabytes, and no units for bytes.
Specifies the increment that the sort memory size is increased by as more memory is needed. As more memory is required, the size increases by the value specified until it reaches the value of SORT_MEMORY_SIZE.
|Siebel Analytics Platform Installation and Configuration Guide|