Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    31

    Unanswered: Tracking SQL Replication timing from Source to Target

    We're using SQL Replication on DB2 9.1 LUW on Windows to send data from MS SQL 2008 to DB2 on mainframe, and I need to somehow track the timing of how long it takes data to go from the CCD table on MS SQL through the SQL Replication process and finally to the DB2 Mainframe database.

    Is there any log or anything that would show this? For now I'm monitiring the CCD table in MS SQL to watch data drop into then be deleted from the table as it's replicated to Mainframe, but I'd like to see if DB2 has something to show the timing of each transaction.

    Thanks for any suggesions or information.

  2. #2
    Join Date
    Nov 2010
    Posts
    99
    I don't have a direct answer to your question but I would look at table ASN.IBMSNAP_APPLYTRAIL and a combination of columns ENDTIME,SOURCE_CONN_TIME and LASTRUN,LASTSUCCESS.

Posting Permissions

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