IBM Support

JR32331: IMPORT & EXPORT FROM DB2 LUW CLIENT TO DB2 Z/OS SERVER OR OTHER HOST SERVERS RETURNS SQL2019N BECAUSE PACKAGE NOT BOUND

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you attempt to use the Import or Export utilities from a DB2
    LUW 9.5 client to a DB2 z/OS server,DB2 on VSE, DB2 on VM, or
    DB2 on iSeries server you may encounter a SQL2019N.
    
    Prior to v95, binding the list file ddcsmvs.lst, ddcsvse.lst,
    ddcsvm.lst or ddcs400.lst  was sufficient
    to use these utilities from a DB2 LUW client to a DB2 on z/OS,
    DB2 on VSE, DB2 on VM or DB2 on iSeries server respectively.
    
    However in V95 a new package named db2uiDescribe.bnd
    was introduced in Import & Export. This package was correctly
    added to db2ubind.lst (for DB2 LUW servers), but not to
    ddcsmvs.lst (for DB2 on z/OS servers), or to ddcsvse.lst (for
    DB2 on VSE servers), or to ddcsvm.lst (for DB2 on VM servers),
    or to ddcs400.lst (for DB2 on iSeries servers).
    
    The APAR fix involves adding db2uiDescribe.bnd to
    the ddcsmvs.lst, ddcsvse.lst, ddcsvm.lst, and ddcs400.lst list
    files.
    

Local fix

  • You can manually bind db2uiDescribe.bnd.
    

Problem summary

  • IMPORT & EXPORT FROM DB2 LUW CLIENT TO DB2 Z/OS SERVER OR OTHER
    HOST SERVERS RETURNS SQL2019N BECAUSE PACKAGE NOT BOUND
    

Problem conclusion

  • First Fixed in DB2 Version 9.5 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32331

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-12

  • Closed date

    2009-12-15

  • Last modified date

    2010-10-08

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

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

    IC63990

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       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":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 October 2010