Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    2

    Unanswered: Q Replication Problem

    Hi,
    I am facing problem in Q replication. Here is the problem synopsis

    Q Subscription in Q Capture Server is in "Loading" state.
    Q Subscription in Q Apply Server is in "Inactive" state.
    The Q Subscription state is not getting changed in Q Apply Server, even if
    we start the Subscription by click the start button.
    Here the data is not getting replicated from source table to target table.
    In Websphere MQ, got some messages in transmission queue of Source manager
    in hexadecimal format.Unable to see any messages in Send Queue.

    Can anyone please help me out in this....

  2. #2
    Join Date
    Jun 2011
    Location
    Boston, Massachusetts
    Posts
    2
    Can you post your subscription definition here? You may need to do the 'LOADDONE' command to indicate that the table on the source and target are in sync and ready for replication.

  3. #3
    Join Date
    Jun 2012
    Posts
    2

    Q Replication Problem

    Hey Catquilt,

    Thanks for your support, Here is the subscription definition.
    In replication window under Source and Target Tab
    Source
    Q Capture Server-- QSource
    Q Capture Schema--ASN
    Table--ASN.EMP

    Queues
    Replication Queue Map--QSource_ASN_TO_QTarget_ASN

    Target
    Q Apply Server--QTarget
    Q Apply Schema--ASN
    Use an existing table
    Table--ASN.EMP2

    Under Subsetting,Errors,Load Tab all are default values

Posting Permissions

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