HDR latency ~ Answered: amber (hollow confidence) — Two plausible sysmaster candidates (sysdri, sysha_lagtime/sysha_workload) were suggested for HDR latency, but David himself notes the documentation doesn't clearly confirm these are populated for HDR secondaries, and Mark never confirmed which (if either) actually worked.

Advisory only.

I see many ways to calculate HDR latency from PRI to SEC via msg log, -g dri, etc. Does anyone know of a sysmaster table (or similar) that captures this? Looked around a bit but syscdrslatency is blank. I assime that's for ER, not HDR. Thanks! Mark Scranton The Mark Scranton Group All Informix ... all the time. 765-729-2601

Hi Mark. sysdri I think could answer your expectations. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/i ds_admin_0954.htm Hope it helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Informix on Cloud - Database Administrator - 2017 IBM dashDB Managed Service for Analytics and Transactions - 2017 DB2 Advanced DBA - v10.5 for LUW IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero Informix independent consultant ________________________________ De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de MARK SCRANTON <mark@markscranton.com> Enviado: quarta-feira, 17 de janeiro de 2018 13:32 Para: ids@iiug.org Assunto: HDR latency [40508] I see many ways to calculate HDR latency from PRI to SEC via msg log, -g dri, etc. Does anyone know of a sysmaster table (or similar) that captures this? Looked around a bit but syscdrslatency is blank. I assime that's for ER, not HDR. Thanks! Mark Scranton The Mark Scranton Group All Informix ... all the time. 765-729-2601 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi Mark, It would be too see if sysha_lagtime and sysha_workload are populated for HDR servers: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.adref.doc/i ds_adr_0210.htm The documentation does not show them being listed to given secondary types - HDR servers certainly are in sysha_type! Regards, David. > On 17 January 2018 at 16:15 Alexandre Marini <alexandre_marini@hotmail.com> wrote: > > > Hi Mark. > > sysdri I think could answer your expectations. > > > https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/i ds_admin_0954.htm > > Hope it helps. > Regards. > > Alexandre Marini > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 > IBM Informix on Cloud - Database Administrator - 2017 > IBM dashDB Managed Service for Analytics and Transactions - 2017 > DB2 Advanced DBA - v10.5 for LUW > IBM Information Management Informix Technical Professional > IBM Certified Developer - Informix Genero > Informix independent consultant > > ________________________________ > De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de MARK SCRANTON > <mark@markscranton.com> > Enviado: quarta-feira, 17 de janeiro de 2018 13:32 > Para: ids@iiug.org > Assunto: HDR latency [40508] > > I see many ways to calculate HDR latency from PRI to SEC via msg log, -g dri, > etc. Does anyone know of a sysmaster table (or similar) that captures this? > Looked around a bit but syscdrslatency is blank. I assime that's for ER, not > HDR. > > Thanks! > Mark Scranton > The Mark Scranton Group > All Informix ... all the time. > 765-729-2601 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >