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 IC70584 Status: Geschlossen

ADMIN_IS_INLINED AND ADMIN_EST_INLINE_LENGTH FUNCTIONS RAISE ERROR FOR
SPATIAL TYPES

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
SQL0245N issued when using ADMIN_IS_INLINED and 
ADMIN_EST_INLINE_LENGTH functions with spatial column types. 
 
For example, the following queries will fail with SQL0245N: 
 
1) select admin_is_inlined(feature) as is_inlined from cntry94 
 
SQL0245N The invocation of routine "ADMIN_IS_INLINED" is 
ambiguous. The argument in position "1" does not have a best 
fit. SQLSTATE=428F5 
 
2) select max(admin_est_inline_length(feature)) from cntry94 
 
SQL0245N The invocation of routine "ADMIN_EST_INLINE_LENGTH" is 
ambiguous. The argument in position "1" does not have a best 
fit. SQLSTATE=428F5 
 
Spatial types can be stored inline.  These functions should 
work.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The ADMIN_IS_INLINED and ADMIN_EST_INLINE_LENGTH functions   * 
* added in Version 9.7 result in error when used with spatial  * 
* column types. Inline support for spatial columns is          * 
* supported.  These functions should not result in error when  * 
* used with spatial column types.                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply Version 9.7 Fix Pack 4                                 * 
****************************************************************
Local-Fix:
The following query can be used to determine if a spatial column 
is inlined: 
   SELECT CASE 
            WHEN 197 + LENGTH(<columnname>..points) <= 
               ( SELECT inline_length 
                 FROM syscat.columns 
                 WHERE tabschema = <tableschema> 
                   AND tabname = <tablename> 
                   AND colname = <columnname>) 
            THEN 1 
            ELSE 0 
          END 
   FROM <tableschema>.<tablename> 
 
Where <tableschema>, <tablename> and <columnname> are 
substituted with the desired schema, table and column names. 
 
A similar query can be used to return the estimated inline 
length.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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
Functions ADMIN_IS_INLINED and ADMIN_EST_INLINE_LENGTH will not 
result in error when used with spatial column types. 
Problem was first fixed in Version 9.7 Fix Pack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.08.2010
28.04.2011
28.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList