Topic
1 reply Latest Post - ‏2009-09-28T12:15:17Z by lenin2k
SystemAdmin
SystemAdmin
6968 Posts
ACCEPTED ANSWER

Pinned topic How to get the table info DSY.SYNC_STATS to an iSeries file?

‏2009-09-15T15:38:21Z |
We have a DB2e Sync Server that manages our field peoples mobile devices. I have been given the task to get the data from the table DSY.SYNC_STATS from a DB2e Sync Server over to an iSeries file so it can be used in a WOW application. I have read the DB2 Everplace help topic at http://publib.boulder.ibm.com/infocenter/db2e/v9r1/index.jsp?topic=/com.ibm.db2e.doc/sync_stats_query.html, which gives an sql statement. However, I am not understanding where this SQL statement should be used. Or if this is the route I should be taking. Does anyone have any suggestions on how to accomplish this task?
Updated on 2009-09-28T12:15:17Z at 2009-09-28T12:15:17Z by lenin2k
  • lenin2k
    lenin2k
    17 Posts
    ACCEPTED ANSWER

    Re: How to get the table info DSY.SYNC_STATS to an iSeries file?

    ‏2009-09-28T12:15:17Z  in response to SystemAdmin
    Hi Bsbrei,

    I think that the information about the Sync Stats is stored only in the mirror database, it is not replicated to the source database. In the DSY schema on the iSeries there are only system tables , but if you open the DB2 Universal Database Control Center in the mirror server and execute the SQL Statement on DSYCSTAT Database

    SELECT SyncOpID, ServerTS, Status
    FROM DSY.SYNC_STATS
    WHERE UserID = 'nurse1' AND
    ServerTS >= '2004-01-01-00.00.00' AND
    ServerTS <= '2004-12-31-23.59.59'

    You will get your Sync Statistics, in the attachment you can see the screenshot of DB2 Control Center on the mirror server

    Regards