i am unable to connect Db2 thru Datastage

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
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

i am unable to connect Db2 thru Datastage

Post by vinodn »

Hi,

I installed Datastge and db2 in one server, i am unable to import the metadata, while importing meta data by using ODBC table definition i am getting the below error,

DSR.MetaGeta(GET.TABLES)(SQLConnect('gifdb2db','root')): BCI Error:
SQLSTATE=HY000,CODE=1222,[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]Incorrect object length.

Can you please advise how to connect DB2 server,
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Find out from your DB2 documentation what code 1222 means. Then fix that.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:
Contact vmcburney

Post by vmcburney »

Why use ODBC? You should have the DB2 client libraries and you can connect via native DB2.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”