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
.