SAP Knowledge Base Article - Preview

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

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 2014 12:20
  I. 06/30 12:20:10. Finished checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 2014 12:20
  I. 06/30 12:20:16. Starting checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 2014 12:20
  I. 06/30 12:20:16. Finished checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 2014 12:20
  ...
  ...
  I. 06/30 12:20:58. Starting checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 2014 12:20
  I. 06/30 12:20:58. Finished checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 2014 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 IQ12.7, 15.x, 16 all. (MPX environment)

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 ONE Support launchpad (Login required).

Search for additional results

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