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

  • 1.  BlockLogXmit status

    Posted 2 days ago

    Dear All,

          Happy New Year to All.

                    I'm working on Informix 14 on Solaris 5.

    We get one issue mostly in every 3 months around for replication issue between Primary Server and RSS server and get the status on Primary server as "BlockLogXmit" and we need to restart the RSS node, and it impact the application connected with the RSS node.

    How can we avoid these situation? in 2025 we faced this situation around 4 times. Kindly suggest.

    Thanks

    Amit Patel



    ------------------------------
    AMIT PATEL
    ------------------------------

    Attachment(s)

    docx
    Informix Parameters.docx   384 KB 1 version
    docx
    onstat_command_output.docx   1.14 MB 1 version


  • 2.  RE: BlockLogXmit status

    Posted 2 days ago

    Hi

     

    Which release of 14 are you running? We use 14.10.FC11 and see this issue with some of our installations. I assumed it was fixed in FC12 but can't find an exact match in the release notes.

     




    Original Message


  • 3.  RE: BlockLogXmit status

    Posted yesterday

    Dear Stuart,

             Currently we are using Informix 14.10.FC6X3 

    Regards

    Amit Patel



    ------------------------------
    AMIT PATEL
    ------------------------------

    Original Message


  • 4.  RE: BlockLogXmit status

    Posted 21 hours ago

    As already stated by Marcus, this is a known defect that is fixed from 14.10.FC11 onwards.



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------

    Original Message


  • 5.  RE: BlockLogXmit status

    Posted 20 hours ago
    Amit:

    Besides the bug fixes, there were important performance enhancements to RSS in later releases. Upgrade!

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.









    Original Message


  • 6.  RE: BlockLogXmit status

    Posted 2 days ago
    APAR IT45413, solved in 14.10 xC11 according to the documentation


    MARCUS HAARMANN



    Original Message


  • 7.  RE: BlockLogXmit status

    Posted 22 hours ago

    Amit and Stuart,

    This support article doesn't mention that this issue doesn't happen randomly. It happens when the number of reads (or possibly writes) on the RSS shown by 'onstat -g smx ses' reaches 4,294,967,296 (2^32). 'onstat -z' won't help here. Therefore you will only see this on busier systems and at fairly regular intervals in time, dependent on activity. Knowing this you can monitor it and schedule a restart at a more convenient time.

    Ben.



    ------------------------------
    Benjamin Thompson
    ------------------------------

    Original Message


Related Content