Posted: Mon Jul 14, 2003 3:13 am Post subject: Cannot create broker.
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...
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.
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