home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList