DB2 CONNECT / DB2CONNCT / 950 - DB2

Calling the IBM DB2 testconn11.exe or testconn20.exe program 
from DB2 Connect v9.5 or v9.7 fails on step 4 with 
a NullReferenceException: 
. 
Step 4: Calling GetSchema for tables to validate existance of 
schema functions 
System.NullReferenceException: Object reference not set to an 
instance of an object. 
  at IBM.Data.DB2.bq.x(String[] A_0) 
  at IBM.Data.DB2.bq.b(String A_0, String[] A_1) 
  at IBM.Data.DB2.DB2Connection.GetSchema(String collectionName, 
String[] restrictionValues) 
  at IBM.Data.DB2.DB2Connection.GetSchema(String collectionName) 
  at TestConn.myClassName.GetSchemaTable() 
Test failed 
---------------------------------------------------------------- 
. 
Those programs should be modified to return a meaningful message 
when failing to run any metadata stored procedure. 
. 
This APAR will only correct the error message, but it will not 
resolve the problem.  The GetSchema function will not work when 
the DESCSTAT parameter is set to NO.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Calling the IBM DB2 testconn11.exe or testconn20.exe         * 
* programfrom DB2 Connect v9.5 or v9.7 fails on step 4 with    * 
* aNullReferenceException:Step 4: Calling GetSchema for tables * 
* to validate existanceof schema                               * 
* functionsSystem.NullReferenceException: Object reference not * 
* set toan instance of an object.at IBM.Data.DB2.bq.x(String[] * 
* A_0)at IBM.Data.DB2.bq.b(String A_0, String[] A_1)at         * 
* IBM.Data.DB2.DB2Connection.GetSchema(StringcollectionName,   * 
* String[] restrictionValues)at                                * 
* IBM.Data.DB2.DB2Connection.GetSchema(StringcollectionName)at * 
* TestConn.myClassName.GetSchemaTable()Test                    * 
* failed-------------------------------------------------------- 
* programs should be modified to return a meaningfulmessage    * 
* when failing to run any metadata stored procedure.           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5, Fixpak 6                         * 
****************************************************************

Set DESCSTAT=YES on DB2 for z/OS and re-run the DSNTIJSG job in 
order to rebind the packages.

DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 UDB Version 9.5, Fixpak 6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC68394 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

04.05.2010
31.05.2010
10.08.2010

9.5.