IBM Support

IT29857: SQLCREATEPKG API IS FAILING WITH SQL0031C ERROR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQLCreatePkg()/SQLCreatePkgW() API called wtih just bind or list
    file name without providing he full pathname, with SQL0031C
    error.
    
    SQLCreatePkgW( hDbc=0:1, szBindFileNameIn="@db2cli.lst",
    cbBindFileNameIn=-3, szBindOpts="ACTION=REPLACE;
    KEEPDYNAMIC=YES; RELEASE=COMMIT; REOPT=ONCE; ENCODING=UNICODE;
    BLOCKING=ALL; COLLECTION=COLID773X2;
    MSGFILE=\\wdflbmd22311\sapmnt\N75\SYS\global\bindout.log;
    GENERIC=APPLCOMPAT V12R1M501", cbBindOpts=-3 )
        ---> Time elapsed - +0,000000E+000 seconds
    
    SQLCreatePkgW( )
        <--- SQL_ERROR   Time elapsed - +0,000000E+000 seconds
    
    SQLGetDiagFieldW( pDiagInfo="[IBM][CLI Driver][DB2] SQL0031C
    File "D:\SLHA\work\ld2295\ibmcase\/usr/sap/N75/SYS/globa" could
    not be opened.
    
    This is because install path on windows returned has '/' in it
    in place of '\', hence SQLCreatePkg() throwing error.
    
    ex:
      Install Path:
    D:/usr/sap/N75/SYS/global\\db2\WINDOWS_AMD64\db2_clidriver\
    

Local fix

  • Use the full path of the bind file (.bnd) or list file (.lst),
    instead of just file name.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 CLI users using SQLCreatePkg() API                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 11.1.4.5                              *
    ****************************************************************
    

Problem conclusion

  • The issue will be fixed in DB2 v11.1 M4FP5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29857

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-07-29

  • Closed date

    2020-02-23

  • Last modified date

    2020-02-23

  • 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 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RB50 PSN

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"11.1"}]

Document Information

Modified date:
02 September 2021