Re: SMI- Sessions level stats

Arun K Shastry <aruns@wpi.WPI.EDU> wrote in article <584lj0$8o9@bigboote.WPI.EDU>... > Is there any way in OnLine 7.2 to get session level > statistics like CPU utilization, idle time, etc. using > SMI queries? > > The closest I got was the table syssdblock which has > a column sdb_cumtime. However, this column never gets > updated in the tests we did. Try: syssessions, syssesprof, sysseswts. There's quite a bit there, but CPU time is notably absent. I know it can be tracked internally because you can see it with "oncockpit" if you have a parameter set right in your "onconfig" file. (I can't rememebr the parameter name and it's not documented. e-Mail me if you want to know and I'll check one of my "onconfig" files. You can also find out yourself by trying to display a session profile in "oncockpit". It will tell you what the parameter is if it's not currently enabled.) Maybe this will also turn on "sdb_cumtime"? HTH -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com