IBM Support

IT08518: SYSPROC.MON_GET_CONNECTION DOES NOT DIFFERENTIATE BETWEEN SECURE AND NON-SECURE CONNECTIONS TO A DATABASE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Using SYSPROC.MON_GET_CONNECTION (and MON_GET_CONNECTIONS) to
    try to differentiate between secure and non-secure connections
    to a
    database.
    
    The definition of the client_protocol API element (in sqlmon.h)
    shows this should be possible.
    
    But the following example SQL returns TCPIP4 for both SSL &
    non-SSL connections.
    
    select client_protocol from
    table(sysproc.mon_get_connection(sysproc.mon_get_application_han
    dle(), -1));
    
    REPRO:
    
    db2 update dbm cfg using svcename 50000
    db2set DB2COMM=TCPIP
    db2stop
    db2start
    db2sampl -sql -xml
    db2 catalog TCPIP node loopback REMOTE localhost SERVER 50000
    db2 catalog db sample as RSAMPLE at NODE loopback
    
    db2 connect to rsample user <USERID> using <Password>
    db2 "select client_protocol from
    table(sysproc.mon_get_connection(sysproc.mon_get_application_han
    dle(), -1))"
    
    Then need to setup and configure SSL as per:
    
    Configuring Secure Sockets Layer (SSL) support in a DB2 instance
    http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.
    ibm.db2.luw.admin.sec.doc/doc/t0025241.html?lang=en
    
    Configuring Secure Sockets Layer (SSL) support in non-Java DB2
    clients
    http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.
    ibm.db2.luw.admin.sec.doc/doc/t0053518.html
    
    Then repeat the above or create a new connection using the SSL
    port.
    
    db2 update dbm cfg using ssl_svcename 50010
    db2set DB2COMM=SSL,TCPIP
    db2stop
    db2start
    db2 catalog TCPIP node ssldb REMOTE localhost SERVER 50010
    db2 catalog db sample as SSAMPLE at NODE ssldb
    db2 connect to ssample user <USERID> using <Password>
    db2 "select client_protocol from
    table(sysproc.mon_get_connection(sysproc.mon_get_application_han
    dle(), -1))"
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 LUW v10.5 Fixpack 7 or Later.                 *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 LUW v10.5 Fixpack 7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT08518

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-04-24

  • Closed date

    2016-01-21

  • Last modified date

    2016-01-21

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA50 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
21 January 2016