SAP Knowledge Base Article - Preview

2037009 - A relationship between ev_begintxn and checkpoint. - SAP IQ

Symptom

Too many checkpoints have been executed at intervals of about 3 or 4 seconds on secondary node.
Normal transaction processings are blocked due to handling excessive checkpoints. An ev_begintxn session has been lasted for about 3 hours at that time.
This situation caused abnormal status on secondary node for a long while.

[srvlog]
  I. 06/30 12:20:10. Starting checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
  I. 06/30 12:20:10. Finished checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
  I. 06/30 12:20:16. Starting checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
  I. 06/30 12:20:16. Finished checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
  ...
  ...
  I. 06/30 12:20:58. Starting checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
  I. 06/30 12:20:58. Finished checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
 
[iqmsg]
  I. 06/30 12:15:47. 0000000139 Connect:  SA connHandle: 1000000127  SA connID: 22  IQ connID: 0000000139  User: dbo
  I. 06/30 12:15:47. 0000000139 ev_begintxn started
    ...
  I. 06/30 12:16:29. 0000000139 Chk
  I. 06/30 12:16:29. 0000000139 ChkDone [NumTxnCP: 6]
  I. 06/30 12:16:29. 0000000139 PostChk
  ...
  I. 06/30 12:16:34. 0000000139 Chk
  I. 06/30 12:16:34. 0000000139 ChkDone [NumTxnCP: 6]
  I. 06/30 12:16:34. 0000000139 PostChk
  ...
  I. 06/30 15:06:55. 0000000139 Disconnect:  SA connHandle: 1000000127  SA connID: 22  IQ connID: 0000000139  User: dbo


Read more...

Environment

  • SAP IQ 12.7
  • SAP IQ 15.x
  • SAP IQ 16.x

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

ev_begintxn, checkpoint, grant , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.