onstat & SMI

Hi, does anybody knows what query (queries) I must run to produce same output as onstat -u command? I'm not sure for flags, which fields in SMI represents those flags. Thnx in advance.

I will give you the tip that was given to me. If you set SQEXPLAIN=1 in your environment ... when running the onstat -u command will generate an sqexplain.out file which you can view what sql commands are necessary in order to retrieve the information from that command. Lloyd Aj Wilson. El Nino wrote in message <7v4e28$8r3$1@bagan.srce.hr>... >Hi, >does anybody knows what query (queries) I must run >to produce same output as onstat -u command? >I'm not sure for flags, which fields in SMI represents >those flags. >Thnx in advance. > > >