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

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

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 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