|
Problem IC61764
|
Status: Closed |
THE RTRIM UDF MAY ABEND INSTANCE WHEN USED ON EMPTY DBCLOB COLUMN IN THE SELECT SQL STATEMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The instance may abend when the RTRIM UDF is used on empty
DBCLOB column. Please consider the following SQL statements:
create table test(name dbclob(1G) not logged);
insert into test values ('');
select RTRIM(SUBSTR(name, 1, 10)) from test;
The instance may abend with the similar call stack
0x000000000000F410 ?unknown + 0x0
0x090000006E4FEA50 memcpy__FPvPCvUl + 0x3C
0x090000006E502D90 sqlo_md_mcpy + 0x204
0x09000000708B52D4
sqlrimso__FP8sqlrr_cbP9sqllf_csoPUcPUiUiisPPvT6 + 0x18DC
0x09000000708B58B8
sqlrimso__FP8sqlrr_cbP9sqllf_csoPUcPUiUiisPPvT6 + 0x1EC0
0x0900000070BE2DF4 sqlriGetArgs__FP8sqlrr_cbP10sqlri_ufob +
0xAC8
0x0900000070BDF820 sqlriInvokeInvoker__FP10sqlri_ufob + 0x230
0x0900000070BDF1F4 sqlriusf__FP8sqlrr_cb + 0x53C
0x0900000070886B5C sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm +
0x60C
0x09000000708860AC sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x4A8
0x0900000070F57FE8
sqlrr_process_fetch_request__FP14db2UCinterface + 0x7B8
0x0900000070F56CEC
sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0xB00
0x0900000073277550
sqljs_ddm_cntqry__FP14db2UCinterfaceP14sqljsDDMObject + 0x1E4
0x0900000073255684
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14d
b2UCinterface + 0x180 |
| Problem Summary: |
Users Affected: All |
| Local Fix: |
n/a |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.06.2009
15.12.2009
15.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
