SMI equivalent of onstat -g spf
Milan Rafaj asked for an SMI equivalent of onstat -g spf. Art Kagel said most details come from the sysrstcb pseudo table (see syssesprof) and the rest from syssdblock. Andreas Legner added syssqltrace, which Art noted only fills if SQLTRACE is enabled. Milan, interested in running queries, accepted that.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello, does anybody know if there is a sql table/view from sysmaster to get the info which command onstat -g spf provides?
Thank you
------------------------------
Milan
------------------------------
Most of the details (from the scans column right) come from the sysrstcb pseudo table in sysmaster (see the syssesprof view for which columns correspond to the report as the column labels are more similar). The rest comes from the syssdblock pseudo table. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
... or syssqltrace. ------------------------------ Andreas Legner ------------------------------
Yes but the syssqltrace* tables are only populated if you have SQLTRACE enabled! ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
True, but also applying to onstat -g spf, afaik.
------------------------------
Andreas Legner
------------------------------
Thank you to both, Art and Andreas and yes I am interesting the most in currently running queries and assume sql tracing is switched on. ------------------------------ Milan ------------------------------
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g