Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC70746 Status: Closed

DATA LINK PROPERTIES IN MICROSOFT EXCEL AND SQL SERVER MANGEMENT STUDIO
DOESNOT SHOW DB2 COPY NAME APPENDED TO DB2 OLE DB PROVID

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
IBM OLEDB Provider listing in "Data Link Provider" does not show 
DB2 copy names when multiple copies are installed. 
 
Repro steps 
open the excel 2007 
Go to menu 
Data -> Get External Data -> using wizard (3rd option) -> 
Other/Advanced drivers -> choose driver with copy name 
For excel 2003 the 
Data->import external data->Connect to new data 
source->Other/advanced 
 
Using sql server managment studio 
Connect to sql server using sql server mangement studio 
Go to linked server ->new linked server 
it will open linked server diaglog box which will list oledb 
providers. 
 
It lists OLE DB Provider(s) and that is where IBM OLEDB 
Providers are listed . Some of them might be displayed 
without having copyname appended 
 
This can happen if the installed DB2 copy is default and in that 
case the DB2 COPY name is not appended to OLEDB provider. 
the problem doesnot happen when installed DB2 copy is non 
default one where the actually copy name is appended. 
 
the excel/SQl server management studo reads the DB2 OLE DB 
provider from 
"HKEY_CLASSES_ROOT\CLSID\{IBMDADB2 guid}\OLE DB Provider" key
Problem Summary:
IBM OLEDB Provider listing in "Data Link Provider" does not show 
DB2 copy names when multiple copies are installed.
Local Fix:
To get copy name for other IBM oledb providers which has not 
showing copy name appended in DB2 oledb provider list, do this 
process as workaround 
 
1)Using regedit go to 
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies 
2) Change the  named "Default" to some value like DB2 ( value 
other than installed DB2Copy names) 
3)Get the sqllib/bin folder path which correspond to db2copy 
which is not appended in oledb provider string in excel DSN 
dialog box. 
4) Run regsvr32 "DB2copypath/sqllib/bin/ibmdadb2.dll" from 
start->run 
5) Repeat step 3 and 4 for other DB2copies for which OLEDB 
provider copy name is not appended in excel DSN dialog box. 
6) Close the excel and reopen it and check if dsn dialog box is 
showing the copyname now 
7) Revert back the DB2 copy value changed in step 2 to original 
DB2 copy
available fix packs:
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Target fix is V9.1 fp10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
24.08.2010
14.06.2011
14.06.2011
Problem solved at the following versions (IBM BugInfos)
9.1.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.10 FixList
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.