No FCM buffers are available

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
joesat
Participant
Posts: 93
Joined: Wed Jun 20, 2007 2:12 am

No FCM buffers are available

Post by joesat »

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!
Last edited by joesat on Fri Feb 13, 2009 6:09 am, edited 2 times in total.
Joel Satire
Top
joesat
Participant
Posts: 93
Joined: Wed Jun 20, 2007 2:12 am

Post by joesat »

:)
Joel Satire
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”