IBM Support

JR38029: CLP WILL CRASH IF WORK WITH NICKNAME WITHOUT USER MAPPING, WHEN FEDERATION SERVER CONNECT TO ODBC DATA SOURCE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • CLP will crash if work with nickname without user mapping, when
    Federation server connect to odbc data source.
    
    Below is log for db2diag.log
    2010-08-02-22.28.43.735706-300 E3511A884          LEVEL: Error
    (Received)
    PID     : 1425690              TID  : 2829        PROC : db2sysc
    INSTANCE: regres1              NODE : 000         DB   : TESTDB
    APPHDL  : 0-587                APPID:
    *LOCAL.regres1.100803032837
    AUTHID  : REGRES1
    EDUID   : 2829                 EDUNAME: db2agent (TESTDB)
    FUNCTION: DB2 UDB, ODBC wrapper, report_error_message,
    probe:1123
    
    Here is information from strap file
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x0000000100069968 clp_print_colnames__FP10clp_colposP5sqldasi +
    0x1A8
    0x0000000100065CD0 clp_print_heading__FP10clp_colpossP5sqldai +
    0x570
    0x000000010005A6A0 clp_fetch_rows__FiUiN21P10clp_colpossP5sqlda
    + 0x1220
    0x000000010005E734 clpbp_exe_sqlselect__Fv + 0x414
    0x0000000100001794 clp_bp_con__Fv + 0x634
    0x0000000100000B24 main + 0x224
    </StackTrace>
    
    Reproduce steps:
    CONNECT TO testdb
    DROP WRAPPER WRAPPER1
    CREATE WRAPPER "WRAPPER1" LIBRARY 'libdb2rcodbc.a'
    OPTIONS(MODULE '/odbcdirver_path', DB2_FENCED 'N')
    create server "S1" type odbc version 5 wrapper "WRAPPER1"
    authorization "***" password "***" OPTIONS(fold_id 'N', fold_pw
    'N', node '***', dbname '***', PUSHDOWN 'Y', DB2_IUD_ENABLE 'Y',
    DB2_ONE_REQUEST_PER_CONNECTION 'N', CODEPAGE '1252',
    DB2_POSITIONED_UD 'Y')
    create user mapping for user server "S1" options ( REMOTE_AUTHID
    '***', REMOTE_PASSWORD '***' )
    SET PASSTHRU "S1"
    DROP TABLE "***"."FEDQGE_S1_TT01"
    SET PASSTHRU RESET
    CREATE TABLE "FEDQGE_S1_TT01" ("I1" INTEGER )
    OPTIONS(REMOTE_SERVER 'S1', REMOTE_SCHEMA '***')
    CREATE NICKNAME "S1_NN01" FOR "S1"."***"."FEDQGE_S1_TT01"
    insert into S1_NN01 values 1
    connect reset
    connect to testdb
    select * from S1_NN01
    drop user mapping for user server S1
    
    Here we drop user mapping , so below statement which works with
    nickname "S1_NN01" will crash CLP
    
    connect reset
    connect to testdb
    select * from S1_NN01
    

Local fix

  • Create user mapping for user and server
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 CLP users                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When we try to perform a select using a dropped user mapping *
    * on a server, clp crashed.                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Create the required mapping if on pre-v97fp4 or upgrade to   *
    * v97fp4.                                                      *
    ****************************************************************
    

Problem conclusion

  • Problem fixed in v97fp4 to throw appropriate error.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR38029

  • Reported component name

    ODBC WRAPPER

  • Reported component ID

    5724N9707

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-10-18

  • Closed date

    2011-04-28

  • Last modified date

    2011-04-28

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

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

    IC71977

Fix information

  • Fixed component name

    ODBC WRAPPER

  • Fixed component ID

    5724N9707

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPM","label":"Data Sources and Wrappers - ODBC"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"970","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
28 April 2011