Various options of the onstat -q command can display information that was not available from the onstat utility in releases earlier than XPS 8.51:
| Specification | New Information Included in the Output Display |
|---|---|
| cfg | Name of every resource class and the settings of its DS_CLASSINFO parameters |
| cfg DS_CLASSINFO | Default DS_CLASSINFO values for the default class, configuration file DS_CLASSINFO parameters when the database was started, and the current DS_CLASSINFO parameter settings for every resource classy |
| env | The string "ses_DS_CLASS" and the name of the DEFAULT resource class |
| env session_id | The string "DS_CLASS" and the name of the resource class of the specified session, and similar support for the new USABLE_SPACES and FORCE_DDL_EXEC session environment variables |
| mut session_id | The string "DS_CLASS" and the mutability status of the DS_CLASS session environment variable, and similar support for the new USABLE_SPACES and FORCE_DDL_EXEC session environment variables |
| rgm | DS_CLASSINFO parameter names and their settings for every resource class |
| ses | Name of the resource class associated with each session |
| ses session_id | The UPDATE STATISTICS status of temporary tables |
| sql session_id | Original format of SQL statements, including white space |
| xmp | Overflow of group iterator instances for queries in all sessions of the coserver where the command is issued |
| xmp query_id | Overflow of group iterator instances for the specified query |
| xqp query_id | Names of tables for which aliases were declared in the FROM clause of queries in the specified session |
In most cases, the information identified in this table is in addition to what the same command displayed in releases earlier than Version 8.51.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]