today we got a error in was log after application deployement

Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0443N Routine “SYSIBM.SQLCOLUMNS” (specific name “COLUMNS”) has returned an error SQLSTATE with diagnostic text “SYSIBM:CLI:-727”. SQLSTATE=38553

solution for this issue

C:\DB2_ESE\bnd>db2 update db cfg for ewelfare using STMTHEAP 1024
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

C:\DB2_ESE\bnd>db2 BIND db2schema.bnd BLOCKING ALL GRANT PUBLIC sqlerror continue

Advertisements