IBM Support

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

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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
    

Local fix

  • use PROGRAMNAME either from db2dsdriver.cfg file or through
    testcase
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * db2-connect                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to db2_v97fp10 and later                             *
    ****************************************************************
    

Problem conclusion

  • db2_v97fp10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT02037

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-27

  • Closed date

    2014-11-10

  • Last modified date

    2014-11-10

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IT02038 IT02039

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSY

       UP

  • RA10 PSY

       UP

  • RA50 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT02037

Modified date: 10 November 2014