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
------------------------------
Original Message:
Sent: Thu September 14, 2023 11:03 AM
From: Andreas Legner
Subject: SMI equivalent of onstat -g spf
True, but also applying to onstat -g spf, afaik.
------------------------------
Andreas Legner
------------------------------
Original Message:
Sent: Thu September 14, 2023 10:01 AM
From: Art Kagel
Subject: SMI equivalent of onstat -g spf
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
Original Message:
Sent: Thu September 14, 2023 09:05 AM
From: Andreas Legner
Subject: SMI equivalent of onstat -g spf
... or syssqltrace.
------------------------------
Andreas Legner
Original Message:
Sent: Thu September 14, 2023 06:35 AM
From: Art Kagel
Subject: SMI equivalent of onstat -g spf
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