To obtain information provided by the onstat utility, you can use SQL to query appropriate SMI tables. The following table indicates which SMI tables to query to obtain the information provided by a given onstat option. For descriptions of the onstat options, see Monitor the Database Server Status.
| onstat Option | SMI Tables to Query | onstat Fields Not in SMI Tables |
|---|---|---|
| -d | sysdbspaces
syschunks |
address
bpages |
| -D | sysdbspaces
syschkio |
|
| -F | sysprofile | address
flusher snoozer state data |
| -g dri | sysdri | Last DR CKPT (id/pg) |
| -g glo | sysvpprof | Listing of virtual processors by class |
| -k | syslocks | address
lklist tblsnum |
| -l | syslogs
sysprofile |
All physical-log fields (except numpages and numwrits)
All logical-log buffer fields (except numrecs, numpages, and numwrits) address begin % used |
| -p | sysprofile | |
| -u | syssessions
syssesprof |
address
wait nreads nwrites |