IBM Support

IT35093: ONSTAT -G DRI ON HDR SECONDARY SHOWS LAST LOG PAGE APPLIED 0,0

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • onstat -g dri output shows correctly in the primary node:

IBM Informix Dynamic Server Version 12.10.FC14AEE -- On-Line
(Prim) -- Up 5 days 00:58:43 -- 199348 Kbytes

Data Replication at 0x47427028:
  Type           State        Paired server        Last DR CKPT
(id/pg)    Supports Proxy Writes
  primary        on           sao_eas_tcp                  22 /
3484       NA

  DRINTERVAL    0
  DRTIMEOUT     30
  HDR_TXN_SCOPE NEAR_SYNC
  DRAUTO        0
  DRLOSTFOUND   /opt/IBM/informix/etc/dr.lostfound
  DRIDXAUTO     0
  ENCRYPT_HDR   0
  Backlog       0
  Last Send     2020/11/30 14:37:55
  Last Receive  2020/11/30 14:37:55
  Last Ping     2020/11/30 14:37:28
  Last log page applied(log id,page): 23,2792

But it shows zeroed in the secondary node:
IBM Informix Dynamic Server Version 12.10.FC14AEE -- Read-Only
(Sec) -- Up 5 days 00:57:38 -- 191156 Kbytes

Data Replication at 0x47427028:
  Type           State        Paired server        Last DR CKPT
(id/pg)    Supports Proxy Writes
  HDR Secondary  on           rio_eas_tcp                  22 /
3484       N

  DRINTERVAL    0
  DRTIMEOUT     30
  HDR_TXN_SCOPE NEAR_SYNC
  DRAUTO        0
  DRLOSTFOUND   /opt/IBM/informix/etc/dr.lostfound
  DRIDXAUTO     0
  ENCRYPT_HDR   0
  Backlog       0
  Last Send     2020/11/30 14:37:51
  Last Receive  2020/11/30 14:37:51
  Last Ping     2020/11/30 14:37:27
  Last log page applied(log id,page): 0,0

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC6.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* onstat -g dri output shows correctly in the primary node:    *
*                                                              *
* IBM Informix Dynamic Server Version 12.10.FC14AEE -- On-Line *
* (Prim) -- Up 5 days 00:58:43 -- 199348 Kbytes                *
*                                                              *
* Data Replication at 0x47427028:                              *
*   Type           State        Paired server        Last DR   *
* CKPT                                                         *
* (id/pg)    Supports Proxy Writes                             *
*   primary        on           sao_eas_tcp                    *
* 22 /                                                         *
* 3484       NA                                                *
*                                                              *
*   DRINTERVAL    0                                            *
*   DRTIMEOUT     30                                           *
*   HDR_TXN_SCOPE NEAR_SYNC                                    *
*   DRAUTO        0                                            *
*   DRLOSTFOUND   /opt/IBM/informix/etc/dr.lostfound           *
*   DRIDXAUTO     0                                            *
*   ENCRYPT_HDR   0                                            *
*   Backlog       0                                            *
*   Last Send     2020/11/30 14:37:55                          *
*   Last Receive  2020/11/30 14:37:55                          *
*   Last Ping     2020/11/30 14:37:28                          *
*   Last log page applied(log id,page): 23,2792                *
*                                                              *
* But it shows zeroed in the secondary node:                   *
* IBM Informix Dynamic Server Version 12.10.FC14AEE --         *
* Read-Only                                                    *
* (Sec) -- Up 5 days 00:57:38 -- 191156 Kbytes                 *
*                                                              *
* Data Replication at 0x47427028:                              *
*   Type           State        Paired server        Last DR   *
* CKPT                                                         *
* (id/pg)    Supports Proxy Writes                             *
*   HDR Secondary  on           rio_eas_tcp                    *
* 22 /                                                         *
* 3484       N                                                 *
*                                                              *
*   DRINTERVAL    0                                            *
*   DRTIMEOUT     30                                           *
*   HDR_TXN_SCOPE NEAR_SYNC                                    *
*   DRAUTO        0                                            *
*   DRLOSTFOUND   /opt/IBM/informix/etc/dr.lostfound           *
*   DRIDXAUTO     0                                            *
*   ENCRYPT_HDR   0                                            *
*   Backlog       0                                            *
*   Last Send     2020/11/30 14:37:51                          *
*   Last Receive  2020/11/30 14:37:51                          *
*   Last Ping     2020/11/30 14:37:27                          *
*   Last log page applied(log id,page): 0,0                    *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC6 (when available).                                  *
****************************************************************

    



Problem conclusion


    

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC6.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT35093
    • 

  • Reported component name
    INFORMIX SERVER
    • 

  • Reported component ID
    5725A3900
    • 

  • Reported release
    C10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2020-11-30
    • 

  • Closed date
    2021-01-25
    • 

  • Last modified date
    2021-01-25
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    INFORMIX SERVER
    • 

  • Fixed component ID
    5725A3900
    • 



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            26 January 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback