|
Problem IC84022
|
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 / 970 - 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 9.7 FP7 or subsequent fix pack *
**************************************************************** |
| Local Fix: |
NA |
| available fix packs: |
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
|
| Solution |
Problem First Fixed in DB2 Version 9.7 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88346 IC88347
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.06.2012
24.10.2012
24.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
