1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

tsm report on failed replications

Discussion in 'Scripting' started by sjimenez3300, Oct 3, 2017.

  1. sjimenez3300

    sjimenez3300 Newcomer

    Joined:
    Sep 29, 2017
    Messages:
    2
    Likes Received:
    0
    Hello all,
    I would like to get a report on failed replication using the OC.(ver 7.1.7)...so that I can get emails with the failures..I found the following select statement but it doesn't tell which node failed :0( ..any suggestions?..or maybe someone knows the ANR that tsm gives out with the failed replication node name?
    SELECT date_time,severity,message from actlog WHERE message LIKE"ANR1893E'' -
    and date_time>current_timestamp-24 hours

    thank you in advance for your help :0)
     
  2.  
  3. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,567
    Likes Received:
    358
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    Try this instead:
    Code:
    SELECT START_TIME,END_TIME,NODE_NAME,STATE,PHASE,COMP_STATE,COMP_REASON,COMP_CODE FROM REPLICATIONVIEW WHERE COMP_CODE!=0 AND START_TIME>current_timestamp-24 hours
    You may need to look at SELECT * FROM REPLICATIONVIEW to see all the fields and possible values in case you need additional filtering. On my test box, they were all successful, so hard to test.
     
  4. sjimenez3300

    sjimenez3300 Newcomer

    Joined:
    Sep 29, 2017
    Messages:
    2
    Likes Received:
    0
    Marclant thank you!! it took me a while to tweak the select statement but I think I got it..however, I'm trying to double check in the actlogs but not seeing it..here is my select; SELECT START_TIME,END_TIME,NODE_NAME,STATE,PHASE,COMP_STATE,COMP_REASON,COMP_CODE FROM REPLICATIONVIEW WHERE COMP_STATE='COMPLETE' AND START_TIME>current_timestamp-24 hours
    I got;

    START_TIME END_TIME NODE_NAME STATE PHASE COMP_STATE COMP_REASON COMP_CODE
    2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 ENDED NONE COMPLETE NONE 0
    2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 FAILED REPLICATING COMPLETE NONE 0
    2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 FAILED REPLICATING COMPLETE NONE
    0
    I ALSO TRIED;
    tsm: >SELECT START_TIME,END_TIME,NODE_NAME,STATE,PHASE,COMP_STATE,COMP_REASON,COMP_CODE FROM REPLICATIONVIEW WHERE STATE='FAILED' AND START_TIME>current_timestamp-24 hours

    START_TIME END_TIME NODE_NAME STATE PHASE COMP_STATE COMP_REASON COMP_CODE
    --------------------------- --------------------------- ------------------------------------------------------------------ -------- ------------ ----------- ------------ ------------
    2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 FAILED REPLICATING COMPLETE NONE 0
    2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 FAILED REPLICATING COMPLETE NONE 0
    2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 BFSKPAP01 FAILED REPLICATING COMPLETE NONE 0

    BUT when I search in actlogs to get more info..nothing related to the replication failure :0( ..where else should I look for this..any idea?
     

Share This Page