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 to use only
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.
No
.
sasv9_usermods.cfg
file
in the \sasconfigdir\Lev#\SASApp\WorkspaceServer\
directory:options mprint symbolgen notes;
No
.
sasv9_usermods.cfg
file
in the \sasconfigdir\Lev#\SASApp\WorkspaceServer\
directory:options validvarname='any';
Database Settings
|
SAS Embedded Process
|
Scoring Function
|
---|---|---|
Server name
|
|
|
HDFS directory
path
|
Hadoop
|
Not applicable
|
MapReduce
server name
|
Hadoop
|
Not applicable
|
Database
name or instance number
|
|
|
User ID
|
|
|
Server user
ID
|
Not applicable
|
DB2
|
Schema
|
|
|
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 enables users
to separate the SAS Decision Manager scoring model files
from the SAS model scoring files when using the SAS Embedded Process
publish method.
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 Decision Manager is selected by default.
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
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 time-out
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
|
Specifies the name of
the directory in which the High-Performance Analytics shared libraries
are installed on the appliance.
|
|
Install location
|
Specifies 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
|
Specifies 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.
|
|
Grid mode
|
Specifies whether the
HPFORECAST procedure runs in symmetric (SYM) mode or asymmetric (ASYM)
mode. The default is symmetric (GRIDMODE=SYM).
|
Symmetric
|