Re: Bug 104328 ? Bug 121447 ?

David Williams wrote: >In article <81j41o$ch7$1@news.xmission.com>, michael martin ><michael_martin@komatsu.co.jp> writes >> >><SNIP> >> >>My question is: Has anyone encountered Bugs 104328 and/or 121447 >>and if so what is the fix ? >> > Not encountered but I belive they are fixed in 7.31.UC4-1. > I would move to it. OK >>Is there some place (URL) I should be looking at to keep up >>with bugs instead of dumping my problems on the list ? >> > www.informix.com Techinfo Centre. When you ask for access > provide a product serial number if you are not sure of the > contract number.. Thanks for that I have now signed up. >> >>$ onstat -c>> >># System Configuration >> >>SERVERNUM 2 # Unique id corresponding to a OnLine instance >>DBSERVERNAME baan300 # Name of default database server >>DBSERVERALIASES baan300tcp # List of alternate dbservernames >>NETTYPE ipcstr,4,50,NET >>NETTYPE soctcp,4,50,CPU > NetTYPE soctcp should be on a NET VP. > > Rule is > > soctcp on NET VP > ipcshm required on CPU VP (for onstat etc in case network fails). > > ipcstr (Art ??, one for the FAQ!) I know ipcstr is new-ish.. Thanks, I have now gone back through the archives and read up on that. >>NOAGE 0 # Process aging> Set to 1, else Informix slows down as it uses up more CPU time. I should have seen that myself because it was pointed out to me by Art in response the a previous posting of mine. >>AFF_SPROC 0 # Affinity start processor >>AFF_NPROCS 0 # Affinity number of processors>> > Set these as well, 0/4 or if that fails 1/4. OK will try. >># Read Ahead Variables >>RA_PAGES 400 # Number of pages to attempt to read ahead >>RA_THRESHOLD # Number of pages left before next group>> > 400!!!!! Big system,slow disk... This is a point I am failing to understand. Is what you are saying that it's dumb to set RA_PAGES so high because disk reads are slow ? >>DBSPACETEMP tempdbs # Default temp dbspaces > ... and one temp dbspace for a big system???... Ouch. Again I should have seen this based on previous advice. >>OPTCOMPIND 0 # To hint the optimizer>> > ...and optcompind = 0, use indexes implying not a DSS system!! Sorry for my ignorance but what does DSS stand for ? Michael Martin michael_martin@komatsu.co.jp