Troubleshooting guide
Subsequent initialization
Create another Replication Agent instance, after you have already initialized the primary data
server.
See also
•
Verifying the Replication Agent Replicating State
on page 73
Creating and Initializing a Replication Agent Instance
Execute the resource file to create the Replication Agent instance.
1.
After the resource file has been validated, use the ra_admin utility to create the Replication
Agent instance using the -r parameter. For example:
%SYBASE%\RAX-15_5\bin\ra_admin -r myra.rs
Execution results are returned as either:
•
Response-file processing completed
Or
•
Response-file processing completed with errors
See the
Replication Agent Administration Guide
.
2.
If your resource file has initialize_instance set to no, start the Replication Agent instance.
a) Change to the directory containing your Replication Agent instance RUN file, for
example:
b) Execute the RUN file, for example:
RUN_myra
3.
Use dsedit to update the Replication Server sql.ini to include an entry for the
Replication Agent location.
To use direct load materialization, also add the server name part of the connection name to
the interfaces file. This entry should point to Replication Agent. For example:
pds
master tcp ether hostname 9030
query tcp ether hostname 9030
4.
Verify the connection to Replication Agent.
a) Open a command window in the %SYBASE% directory of your Replication Agent
installation.
b) Set the environment variables by executing the SYBASE.bat file.
c) Log in to Replication Agent:
isql –Usa –Psa_pass –Smyra
5.
If your resource file has initialize_instance set to no, open a new command window, log in
to the Replication Agent instance, and initialize the Replication Agent instance and the
primary Microsoft SQL Server database using this Replication Agent command:
CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup
72 Replication Server