Resource configuration for an INTERACTIVE workload type service superclass

INTERACTIVE service superclasses are pre-configured for short, interactive activities that have high response time requirements.

To create a service superclass for an interactive workload, issue the following statement:

CREATE SERVICE CLASS superclass_name FOR WORKLOAD TYPE INTERACTIVE

For an INTERACTIVE service superclass, a single service subclass is created with a latency queue order and a minimum resource share to ensure the responsiveness of the interactive queries and prioritize the shortest queries.

All queries are routed to SYSDEFAULTSUBCLASS. — Figure 1. Workload distribution for a superclass for an INTERACTIVE workload

Table 1. Default resource shares, entitlements, minimum resource share, and queue order for the single subclass created for the INTERACTIVE superclass.
Subclass name	Resource shares	Minimum resource share	Admission queue order	Resource share type
SYSDEFAULTSUBCLASS	1000	25%	Latency	SOFT