Configuring the SAS Workspace Server to Enable the Bulk Loading of Data

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:

1. On the SAS Workspace Server host, in a Command Prompt window, change directories to SAS-configuration-directory\Lev1\ObjectSpawner.

2. Stop the object spawner by entering the command ObjectSpawner stop .

3. 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 .

4. 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 .

5. Save your changes.

6. If you want to run the object spawner as a service, install the service. You can do this by entering the command ObjectSpawner install .

7. Start the object spawner by entering the command ObjectSpawner start .

To set -allowxcmd in the UNIX operating environment, follow these steps:

1. Change directories to ../Lev1/appServer/ObjectSpawner.

2. Stop the object spawner by entering the command ObjectSpawner.sh stop .

3. 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.

4. Save your changes.

5. Restart the object spawner by entering the command ObjectSpawner.sh start .

Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.