IBM Support

PI22421: AFTER PTF UI18014 APPLIED TO DB2 10 FOR Z/OS DSNTIAUL, DSNTEJ2A STEP PREPUNL.ASM GETS RC=8 DUE TO ASMA034E 14/08/20 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After PTF UI18014 (fixes APAR PM86927) is applied to DB2 10 for
    z/OS, sample job DSNTEJ2A job.proc step PREPUNL.ASM terminates
    with return code 8 due to ASMA034E Addressability error during
    assembly of the DSNTIAUL sample unload program.  The error
    occurs only on z/OS V1R12 and older releases.
    

Local fix

  • Continue to use your existing (pre-UI18014) DSNTIAUL module or
    migrate the environment to z/OS 1.13 or a newer release that
    uses compact DFP macros.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DSNTIAUL in DB2 Version 9 and   *
    *                 DB2 Version 10 for z/OS who have PM86927     *
    *                 applied (UI18016 for V9,UI18014 for V10)     *
    *                 are affected by this change.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: After applying UI18016 and UI18014,     *
    *                      DB2 9 and 10 customers who run on       *
    *                      z/OS 1.12 or older cannot assemble      *
    *                      DSNTIAUL.  It is terminated with        *
    *                      return code 8 and the message:          *
    *                         ASMA034E *** ERROR ***               *
    *                      Addressability error                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DSNTIAUL is a sample dynamic SQL processing application that is
    used primarily to unload data from DB2 tables to an externalized
    format.  DSNTIAUL also generates a LOAD control statement that
    can be used in conjunction with the DB2 LOAD utility to load the
    externalized data back into DB2.
    
    A recent APAR, PM86927, modified DSNTIAUL to specify 'XML'
    rather than 'CLOB' in the field specification for each XML
    column in the generated LOAD control statement when the
    DSNTIAUL LOBFILE option is not specified. In z/OS 1.12 and
    previous releases, certain system macros can cause assembly
    to fail with msgASMA034E.
    

Problem conclusion

  • In response, this APAR removes the PM86927 modications to
    DSNTIAUL in DB2 9 and 10 to avoid disrupting customers who
    use z/OS 1.12 and older releases.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI22421

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-07-21

  • Closed date

    2014-11-18

  • Last modified date

    2015-01-02

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

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

    UI23147 UI23148

Modules/Macros

  •    DSNTIAUL
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI23147

       UP14/12/03 P F412 Ø

  • R910 PSY UI23148

       UP14/12/03 P F412 Ø

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1"}]

Document Information

Modified date:
05 March 2021