Change db2<sid> password

[Former Member]

Hi folks,

I need to reset the db2<sid> password.

Should I run any extra steps after resetting it in OS level side?

Thanks in advance,

Ma

[Former Member]

Hi Marilia,

After changing any OS user, DB Connection will fail. According to SAP Note 940260, use the below commands(from SIDADM user) to check the connection:

db6util -f

if it is not successful, need to change encryption file at

/usr/sap/SI4/SYS/global/dscdb6.conf

Then use below to commands:

dscdb6up <sid>adm <password>        dscdb6up sap<sid> <password>

Thanks

Asad  

[divyanshu_srivastava3]

Hi Marilia,

For db2sid, change the password, nothing else is required then.

You need to update the password in central system, for eg, solman in DBACOCKPIT or scripts if you have used this password directly.

However, in case of sapsid and sidadm, you need to refer below note.

582875 - DB6: SAP cannot log onto the database

Regards,