This section presents an example that illustrates how the system administrator interprets execution class attributes, including:
Planning – the system administrator analyzes the environment, performs benchmark tests, sets goals, and understands 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 administrator has created.
Figure 4-4 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-4: Conflict resolution
