IBM Support

IC84843: SQLGETDIAGFIELDW TRUNCATES THE ERROR MESSAGE RETURNED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you have a CLI application that calls SQLGetDiagField(), the
    error message returned may be incomplete because CLI calls
    SYSIBM.SQLCAMESSAGE() with incorrect parameters.
    
    Example :
    If your CLI application is calling the following procedure CALL
    SYSPROC.ADMIN_INFO_SYSLOG
    (NULL,'*','2012-05-06','00.01.00','2012-05-30','23.00.00',3000,?
    ) and it fails with error -471 :
    
    the message returned is
    
    SQLGetDiagField( pDiagInfo="[IBM][CLI Driver][DB2] INVOCATION OF
    FUNCTION OR PROCEDURE SYSPROC.ADMIN_INFO_SYSLOG", pcbDiagInfo=84
    )
        <--- SQL_SUCCESS   Time elapsed - +1.237700E-002 seconds
    
    instead of
    
    SQLGetDiagField( pDiagInfo="[IBM][CLI Driver][DB2] INVOCATION OF
    FUNCTION OR PROCEDURE SYSPROC.ADMIN_INFO_SYSLOG FAILED DUE TO
    REASON 00E79106", pcbDiagInfo=114 )
        <--- SQL_SUCCESS   Time elapsed - +1.237700E-002 seconds
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * db2connect users using cli.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v97fp7 or later releases.                     *
    ****************************************************************
    

Problem conclusion

  • db2_v97fp7 contains fix of this issue. After the fix, user will
    get correct error message.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC84843

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-22

  • Closed date

    2012-10-24

  • Last modified date

    2012-10-24

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

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

    IC85658

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 October 2012