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 IC85803 Status: Closed

USING ATTACH=TRUE DURING CONNECT THROWS SQL0843N

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
USING ATTACH=TRUE DURING CONNECT THROWS SQL0843N. 
For e.g. 
Here's a sample db2dsdriver.cfg 
<configuration> 
   <dsncollection> 
      <dsn alias="mydsn" name="mydb" host="myhost" port="9999"> 
      </dsn> 
   </dsncollection> 
   <parameters> 
      <parameter name="Attach" value="TRUE"/> 
      <parameter name="ConnectionTimeout" value="300"/> 
   </parameters> 
</configuration> 
 
During connect with mydsn, following error occurs 
[IBM][CLI Driver] SQL0843N  The server name does not specify an 
existing connection.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v101fp1 or later                              * 
****************************************************************
Local Fix:
NA
available fix packs:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
Fixed in db2_v101fp1. 
SQL0843N will not occur with ATTACH=TRUE during connect.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.08.2012
02.11.2012
02.11.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.1 FixList
10.5.0.1 FixList