From OnManager
Jump to: navigation, search

OnManager is a program for database administrators to monitor Informix servers.

Monitor server

onconfig parameters, onstat -p, onstat -g seg, onstat -g glo, onstat -l, onstat -D, threads list, checkpoints list, online.log

Manage disk space

onstat -d, onspaces, tables layout in dbspace/chunk, individual table size.

Monitor user sessions

onstat -u, SQL statements, locks, used memory, error code, sorts, last run time, connect time, isolation, active session filter.

Grant and limit access to databases

grant/revoke permissions on tables, views and procedures to users/roles, generate script for object/grantee.


List of supported SQL Administration API Functions

What's new in latest version