|
Problem IC88346
|
Status: Geschlossen |
LOAD CLIENT MIGHT RETURN SQL0437W TO CLP WHILE RUNNING LOAD FROM CURSOR IN DPF SO THAT CLP ENDS UP ENDLESSLY PROMPTING |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
Load client might return SQL0437W to CLP while running Load
Remote Fetch (load from cursor with database option) in DPF so
that CLP ends up endlessly prompting.
You can see the following in the CLP:
SQL0437W Performance of this complex query may be sub-optimal.
Reason code: "1". SQLSTATE=01602
Do you want to continue(c), terminate this device only(d), abort
the utility(t) ? (c/d/t)
Even after providing the input, the message and prompting appear
in an infinite loop. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.1 FP2 or subsequent fix pack. *
**************************************************************** |
| Local-Fix: |
NA |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
First Fixed in DB2 Version 10.1 Fix Pack 2 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 17.11.2012
16.01.2013
16.01.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
