If the error is a connection failure to the database:
Verify that the data server is defined in the interfaces file.
Verify that the data server is running.
Verify that the maintenance user name and password are correct.
To find the maintenance user name and password for a database, log in to the system Adaptive Server, use the RSSD, and execute the following query:
select username, password from rs_maintusers, rs_databases where destid = dbid and dsname = data_server and dbname = database
If the maintenance user name or password is not correct, you can either change them on the data server or use the alter connection command to change them in the Replication Server. If you have password encryption, you cannot access the password by executing a query. After correcting the user name or password, resume the connection.