Error connecting to Big SQL

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
raji33
Premium Member
Premium Member
Posts: 151
Joined: Thu Sep 23, 2010 9:21 pm
Location: NJ

Error connecting to Big SQL

Post by raji33 »

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
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

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.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
UCDI
Premium Member
Premium Member
Posts: 383
Joined: Mon Mar 21, 2016 2:00 pm

Post by UCDI »

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.
Post Reply