Changing the DB2 user ID and password

About this task

To change the DB2® user ID and password, you must manually update the configuration file by completing the following steps:

Edit the Common.cfg file, which is typically found in installation_directory\config.
Within the [Database] section, locate the following lines:
```
username = DBUSER 
password* = DBPW
```
Type the new administrator user ID and password over the previous text to the right of the equal sign, for example:
```
username = NewUSER 
password* = NewPW
```
Tip:
Use a user ID that has SELECT, UPDATE, DELETE, and INSERT authority for the Rational® Asset Analyzer tables and has SELECT authority to various catalog tables, such as SYSIBM.SYSTABLES and SYSIBM.SYSSYNONYMS.
When the enterprise application is restarted, the DB2 password is encrypted, and will be displayed in the Common.cfg file as an encrypted string, for example:
```
password* = {aes}REYyNzI0MEM0N0M4ODhERUU1NjUxRDI3QTY3RjVFN0E=
```
If you are using the embedded application server, run the command installation_directory\bin\server restart. Otherwise, from the WebSphere® Application Server administrative console, restart the Rational Asset Analyzer enterprise applications.