Home | Previous Page | Next Page   Utility Reference > onstat: Monitor Database Server Operations > The onstat -g Monitoring Options >

onstat -g mut session id

Lists the mutability value of the environment variables in the specified session that have a mutability property.

The mutability property of certain environment variables can be set using the SET, SET ENVIRONMENT, and SET PDQPRIORITY statements. For each session, it is usually set in the sysdbopen() procedure. For more information on the SET statements and the sysdbopen() stored procedure, see the IBM Informix Guide to SQL: Syntax.

Example Output

Figure 45. onstat -g mut output
Mutability Status for Session: 1.41
Environment variable             Mutability 
MAXSCAN                          IMMUTABLE    
TEMP_TAB_EXT_SIZE                MUTABLE    
TEMP_TAB_NEXT_SIZE               MUTABLE    
COMPUTE_QUOTA                    MUTABLE    
IMPLICIT_PDQ                     IMMUTABLE    
BOUND_IMPL_PDQ                   MUTABLE    
TMPSPACE_LIMIT                   MUTABLE    
CLIENT_TZ                        IMMUTABLE  
PDQPRIORITY                      IMMUTABLE    
TABLE_SPACE                      MUTABLE    
TABLE_TYPE                       MUTABLE    
TEMP_TABLE_SPACE                 MUTABLE    
TEMP_TABLE_TYPE                  MUTABLE    

Output Description

Environment Variable
lists the environment variables in the current session which have a mutability property.
Mutability
the value of the mutability property.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]