Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
#Automation
Error we see is
java.sql.SQLException: [SoftwareAG][DB2 JDBC Driver][DB2]EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT
can some one help with error or any fix available.
What is the IS version here?
Are you experiencing this issue first time or this worked before?
HTH, RMG
IS version is 8.2.2
It’s not working for any queue…upgrade has happened from 7.1.2 to 8.2.2
is this the immediate error you are getting after upgrade?
yes…
Did you run migrate scripts in TN schema…during migration???
What migrate scripts you ran during this upgrade 712–>822 so far?
And where are you exactly seeing this error? while creating JDBC pools or JDBC AS for DB2?
Hi RMG,
We did ran scripts
Contacted SAG Support they suggested us to do following and it worked
Please add the following to your TN JDBC Url:
;CreateDefaultPackage=TRUE;ReplacePackage=TRUE;DynamicSections=1000
OK thanks for the update back:
quick question: Do you know is this settings apply only to DB2 based pool connection?