DB2 Version 9.7 for Linux, UNIX, and Windows

db2ida - Stop or restart the SAS embedded process command

Stops or restarts the SAS embedded process (SAS EP) without recycling the DB2® instance. This is useful when maintenance operations, such as upgrading the SAS EP library or correcting an erroneous library path, are to be performed.

Authorization

One of the following:

sysadm
sysctrl
sysmaint

Required connection

None

Command syntax


>>-db2ida-- -provider--provider-name--+- -start-----+----------><
                                      +- -stop------+   
                                      '- -stopforce-'

Command parameters

-provider provider-name: Specifies an analytics provider. This parameter is case insensitive. Currently, the only supported value is SAS.
-start: Starts the SAS EP if it is not currently running. DB2 respawn logic applies if the process terminates abnormally.
-stop: Stops the SAS EP if it is safe to do so. If any executing queries are dependent on the SAS EP, the command fails. The database manager does not attempt to respawn the SAS EP after it has successfully stopped.
-stopforce: Forces the SAS EP to shut down, even if there are dependent queries running on the system. The database manager does not attempt to respawn the SAS EP after it has successfully stopped.

Examples

Start the SAS embedded process on the current instance:
```
db2ida -provider sas -start
```
Force the SAS embedded process to shut down even if dependent queries are running on the system:
```
db2ida -provider sas -stopforce
```