|
Problem IC62878
|
Status: Closed |
WHEN USING BUFFERED INSERT FROM CLI APPLICATION THE OPERATION DEFAULTS TO ATOMIC WHICH DOESN'T YIELD FULL PERFORMANCE BENEFIT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.09.2009
17.02.2010
17.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
