Options visible in options.cfg

Most configuration options can be changed using the IBM® SPSS® Modeler Administration Console included with IBM SPSS Deployment Manager. But there are some exceptions, such as those described in this section. The options in this section must be changed by editing the options.cfg file. See IBM SPSS Modeler Server Administration and Using the options.cfg file for more information. Note that there may be additional settings in options.cfg that are not listed here.
Note: This information only applies to a remote server (IBM SPSS Modeler Server, for example).

administrators. Specify the user names of those users to whom you want to grant administrator access. See the topic Configuring Access with Modeler Administration Console for more information.

allow_config_custom_overrides. Do not modify unless instructed to do so by a technical-support representative.

data_view_port_number. You can right-click a data node and select View Data to examine and refine your data in interesting ways with advanced data visualizations. This feature uses the port number 28900 by default. Modify the value for this data_view_port_number configuration option if you need to use a different port number. We recommend using the default, if possible.

fips_encryption. Enables FIPS compliant encryption. The default is N.

group_configuration. When enabled, IBM SPSS Modeler Server checks the groups.cfg file which controls who can log on to the server.

max_transfer_size. For internal system use only. Do not modify.

shell. (UNIX servers only) Overrides the default setting for the UNIX shell, for example shell, "/usr/bin/ksh". By default, IBM SPSS Modeler uses the shell defined in the user profile of the user who is connecting to IBM SPSS Modeler Server.

start_process_as_login_user. Set this to Y if you are running SPSS Modeler Server with a private password database, starting the server service from a non-root account.

use_bigint_for_count. When the number of the records to be counted is larger than what a normal integer (2^31-1) can hold and is within the range of -2^63 to 2^63-1, set this option to Y. When this option is set to Y, and a stream is connected to Db2; SQL Server; or a Teradata, Oracle, or Netezza database, a function is used where a record count is needed (for example, the Record_Count field generated by the Aggregate node).

When this option is enabled, and if working with either Db2 or SQL Server, SPSS Modeler uses COUNT_BIG() for record counting. If working with Teradata, Oracle, or Netezza, SPSS Modeler will use COUNT(). For all other databases, there is no SQL pushback for the function. The difference is that when use_bigint_for_count is enabled, all record counts are saved as BIG INT (or LONG) type, as compared to normal integer when the options is disabled.

From the point of view of database numeric, see the following table for the results of setting use_bigint_for_count to Y and N for the same data.

Table 1. Database numeric interpretations when use_bigint_for_count is set to Y and N
Database Numeric Interpretation for data when use_bigint_for_count is set to Y Interpretation for data when use_bigint_for_count is set to N
Numeric(18,0) int int
Numeric(19,0) int string
Numeric(38,0) int string

cop_ssl_enabled. Set this option to Y if you are using SSL to connect to the Coordinator of Processes Service. If this option is used, you must import the SSL certificate file into the SPSS Modeler Server JRE. To do this, you must obtain the SSL certificate file and its alias name and password. Then run the following command on the SPSS Modeler Server:

$JAVA_HOME/bin/keytool -import -trustcacerts -alias $ALIAS_NAME -file $CERTIFICATE_FILE_PATH -keystore $ModelerServer_Install_Path/jre/lib/security/cacerts

cop_service_default_data_path. You can use this option to set the default data path for a Coordinator of Processes registered IBM SPSS Modeler Server installation.

Users can create their own Analytic Server connections in SPSS Modeler via Tools > Analytic Server Connections. Administrators can also define a default Analytic Server connection using the following properties:

as_ssl_enabled. Y or N.

as_host. Specify the Analytic Server host name or IP address.

as_port. Specify the Analytic Server port number.

as_context_root. Specify the Analytic Server context root.

as_tenant. Specify the name of the tenant that the IBM SPSS Modeler Server is a member of

as_prompt_for_password. Y or N.

By default, Analytic Server authentication using the Kerberos method is not enabled. To enable Kerberos authentication, use the three following properties:

as_kerberos_auth_mode. To enable Kerberos authentication, set this option to Y.

as_kerberos_krb5_conf. Specify the path to the Kerberos configuration file that Analytic Server should use; for example, c:\windows\krb5.conf.

as_kerberos_krb5_spn. Specify the Analytic Server Kerberos SPN; for example, HTTP/ashost.mydomain.com@MYDOMAIN.COM.