R
Rob Fitzpatrick
Guest
> -B 1500000 -B2 250000 -L 400000 -n 1500 -bibufs 200 -aibufs 200 -lkrela -spin 64000 -S MYPRIMARY -DBService replserv -pica 32768 -tablerangesize 1050 -indexrangesize 4200 -omsize 5200 -semsets 12 -bithold 32768 -lruskips 200 -aiarcdir /aiarchive -aiarcinterval 3600 -prefetchDelay -prefetchPriority 100 -refetchNumRecs 100 -Nmsgwait 2 -Mm 32000 -Mn 62 -Mpb 40 -Ma 5 -Mi 1 Unrelated to ODBC... - you have a typo in what should be -prefetchNumRecs 100 - either the *rangesizes are a fair bit higher than they need to be (which is fine) or omsize isn't high enough; do you have fewer than 5200 _storageobject records? - I'm curious about your reason for using -lkrela; I view it as a backward-compatibility param to use as a work-around if you encountered errors with the "new" (10.1B) lock-release algorithm, with the downside that it can impact performance, especially with a large -L. Did you encounter such errors? - since you are using -B2 and -lruskips, it's not a bad idea to add -lru2skips as well, in the event that the LRU2 replacement policy becomes enabled (i.e. you fill the ABP to capacity)
Continue reading...
Continue reading...