IBM Support

PH41734: RECEIVE ABEND04E WHEN VIEWING A DB2 TABLE WITH FILE MANAGER DB2.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using FM/Db2 to view a table which includes CLOB
    columns, abend S04E reason code=00E7000C is received.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All FM/Db2 users.                            *
    ****************************************************************
    * PROBLEM DESCRIPTION: A Db2 04E abend occurs when attempting  *
    *                      to edit a Db2 table with a Character    *
    *                      Large Object (CLOB) column.             *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    A Db2 table with an internal type of 409 for a Character Large
    Object (CLOB)column was causing FM/Db2 to generate an invalid
    SQLDA. A Db2 04E abend occurred when SQL was prepared using this
    SQLDA.
    

Problem conclusion

  • FM/Db2 is modified to resolve this issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH41734

  • Reported component name

    FILE MANAGER Z/

  • Reported component ID

    5655Q4200

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-11-01

  • Closed date

    2021-12-07

  • Last modified date

    2022-01-04

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

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

Modules/Macros

  • FMN0LVL  FMN0LVLJ FMN0LVLK FMN0MENU FMN0MJPN FMN0MKOR FMN1ASMX
    FMN1DLI  FMN1END  FMN1LVL  FMN1LVLJ FMN1LVLK FMN1MENU FMN1MJPN
    FMN1MKOR FMN1POPT FMN2D2I8 FMN2D2IA FMN2D2IB FMN2D2IC FMN2D2JA
    FMN2D2JB FMN2D2JC FMN2DATA FMN2LVL  FMN2LVLJ FMN2LVLK FMN2RLIB
    FMN4POPT FMNASMBX FMNASMBY FMNASMX  FMNBA15  FMNBIDXM FMNCBLX
    FMNCGEN  FMNCHMAC FMNCHNG  FMNCLFMC FMNCLNED FMNCLONE FMNCNVDS
    FMNELIBD FMNEPROC FMNESRCH FMNFC1ST FMNFMLST FMNFTDSP FMNFTFCH
    FMNGDSM  FMNGDSME FMNGDSMV FMNGTRC  FMNIA01  FMNIA19  FMNIA33
    FMNIB35  FMNIDX   FMNIDXEM FMNIDXLS FMNINDEX FMNMAIN  FMNMAINZ
    FMNMOD1  FMNMOD16 FMNMOD2  FMNMOD2B FMNMOD2S FMNMOD6Z FMNMODC
    FMNMODD  FMNMODO  FMNMODPB FMNMODT  FMNODIRS FMNPANL  FMNPCRDL
    FMNPCRZL FMNRCRDL FMNRCRM1 FMNRCRM2 FMNRCRM3 FMNRCRZL FMNREFEM
    FMNRUNPR FMNRXCOM FMNRXEX  FMNRXFUN FMNRXINI FMNRXIO  FMNSETUP
    FMNSMF   FMNSMFZ  FMNSPWB  FMNSRCH  FMNSRCHB FMNSRCHE FMNSRCHK
    FMNSRCHL FMNSRCHM FMNSRCHT FMNSRCHX FMNSREF  FMNVGENM FMNVMAC
    FMNVMACM FMNVMACR FMNVWGEN FMNWD1ST FMNXIDXM
    

Fix information

  • Fixed component name

    FILE MANAGER Z/

  • Fixed component ID

    5655Q4200

Applicable component levels

  • RE10 PSY UI78425

       UP21/12/10 P F112

  • RE11 PSY UI78426

       UP21/12/10 P F112

  • RE12 PSY UI78428

       UP21/12/10 P F112

  • RE13 PSY UI78429

       UP21/12/10 P F112

  • RE14 PSY UI78431

       UP21/12/10 P F112

  • RE15 PSY UI78432

       UP21/12/10 P F112

  • RE1A PSY UI78427

       UP21/12/10 P F112

  • RE1B PSY UI78430

       UP21/12/10 P F112

  • RE1C PSY UI78433

       UP21/12/10 P F112

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":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
05 January 2022