IBM Support

JR31585: CREATE NICKNAME ERROR WHEN CREATING NICKNAME BY USING MICROSOFT ODBC DRIVER WITHOUT VALID CARD AND NPAGES VALUE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You may create nickname failed when the remote table has an
    index on WINDOWS. This is because the wrapper gets invalid
    statistics data from the remote data source for the table.
    In the db2diag.log:
    INSTANCE: iidev5 NODE : 000   DB   : TEST
    APPHDL : 0-187        APPID: *LOCAL.iidev5.081211092014
    AUTHID : IIDEV5
    EDUID : 7969      EDUNAME: db2agent (TEST)
    FUNCTION: DB2 UDB, catalog services,
    sqlrlCatalogScan::checkLenValid, probe:10
    DATA #1 : String, 11 bytes
    PACKED_DESC
    DATA #2 : signed integer, 4 bytes
    9656
    DATA #3 : String, 33 bytes
    sqlrz_pd_verify failed with rc -4
    

Local fix

Problem summary

  • Users affected:
       Users of the ODBC wrapper in InfoSphere Federation Server
    Problem description and summary:
       See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9.5, FixPak 4 (s090429). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR31585

  • Reported component name

    ODBC WRAPPER

  • Reported component ID

    5724N9707

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-03

  • Closed date

    2009-06-16

  • Last modified date

    2009-06-16

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

    JR31478

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

Fix information

  • Fixed component name

    ODBC WRAPPER

  • Fixed component ID

    5724N9707

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPM","label":"Data Sources and Wrappers - ODBC"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2009