DataStage Errors while trying to write records to DB2 Connector Stage

DataStage Errors while trying to write records to DB2 Connector Stage

One more annoying error that I faced yesterday when I tried to Load data on to a DB2 database

It took lot of hours to find the root cause of the problem even though every thing looks fine in Job

DB2 function SQLFetch failed:  SQLSTATE = HY000: Native Error Code = -1,042: Msg = [IBM][CLI Driver][DB2/AIX64] SQL1042C  An unexpected system error occurred.  SQLSTATE=58004 (CC_DB2Connection::queryServerHostName, file CC_DB2Connection.cpp, line 3,256) 

This problem occurs when DB2 heap size is set to too low on DB Side and can be resolved easily

To Fix this problem

Increase DB2_FMP_COMM_HEAPSZ on the db2 side (with the help of DBA and they might to restart the instance)

Probably – once you increase the heap size job should run fine without any issues

Author: Kuntamukkala Ravi

ETL Consultant by Profession, Webmaster by Passion

Leave a Reply

Your email address will not be published. Required fields are marked *