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

Read syntax diagramSkip visual syntax diagramdb2ida-providerprovider_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