IBM Support

IC85558: TABLESAMPLE SYSTEM WITH HOST VARIABLE OR PARAMETER MARKER SPECIFIED AS A VARIABLE OF THE SAMPLING RATE MAY CAUSE SQL0901N

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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).
    

Local fix

  • Provide the value for the sampling rate instead of using a host
    variable or a parameter marker
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 Fix Pack 7                        *
    ****************************************************************
    

Problem conclusion

  • Upgrade to DB2 version 9.7 Fix Pack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC85558

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-26

  • Closed date

    2012-10-31

  • Last modified date

    2012-10-31

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP

  • RA10 PSN

       UP

  • RA10 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC85558

Modified date: 31 October 2012