SAS Workflow provides services that
work together to model, automate, integrate, and streamline business
processes. It provides a platform for more efficient and productive
business solutions. SAS Workflow is used by SAS solutions that benefit
from business process management.
SAS Workflow Studio
is a desktop client application that is used to design and deploy
workflows. The SAS middle tier hosts the workflow engine and the workflow
services.
For deployments that
use the default SAS Web Infrastructure Platform database provided
by SAS Framework Data Server, there is a limitation on the number
of groups and roles that SAS Workflow user can belong to. Users of
SAS Workflow, and SAS solutions that use SAS Workflow, are limited
to being members of 26 roles and groups. Attempting to assign more
than 26 roles and groups to a user can cause queries to fail in the
SAS Framework Data Server.
For deployments that
use WebSphere Application Server and have a SAS solution, such as
SAS Enterprise Case Management, that uses SAS Workflow, change the
following settings to improve performance:
-
Increase the memory
settings in the JVM options:
-
Select
ServersServer TypesWebSphere application servers and
then select
SASServer1. If SASWorkflow9.3
is deployed on a different server, then select that server instance
instead.
-
Select
Java and Process ManagementProcess
definition and then click
Java
Virtual Machine. In the Generic JVM arguments field, change
the settings to the following values:
-Xms4096m -Xmx4096m -Xss512k
Remove the -Xmso JVM
option if it is present.
-
Set optimistic locking
and increase the connection pool size for the SharedServices data
source:
-
Select
ResourcesJDBCData
sources and then select
SharedServices.
-
Click
Custom
properties and then click
New.
Enter the following settings:
Name:
websphereDefaultIsolationLevel
-
Select
SharedServices from
the breadcrumb at the top of the page and then select
Connection
pool properties. Change the values for the following
settings:
-
Increase the settings
for JMS connection pooling:
-
Select
ResourcesJMSQueue
connection factories and then select
SASQueueConnectionFactory.
-
Click
Connection
pool properties. Change the values for the following
settings: