|
Problem IC88346
|
Status: Closed |
LOAD CLIENT MIGHT RETURN SQL0437W TO CLP WHILE RUNNING LOAD FROM CURSOR IN DPF SO THAT CLP ENDS UP ENDLESSLY PROMPTING |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.1 FP2 or subsequent fix pack. *
**************************************************************** |
| Local Fix: |
NA |
| available fix packs: |
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
|
| Solution |
First Fixed in DB2 Version 10.1 Fix Pack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.11.2012
16.01.2013
16.01.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
