Stored Procedures
Problem: How to Increase the Cache.
I have a lot of stored procedures and the stored procedure cache is limited to 50. Can I increase it so that more of stored procedures are cached?
Solution: PC_POOLSIZE
Insert the parameter PC_POOLSIZE into the ONCONFIG file and set it to whatever number you like. This parameter is not usually in the ONCONFIG file, but it defaults to 50.
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
