G
George Potemkin
Guest
> They purged last Wednesday and the LOB area continues to grow. Theory says it's impossible - unless if RM chain(s) is broken. BTW, 'proutil carolina -C chanalys "LOB" -scan' will report the chain's corruptions if they exist. Viewdbblock says the blocks at the beginning of area are full of LOB data. This means the space is re-used. You can use the script to check the blocks just below area's HWM: > 1781948 total blocks found in the storage area. It's dbkey 114044672 (= 1781948 * 64) or lower. BTW, I'd rise the toss limit for the zsaztdl.querydata field to 900 bytes or so. There are no reasons to have the long RM chains for LOB fields. On other hand you will be unable to use dbanalys to estimate the number of blocks allocated for LOB (untill V11.6). But 'viewdbblock db area bkObjDbkey' will report the accurate number with your Progress version.
Continue reading...
Continue reading...