This discussion is archived
2 Replies Latest reply: Nov 7, 2012 4:54 AM by 435128 RSS

OWB 11G error during returning data from DB2

435128 Newbie
Currently Being Moderated
Hi,

I am trying to bring data from DB2 into Oracle. DB2 is a Zseries DB, Oracle is 11G.
I have brought all the drives into the correct path (version 3.53.95) and I build a new platform according to what I've seen and experienced on the net.

The new platform seems to behave fine (retrieving schema, tables and views list), but when trying to unload data, it gives me an error:
com.ibm.db2.jcc.b.eo: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=GGDWHET;SELECT;DB2OWNER.TPARKAT, DRIVER=3.53.95

This is a very simple 1-1 mapping - I used SQL_TO_ORACLE loading code template from unloading data.

Did someone have the same issue?

Cheers,
Norbert

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points