Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: Activate Replication Agent

    dear friends,
    i want to replicate the DML,DDL & all which are happening at one database SRCDB at SERVER1 to database REPDB at SERVER2. The replication server REPSRV is installed on SERVER2.
    if i run "sp_help_rep_agent srcdb" at SERVER1, i am getting

    1> sp_help_rep_agent srcdb
    2> go
    Replication Agent Recovery status
    dbname connect dataserver
    connect database status
    rs servername rs username
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    srcdb SERVER1
    srcdb not active
    REPSRV REPSRV_ra
    Replication Agent Process status
    dbname spid sleep status
    retry count last error
    ------------------------------ ----------- ------------------------------
    ----------- -----------
    srcdb 1 end of log
    0 0
    Replication Agent Scan status
    dbname start marker
    end marker current marker
    log recs scanned oldest transaction
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    ---------------- ------------------------------
    srcdb (772,17)
    (772,19) (772,19)
    0 (-1,0)
    Replication Agent Configuration
    dbname auto start
    rs servername rs username
    connect dataserver connect database
    scan batch size scan timeout retry timeout
    skip ltl errors batch ltl
    send warm standby xacts send maint xacts to replicate
    ha failover skip unsupported features
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    --------------- ------------ -------------
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    srcdb true
    REPSRV REPSRV_ra
    SERVER1 srcdb
    1000 15 60
    false true
    false false
    true false
    Replication Agent Security Configuration
    dbname security mechanism
    unified login msg confidentiality
    msg integrity msg replay detection
    msg origin check msg out-of-sequence check
    mutual authentication
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    ------------------------------ ------------------------------
    ------------------------------
    srcdb n/a
    false false
    false false
    false false
    false
    (return status = 0)

    if i run "admin who" at REPSRV, i am getting

    1> admin who
    2> go
    Spid Name State Info
    ---- ---------- -------------------- ----------------------------------------
    25 DSI EXEC Awaiting Command 102(1) SERVER1.srcdb
    20 DSI Awaiting Command 102 SERVER1.srcdb
    22 DIST Active 102 SERVER1.srcdb
    23 SQT Awaiting Wakeup 102:1 DIST SERVER1.srcdb
    21 SQM Awaiting Message 102:1 SERVER1.srcdb
    19 SQM Awaiting Message 102:0 SERVER1.srcdb
    33 REP AGENT Awaiting Command SERVER1.srcdb
    12 DSI EXEC Awaiting Command 101(1) SERVER2.repdb
    8 DSI Awaiting Command 101 SERVER2.repdb
    11 SQM Awaiting Message 101:0 SERVER2.repdb
    9 dSUB Active
    6 dCM Awaiting Message
    7 dAIO Awaiting Message
    10 dREC Active dREC
    35 USER Active sa
    5 dALARM Awaiting Wakeup

    Is this status show that replication agent is running? if yes, how can i enable replicating all transaction in SERVER1 to SERVER2? If no, how can i activate REP AGENT? and where i can i verify that replication is happening.? in this case i didnot create any replication definition. bcas i m not able to create in any server. i didnot do anything for LTM. Is replication definition necessary in this case?

    Thank u all,

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    The replication of the DDL satements is only possible in a warm-standby architecture. What's the version of your RS server ?
    F. Celaia
    DBA Sybase/DB2/Oracle/MS-SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •