onstat -g sql session id

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

onstat -g sql session id

This option prints SQL information by session id. If session id is omitted, a one-line summary for each session prints.

Example Output

Figure 63. onstat -g sql output

|--Session ID--| SQL         Current  Iso Lock     SQL ISAM F.E. Submit   Admit    Current
Global    Local  Stmt type   Database Lvl Mode     ERR ERR  Vers Time     Time     Role
1.101     101    SELECT INTO ko       CR  Not Wait 0   0    8.50 14:22:29 14:23:01 engineer
PDQ priority : 0
Scheduling level : 50

Current SQL statement :
  select a.* from systables a, systables b, systables c, systables d into scratch tmp1

Output Description

Submit Time: time after the query is parsed and optimized just before start of execution
Admit Time: time when the query actually started executing after getting past the RGM queue.