onmode

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Summary of User Interface Enhancements > Command-Line Options >

onmode

A blank space and a single hyphen ( - ) must follow the onmode keyword when you use the new j flag of the onmode utility to switch the database server to single-user mode:

Table 5. Flag to change the operating mode of the database server
Flag	Effect
j	Switches to single-user mode (from on-line mode or quiescent mode)

onmode -q

A user with DBA privilege can reset the mutability attributes of the new DS_CLASS session environment variables by using these onmode -q commands:

onmode -q IMMUTABLE DS_CLASS session_id 
onmode -q MUTABLE DS_CLASS session_id

These commands have the following effects:

Table 6. The mutability attribute of the DS_CLASS session variable
Keyword	Effect
IMMUTABLE	Restricts subsequent DML operations by a non-DBA user in the specified session to the current resource class of that session
MUTABLE	Enables a non-DBA user to issue the SET ENVIRONMENT DS_CLASS statement to replace the current resource class of the specified session with some other resource class

A user with DBA privilege can reset the mutability attributes of the new USABLE_SPACES session environment variables by using these onmode -q commands:

onmode -q IMMUTABLE USABLE_SPACES session_id 
onmode -q MUTABLE USABLE_SPACES session_id

These commands have the following effects:

Table 7. The mutability attribute of the USABLE_SPACES session variable
Keyword	Effect
IMMUTABLE	Restricts subsequent DDL operations by a non-DBA user in the specified session to the storage spaces that the current USABLE_SPACES setting specifies for that session
MUTABLE	Enables a non-DBA user to issue the SET ENVIRONMENT USABLE_SPACES statement to replace the current spaces list of the specified session with another list of spaces

To display the optimizer plan of a currently executing DML statement, the IMMEDIATE keyword is now valid in the onmode -q explain session_id commands of these forms:

 onmode -q EXPLAIN session_id IMMEDIATE
 onmode -q EXPLAIN session_id IMMEDIATE FILE filename
 onmode -q EXPLAIN session_id IMMEDIATE FILEAPPEND filename

These commands have the following effects:

Table 8. Keyword options to the **onmode -q EXPLAIN** command
Keywords	Effect
IMMEDIATE	Replaces the contents of the default sqexplain.out file with the optimizer plan for the currently executing query
IMMEDIATE FILE	Replaces the contents of the specified file filename with the optimizer plan for the currently executing query
IMMEDIATE FILEAPPEND	Appends the optimizer plan for the currently executing query to the specified file filename