PK76115: ARSZIFLD ABENDS W/U999 DUE TO SQLCODE -803.

A fix is available

 

APAR status

  • Closed as program error.

Error description

  • ARZIFLD encounters sqlcode -803 and issues U999 abend when
    ARSZIFLD is pre-compiled using a code page different from the
    code page under which the ARSZIFLD package is bound and in which
    CDSDT table data is stored.

    E.G., ARSZIFLD pre-compiled with code page 37, but ARSZIFLD
    package bound and CDSDT table data stored using code page 278.

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: IAFC migration customers with non-English *
    * codepage. *
    ****************************************************************
    * PROBLEM DESCRIPTION: ARSZIFLD ABENDS W/U999 DUE TO SQLCODE *
    * -803. *
    ****************************************************************
    * RECOMMENDATION: Re-bind required for ARSZIFLD package. *
    ****************************************************************
    The ARSZIFLD program was modified to access the CDSDT DB2 table
    using host variables rather than literal values due to codepage
    issues.

Problem conclusion

  • The ARSZIFLD program was selecting and inserting rows in the
    CDSDT DB2 table in an inconsistent manner with regard to
    codepage translations used by DB2. The code was modified to
    use only host variables to resolve this issue .

Temporary fix

Comments

APAR Information

  • APAR number

    PK76115

  • Reported component name

    CM OD Z/OS, OD/

  • Reported component ID

    5655H3900

  • Reported release

    841

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-20

  • Closed date

    2009-01-27

  • Last modified date

    2009-02-02

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

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

    UK43510

Modules/Macros
ARSZIFLD          

Fix information

  • Fixed component name

    CM OD Z/OS, OD/

  • Fixed component ID

    5655H3900

Applicable component levels

  • R841 PSY UK43510

       UP09/01/30 P F901

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Content Manager OnDemand for z/OS

Software version:

841

Reference #:

PK76115

Modified date:

2009-02-02

Translate my page

Machine Translation

Content navigation