home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC64508 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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:
verfügbare FixPacks:
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

Lösung
First fixed in V9.5 FP6.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC64517 IC64518 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.11.2009
09.09.2010
09.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP6
Problem behoben lt. FixList in der Version