• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

Informix - Problem description

Problem IT35093 Status: Closed

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

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
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
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).                                  *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
30.11.2020
25.01.2021
25.01.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.