I am working on DB2 UDB 8.1 FP 4 on AIX 5.2. When I am trying to rebinding a particular package I am getting the below error. As per that error message recommending to increase statheap size. Currently statheap set to 2048 and I changed to 4096 then I tried to rebind the package and received exactly same warning message.
Can some one please help me how to fix this problem?
Also How do I exactract SQL statement from particulat package?
SQL0437W Performance of this complex query may be sub-optimal. Reason code:
Short Question consurning this warning. I also get it, but i want to ignore it. Now the problem is the compiler looks what the returncode from the precompile was, and if its not zero, it does not compile the resulting sqc file. Now the db2 precompiler does not return zero if a warning occur. That is, in my opinion, completly wrong.
Therefore, i would like to completly IGNORE such warnings, they shouldn't even be printed out. Is there any possibility (eg. a flag) which can help me?