|
Problem IT02037
|
Status: Closed |
SETTING PROGRAMNAME IN DB2DSDRIVER.CFG (PROGRAMNAME) AND IN THE TESTCASE (SQL_ATTR_INFO_PROGRAMNAME ) TO A VALID VALUE AND CONNE |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
Steps
1. 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_INFO_PROGRAMNAME asasas
sqlconnect 1 sap -3 sysadm -3 c0deshop -3
Output
> sqlconnect 1 sap -3 sysadm -3 c0deshop -3
Segmentation fault
Note 1 : Commenting "sqlsetconnectattrW 1
SQL_ATTR_INFO_PROGRAMNAME asasas" does not crash
Note 2: Also commenting the "<parameter name="ProgramName"
value="string"/>" in the db2dsdriver.cfg will not crash
So basically when ProgramName is present in db2dsdriver.cfg as
well as program name it crashes.
Since it crashes at the basic connection it needs to be fixed.
Happens even with 10.5fp2. So seems like its something missed
always |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* db2-connect *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to db2_v97fp10 and later *
**************************************************************** |
| Local Fix: |
use PROGRAMNAME either from db2dsdriver.cfg file or through
testcase |
| Solution |
db2_v97fp10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.05.2014
10.11.2014
10.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
