[progress Communities] [progress Openedge Abl] Forum Post: Re: Are There Any Caveats...

[George Potemkin]

The tests were re-done with a fresh mind. The trick is a bit harder than I thought yesterday: the -lruskips sets new "countdown" value in the buffer headers only when a buffer is accessed (obviously) and only when its current "countdown" counter is zero (what I missed yesterday). proserve sports -lruskips 0 promon sports Step 1: promon reads ACO blocks at its startup: promon/R&D/debghb/6/1. Cache Entries 05/09/16 Status: Cache Entries Num DBKEY Area Hash T S Usect Flags Updctr Lsn Chkpnt Lru Skips 33 64 1 139 O 0 L 4 0 0 0 0 34 64 6 824 O 0 L 1385 0 0 0 0 35 64 7 74 O 0 L 43 0 0 0 0 36 64 8 211 O 0 L 10 0 0 0 0 37 2 9 348 O 0 L 6 0 0 0 0 38 2 10 485 O 0 L 6 0 0 0 0 39 64 11 622 O 0 L 6 0 0 0 0 Step 2: Increase the -lruskips and access the ACO blocks. 4. Administrative Functions ... 4. Adjust Latch Options 8. Adjust LRU force skips: 100 U - Update activity counters (any "Activity" screen) in promon or read any VST table. Look at the "Skips" coulmn. Num DBKEY Area Hash T S Usect Flags Updctr Lsn Chkpnt Lru Skips 33 64 1 139 O 0 L 4 0 0 0 100 34 64 6 824 O 0 L 1385 0 0 0 100 35 64 7 74 O 0 L 43 0 0 0 100 36 64 8 211 O 0 L 10 0 0 0 100 37 2 9 348 O 0 L 6 0 0 0 100 38 2 10 485 O 0 L 6 0 0 0 100 39 64 11 622 O 0 L 6 0 0 0 100 Step 3: Access the ACO blocks again. U - Update activity counters Num DBKEY Area Hash T S Usect Flags Updctr Lsn Chkpnt Lru Skips 33 64 1 139 O 0 L 4 0 0 0 99 34 64 6 824 O 0 L 1385 0 0 0 99 35 64 7 74 O 0 L 43 0 0 0 99 36 64 8 211 O 0 L 10 0 0 0 99 37 2 9 348 O 0 L 6 0 0 0 99 38 2 10 485 O 0 L 6 0 0 0 99 39 64 11 622 O 0 L 6 0 0 0 99 Step 4: Increase the -lruskips to its maximum value and access the ACO blocks. 8. Adjust LRU force skips: 2147483647 U - Update activity counters Num DBKEY Area Hash T S Usect Flags Updctr Lsn Chkpnt Lru Skips 33 64 1 139 O 0 L 4 0 0 0 98 34 64 6 824 O 0 L 1385 0 0 0 98 35 64 7 74 O 0 L 43 0 0 0 98 36 64 8 211 O 0 L 10 0 0 0 98 37 2 9 348 O 0 L 6 0 0 0 98 38 2 10 485 O 0 L 6 0 0 0 98 39 64 11 622 O 0 L 6 0 0 0 98 Step 5: Access the ACO blocks another 98 times UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU... ;-) Num DBKEY Area Hash T S Usect Flags Updctr Lsn Chkpnt Lru Skips 33 64 1 139 O 0 L 4 0 0 0 0 34 64 6 824 O 0 L 1385 0 0 0 0 35 64 7 74 O 0 L 43 0 0 0 0 36 64 8 211 O 0 L 10 0 0 0 0 37 2 9 348 O 0 L 6 0 0 0 0 38 2 10 485 O 0 L 6 0 0 0 0 39 64 11 622 O 0 L 6 0 0 0 0 Step 6: Access the ACO blocks just one more time: Num DBKEY Area Hash T S Usect Flags Updctr Lsn Chkpnt Lru Skips 33 64 1 139 O 0 L 4 0 0 0 2147483647 34 64 6 824 O 0 L 1385 0 0 0 2147483647 35 64 7 74 O 0 L 43 0 0 0 2147483647 36 64 8 211 O 0 L 10 0 0 0 2147483647 37 2 9 348 O 0 L 6 0 0 0 2147483647 38 2 10 485 O 0 L 6 0 0 0 2147483647 39 64 11 622 O 0 L 6 0 0 0 2147483647

Continue reading...