|
Problem IC70584
|
Status: Closed |
ADMIN_IS_INLINED AND ADMIN_EST_INLINE_LENGTH FUNCTIONS RAISE ERROR FOR SPATIAL TYPES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
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 |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.08.2010
28.04.2011
28.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
