This section presents an example that illustrates how Adaptive Server interprets the execution class attributes. The section contains three sections:
Planing – the system administrator analyzes the environment, perform benchmark tests, set goals, and understand the concepts well enough to predict consequences.
Configuration – the system administrator runs sp_bindexeclass with parameters based on the information gathered in the Planning section.
Execution characteristics – applications connect with Adaptive Server, using the configuration the system administer created during the Configuration section.
Figure 4-5 shows two client applications, OLTP and isql, and three Adaptive Server logins, “L1”, “sa”, and “L2”.
sp_xyz is a stored procedure that both the OLTP application and the isql application need to execute.
Figure 4-5: Conflict resolution
