Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for Applications >

Removing Call Center Duplicate Logins After Upgrade

Upgrades: Release 6.2.1 only.

Environments: All environments.

This topic is part of an upgrade process. See How to Perform the Upgrade.

During the upgrade to Release 7.8, employee and contact data were moved to the same tables. As a result, your database may contain duplicate logins for Contact user login names.

The upgrade appends +ROW_ID to duplicate logins. You must resolve user logins after the upgrade; otherwise, users are unable to log in. For example, contact user login names appear concatenated with their row ID.

To locate user logins that require resolution of duplicates

1. Open your Call Center application and navigate to Site Map > Administration - User.
2. For each User Administration view (Employees, Persons, and Users) query the User ID field for login name=*+*. This query brings up all names that are appended with +ROW_ID.
3. Repeat this procedure for each User Administration view (Employees, Persons, and Users).