Re: Changing the Stored Procedure Cache (PC_POOLSIZE)

In article <859052869.29347.1@basharlp.ctl.com>, Bashar Chalabi <bashar@ctl.com> writes >Hi there, > >We have ODS 7.10 on SCO OSR5. > >We tried changing the PC_POOLSIZE parameter to increase the size of the stored >procedure cache. The >performance gains are fairly dramatic. However, we now have an unstable system. >Every once in a while, we >get a: > >Assert Failed: Internal Error - Segmentation Violation.> >By removing PC_POOLSIZE from onconfig, we get a stable system. > >Can anybody help? Any reason why PC_POOLSIZE is not the manuals? Because it is not supported..there are several of these parameters which are not documented. I suspect they are only used by the Informix development team when making decisions about how Informix should work internally in a particular port. i.e. when tuning a port of Informix they change these to deciede what the default values should be, then hardcode these as the detauls and make sure Online works correctly with these values.... > >Thanks > >Bashar Chalabi >Card Tech Ltd > -- David Williams