IDS Forum

RE: Checkpoints statistics

Posted By: Alexandre Marini
Date: Monday, 22 January 2018, at 7:12 a.m.

In Response To: Checkpoints statistics (MUKESH TANUKU)

Hello.

What kind of cluster do you have? HDR? SDS? RSS? Seems you might be facing lag on primary because of misconfigured cluster.

Is this a new installation, or an old one? Was it recently upgraded?

Please send us some outputs:

1) onstat -g cluster
2) onstat -c

What is your operational system (complete version number and name please)

That would clear up some things for us to help you.

Best 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 MUKESH TANUKU <mukeshbt1328@gmail.com>
Enviado: segunda-feira, 22 de janeiro de 2018 07:34
Para: ids@iiug.org
Assunto: Checkpoints statistics [40531]

Hello Users,
We are using IDS 12.10 FC8 DB server,
Application is developed in Java and app server is JBOSS

Our application is taking long time to save the data into database trhough
application.

Find the online log details below:

09:23:22 Checkpoint Completed: duration was 0 seconds.
09:23:22 Mon Jan 22 - loguniq 401, logpos 0x4f9b018, timestamp: 0x7149beaf
Interval: 2987

09:23:22 Maximum server connections 46
09:23:22 Checkpoint Statistics - Avg. Txn Block Time 0.009, # Txns blocked 2,
Plog used 6450, Llog used 20509

10:28:32 Dynamically added 1 cpu VP
10:28:33 ** AUTO TUNING - Added CPU VP.
10:33:45 Checkpoint Completed: duration was 3 seconds.
10:33:46 Mon Jan 22 - loguniq 401, logpos 0x95a4b44, timestamp: 0x715ac4ce
Interval: 2988

10:33:46 Maximum server connections 87
10:33:46 Checkpoint Statistics - Avg. Txn Block Time 101.278, # Txns blocked
2, Plog used 7947, Llog used 17968

11:30:05 Checkpoint Completed: duration was 7 seconds.
11:30:05 Mon Jan 22 - loguniq 401, logpos 0xdbf7018, timestamp: 0x7167f105
Interval: 2989

11:30:05 Maximum server connections 126
11:30:05 Checkpoint Statistics - Avg. Txn Block Time 112.880, # Txns blocked
9, Plog used 7876, Llog used 18032

if you can find the Checkpoint Statistics, the Avg. Txn Block Time is 101.278
and 112.880

Why it is blocking the transactions for more time, what is the scenario to
find the root cause for this.
Please help on this.

output for onstat -p

IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 16:39:54
-- 4395776 Kbytes

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
71044170 426052077 2775484776 97.50 1676165 3794823 545281140 99.98

isamtot open start read write rewrite delete commit rollbk
1989899613 16477171 4937867 323514127 268245332 28009 4239 39738 0

gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
309214 2843 30420 0 0 0 0

ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 32975.28 5837.82 3 8

bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
16137531 15013 193865471 0 0 17 212315 418930

ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
62341090 490835 6950466 0 45516580 5635212

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Checkpoints statistics
  MUKESH TANUKU -- Monday, 22 January 2018, at 4:34 a.m.
  • RE: Checkpoints statistics
    Alexandre Marini -- Monday, 22 January 2018, at 7:12 a.m.
    • Re: RE: Checkpoints statistics
      MUKESH TANUKU -- Tuesday, 23 January 2018, at 12:18 a.m.
      • RE: RE: Checkpoints statistics
        Alexandre Marini -- Tuesday, 23 January 2018, at 8:54 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.