| Author |
Message
|
| syangloo |
 Posted: Fri Nov 15, 2002 3:31 am Post subject: Password expired when connect to broker db |
 |
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
Dear All,
hpux 11i, MQSI 2.1, DB 7.1.
Today we did a backup for broker DB, so we stop the broker and qmgr for the db2 backup. After that, we can't bring up the broker. Qmgr is up and only the bipservices is up after the command mqsistart broker.
I try to isseu the command db2 connect to mqsibkdb user iser using password
It display
| Quote: |
| SQL1404N Password expired. SQLSTATE=08004 |
Any idea how to solve this problem?
Regards |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Nov 15, 2002 8:40 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
First change the password for [n]iser[/b] user-id and then run mqsichangebroker command with original parameters, this time specify the new password while running this command.
Restart the broker service after this.
_________________
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: Fri Nov 15, 2002 6:55 pm Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
Hi Kiran,
I get the response from local IBM support, they say this error is due to the OS configuration at installation time.
Any impact for me to change the user password (other then broker)? If the use id i need to change is the one i use for creating all the db like user id db2inst1?
Regards |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Nov 15, 2002 7:51 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
well .. all your applications using this user-id will be impacted by changing the password.
_________________
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: Fri Nov 15, 2002 8:06 pm Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
OK. If i change the db2inst1 password from the hp sam software, then i need to change the broker with mqsichangebroker. This will solve broker problem, then how about the DB2?
Did i need to issue any command to change the DB2 password for the user?
This server is mainly for broker only, How about qmgr? |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Nov 15, 2002 10:30 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
DB2 doesn't maintain any internal user-id/pwd, it uses the OS user-id/pwd instead, so you don't have to issue any command to change db2 password. You don't have to change anything in Qmgr either.
_________________
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 16, 2002 4:47 am Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
Hi Kiran,
Thanks for you advice, we will try to change the password. but before we change the password, we would like to let our local IBM support to check our system configuration.
Regards |
|
| Back to top |
|
|
| kirani |
| Posted: Sat Nov 16, 2002 10:14 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
sure! I forgot to mention one thing, if you have configured your broker qmgr for 2-phase commit then you will have to update your db password also.
Good luck!
_________________
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 17, 2002 3:56 pm Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
| Sorry, What you mean 2 -phase commit? |
|
| Back to top |
|
|
| kirani |
| Posted: Sun Nov 17, 2002 4:40 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
http://www.mqseries.net/phpBB2/viewtopic.php?t=3577&highlight=phase
Chapter 12 in MQSeries System Administration guide explains more about 2-phase commit.
_________________
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 17, 2002 9:34 pm Post subject: |
|
|
Centurion
Joined: 01 Oct 2002
Posts: 120
Location: Kuala Lumpur
|
Thanks Kiran i'll go though it.
Now i solve my problem with the changing the user id password setting in the HPUX SAM setting.
I turn off for the password aging option in the SAM for the user id, then i can connect. But funny thing is, if my user id password is expiry then how can i log in to the system?
Thanks for you advices again. |
|
| Back to top |
|
|
|
|
