Resource configuration for a BATCH workload type service superclass

BATCH service superclasses are pre-configured to handle larger activities that do not have high response time requirements.

To create a service superclass for a batch workload, issue the following statement:
CREATE SERVICE CLASS superclass_name FOR WORKLOAD TYPE BATCH

For a BATCH service superclass, a single service subclass is created with a FIFO queue order and no minimum resource share.

Figure 1. Workload distribution for a superclass for a BATCH workload
All queries are routed to SYSDEFAULTSUBCLASS.
Table 1. Default resource shares, entitlements, minimum resource share, and queue order for the single subclass created for the BATCH superclass.
Subclass name Resource shares Minimum resource share Admission queue order Resource share type
SYSDEFAULTSUBCLASS 1000 0% FIFO SOFT