home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT02037 Status: Geschlossen

SETTING PROGRAMNAME IN DB2DSDRIVER.CFG (PROGRAMNAME) AND IN THE TESTCASE
(SQL_ATTR_INFO_PROGRAMNAME ) TO A VALID VALUE AND CONNE

Produkt:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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
Lösung
db2_v97fp10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.05.2014
10.11.2014
10.11.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.10 FixList