Resetting WPG HubAdmin Password

Resolving The Problem

There are 2 methods(Method A and B) to reset the 'HUBADMIN' password in WPG but method A is recommended.

Method A:

Step to reset 'HUBADMIN' password using bcgResetAuthentication.sh script, recommended method. (bcgResetAuthentication.bat script is used in Windows environments)

bcgResetAuthentication.sh script is available under wpg application

DBloader installed path

<installed PATH>/bcgappsdb/scripts/DB2/bcgResetAuthentication.sh

for example, /opt/IBM/bcgappsdb/scripts/DB2/bcgResetAuthentication.sh

Make sure DB2 instance owner has execute permission on script bcgResetAuthentication.sh

1. Open a terminal and switch to db2 instance owner,
   su - <db2 instance owner>
   for example, su - db2inst1
2. connect to wpg application database,
   db2 connect to <wpg application database>
   for example, db2 connect to bcgapps
3. Execute the bcgResetAuthentication.sh from installed path using below command
   ./bcgResetAuthentication.sh <db2 instance owner name> <db2 instance owner password>
   for example, ./bcgResetAuthentication.sh db2inst1 db2inst1

Above steps will reset the 'HUBADMIN' password.

Method B:

Steps to reset 'HUBADMIN' password using db2 commands

1. Open a terminal and switch to db2 instance owner,
   su - <db2 instance owner>
   for example, su - db2inst1
2. connect to wpg application database,
   db2 connect to <wpg application database>
   for example, db2 connect to bcgapps
3. execute the below mentioned commands
   db2 "UPDATE PR_USER SET PASSWORD =
   x'4DC515D55FA80E036EBA47924BD31378', PWDRESETFLG=1 WHERE UserName ='hubadmin'"
   
   db2 "UPDATE db_sysproperties set PROPVALUE = 'False' where PROPNAME
   ='bcg.ldap.containerauth'"
   
   db2 commit