Using IBM DB2 Universal Database user names and passwords
IBM DB2 Universal Database user name and password behavior that you need to consider include:
- When the DB2 database resides on the same computer as the BMC Remedy AR System (AR System) server, ARAdmin user is not used. You can run the AR System server installer as root or any other user as long as that user has administrator privileges for the specific DB2 instance on which you install the BMC Remedy AR System database.
- When the DB2 database resides on a different computer from the AR System server, the database user name, aradmin, must be created in lowercase before installing AR System server. The database user name is associated with the operating system. For overwrite and new installations (but not for upgrade installations), this operating system account must exist before installing AR System server. The password must be AR#Admin#. After the AR System server is installed, you can change the password.
- Because the database user name is associated with the operating system, you must make password changes in the operating system and set the new password in the AR System Administration: Server Information form. For more information about this form, see Configuring after installation.
See Using IBM DB2 Universal Database with BMC Remedy AR System for DB2-specific information.
Changing the BMC Remedy AR System database user name and password
The BMC Remedy AR System database user (ARAdmin by default) and password (AR#Admin# by default) are set during the AR System server installation. You can, however, change them to suit your needs.
To change the BMC Remedy AR System database user name
- Stop the AR System server.
- Update the database user name in the database. For more information, see your database documentation.
- Update the Db-user option in the ar.conf (ar.cfg) file.
- Open the ar.conf (ar.cfg) file with a text editor.
- Change the Db-user entry to match the value you specified in step 2.
- Save the ar.conf (ar.cfg) file.
- Restart the BMC Remedy AR System server.
To change the BMC Remedy AR System database password
- Use the Database tab in the AR System Administration: Server Information form. See Configuring after installation.
- Use the ARSetServerInfo API call. See ARSetServerInfo.
Do not change this password directly in the database.
To change the database password in a server group, change the password in each AR System server's AR System Administration: Server Information form. Each server attempts to alter the password in the database, but only the first one changes the password. Each server updates its configuration file. On database platforms that require an existing (old) password to perform the change, the server initially logs a failure to the SQL log as servers (after the first one) have their passwords changed. This occurs because the subsequent servers do not know that the first server already changed the password, so they do not supply the correct existing password. The servers recover from this condition and successfully update the configuration file.
See Using IBM DB2 Universal Database with BMC Remedy AR System for special considerations for database user name and password with DB2.