Support Article
Problem encoutered executing stored procedure
SA-8106
Summary
You experience DB2 SQL errors on startup and regularly during application operation:
Error code -206: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=PR_USAGE_SUMMARY.PYPERIODSTARTS, DRIVER=4.14.122
Error Messages
SQLState 42703, Error code -206: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=PR_USAGE_SUMMARY.PYPERIODSTARTS, DRIVER=4.14.122
in SQL: {call DATA.sppr_aggregate_usage ()}
Steps to Reproduce
This error happens on startup and periodically through out the application. The environment is:
JBOSS EAP 6.2 Application Server
DB2 / LUW 9.7
DB2 JDBC 4.0 driver (db2jcc4.jar)
Root Cause
The JDBC datasource custom properties were not correctly set: currentSchema and currentFunctionPath.
Resolution
For a split schema installation, currentSchema should be set to the data schema name and currentFunctionPath should be set to SYSIBM,SYSFN,[data schema name]
Published June 12, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.