DSXchange

Hi,

I searched the forum for 'DSD.BCIGetNext call to SQLFetch failed' error and there were replies based on the 'SQL State'. Looks like this 'No FCM buffers are available' issue has not been dealt before.

• jobname..stagename.linkname: DSD.BCIGetNext call to SQLFetch failed.
  SQL statement:
  <SQL statement goes here>
  SQLSTATE=57011, DBMS.CODE=-6040
  [DataStage][SQL Client][ODBC][IBM][CLI Driver][DB2/AIX64] SQL6040C No FCM buffers are available. SQLSTATE=57011

The IBM documentation had the following details related this SQLSTATE

http://publib.boulder.ibm.com/infocente ... 6040c.html


The fatal error in the datastage logs had the following statement

• JobName..TransformerStageName: |19|

Could someone shed some light on what this error is? Thanks!

From your link, it sounds like a DB2 issue and one that you'd need to take to your DBA for resolution.