Oninit cdi / Archive
Talk to an expert →

onstat -g ckp - conv/rev ???

Posted in 2010

Summary

A user saw a checkpoint in 'onstat -g ckp' with trigger '*Conv/Rev' on a live production server where no version upgrade or maintenance was running, and asked what caused it. Replies explained that the Trigger column shows who requested the checkpoint, and that 'Conv/Rev' (conversion/reversion) isn't limited to version upgrades: IBM support noted several code paths raise it, notably altering a table from RAW to STANDARD. Another poster suggested checking/disabling CONVERSION_GUARD. The poster agreed a raw-to-standard conversion by another user was plausible but could not confirm it without SQL tracing, so no definitive cause was established.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Triggers, Constraints & Referential Integrity, Logging & Checkpoints

Cesar Inacio Martins — — source: IIUG Forums & Mailing Lists

Hi people, What's the trigger Conv/Rev mean? This occur into a production environment... AUTO_CKPTS=On RTO_SERVER_RESTART=1800 seconds Estimated recovery time 57 seconds Critical Sections Physical Log Logical Log Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total Avg Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /Sec Pages /Sec Pages /Sec 4407 10:31:35 Startup 97674:0x39d5018 0.6 0.5 0.0 0 0.0 0.0 0.0 59 59 105 1 1 0 4408 10:35:02 *User 97674:0x510d018 0.6 0.1 0.0 9 0.4 0.4 0.6 375 375 8621 41 5944 28 4409 18:38:06 *CDR 97713:0x32de018 11.7 0.7 0.0 29 0.1 7.4 11.7 7572 7572 1250774 43 967270 33 4410 22:18:34 *Backup 97720:0xc39018 36.6 36.4 0.0 0 0.0 0.0 0.0 123316 3388 208923 15 165107 12 4411 15:40:34 *Conv/Rev 97818:0x1de2018 13.1 1.1 0.0 110 0.3 9.6 13.1 11294 10532 1676190 26 1509509 24 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 1277 722 36 4384 1 0

↪ replying to Cesar Inacio Martins
Madison Pruet — — source: IIUG Forums & Mailing Lists

In this context, trigger is who requested the checkpoint. Conversion/Reversion does request checkpoints. From: "Cesar Inacio Martins" <cesar_inacio_martins@yahoo.com.br> To: ids@iiug.org Date: 10/05/2010 01:56 PM Subject: onstat -g ckp - conv/rev ??? [21547] Sent by: ids-bounces@iiug.org Hi people, What's the trigger Conv/Rev mean? This occur into a production environment... AUTO_CKPTS=On RTO_SERVER_RESTART=1800 seconds Estimated recovery time 57 seconds Critical Sections Physical Log Logical Log Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total Avg Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /Sec Pages /Sec Pages /Sec 4407 10:31:35 Startup 97674:0x39d5018 0.6 0.5 0.0 0 0.0 0.0 0.0 59 59 105 1 1 0 4408 10:35:02 *User 97674:0x510d018 0.6 0.1 0.0 9 0.4 0.4 0.6 375 375 8621 41 5944 28 4409 18:38:06 *CDR 97713:0x32de018 11.7 0.7 0.0 29 0.1 7.4 11.7 7572 7572 1250774 43 967270 33 4410 22:18:34 *Backup 97720:0xc39018 36.6 36.4 0.0 0 0.0 0.0 0.0 123316 3388 208923 15 165107 12 4411 15:40:34 *Conv/Rev 97818:0x1de2018 13.1 1.1 0.0 110 0.3 9.6 13.1 11294 10532 1676190 26 1509509 24 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 1277 722 36 4384 1 0 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Madison Pruet
Cesar Inacio Martins — — source: IIUG Forums & Mailing Lists

Hi Madison, Thanks for your answer, but.. my question still... What's this Conversion/Reversion means? This is a production environment, with users running and no mantaince at the moment. I trying understand what trigger this checkpoint. Conversion/Reversion , for me this should appear only when a upgrade of version is running... what we don't running here... the environment still up and running with users. On the message log, there is nothing special.. only the log of the checkpoint: 15:36:43 Logical Log 97817 Complete, timestamp: 0x511c4867. 15:36:46 Logical Log 97817 - Backup Started 15:36:48 Logical Log 97817 - Backup Completed 15:40:34 Checkpoint Completed: duration was 13 seconds. 15:40:34 Tue Oct 5 - loguniq 97818, logpos 0x1de2018, timestamp: 0x511e667e Interval: 4411 15:40:34 Maximum server connections 624 15:40:34 Checkpoint Statistics - Avg. Txn Block Time 0.275, # Txns blocked 0, Plog used 1676190, Llog used 1509509 15:41:12 Logical Log 97818 Complete, timestamp: 0x511ef461. 15:41:15 Logical Log 97818 - Backup Started 15:41:17 Logical Log 97818 - Backup Completed --- Em ter, 5/10/10, Madison Pruet <mpruet@us.ibm.com> escreveu: De: Madison Pruet <mpruet@us.ibm.com> Assunto: Re: onstat -g ckp - conv/rev ??? [21548] Para: ids@iiug.org Data: Terça-feira, 5 de Outubro de 2010, 16:03 In this context, trigger is who requested the checkpoint. Conversion/Reversion does request checkpoints. From: "Cesar Inacio Martins" <cesar_inacio_martins@yahoo.com.br> To: ids@iiug.org Date: 10/05/2010 01:56 PM Subject: onstat -g ckp - conv/rev ??? [21547] Sent by: ids-bounces@iiug.org Hi people, What's the trigger Conv/Rev mean? This occur into a production environment... AUTO_CKPTS=On RTO_SERVER_RESTART=1800 seconds Estimated recovery time 57 seconds Critical Sections Physical Log Logical Log Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total Avg Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /Sec Pages /Sec Pages /Sec 4407 10:31:35 Startup 97674:0x39d5018 0.6 0.5 0.0 0 0.0 0.0 0.0 59 59 105 1 1 0 4408 10:35:02 *User 97674:0x510d018 0.6 0.1 0.0 9 0.4 0.4 0.6 375 375 8621 41 5944 28 4409 18:38:06 *CDR 97713:0x32de018 11.7 0.7 0.0 29 0.1 7.4 11.7 7572 7572 1250774 43 967270 33 4410 22:18:34 *Backup 97720:0xc39018 36.6 36.4 0.0 0 0.0 0.0 0.0 123316 3388 208923 15 165107 12 4411 15:40:34 *Conv/Rev 97818:0x1de2018 13.1 1.1 0.0 110 0.3 9.6 13.1 11294 10532 1676190 26 1509509 24 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 1277 722 36 4384 1 0 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Cesar Inacio Martins
Madison Pruet — — source: IIUG Forums & Mailing Lists

But it was converted at some time in the past. = From: "Cesar Inacio Martins" <cesar_inacio_martins@yahoo.com.br= > = To: ids@iiug.org = = Date: 10/05/2010 02:58 PM = = Subject: Re: onstat -g ckp - conv/rev ??? [21550] = = Sent by: ids-bounces@iiug.org = = Hi Madison, Thanks for your answer, but.. my question still... What's this Conversion/Reversion means? This is a production environment, with users running and no mantaince a= t the moment. I trying understand what trigger this checkpoint. Conversion/Reversion , for me this should appear only when a upgrade of= version is running... what we don't running here... the environment sti= ll up and running with users. On the message log, there is nothing special.. only the log of the checkpoint: 15:36:43 Logical Log 97817 Complete, timestamp: 0x511c4867. 15:36:46 Logical Log 97817 - Backup Started 15:36:48 Logical Log 97817 - Backup Completed 15:40:34 Checkpoint Completed: duration was 13 seconds. 15:40:34 Tue Oct 5 - loguniq 97818, logpos 0x1de2018, timestamp: 0x511e= 667e Interval: 4411 15:40:34 Maximum server connections 624 15:40:34 Checkpoint Statistics - Avg. Txn Block Time 0.275, # Txns bloc= ked 0, Plog used 1676190, Llog used 1509509 15:41:12 Logical Log 97818 Complete, timestamp: 0x511ef461. 15:41:15 Logical Log 97818 - Backup Started 15:41:17 Logical Log 97818 - Backup Completed --- Em ter, 5/10/10, Madison Pruet <mpruet@us.ibm.com> escreveu: De: Madison Pruet <mpruet@us.ibm.com> Assunto: Re: onstat -g ckp - conv/rev ??? [21548] Para: ids@iiug.org Data: Ter=E7a-feira, 5 de Outubro de 2010, 16:03 In this context, trigger is who requested the checkpoint. Conversion/Reversion does request checkpoints. From: "Cesar Inacio Martins" <cesar_inacio_martins@yahoo.com.br> To: ids@iiug.org Date: 10/05/2010 01:56 PM Subject: onstat -g ckp - conv/rev ??? [21547] Sent by: ids-bounces@iiug.org Hi people, What's the trigger Conv/Rev mean? This occur into a production environment... AUTO_CKPTS=3DOn RTO_SERVER_RESTART=3D1800 seconds Estimated recovery ti= me 57 seconds Critical Sections Physical Log Logical Log Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total= Avg Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /= Sec Pages /Sec Pages /Sec 4407 10:31:35 Startup 97674:0x39d5018 0.6 0.5 0.0 0 0.0 0.0 0.0 59 59 1= 05 1 1 0 4408 10:35:02 *User 97674:0x510d018 0.6 0.1 0.0 9 0.4 0.4 0.6 375 375 8= 621 41 5944 28 4409 18:38:06 *CDR 97713:0x32de018 11.7 0.7 0.0 29 0.1 7.4 11.7 7572 75= 72 1250774 43 967270 33 4410 22:18:34 *Backup 97720:0xc39018 36.6 36.4 0.0 0 0.0 0.0 0.0 123316= 3388 208923 15 165107 12 4411 15:40:34 *Conv/Rev 97818:0x1de2018 13.1 1.1 0.0 110 0.3 9.6 13.1 1= 1294 10532 1676190 26 1509509 24 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 1277 722 36 4384 1 0 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to Cesar Inacio Martins
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Hello Cesar! Is it a new version, like XC6 ??? Did you check your CONVERSION_GUARD variable???? Just a tip, try to disable it, I had some troubles after running FC7 with it enabled, ok? Best regards! Em 05/10/2010 15:55, Cesar Inacio Martins escreveu: > Hi Madison, > > Thanks for your answer, but.. my question still... > What's this Conversion/Reversion means? > This is a production environment, with users running and no mantaince at the > moment. > I trying understand what trigger this checkpoint. > > Conversion/Reversion , for me this should appear only when a upgrade of > version is running... what we don't running here... the environment still up > and running with users. > On the message log, there is nothing special.. only the log of the checkpoint: > > 15:36:43 Logical Log 97817 Complete, timestamp: 0x511c4867. > 15:36:46 Logical Log 97817 - Backup Started > 15:36:48 Logical Log 97817 - Backup Completed > 15:40:34 Checkpoint Completed: duration was 13 seconds. > 15:40:34 Tue Oct 5 - loguniq 97818, logpos 0x1de2018, timestamp: 0x511e667e > Interval: 4411 > > 15:40:34 Maximum server connections 624 > 15:40:34 Checkpoint Statistics - Avg. Txn Block Time 0.275, # Txns blocked 0, > Plog used 1676190, Llog used 1509509 > > 15:41:12 Logical Log 97818 Complete, timestamp: 0x511ef461. > 15:41:15 Logical Log 97818 - Backup Started > 15:41:17 Logical Log 97818 - Backup Completed > > --- Em ter, 5/10/10, Madison Pruet<mpruet@us.ibm.com> escreveu: > > De: Madison Pruet<mpruet@us.ibm.com> > Assunto: Re: onstat -g ckp - conv/rev ??? [21548] > Para: ids@iiug.org > Data: Terça-feira, 5 de Outubro de 2010, 16:03 > > In this context, trigger is who requested the checkpoint. > Conversion/Reversion does request checkpoints. > > From: "Cesar Inacio Martins"<cesar_inacio_martins@yahoo.com.br> > > To: ids@iiug.org > > Date: 10/05/2010 01:56 PM > > Subject: onstat -g ckp - conv/rev ??? [21547] > > Sent by: ids-bounces@iiug.org > > Hi people, > > What's the trigger Conv/Rev mean? > This occur into a production environment... > > AUTO_CKPTS=On RTO_SERVER_RESTART=1800 seconds Estimated recovery time 57 > seconds > > Critical Sections Physical Log Logical Log > > Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total Avg > > Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /Sec > Pages /Sec Pages /Sec > 4407 10:31:35 Startup 97674:0x39d5018 0.6 0.5 0.0 0 0.0 0.0 0.0 59 59 105 1 > 1 > 0 > 4408 10:35:02 *User 97674:0x510d018 0.6 0.1 0.0 9 0.4 0.4 0.6 375 375 8621 > 41 > 5944 28 > 4409 18:38:06 *CDR 97713:0x32de018 11.7 0.7 0.0 29 0.1 7.4 11.7 7572 7572 > 1250774 43 967270 33 > 4410 22:18:34 *Backup 97720:0xc39018 36.6 36.4 0.0 0 0.0 0.0 0.0 123316 > 3388 > 208923 15 165107 12 > 4411 15:40:34 *Conv/Rev 97818:0x1de2018 13.1 1.1 0.0 110 0.3 9.6 13.1 11294 > > 10532 1676190 26 1509509 24 > > Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked > pages/sec pages/sec Time pages/sec pages/sec Time > 1277 722 36 4384 1 0 > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color IBM Informix Dynamic Server Certified Professional V10 / V11

↪ replying to Cesar Inacio Martins
JACQUES RENAUT — — source: IIUG Forums & Mailing Lists

Original post: Hi people, What's the trigger Conv/Rev mean? This occur into a production environment... AUTO_CKPTS=On RTO_SERVER_RESTART=1800 seconds Estimated recovery time 57 seconds Critical Sections Physical Log Logical Log Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total Avg Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /Sec Pages /Sec Pages /Sec 4407 10:31:35 Startup 97674:0x39d5018 0.6 0.5 0.0 0 0.0 0.0 0.0 59 59 105 1 1 0 4408 10:35:02 *User 97674:0x510d018 0.6 0.1 0.0 9 0.4 0.4 0.6 375 375 8621 41 5944 28 4409 18:38:06 *CDR 97713:0x32de018 11.7 0.7 0.0 29 0.1 7.4 11.7 7572 7572 1250774 43 967270 33 4410 22:18:34 *Backup 97720:0xc39018 36.6 36.4 0.0 0 0.0 0.0 0.0 123316 3388 208923 15 165107 12 4411 15:40:34 *Conv/Rev 97818:0x1de2018 13.1 1.1 0.0 110 0.3 9.6 13.1 11294 10532 1676190 26 1509509 24 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 1277 722 36 4384 1 0 Response: Looking at the code it there is a number of places that can kick off a checkpoint of this type, one of them appears to be when you convert a table from type raw to standard. Could that be what triggered it on your system? Jacques Renaut IBM Informix Advanced Support APD Team

↪ replying to JACQUES RENAUT
Cesar Inacio Martins — — source: IIUG Forums & Mailing Lists

Hi Jacques, Could be.. I can't confirm just now , because I don't have sql trace active at the moment. But this is possible (others users using the system have privileges to do this). Thank you for your answer! Regards Cesar --- Em ter, 5/10/10, JACQUES RENAUT <jrenaut@us.ibm.com> escreveu: De: JACQUES RENAUT <jrenaut@us.ibm.com> Assunto: Re: onstat -g ckp - conv/rev ??? [21553] Para: ids@iiug.org Data: Terça-feira, 5 de Outubro de 2010, 18:18 Original post: Hi people, What's the trigger Conv/Rev mean? This occur into a production environment... AUTO_CKPTS=On RTO_SERVER_RESTART=1800 seconds Estimated recovery time 57 seconds Critical Sections Physical Log Logical Log Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total Avg Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /Sec Pages /Sec Pages /Sec 4407 10:31:35 Startup 97674:0x39d5018 0.6 0.5 0.0 0 0.0 0.0 0.0 59 59 105 1 1 0 4408 10:35:02 *User 97674:0x510d018 0.6 0.1 0.0 9 0.4 0.4 0.6 375 375 8621 41 5944 28 4409 18:38:06 *CDR 97713:0x32de018 11.7 0.7 0.0 29 0.1 7.4 11.7 7572 7572 1250774 43 967270 33 4410 22:18:34 *Backup 97720:0xc39018 36.6 36.4 0.0 0 0.0 0.0 0.0 123316 3388 208923 15 165107 12 4411 15:40:34 *Conv/Rev 97818:0x1de2018 13.1 1.1 0.0 110 0.3 9.6 13.1 11294 10532 1676190 26 1509509 24 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 1277 722 36 4384 1 0 Response: Looking at the code it there is a number of places that can kick off a checkpoint of this type, one of them appears to be when you convert a table from type raw to standard. Could that be what triggered it on your system? Jacques Renaut IBM Informix Advanced Support APD Team ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary