DB2 10.5 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 command is useful when you perform maintenance operations, such as upgrading the SAS EP library or correcting an erroneous library path.

Authorization

You require one of the following authorizations:

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

The following command starts the SAS embedded process on the current instance:
```
db2ida –provider sas -start
```
The following command forces the SAS embedded process to shut down even if dependent queries are running on the system:
```
db2ida –provider sas –stopforce
```