Add a primary database to the Replication Server for MSA.
Parameter | Description | Value |
---|---|---|
sybinit.release_directory | Valid path of the Replication Server software ($SYBASE). | /opt/sybase |
rs.rs_name | Name of the Replication Server. | PRS |
rs.rs_rs_sa_user | Specifies the user ID that has “sa” privileges on Replication Server. | sa |
rs.rs_rs_sa_pass | Specifies the password of the “sa” user. | sa_pass |
rs.rs_ds_name | Name of the data server that hosts the primary database. | sunak1502i |
rs.rs_ds_sa_user | Specifies the user ID that has “sa” privileges on data server. | sa |
rs.rs_ds_sa_password | Specifies the password of the “sa” user for the data server. | password |
rs.rs_db_name | Specifies the name of the primary database. | pubs2 |
rs.rs_needs_repagent | Specifies whether you plan to replicate from specified primary database. | yes |
rs.rs_db_maint_user | Specifies the user ID whose work is not replicated when logged on the primary database. The user is called maintenance user. | <database>_maint
Note: If the user ID does not exist, the
script creates the user ID on the database. The user ID
cannnot be the name of an alias.
|
rs.rs_db_maint_password | Specifies the password for the maintenance user. | <database>_maint_ps |
rs.rs_ltm_rs_user | Specifies the user that the Replication Agent will use to log into the Replication Server. The name must exist. This name typically comes from values that were set up during Replication Server creation time: rs.rs_ltm_rs_user. | PRS_ra |
rs.rs_ltm_rs_pass | Specifies the password of the rs.rs_ltm_rs_user. | PRS_ra_ps |
rs.rs_db_physical_for_logical | Specifies whether this is a warm standby database. | no |
./rs_init -r ../init/rs/myprimary.rs
sp_config_rep_agent pubs2,'disable' go
Re-run rs_init command
isql -Usa -Psa_pass -SPRS
admin who go The output from the command looks similar to: Spid Name State Info ------ ------- ------------ ----------- 48 DSI EXEC Awaiting Command 102(1)sunak1502i.pubs2 33 DSI Awaiting Message 102 sunak1502i.pubs2 35 DIST Awaiting Wakeup 102 sunak1502i.pubs2 36 SQT Awaiting Wakeup 102:1 DIST sunak1502i.pubs2 34 SQM Awaiting Message 102:1 sunak1502i.pubs2 32 SQM Awaiting Message 102:0 sunak1502i.pubs2 37 REP AGENT Awaiting Command sunak1502i.pubs2 39 NRM Awaiting Message sunak1502i.pubs2 27 DSI EXEC Awaiting Command 101(1)sunak1505i.PRS_RSSD 20 DSI Awaiting Message 101 sunak1505i.PRS_RSSD 26 SQM Awaiting Message 101:0 sunak1505i.PRS_RSSD 21 dSUB Sleeping 15 dCM Awaiting Message 18 dAIO Awaiting Message 23 dREC Sleeping dREC 9 dDELSEG Awaiting Message 49 USER Active sa 14 dALARM Awaiting Wakeup 24 dSYSAM Sleeping