To change the mode of the database server, a blank space and a single hyphen ( - ) must follow the onmode keyword, immediately followed by exactly one of the following flags that switch the database server to another mode:
| Flag | Effect |
|---|---|
| j | Switches to single-user mode (from on-line mode or quiescent mode) |
| k | Switches to off-line mode and removes shared memory |
| m | Switches to on-line mode (from single-user mode or quiescent mode) |
| s | Switches to quiescent mode gracefully, leaving shared memory intact |
| u | Switches to off-line mode immediately |
Except for the -j option, which this document describes in Switching to or Starting the Server in Single-User Mode, the options listed above are documented in Chapter 9 of the IBM Informix Dynamic Server Administrator's Reference.
Version 8.31 of Extended Parallel Server introduced the onmode -g ds_total_tempspace command to reset the value of the DS_TOTAL_TEMPSPACE configuration parameter dynamically while the server is online. You can specify one of the following two options after the ds_total_tempspace keyword:
| Option | Effect |
|---|---|
| value | Resets the DS_TOTAL_TEMPSPACE parameter to the specified value in units of kilobytes as the maximum amount of temporary space that a single query can use for query-operator overflow on each coserver |
| OFF | Disables restrictions on TEMP space for the server instance, and enables queries in all sessions of the server to use all configured TEMP space |
The onmode -g ds_total_tempspace command and the DS_TOTAL_TEMPSPACE configuration parameter are documented in Chapter 2 of the Feature Enhancements Guide for IBM Informix Extended Parallel Server, Version 8.32.
Versions 8.31 and 8.32 of Extended Parallel Server introduced several onmode -q commands that change the behavior of queries in a specified session or display their optimizer plan. To use these features, specify one of the following options after the -q command-line flag:
| Option | Effect |
|---|---|
| explain | Equivalent to the SET EXPLAIN statement of SQL. Prints output describing queries to the sqexplain.out file, or to a non-default file. See also Displaying the Optimizer Plan of an Executing Query, which describes the new IMMEDIATE option that Version 8.51 adds to this command. |
| intr | Aborts all queries submitted by a specified session. Use onmode -q intr instead of onmode -z when you do not want to terminate the session, but you want to abort all of its queries. |
| pdqpriority | Equivalent to setting the session PDQPRIORITY level with the PDQPRIORITY environment variable or the SQL statement SET PDQPRIORITY, except that queries in the RGM Wait queue are also affected. |
| schlevel | Sets the schedule level for a specified session. The schedule level assigns a priority to queries submitted by the session. The default schedule level is 50. The onmode -q schlevel command is equivalent to executing the SET SCHEDULE LEVEL statement, except that queries in the Resource Grant Manager Wait queue are also affected. |
These onmode -q commands must be executed on the coserver to which the session is connected, and they fail with an error if issued at the wrong coserver. (The onmode -q intr command can also run on a coserver where the specified session has a secondary session.) These commands are documented in Chapter 2 of Feature Enhancements Guide for IBM Informix Extended Parallel Server, Version 8.32.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]