DB2 FOR LUW / DB2FORLUW / 950 - DB2

If a select query is executed against 2 or more OLEDB table 
functions that references the same data source, SQL1182 error is 
returned. 
 
Eg) 
 
1) View V1 was created with a reference to a table function F1. 
 
 
CREATE VIEW V1 AS SELECT * FROM TABLE(F1( )) OLEDBTB; 
 
Where the table function F1( ) uses Provider=SQLOLED and gets 
data from SQL server. 
 
 
2) View V2 was created with a reference to a table function 
 
CREATE VIEW V2 AS SELECT * FROM TABLE(F2( )) OLEDBTB; 
 
Where the table function F2 also gets the data from the same SQl 
Server data source. 
 
 
 
3) View VW is a join of the V1 and V2 views noted above. 
 
 
Queries ran directly against views V1 & V2 are successful. 
 
A query ran against view VW fails with the error 
 
Select from V1 works 
 
Select from V2 works 
 
Select from VW throws this error; 
      0 rows selected because of ERROR. 
 
[DB2/NT] SQL1182N  User defined function "F2" could not 
initialize data source object of specified OLE DB provider. 
 HRESULT="0x80040e52". Diagnostic text: "Data source object is 
already initial".  SQLSTATE=38506

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 LUW V9.5 users.                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If a select query is executed against 2 or more OLEDB        * 
* tablefunctions that references the same data source,         * 
* SQL1182error isreturned.                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.5 Fp6.                                         * 
****************************************************************

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 V9.5 FP6.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC64517 IC64518 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.11.2009
09.09.2010
09.09.2010

9.5.FP6