1967497 - Bulk insert or other continuous DML command creates a very large size versioning - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1967497 - Bulk insert or other continuous DML command creates a very large size versioning - SAP IQ

Symptom

  • Bulk insert or other continuous DML command to the SAP IQ from such an ODBC application create a very largre versioning.
  • This is specification of SAP IQ.
  • For example, Bulk insert is to send the following INSERT statement from such an ODBC application.

INSERT TABLE1 VALUES (....);
INSERT TABLE1 VALUES (....);
INSERT TABLE1 VALUES (....);
INSERT TABLE1 VALUES (....);
INSERT TABLE1 VALUES (....);
....
more times...
COMMIT;

  • Also, in order to create a large versioning, IQ store may be out of space.

I. 11/15 01:26:25. 0000003285 Allocation failed. Dbspace user_main is OUT OF SPACE
I. 11/15 01:26:25. 0000003285 Exception Thrown from s_blockmap.cxx:4598, Err# 0, tid 3 origtid 3
I. 11/15 01:26:25. 0000003285    O/S Err#: 0, ErrID: 2096 (s_nodbspaceexception); SQLCode: -1009170, SQLState: 'QSB66', Severity: 14
I. 11/15 01:26:25. 0000003285 [20223]: You have run out of space in user_main DBSpace. -- (s_blockmap.cxx 4598)
I. 11/15 01:26:25. 0000003285 Rbck
I. 11/15 01:26:25. 0000003285 PostRbck


Read more...

Environment

  • SAP IQ 15.4 ESD 1 or later
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

696673, CR696673, savepoints, version, odbc, -1009170, degrade performance , 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.