DSXchange

Team,

We are getting the below error while connecting to Big SQL through DB2 connector. We did catalog and configured isjdbc.config file as well. Any suggestions please?

DB2_Connector_0: DB2 function SQLFetch failed: SQLSTATE = 40504: Native Error Code = -1,229: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL1229N The current transaction has been rolled back because of a system error. SQLSTATE=40504 (CC_DB2Connection::queryServerHostName, file CC_DB2Connection.cpp, line 3,246)

Thanks

SQLState 40504: A system error has caused the unit of work to be rolled back.
SQLCode -1229: The current transaction has been rolled back because of a system error.

https://www.ibm.com/support/knowledgece ... 1229n.html

Doesn't say "why". You'll need to get your DB2 DBA to see what he sees on his side. Should be log with more info from their side.

It does say why The error code can be tapped online to see what the root causes and resolutions might be. This almost always leads back to a DBA, though, but at least you can see what is happening.

I think this is what you seek:
https://www.ibm.com/support/knowledgece ... 1229n.html


Another hit by google said "big sql can have this error due to connection problems caused by high activity"

I would re-run it once more, and if it dies again, get with the DBA.