IBM Support

PI73002: PACKAGE VERSIONING WILL BE REINSTATED, SQLCODE805

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Starting with the fix for PI68502, in DB2 HPU 4.2 and from HPU
    4.3, the packages delivered via the maintenance stream no longer
    have versions.
    
    Package versioning will be reinstated to avoid SQL code -805
    after binding new maintenance.
    
    PB47381  SQLCODE805 SQLCODE -805
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
    *                 z/OS.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: From the fix for PI68502 in DB2 HPU     *
    *                      4.2 and from HPU 4.3, the packages      *
    *                      delivered via the maintenance stream    *
    *                      no longer have versions. The            *
    *                      versioning must be reinstated.          *
    *                      pb 47381                                *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    The infotel, infoutil, inzquery, inzqryv8, inzqryv9, inzqry11,
    inzcrxsm, inzcrxsq, inzseta, inzsete, inzsetu and inzacdb2
    module were changed.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI73002

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    430

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-11-30

  • Closed date

    2017-01-10

  • Last modified date

    2017-02-01

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

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

    UI43798 UI43799

Modules/Macros

  •    INZ$$PRM INZACDB2 INZCRXSM INZCRXSQ INZQRYV8
    INZQRYV9 INZQRY11 INZQUERY INZSETA  INZSETE  INZSETU  INZTPMEM
    INZTVAR  INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R420 PSY UI43798

       UP17/01/16 P F701

  • R430 PSY UI43799

       UP17/01/16 P F701

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUV","label":"IBM Db2 High Performance Unload for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021