Configuring Model Manager Java Services Options

Overview of Configuring Model Manager Java Services Options

The Model Manager Java Services Options in SAS Management Console enables you to modify SAS Model Manager configurations. The configurations can be modified for reporting, metadata tables usage when publishing a scoring function, SAS code debugging, SAS system options, In-database connection and publishing options, and performance options for the High-Performance Analytics procedure.
To modify the settings for the report options, follow these steps:
  1. Log on to SAS Management Console as a SAS administrator.
  2. On the Plug-ins tab, navigate to Application Managementthen selectConfiguration Managerthen selectSAS Application Infrastructure.
  3. Right-click Model Manager JavaSvcs 12.1 and select Properties.
  4. Click the Settings tab and then select Model Manager Java Services.
    Model Manager Java Services Options
  5. Select one of the following options to view and configure the available settings.
  6. Click OK.
  7. For the changes to take effect you must restart the Web application server.

Report Options

The Report Options setting in SAS Management Console enables you to modify the SAS Model Manager configurations for the dashboard reports, model retrain reports and performance monitoring. These reports are available when you use the SAS Model Manager client.
To modify the report options setting, follow these steps:
  1. Specify the formats that are available when a user creates model retrain reports. The default values are RTF, PDF, HTML, and EXCEL. You can remove any of the default values so that they are not available in the SAS Model Manager client.
  2. Specify the report styles that are available when a user creates the model retrain reports and dashboard reports. You can add or remove SAS styles. The default values are SAS default, Seaside, Meadow, and Harvest. For more information about SAS styles, see Understanding Styles, Style Elements, and Style Attributes in SAS Output Delivery System: User's Guide.
  3. Select Yes for the dashboard indicator override. When you do that, indicators with conditions are available when a user adds dashboard report indicators.
  4. Specify a value for random seed to be used by performance tasks for models that have an interval target. The default value is 12345. The random seed is the initial seed for the random number generator used for sampling the input data set.
  5. Specify a value for the sample size that is used by performance tasks for models that have an interval target. The default value is 1000. The sample size for models with an interval target is the number of observations from the input data set.
  6. Specify a value for the sample size that is used by performance tasks for characteristic and stability analysis. The default value is 10000. The sample size for characteristic and stability analysis is the number of observations from the input data set.
  7. Select Yes or No to specify whether to use the temporary tables on the High-Performance Analytics appliance for performance monitoring. The default is Yes.

Publish Scoring Options

The Publish Scoring Options setting enables you to indicate that the metadata tables be populated in the target database when publishing a scoring function. The default is Yes. During the installation and configuration process of the database, the metadata tables must be created in the database if this setting is set to Yes. If you plan on only using the SAS Embedded Process publish method to publish scoring model files, this setting can be ignored, and you do not need to create the metadata tables during the database configuration process.
For information about the database configurations, see Configure the SAS Model Manager Database . For more information about publishing models to a database, see Publishing Models to a Database in SAS Model Manager: User's Guide.

Debug Options

The Debug Options setting to enables you to use the debug options when executing SAS code within the SAS Model Manager client. The default value is No.
The Debug Options setting does not work for scoring tasks. To enable debug options with scoring tasks, you must add the following line of code to the sasv9_usermods.sas file in the \sasconfigdir\Lev#\SASApp\WorkspaceServer\ directory:
options mprint symbolgen notes;

Valid Variable Name Options

The Valid Variable Name Options setting enables you to set the VALIDVARNAME system option to ANY when executing SAS code. The default value is No.
The Valid Variable Name Options setting does not work for scoring tasks. To use the VALIDVARNAME system option with scoring tasks, you must add the following line of code to the sasv9_usermods.sas file in the \sasconfigdir\Lev#\SASApp\WorkspaceServer\ directory:
options validvarname='any';

In-Database Options

The In-Database Options settings enables you to specify the publish type, database connection settings, and publish settings that are used when publishing models to a database using SAS Model Manager.
To modify the settings for the in–database options, follow these steps:
  1. Select a method to publish models to the database for scoring. The default publish type is the SAS Embedded Process publish method.
  2. Select a database type.
  3. Specify values for database settings that are required to publish to the selected database type.
    Here are the available database settings according to the publish method and database type:
    Database Settings
    SAS Embedded Process
    Scoring Function
    Server name
    • Teradata
    • Oracle
    • Netezza
    • Greenplum
    • DB2
    • Teradata
    • Netezza
    • Greenplum
    • DB2
    Database name
    • Teradata
    • Oracle
    • Netezza
    • Greenplum
    • DB2
    • Teradata
    • Netezza
    • Greenplum
    • DB2
    User ID
    • Teradata
    • Oracle
    • Netezza
    • Greenplum
    • DB2
    • Teradata
    • Netezza
    • Greenplum
    • DB2
    Server user ID
    Not applicable
    DB2
    Schema
    • Oracle
    • Greenplum
    • DB2
    • Greenplum
    • DB2
  4. Specify to use the model manager table when publishing. The default value is No. When you are publishing the scoring model files to a database using the SAS Embedded Process publish method, the files are by default stored in the table sas_model_table. If the use model manager table value is set to Yes, the scoring model files are stored in the table sas_mdlmgr_ep. These tables are located in the target database. This setting provides the ability for users to segregate the SAS Model Manager scoring model files from the SAS model scoring files when using the SAS Embedded Process publish method.
  5. Specify to force the republish of model scoring files by default when using the SAS Embedded Process publish type. The default value is No. If you set this setting to Yes, then the Replace scoring files that have the same publish name option in the Publish Models to a Database window in SAS Model Manager is selected by default.
  6. Select the default format of the model publish name when using the SAS Embedded Process publish method. The format selected determines the value that appears for the publish name in the Publish Models to a Database window in SAS Model Manager. The scoring function publish method publish name defaults to the model name.
  7. Specify a directory path to store the temporary scoring files. If a value is not specified, the SAS work directory is used by default. However, if you select the Display detailed log messages option when publishing to a database, the SASUSER directory is used.
Note: The Support Netezza SAS Embedded Process setting is set to No by default since with the release of SAS Model Manager 12.1 on SAS 9.3. Therefore, the SAS Scoring Accelerator does not support the SAS Embedded Process publish method for Netezza. When the support is made available for SAS 9.3 this setting enables you to turn on the support for SAS Model Manager, so that Netezza appears in the database type drop-down list in SAS Model Manager.
For information about the database configurations, see Configure the SAS Model Manager Database . For more information about publishing models to a database, see Publishing Models to a Database in SAS Model Manager: User's Guide.

Performance Options

The performance options contains the performance parameters for the PERFORMANCE statement to use the High-Performance Analytics procedure. Currently only the Teradata and Greenplum database types support High-Performance Analytics.
The PERFORMANCE statement defines performance parameters for multithreaded and distributed computing, passes variables about the distributed computing environment, and requests detailed results about the performance characteristics of a High-Performance Analytics procedure.
The following performance options can be specified for the PERFORMANCE statement.
Option
Description
Default Value
Commit
Specifies an integer to request that the High-Performance Analytics procedure writes periodic updates to the SAS log.
10000
CPU count
Specifies how many processors that the procedure should assume are available on each host in the computing environment. You can enter the value of ACTUAL, or enter an integer between 1 and 256.
ACTUAL
Database server
Specifies the name of the server for the database as defined through the hosts file and as used in the LIBNAME statement.
Details
Requests a table that shows a timing breakdown of the procedure steps.
No
Timeout
Specifies the timeout in seconds for a High-Performance Analytics procedure to wait for a connection to the appliance and establish a connection back to the client.
120
Host name
Specifies the name of the appliance. If a value for the Host option is specified, it overrides the value of the grid host environment variable.
Installation directory
Specify the name of the directory in which the High-Performance Analytics shared libraries are installed on the appliance.
Installation location
Specify the name of the directory in which the High-Performance Analytics shared libraries are installed on the appliance. If a value is specified for the Installation directory option, it overrides this option.
Number of nodes
Specifies the number of nodes in the distributed computing environment, provided that the data is not processed alongside the database. You can enter an integer or you can specify a value of ALL if you want to use all available nodes on the appliance without oversubscribing the system.
Number of threads
Specify the number of threads for analytic computations. This option overrides the SAS system option THREADS | NOTHREADS. If you do not specify a value for this option, the number of threads are determined based on the number of CPUs on the host on which the analytic computations execute.
Grid host
Specifies the host name for the grid. If a value for the Host option is specified, it overrides the value of the grid host environment variable.
Grid RSH command
Specifies the command to run a remote shell.
Grid reply host
The host name of the client node to which the grid connects.
Grid port range
Specifies the range of parts that are permitted by the firewall.
Grid path
Specifies the local directory path for the grid node.
For more information about High-Performance Analytics, see the SAS High-Performance Analytics Server 12.1: User's Guide.