Reset Password DB2 Database

[former_member306260]

Dear all,

I have handover the SAP System from the old Basis. But i didn't recieve the DB Admin password.

So if i reset the password, which point do i need to check before process ?

My system was AIX, DB2 v9.1

thanks

[maria_shen · Accepted solution]

Hello,

DB2 will authenticate user at OS level.

For db2<sid> user, OS password change should be ok.

For SAP connect user, or <sid>adm user, besides OS password change, you have to update the password configuration file using dscdb6up. e.g. dscdb6up <sid>adm <password>.

Kind regards
Maria

[former_member306260]

HI all !

I have successfully to change the password for DB2<SID>.

But my concern is  if i create a new user with the authorizations same as DB2<SID>, eg DB2BAK, so can it work like DB2<SID> ?

Thanks

[Former Member]

Hello,

If you create the user with authorizations the same as DB2<SID>, please change the password of it as you have done like DB2<SID>.
If you need to change the password of connection user or <sid>adm, please change the password
as the detailed info of note 582875.

Best regards
Alfred

[former_member306260]

Thanks Alfred

Regards,

Luan

[former_member306260]

Thank you all

[Former Member]

Hello Pham,

Please check the following Links.

For unix-linux-Aix

Changing Passwords of the Database Standard Users - IBM DB2 for Linux, UNIX, and Windows under UNIX ...

For Windows:-

DB2: Changing Ready-to-Run User Passwords - DB2 UDB Database Administration (BC-RRR) - SAP Library

Regards

Anand