Re: sysptprof questoin
No..... ISAMreas are read function calls. Don't assume nothing beyond
that....
Even things like BATCHEDREAD_* can change it.... for the same workload
On Feb 17, 2017 19:59, "MARK JALKIEWICZ" <mark.jalkiewicz@verizon.net>
wrote:
IDS 1150.FC8
I am debugging a "hot table contention issue" by extracting info from the
sysptprof table. To test this script I kicked off a session that forced
repeated sequential scans on the table ( "select * from table ") and the
output from sysptprof is what I expected ; but one thing that seems out of
order is that isreads is increasing proportionally with bufreads (about 50%
of
bufreads); an sqexplain does confirm a seq scan. There are two indexes on
this
table. I do clear the metrics (onstat -z) before starting my monitoring.
Anyone know why isread would increase ? I assumed isreads are soley reads on
index fragments.
Mark
************************************************************
*******************
Forum Note: Use "Reply" to post a response in the discussion forum.
--001a11448bb45601dd0548bfed59