home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC87869 Status: Geschlossen

PREDICATES WITH LTRIM() FUNCTION CAN NOT BE PUSHED DOWN

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Function mapping for SYSIBM.LTRIM is missing, which prevents 
predicates with this function from being pushdown. 
 
This could lead to performance problem, or SQL1822N error in 
delete/update. A delete/update statement against MSSQL nicknames 
may fail with an error as: 
 
DELETE  FROM NICKNAME1 A 
      WHERE NOT EXISTS 
      ( SELECT 1 
          FROM NICKNAME2 B 
         WHERE A.COLUMN1 = B.COLUMN1 
           AND LTRIM(A.COLUMN2)  = B.COLUMN2 ) 
 
DB21034E  The command was processed as an SQL statement because 
it was not a valid Command Line Processor command. During SQL 
processing it returned: SQL1822N  Unexpected error code "24000" 
received from data source "MYSERVER". Associated text and tokens 
are " Invalid cursor state". SQLSTATE=560BD
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* The users running MSSQL wrapper attempting to execute a SQL  * 
* statment having LTRIM() function.                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to InfoSphere Federation Server v101fp2 or later.    * 
****************************************************************
Local-Fix:
CREATE FUNCTION MAPPING my_mapping1  FOR 
SYSIBM.LTRIM(SYSIBM.CHAR())  SERVER  <SERVER>  OPTIONS 
(REMOTE_NAME 'LTRIM(:1P)') 
 
CREATE FUNCTION MAPPING my_mapping2  FOR 
SYSIBM.LTRIM(SYSIBM.VARCHAR())  SERVER <SERVER>OPTIONS 
(REMOTE_NAME 'LTRIM(:1P)')
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
The problem is first fixed at v101fp2.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.11.2012
18.12.2012
18.12.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.2 FixList
10.5.0.2 FixList