|
Problem IT04010
|
Status: Closed |
SQL101N MAY BE RETURNED WHEN SPECIAL REGISTER IS REFERENCED MANY TIMES IN THE SAME EXPRESSION IN THE SELECT LIST OR IN THE WHEN |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
SQL101N may be returned when the special register CURRENT DATE,
CURRENT TIMESTAMP, CURRENT TEMPORAL SYSTEM_TIME or CURRENT
TEMPORAL BUSINESS_TIME is referenced multiple times in a complex
expression
The multiple references could also be a result of a single
reference of the special register in the search condition of a
CASE expression that has many WHEN clauses. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.1 FixPack 5 *
**************************************************************** |
| Local Fix: |
Set registry variable DB2_EXTENDED_OPTIMIZATION=OLD_SPREG_FF.
For example:
db2set -im DB2_EXTENDED_OPTIMIZATION=OLD_SPREG_FF |
| Solution |
Upgrade to DB2 V10.1 FixPack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.08.2014
16.07.2015
16.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
