Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC64508 Status: Closed

A QUERY EXECUTED AGAINST 2 OR MORE OLEDB TABLE FUNCTIONS THAT REFERENCES
THE SAME DATA SOURCE RETURNS SQL1182 ERROR.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
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
Problem Summary:
**************************************************************** 
* 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.                                         * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
First fixed in V9.5 FP6.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC64517 IC64518 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.11.2009
09.09.2010
09.09.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.