DB2 API stage error

suneelchallagali · Post by **suneelchallagali** » Mon Jan 11, 2010 6:20 pm

Biz_type..DB2_UDB_API_0: IBMCLI Driver CLI0124E SQLSTATE=HY009
Unable to connect to DB2 server '172.19.37.158'.
Biz_type..DB2_UDB_API_0.DSLink1: DSP.Open GCI $DSP.Open error -100.

suneelchallagali · Post by **suneelchallagali** » Mon Jan 11, 2010 6:22 pm

I am just loading dataa from db2 to file

suneelchallagali · Post by **suneelchallagali** » Mon Jan 11, 2010 6:27 pm

I have got the solution just type alias server name rather than writting IP or original server name. just create alias server name on host file and give the same name in db2 api stage under servername

thank you,

ravireddy25 · Post by **ravireddy25** » Wed Jul 13, 2011 12:24 pm

can you plz expand it, iam also facing the same(below) issue

DSTAGE-DB2CLI-0027`:`SQLExecDirect: Error executing statement 'SELECT <columnames> FROM <tablename> '. See following DB2 message for details.
DSP.Open GCI $DSP.Open error -100.