|
Problem IC84022
|
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 / 970 - 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 9.7 FP7 or subsequent fix pack *
**************************************************************** |
| Local-Fix: |
NA |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Problem First Fixed in DB2 Version 9.7 Fix Pack 7 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC88346 IC88347
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 08.06.2012
24.10.2012
24.10.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP7
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.7
|
 |
