var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ISAM vs PAGE acces
In sysmaster's table 'sysptprof', what is the difference between
'isreads' and 'pagreads' ?
In toehr words, what is the difference between an ISAM access and a PAGE access ?
Any help highly appreciated,
ISAM reads are reads comparable with COBOL.
onstat -p shows you this difference very well (2nd line)
In Cobol when you had to select from a file, you had to
1. Open the file.
2. issue a 'start'
3. read next
It is just a layer in the sql execution process.
a isread is practically the same as a SELECT.
Why are there sometimes more page reads? f.ex when the read ahead stuff is turned on.
An isread can also be a bufread.
Thank you so much for that.
I am looking for some experts to do a few (paid) stuff, if you're interested, can you send an email to email@example.com ?