Application received several SQL0437W Performance of this complex query might be sub-optimal. Reason code “3”. SQLSTATE=01602
Posted on 2013-11-22
Our application has started to report SQL warnings when it runs:
DBD::DB2::st execute failed: (IBM) (CLI Driver) (DB2/LINUXX8664) SQL0437W Performance of this complex query might be sub-optimal. Reason code “3”. SQLSTATE=01602
For RC=3, it says to increase the size of the statement cache. We have STMM enabled and the sizes of the various memory parameters are all set to AUTOMATIC. The STMTHEAP should grow to accommodate the query as I understand it.
There is plenty of free memory on the database server.
I haven't been able to find the offending sql statement. Even if I do, I don't think the developer would be able to "fix it" quickly.
What can we do in the mean time?