Home |
Previous Page | Next Page Configuring and Monitoring Dynamic Server > Configuration Parameters >
- onconfig.std value
- 1
- possible values
- 0 = All database administrators can run onstat commands to
view running SQL statements.
1 = Users with GRANT DBA access to a database cannot
run onstat commands to view running SQL statements.
- takes effect
- When the database server is shut down and restarted
- refer to
- IBM Informix Administrator's Guide
The onstat commands that show the SQL statement text that is executing
on a session are normally restricted to DBA users. To remove this restriction,
set the UNSECURE_ONSTAT configuration parameter to 1. Onstat commands that
show SQL statements include the onstat -ses, onstat -stm, onstat -ssc, and
onstat -sql.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]