DB2 Import error

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
velagapudi_k
Premium Member
Premium Member
Posts: 142
Joined: Mon Jun 27, 2005 5:31 pm
Location: Atlanta GA

DB2 Import error

Post by velagapudi_k »

I am trying into import Table Defnitions from DB2 using ODBC connectivity and I am getting the below error. Not sure if its a DB2 issue or Datastage issue. I am new to DB2.

DSR.MetaGeta(GET.DSNINFO)(SQLConnect('DB','userid')) : BCI Error :
SQLSTATE=S1000,CODE=-567,[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][DB2]AUTHORIZATION ERROR BIND 'userid'. DB.NULLID.DDOS510A CREATE IN

Any replies would be helpful. Appreciate your help.
Venkat Velagapudi
kittu.raja
Premium Member
Premium Member
Posts: 175
Joined: Tue Oct 14, 2008 1:48 pm

Post by kittu.raja »

Seems like credential problem but not sure
Rajesh Kumar
Teckamal
Participant
Posts: 3
Joined: Sun Mar 14, 2010 10:08 am
Location: IN

Post by Teckamal »

kittu.raja wrote:Seems like credential problem but not sure
yes, its a privilege issue. get the right privileges to complete your action.
there is a way to discover things
Post Reply