How to update the password file using dscdb6up under Windows IBM DB2

 

How to update the password file using dscdb6up under Windows IBM DB2.

If you need to update the password file (dscdb6.conf), if you have changed password of <sid>adm user.

    Scenario 1

    You have changed the OS password of <sid>adm user beforehand.

    Scenario 2

    You have changed the OS password of <sid>adm user together with the password file update.

Solution for scenario 1

    dscdb6up -create <connect_user password> <current <sid>adm password>

    Solution for scenario 2

   dscdb6up <sid>adm <new password>

   Remarks:
   You may get the following error when executing the above command.
   **************************************************************************
   Current OS password does not match password in password file.
   Please enter current OS password for '<domain>\<sid>adm':
   **************************************************************************
   In such case, you need to enter the old (current) password first.

Note: dscdb6up file location SAP Kernel directory.