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

• 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

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

696673, CR696673, savepoints, version, odbc, -1009170, degrade performance , KBA , BC-SYB-IQ , Sybase IQ , Problem