The onmode -q ... DS_CLASS Command

Also supporting resource classes is the keyword DS_CLASS as a new command-line option to the onmode utility. The DBA can use following syntax to reset the mutability attribute of the DS_CLASS session environment variable:

>>-onmode -q--+-IMMUTABLE-+--DS_CLASS--session_id--------------><
              '-MUTABLE---'
 

• session_id specifies the number of the user session whose DS_CLASS mutability is being modified.
• MUTABLE enables a non-DBA user to reset the resource class whose limits are in effect for subsequent queries in the specified session.
• IMMUTABLE prevents users from specifying a different resource class.

Only a user who holds the DBA privilege can issue this command to change the mutability status of the DS_CLASS setting. After the onmode -q MUTABLE DS_CLASS session_id command executes successfully, a user in session_id can execute the SET ENVIRONMENT DS_CLASS statement of SQL to reset the session value for DS_CLASS to any existing resource class.

For more information about command-line options of the onmode utility, see Appendix A. Syntax Summaries of Selected Utilities.