R
Ruanne Cluer
Guest
"even though the -Bp value is limited by 64?" -Bp is not limited to 64. That's the default. It's limited to 25% of -B and can be increased with -Bpmax "db connection has its own LRU for its -Bp separate from other user's" If you want to get an idea of how when the -Bp user disconnects, their -Bp LRU is then simply added to the -B LRU chain, proserve sports2000 -B 1000 -Bpmax 250 Start a PROMON session: R&D > 1 > 7. Buffer Cache prowin sports2000 -Bp 100 FOR EACH Customer NO-LOCK: Display CustNum Name. END. In promon, the Used buffers never goes above -Bp When you exit the -Bp client, their buffers goto the LRU chain Now run the above query without -Bp To get the best idea, you ideally want to add more customer records than the 1117
Continue reading...
Continue reading...