MQSeries.net :: View topic

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 Error

DB2 Error

« View previous topic :: View next topic »

Author

Message

Missam

Posted: Mon Aug 01, 2005 7:40 am Post subject: DB2 Error

Chevalier

Joined: 16 Oct 2003
Posts: 424

Hai,
I'm trying to connect to a remote DB2 database which resides on a mainframe box.
I created a ODBC conenction on the local AIX box which is hosting the broker.I have WBIMB 5.0 CSD 4 ,DB2 8.1 Fixpack 8 on this Box.
And my .odbc.ini entry is

Code:

TEMPDB=IBM DB2 ODBC Driver

[TEMPDB]
Driver=/u/db2inst4/sqllib/lib/libdb2.a
Description=TEMPDB DB2 ODBC Database
Database=TEMPDB

when i run the flow i get this error

Quote:

'[IBM][CLI Driver][DB2] SQL0440N No authorized routine named "SQLPROCEDURES" of type "" having
compatible arguments was found. SQLSTATE=42884 '

Any help will be appreciated

Thankyou

wschutz

Posted: Mon Aug 01, 2005 10:05 am Post subject:

Jedi Knight

Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)

Did you see this article:
http://www-128.ibm.com/developerworks/forums/dw_expandTree.jsp?thread=60138&forum=293&cat=19&message=4104225
_________________
-wayne

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB2 Error

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