Updating the analysis database owner account password

You can change your IBM® InfoSphere® Information Analyzer analysis database owner account credentials after installation.

Before you begin

You must have InfoSphere Information Analyzer administrator authority, and Common Metadata Importer or Common Metadata Administrator role.

About this task

The analysis database owner account has ownership authority over the analysis database. By default, the user name of this account is iauser.

The following procedure refers to changing the password by using IBM InfoSphere Metadata Asset Manager. If you want to change the password by using command line, see the technote How to update Data Connection password for IMAM Import Areas via imam.sh | .bat command.

You can't change the user name in an existing connection, you must create a new one. For more information, see Defining the connection to the analysis database.


  1. Change the analysis database owner credentials on the computer.
    If your database is implemented within IBM Db2®, change the credentials by using standard operating system utilities. If your database is implemented within another database management system, refer to the database management system documentation for information about changing the credentials.
  2. Log in to IBM InfoSphere Metadata Asset Manager.
  3. Open Import tab, and search for the analysis database import area, for example iadb. Select it, and click Open.
  4. Open Staged Imports tab, and click Reimport.
  5. In the Import Parameters section, find Data connection field with the import area name, and click Edit.
  6. In the Edit Data Connection window, specify a new password.
  7. Click OK to save the new password.
  8. Follow the wizard to reimport the database metadata to save the new connection properties.