var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Algorithm to calculate optmimal APPL_CTL_HEAP_SZ db parm
[ 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.