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

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.

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

... or syssqltrace.

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.

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

Yes but the syssqltrace* tables are only populated if you have SQLTRACE enabled!

... or syssqltrace.

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.

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

True, but also applying to onstat -g spf, afaik.

Yes but the syssqltrace* tables are only populated if you have SQLTRACE enabled!

... or syssqltrace.

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.

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