A particular stored procedure when called in an environment works fine but fails in another AIX box with the error message
SQL0973N Not enough storage is available in the "APP_CTL_HEAP_SZ" heap to
process the statement. SQLSTATE=57011
However the APP_CTL_HEAP_SZ is same in both the AIX 5.3 boxes. The only difference which i can see is that it succeeds against a non-paritioned database while on a partitioned database it fails. Will it be a reason ?