MQSeries.net :: View topic - db2 schema problem

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » db2 schema problem

db2 schema problem

« View previous topic :: View next topic »

Author

Message

shubha_s

Posted: Thu Feb 11, 2010 4:29 am Post subject: db2 schema problem

Acolyte

Joined: 10 Mar 2009
Posts: 57

Hi,

I have created the tables in DB2 using the user_id used to create the broker and the DSN also.
The tables are in that user_id schema.
But when I put a message am getting a DB exception saying
"[IBM][CLI Driver][DB2/NT64] SQL0204N <schema>.<table-name> is an undefined name. SQLSTATE=42704

Can any one tell me what I am supposed to do? Irestarted all the db services, but in vain!!

--
Thanks

smdavies99

Posted: Thu Feb 11, 2010 5:36 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Can you show us your code?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » db2 schema problem

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP