DB2 CONNECT / DB2CONNCT / A10 - DB2

Steps 
 
db2dsdriver.cfg 
 
<configuration> 
<dsncollection> 
<dsn alias="sap" name="STLEC1" host="inec002.vmec.svl.ibm.com" 
port="446"/> 
</dsncollection> 
<databases> 
<database name="STLEC1" host="inec002.vmec.svl.ibm.com" 
port="446"> 
      <acr> 
         <parameter name="enableACR" value="true"/> 
        <parameter name="enableSeamlessACR" value="true"/> 
                    <alternateserverlist> 
                        <server name="S1" 
hostname="inec002.vmec.svl.ibm.com" port="446"/> 
                        <server name="S2" 
hostname="inec003.vmec.svl.ibm.com" port="446"/> 
                        <server name="S3" 
hostname="inec013.vmec.svl.ibm.com" port="446"/> 
                    </alternateserverlist> 
                    <affinitylist> 
                        <list name="list1" 
serverorder="S1,S2,S3"/> 
                    </affinitylist> 
                    <clientaffinitydefined> 
                        <client name="client1" 
hostname="localhost" listname="list1"/> 
                    </clientaffinitydefined> 
                </acr> 
</database> 
</databases> 
<parameters> 
<parameter name="ProgramName" value="string"/> 
<parameter name="SQLCODEMAP" value="NOMAP"/> 
 
</parameters> 
</configuration> 
 
 
2. Run this testcase 
 
opt echo on 
opt caller on 
opt echo on 
SQLAllocEnv 1 
SQLAllocconnect 1 1 
sqlsetconnectattrW 1 SQL_ATTR_REPORT_SEAMLESSFAILOVER_WARNING 
SQL_REPORT_SEAMLESSFAILOVER_WARNING_YES 
 
sqlconnect 1 sap -3 sysadm -3 c0deshop -3 
sqlallocstmt 1 1 
 
### stop the connected server to see the message like below 
> sqlexecdirect 1 "create table aa.s(id int)" -3 
sqlexecdirect 1 "create table aa.s(id int)" -3 
SQLExecDirect: rc = 1 (SQL_SUCCESS_WITH_INFO) 
SQLError: rc = 0 (SQL_SUCCESS) 
SQLError: SQLState     : xxxxx 
          fNativeError : -99999 
          szErrorMsg   : [IBM][CLI Driver] CLI0212W  A seamless 
failover occurred during a connect or an execute request. 
SQLSTATE=xxxxx 
          cbErrorMsg   : 111 
 
 
 
The SQLState is xxxxx and should have been some correct number 
instead ? 
 
Happens even in 10.5fp2.   Better to fix since it should be an 
easy fix. 
 
Will check if the existing buckets has this

**************************************************************** 
* USERS AFFECTED:                                              * 
* db2-connect                                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to db2_v101fp5                                       * 
****************************************************************

db2_v101fp5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

18.08.2014
13.07.2015
13.07.2015