[ UDB 7.2 EEE FP7, AIX 4.3 ]

ERROR MESSAGE: SQL0973N Not enough storage available APP_CTL_HEAP heap process statement SQLSTATE=57011

Aside from going through a trial-and-error exercise on our production server, does anyone have an algorithm that we can use to come up with an optimal value for this parameter.

Our application uses stored procedures that builds sqls dynamically, uses GLOBAL temporary tables, FEDERATED tables (on OS/390), etc... and returns large result sets.

Thanks for any feedback.