|
Problem IC67780
|
Status: Closed |
IN CONFIGURATION ASSISTANT (DB2CA), IN THE ADD DATABASE WIZARD THE "OPTIMIZE FOR APPLICATION" DROP DOWN LIST BOX IS EMPTY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In Configuration Assistant (db2ca), in the Data Source panel of
the Add Database Wizard, the "Optimize for Application" drop
down list box contains only the item "None".
Here is how to reproduce this problem:
1) Start Configuration Assistant.
2) Select from the Configuration Assistant menu
Select -> Add Database Using Wizard...
The Add Database Wizard window should appear.
3) In the "1. Source" panel of the Add Database Wizard, select
"Manually configure a connection to a database",
then click the "Next>" button.
4) In each of the following panels, select suitable values for
your database
then click the "Next>" button until you get to the "5. Data
Source" panel.
5) In the "5. Data Source" panel, check the "Register this
database for CLI/ODBC" checkbox.
Now the "Optimize for application" drop down list box contains
only the item "None". |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of DB2 on Linux, UNIX and Windows *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* . *
**************************************************************** |
| Local Fix: |
To work around this problem, before you start Configuration
Assistant, set the DB2 registry variable DB2CLIINIPATH to the
SQLLIB directory under the DB2 database product installation
path.
For example, if your DB2 database product installation path is
C:\Program Files\IBM, run:
db2set DB2CLIINIPATH="C:\Program Files\IBM\SQLLIB"
If you start Configuration Assistant after that, the "Optimize
for application" drop down list box contains these items:
None
Lotus Approach
Microsoft Access
Microsoft Visual Basic |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 4 |
| Workaround |
To work around this problem, before you start Configuration
Assistant, set the DB2 registry variable DB2CLIINIPATH to the
SQLLIB directory under the DB2 database product installation
path.
For example, if your DB2 database product installation path is
C:\Program Files\IBM, run:
db2set DB2CLIINIPATH="C:\Program Files\IBM\SQLLIB"
If you start Configuration Assistant after that, the "Optimize
for application" drop down list box contains these items:
None
Lotus Approach
Microsoft Access
Microsoft Visual Basic |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC73743
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.04.2010
24.05.2011
24.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
