|
Problem IC85558
|
Status: Closed |
TABLESAMPLE SYSTEM WITH HOST VARIABLE OR PARAMETER MARKER SPECIFIED AS A VARIABLE OF THE SAMPLING RATE MAY CAUSE SQL0901N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When using the TABLESAMPLE SYSTEM with a host variable or a
parameter marker specified
as a variable of the sampling rate may cuase SQL0901N with the
follow call stack trace:
0x09000000317AFDF8 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x58
0x09000000317B07F4 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc +
0x3D4
0x09000000325D6200 sqlnn_erds__FiN41e + 0x200
0x090000003715F210
sqlng_process_parse_tree_node__FP9sqlng_blkP9sqlnq_pid + 0x5B0
0x0900000037161724
sqlng_process_BF_node__FP9sqlng_blkP9sqlnq_pid + 0x244
0x0900000037165620 sqlng_walk_BF_chain__FP9sqlng_blk + 0x1180
0x0900000032509880
sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x900
0x09000000356F1C20
sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb +
0x2200
0x09000000370F1208
sqlng_process_f_iscan__FP9sqlng_blkP19sqlno_plan_operator +
0xF08
0x09000000370F2794
sqlng_process_fetch_op__FP9sqlng_blkP19sqlno_plan_operator +
0x2D4
0x09000000370BF174
sqlngProcessLolepop__FP9sqlng_blkP19sqlno_plan_operator + 0x254
0x09000000370FD804
sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +
0x7E4
0x09000000370BF174
sqlngProcessLolepop__FP9sqlng_blkP19sqlno_plan_operator + 0x254
0x09000000370FE810
sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +
0x570
0x09000000370BF174
sqlngProcessLolepop__FP9sqlng_blkP19sqlno_plan_operator + 0x254
0x090000003250955C
sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x5DC
0x09000000397357A4
sqlng_process_tq_op__FP9sqlng_blkP19sqlno_plan_operator + 0xC64
0x09000000370BF174
sqlngProcessLolepop__FP9sqlng_blkP19sqlno_plan_operator + 0x254
0x0900000039788850
sqlng_process_return_op__FP9sqlng_blkP19sqlno_plan_operator +
0xC50
0x09000000370BF174
sqlngProcessLolepop__FP9sqlng_blkP19sqlno_plan_operator + 0x254
0x09000000325093B8
sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x438
0x09000000370D24AC sqlng_main__FP9sqlnq_qur + 0x2E0C
0x0900000035F2F144
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x7044
0x0900000035F31CA4
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x64
0x0900000035F171A8
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPi + 0x1C88
One observation on this problem is the access plan to perform
the table sampling needs to be an index scan (IXSCAN), not a
table scan (TBSCAN). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 Fix Pack 7 *
**************************************************************** |
| Local Fix: |
Provide the value for the sampling rate instead of using a host
variable or a parameter marker |
| available fix packs: |
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 |
Upgrade to DB2 version 9.7 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.07.2012
31.10.2012
31.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
