DB2 - Problembeschreibung
Problem IC62878 | Status: Geschlossen |
WHEN USING BUFFERED INSERT FROM CLI APPLICATION THE OPERATION DEFAULTS TO ATOMIC WHICH DOESN'T YIELD FULL PERFORMANCE BENEFIT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When using buffered insert from CLI application, the operation defaults to ATOMIC which does not deliver the full performance benefit. The full benefit of bufferred insert (a DPF insert performance enhancement feature for inserting large numbers of rows into moderate to large DPF tables) can be achieved by taking one of the following workarounds. 1) Setting patch2=74 in the db2cli.ini file. 2) Setting the connection attribute SQL_ATTR_NONATMOIC_BUFFER_INSERT (spelling intentional) from the CLI application. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * When using buffered insert from CLI application, the * * operation defaults to ATOMIC which does not deliver the full * * performance benefit. * * * * The full benefit of bufferred insert (a DPF insert * * performance * * enhancement feature for inserting large numbers of rows into * * moderate to large DPF tables) can be achieved by taking one * * of the following workarounds. * * * * 1) Setting patch2=74 in the db2cli.ini file. * * * * 2) Setting the connection attribute * * SQL_ATTR_NONATMOIC_BUFFER_INSERT (spelling intentional) * * from the CLI application. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 Fix Pack 1 or implement one of * * the workarounds. * * * * 1) Setting patch2=74 in the db2cli.ini file. * * * * 2) Setting the connection attribute * * SQL_ATTR_NONATMOIC_BUFFER_INSERT (spelling intentional) * * from the CLI application. * **************************************************************** | |
Local-Fix: | |
There are 2 workarounds choose one: 1) Setting patch2=74 in the db2cli.ini file. 2) Setting the connection attribute SQL_ATTR_NONATMOIC_BUFFER_INSERT (spelling intentional) from the CLI application. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 1 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.09.2009 17.02.2010 17.02.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP1 | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |