To improve
performance, SAS Data Integration Studio transformations such as the
Table Loader can be configured to use the bulk-loading capabilities
of native DBMS software.
To enable bulk-loading,
you need to set the
-allowxcmd option
in the invocation statement for the object spawner that instantiates
SAS sessions on the SAS Workspace Server.
To set
-allowxcmd in the Windows operating environment,
follow these steps:
-
On the SAS Workspace
Server host, in a Command Prompt window, change directories to
SAS-configuration-directory\Lev1\ObjectSpawner.
-
Stop the object spawner
by entering the command
ObjectSpawner stop.
-
If the object spawner
is set up to run as a service, remove the service. You can do this
by entering the command
ObjectSpawner remove.
-
Edit ObjectSpawner.bat,
which is the script that is used to start the object spawner. Add
the spawner invocation option
-allowxcmd to
the appropriate line. If you run the object spawner as a service (which
is recommended), append the option to the line following the label
:install. Otherwise, append the option to the line following
the label
:start2.
-
-
If you want to run the
object spawner as a service, install the service. You can do this
by entering the command
ObjectSpawner install.
-
Start the object spawner
by entering the command
ObjectSpawner start.
To set
-allowxcmd in the UNIX operating environment, follow
these steps:
-
Change directories to
../Lev1/appServer/ObjectSpawner.
-
Stop the object spawner
by entering the command
ObjectSpawner.sh stop.
-
Edit the script ObjectSpawner.sh
so that the command used to start the object spawner contains the
option
-allowxcmd. Add the option to the
line that begins with
$CMD, just before the
first
> sign.
-
-
Restart the object spawner
by entering the command
ObjectSpawner.sh start.