TN Queue returning error in 7.1.2

, ,
1

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.

2

What is the IS version here?

Are you experiencing this issue first time or this worked before?

HTH,
RMG

3

IS version is 8.2.2

It’s not working for any queue…upgrade has happened from 7.1.2 to 8.2.2

4

is this the immediate error you are getting after upgrade?

5

yes…

6

Did you run migrate scripts in TN schema…during migration???

7

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?

HTH,
RMG

8

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

9

OK thanks for the update back:

quick question:
Do you know is this settings apply only to DB2 based pool connection?