The onstat -g ... cfg DS_CLASSINFO Command

Output from the onstat utility can display information about resource classes:

>>-onstat -g--+-env--session_id-------+------------------------><
              +-mut--session_id-------+
              +-rgm-------------------+
              +-ses-------------------+
              '-cfg--+--------------+-'
                     '-DS_CLASSINFO-'
 

Here session_id specifies the session number of the user session as an unsigned integer.

These onstat -g commands have been enhanced to display the following new output describing resource classes:

• onstat -g env displays "ses_DS_CLASS" and the name of the DEFAULT resource class.
• onstat -g env session_id displays "ses_DS_CLASS" and the name of the resource class of the specified user session.
• onstat -g mut session_id displays "DS_CLASS" and the mutability status (either MUTABLE or IMMUTABLE) of the DS_CLASS session environment variable.
• onstat -g rgm lists the parameter names and their values for every resource class. For queries listed in the RGM Wait Queue and Active Queue, this also shows the DS_CLASS considered by the RGM for each query.
• onstat -g ses lists in the last column the resource class associated with each session.
• onstat -g cfg lists each resource class and its associated DS_CLASSINFO parameter values.
• onstat -g cfg DS_CLASSINFO lists separately the default DS_CLASSINFO values for the DEFAULT class, the configuration file settings of DS_CLASSINFO for every class that was defined when the database server was started, and the current settings of DS_CLASSINFO for every class.

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