Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

Enterprise Replication and IfxSmartTrigger doubts

  • 1.  Enterprise Replication and IfxSmartTrigger doubts

    Posted 08/22/22 12:30 PM
    Hello,

    I'm capturing some events on a informix database using IfxSmartTrigger in Java.

    My first question is about ER function to reset capture, i tried to execute the following function on sysadmin: execute function admin("pushdata reset_capture", '{"logid":"440467", "logpos":"0x0"}'); but it doesn't work, say that this function doesnt exists.

    My second question is about IfxSmartTrigger, how can i test if the sessionID is still valid? For example, mostly i will use the sessionID that i store in a database to retach to my created triggers but let suppose my server failure and i lost this triggers, there is one function that i can test if this sessionID is still valid? The only way that i could do that was trying to recconect to the sessionID executing the watch function (if work it get uninterrupted and if don't it raise one exception), someone know if there is one better way that i could test de sessionID?




    ------------------------------
    guilherme schneider
    ------------------------------

    #Informix