| Author |
Message
|
| syangloo |
 Posted: Fri Nov 08, 2002 8:47 pm Post subject: DB2 Connection error |
 |
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
Dear All,
I'm using the HPUX 11i and DB2 v7.1.
I have the problem for connecting to the DB with the user id use for createing the DB.
Error message is get as below:
SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004
i issue the command as below:
db2 connect to QTMQBKDB user qtuser using ut123
I added the setting at the ODBC.ini file as below:
[QTMQBKDB]
Driver=/home/db2inst1/sqllib/lib/libdb2.sl
Description=QTMQBKDB DB2 ODBC Database
Database=QTMQBKDB
If i issue db2 connect to QTMQBKDb, it working fine. So what is the user id use by "db2 connect to" command.
Your advice is appreciated
Regards |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Nov 08, 2002 10:48 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Are you getting this error in a message flow at runtime?
The broker uses user-id/pwd specified in -u & -p parameter in mqsicreatebroker command to connect to the external database. If you don't specify one, broker will use user-id/pwd specified in -i & -a parameter instead.
Pl make sure you are using correct combination of user-id/pwd.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| syangloo |
| Posted: Sat Nov 09, 2002 5:31 am Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
I deleted the broker and broker db before, now i creating the new db for new broker with the same name as i deleted before.
(At this point, i not creating the broker yet)
I can connected to the db with this command db2 connect to QTMQBKDB, but can't connect to the db with db2 connect to QTMQBKDB user qtuser using qt123. qtuser is the user id i use for creating the db.
Let say, i have two db before, now i deleted one db and other db still remain. Now when issue the command to connect to the remain db also hitting the same error.
What will cause this error occur? 
I posted the other question for creating the broker at topic creating a config manager.
Any other advice for solving this problem?
What i should check for the db connection authorization id and password?
What is the command i can use for changing the db authorization?
Regards |
|
| Back to top |
|
|
| kirani |
| Posted: Sat Nov 09, 2002 1:17 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Hi,
What did you login as on your machine when db2 connect to QTMQBKDB command works?
Let's say if you login as Administrator on your machine and issue db2 connect command without any user-id/pwd it will use Administrator user-id to connect to the database.
If you want to connect to the db as different user-id/pwd then you could use db2 connect to db user user-id using pwd command.
From the above error it looks like either the user-id doesn't exist or the password is incorrect. Pl verify your user-id/pwd.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| syangloo |
| Posted: Sat Nov 09, 2002 7:38 pm Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
Hi Kinari,
I use the same user is and password for both command to connect the db.
db2 connect to QTMQBKDB -- unix login user id "qtuser" and password "qt123"
db2 connect to QTMQBKDB user qtuser using qt123
It not a different user id and is the is i use for creating the db.
Why this problem happen? Any thing i need to update the DB connection or athouriztion for all DB?
For the existing DB, also having the same error.
Regards |
|
| Back to top |
|
|
| kirani |
| Posted: Sun Nov 10, 2002 11:32 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Try giving authorities (connect, administration, ....etc) to user qtuser on QTMQBKDB database. For example,
| Code: |
GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED,IMPLICIT_SCHEMA,LOAD ON DATABASE TO USER qtuser
|
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| syangloo |
| Posted: Sun Nov 10, 2002 11:12 pm Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
HI Kiran,
Where should i issue the command?
I using the root id and issue the command, is display GRANT: not found
regards |
|
| Back to top |
|
|
| syangloo |
| Posted: Mon Nov 11, 2002 11:30 pm Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
HI Kiran,
I manage to run the GRANT command in the system, but i still hitting the same errors.
Any other advice for me to solve this problem.
Any other expert can help?
Regards |
|
| Back to top |
|
|
| syangloo |
| Posted: Thu Nov 14, 2002 9:54 pm Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
Dear All,
thanks for your advice, i solve the problem with IBM DB2 support.
For solving this probelm, we just need to run the db2iupdt command at the db2home/instance directory with root id.
Regards |
|
| Back to top |
|
|
|
|
