|
Problem IC88275
|
Status: Closed |
DB2DSDCFGFILL CREATES A DB2DSDRIVER.CFG FILE WITH AN INCORRECT AUTHENTICATION VALUE ON THE DATABASE ALIAS |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
When using db2dsdcfgfill to create a db2dsdriver.cfg file, a
database alias may have a value for the authentication parameter
set when the original entry for the same alias in the "list db
directory" output does not have an authentication value set.
For example:
The following entry in the "list db directory" output:
Database alias = DB1
Database name = DB1
Node name = SV75DD02
Database release level = d.00
Comment = DB2 MVS
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
May result in an entry like the following in the db2dsdriver.cfg
file created by db2dsdcfgfill:
<dsn alias="DB1" name="DB1" host="HOST1" port="50000">
<parameter name="Authentication" value="Server_Encrypt"/>
</dsn>
The authentication value is being carried over from a different
alias and being incorrectly applied to the alias that is not
supposed to have an authentication value.
This problem only occurs when the database directory has a
mixture of database aliases that do not have the authentication
value set and aliases that do have the authentication value set. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* CLI users using db2dsdcfgfill utility. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7.6 and later *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
From DB2 v9.7.6 onwards db2dsdcfg fill will create the correct
authentication based on the catalog information. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.11.2012
16.11.2012
16.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
