ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Cannot create broker.

Post new topic  Reply to topic
 Cannot create broker. « View previous topic :: View next topic » 
Author Message
jgooch
PostPosted: Mon Jul 14, 2003 3:13 am    Post subject: Cannot create broker. Reply with quote

Acolyte

Joined: 29 May 2002
Posts: 63
Location: UK

Hi,

We're trying to create our new WMQIv2.1 UAT environment on Solaris 8 and we cannot create the brokers. We get the ODBC error:-
Quote:
BIP2322E: Database error: SQL State '08004'; Native Error Code '-1403'; Error Text '[IBM][CLI Driver] SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004
'.
The error has the following diagnostic information: SQL State '08004' SQL Native Error Code '-1403' SQL Error Text '[IBM][CLI Driver] SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004

We have successfully created v2.1 brokers previously on (seemingly) identical environments. The only difference this time is that DB2 has been installed into a different location.

Installed on the server are:-
MQ 5.3
DB2 v7.1 + FP3 + FP5
WMQI2.1 + NNSY + CSD04 + fix for IY43115

We use the ID wmqi to run the brokers and db2admin to administer DB2 so the creation command we're using is:-
mqsicreatebroker BWMQU02 -i wmqi -a xxxx -q MWMQUD02 -n BWMQU02 -u db2admin -p xxxx

The $ODBCINI file contains:-
Quote:
[ODBC Data Sources]
BWMQU02=IBM DB2 ODBC Driver
...snip...

[BWMQU02]
Driver=/Software/IBMdb2/home/db2admin/sqllib/lib/libdb2.so
Description=BWMQU02 DB2 ODBC Database
Database=BWMQU02
...snip...


A difference I have spotted, but think might be a red herring, is that db2admin's home directory has slightly different rights:-
On the working environment it is:-
Quote:
drwxrwxrwx 34 1394 db2admin 4608 Jun 18 14:06 .

On the broken environment it is:-
Quote:
drwxr-xr-x 4 db2admin db2admin 512 Jul 14 12:19 .

The sub-directories, like db2admin (the DB2 instance) and sqllib are identical across the servers.

Can anyone help?

Thanks,

J.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Cannot create broker.
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
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.