MDM 5.5 : db2sid Password changed - Not able to connect to Catalogue

[Former Member]

Hi Guys,

Recently we changed the password the db2sid user at OS level for the MDM 5.5 system.

After changing the password we are facing issues in connecting to Catalogue.

1) When we try to stop mds or mdis at OS level below is the error we get.

Loading '/sapmnt/MDA/LangStrings/CatMgrCommonCore.lang' (eng_US)...

Loaded 1418 strings from '/sapmnt/MDA/LangStrings/CatMgrCommonCore.lang'

Error: 0xffaa0202, Invalid password

2) When we try to connect to MDM catalgoue in MDM console we get the below error.

"Respository connect failed : Error: Invalid logon credentials".

3) And also at the database level we see many errors in db2diag.log.

2010-08-04-17.39.43.101803+060 I32916A271 LEVEL: Warning

PID : 7974 TID : 1

FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20

DATA #1 : String, 65 bytes

Password validation for user db2mda failed with rc = -2146500507

Please let us know the actual procedure to change the db2sid password. I think there is something we need to look into mds.ini file where some password entry is encrypted.

Below are the entries in mds.ini.

[MDM Server]

String Resource Dir=/sapmnt/MDA/LangStrings/

Log Dir=./Logs/

Autostart=0

Log Protocol Transactions=False

Lexicon Dir=/sapmnt/MDA/Lexicons/

MDS Ini Version=1

Accelerator Dir=./Accelerators/

Report Dir=./Reports/

Archive Dir=./Archives/

RELEASE/UseAssert=True

Distribution Root Dir=./Distributions/

CPU Count=1

Wily Instrumentation=True

Wily Instrumentation Level Threshold=0

Default Interface Language Code=eng

Default Interface Country Code=US

SLD Registration=True

IBMDB2 Use Long Varchar For Languages=True

MDS Scone=LRUJFGUVPJBUHFBR72TIHD0A91

Allow Console to Retrieve Files=True

Disable Log Retrieval=False

Log SQL Modifications=False

Extra DBConnection Validation=True

Maximum DBMS Bind Count=512

IBMDB2 DBA Username=SYSIBM

Client Ping Timeout Minutes=0

Inactive Client Timeout Minutes=30

Value Retrieval Threshold=0

Protect Family Nodes With Locked Data=False

Expression Search Limits Picklists=False

Stemmer Install Dir=

[MDM Server/Databases/SRM_MDM_CatalogMDAIDB2_15_3_4_3]

Port=2345

Login=db2mda

Password+=F4SNPQ0S9E76K84CLGUA1GHVME4UNQIBJRQM860

Stemmer Language=

Stemmer Variant=

Valid Keyword Chars=abcdefghijklmnopqrstuvwxyz0123456789

Max Large Text Length=250000

Number of Rows Per Fetch=100

Max Initial MB to Retain=4

Max Send Failure MB to Retain=4

Workflow Detailed Report=False

Mail Server=

Mail SMTP Timeout=1

Regards,

Manje

[Former Member · Accepted solution]

Hi Manje,

Password+=F4SNPQ0S9E76K84CLGUA1GHVME4UNQIBJRQM860

I would suggest give same password you have change at OS level or keep this password as blank after that restart the sever and connect to repository

Hope this will solved your problem if not then revertback

Thanks,

Jignesh Patel

[Former Member · Accepted solution]

Hello Manje

After changing the password we need to restart the MDS for the encryption to happen automatically.

Save the password in mds.ini file without the encryption and then open the mds.ini file again after restarting the MDS.

You can follow the below thread for steps-

Thanks-Ravi

[Former Member · Accepted solution]

Thanks Ravi,

Issue resolved with the help of link provided by you.

[former_member206388]

Hi Manje.

As mentioned by the experts try to change the password, restart the MDM server. Now try to login to the MDM Console and try to connect to a repository if it works now try to launching the Catalog application, it should work now.

Regards

Bala

[Former Member]

Hi All,

We are currently facing similar scenario, in which DB password is made re-set. Can I do the same process as mentioned above - Changing password in CONFIGURATION file(.ini file) will that alone be enough ? or do we need to change at OS level too.

If so may I know how to change the password in OS level.

Thanks in advance.

Regards,

Ganesh Mani.K