Making the Server User’s IDs Match

Within each data server, the server user’s ID (suid) for each login name must be the same in the syslogins table in the master database and the sysusers table in each user database.

This must be true for the active and standby databases in a warm standby application. The server user’s ID and role settings must also be the same in the syslogins and sysloginroles tables in the master database.

Make the server user’s IDs match using one of three methods:

Add all login names, including maintenance user names, to both Adaptive Servers in the same order. Adaptive Server assigns server user’s IDs sequentially, so the server user’s IDs for all login names will match.
After loading the dump into the standby, reconcile the sysusers table in the standby database with the syslogins table in the master database of the standby Adaptive Server.
Maintain a master Adaptive Server with all of your login names and copy the syslogins table from the master database for the master Adaptive Server to all newly created Adaptive Servers.