Re: Check points extremely , extremely long & other issues

From: "pankaj" <pankaj.patel@punks.demon.co.uk> > >I know I have to increase number of CLEANER to the same value as the LRS. Just make sure the number is not a power of 2. Like 16, say. :-) Try 17. How many disks are on the machine. >NETTYPE soctcp,2,200,CPU # Configure poll thread(s) for Might want to try soctcp,2,200,NET >LOCKS 50000 # Maximum number of locks Too low. >NUMAIOVPS 10 # Number of IO vps KAIO? >PHYSBUFF 32 # Physical log buffer size (Kbytes) >LOGBUFF 32 # Logical log buffer size (Kbytes) Depending on your logging mode, you might tweak these. >DBSPACETEMP tempdbs # Default temp dbspaces You might want to create more than one temp dbspace. ># Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS >OPT_GOAL 4294967295 You probably want 0 for Baan. >Physical Logging >Buffer bufused bufsize numpages numwrits pages/io > P-2 8 16 684078 43647 15.67 Yep, you can probably increase PHYSBUFF. > phybegin physize phypos phyused %used > 200035 204800 65916 520 0.25 > >Logical Logging >Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io > L-3 4 16 17193934 1037551 93180 16.6 11.1 But not LOGBUFF... Did I miss the onstat -p output? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Thanks very much Obnoxio The Clown. Help very much appreciated. And no you did not miss the onstat -p . I may have deleted in the cutting and pasting. But here it is. Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 8364400 4123327 476705754 98.25 1590809 3175624 20540646 92.26 isamtot open start read write rewrite delete commit rollbk 277036502 7367363 38810311 122440839 3047912 2798382 927089 741207 5894 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 47149.46 90698.70 478 1660 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 1558835 0 172670248 0 0 1686 194242 216797 ixda-RA idx-RA da-RA RA-pgsused lchwaits 6020100 4471 20004 5658126 112464 Obnoxio The Clown wrote in message <7raugv$mn5$1@news.xmission.com>... > >From: "pankaj" <pankaj.patel@punks.demon.co.uk> >> >>I know I have to increase number of CLEANER to the same value as the LRS. > >Just make sure the number is not a power of 2. Like 16, say. :-) > >Try 17. How many disks are on the machine. > >>NETTYPE soctcp,2,200,CPU # Configure poll thread(s) for> >Might want to try soctcp,2,200,NET > >>LOCKS 50000 # Maximum number of locks> >Too low. > >>NUMAIOVPS 10 # Number of IO vps> >KAIO? > >>PHYSBUFF 32 # Physical log buffer size (Kbytes) >>LOGBUFF 32 # Logical log buffer size (Kbytes)> >Depending on your logging mode, you might tweak these. > >>DBSPACETEMP tempdbs # Default temp dbspaces> >You might want to create more than one temp dbspace. > >># Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS >>OPT_GOAL 4294967295> >You probably want 0 for Baan. > >>Physical Logging >>Buffer bufused bufsize numpages numwrits pages/io >> P-2 8 16 684078 43647 15.67 > >Yep, you can probably increase PHYSBUFF. > >> phybegin physize phypos phyused %used >> 200035 204800 65916 520 0.25 >> >>Logical Logging >>Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io >> L-3 4 16 17193934 1037551 93180 16.6 11.1 > >But not LOGBUFF... > >Did I miss the onstat -p output? > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com >