|
Problem IT03820
|
Status: Closed |
WHEN FAILOVER HAPPENS THE SQLSTATE HAS A XXXXX INSTEAD OF A NUMB ER, BETTER TO HAVE AN APPROPRIATE NUMBER. A SEAMLESS FAILOVER OC |
| product: |
DB2 CONNECT / DB2CONNCT / A10 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* db2-connect *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to db2_v101fp5 *
**************************************************************** |
| Local Fix: |
|
| Solution |
db2_v101fp5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.08.2014
13.07.2015
13.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
