IBM Support

PI29475: MISSING 'WITHOUT ROW ATTRIBUTES' WHEN EXTRACTING DDL FOR A USING A EDITPROC USING DB2ENCRI

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When attempting to extract DDL for a table and specify the
    'Without Row Attributes' parm, FM/DB2 drops the parm.
    
      Expected:
    
           ...
           EDITPROC  DB2ENCRI WITHOUT ROW ATTRIBUTES
           AUDIT NONE
           DATA CAPTURE NONE
           CCSID      EBCDIC
           NOT VOLATILE
           APPEND NO  ;
    
      Results:
    
           ...
           EDITPROC  DB2ENCRI
           AUDIT NONE
           DATA CAPTURE NONE
           CCSID      EBCDIC
           NOT VOLATILE
           APPEND NO  ;
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of File Manager DB2 component.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: The DDL generated using the FM/DB2 GEN  *
    *                      command is missing the 'WITHOUT ROW     *
    *                      ATTRIBUTES' clause.                     *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    The SQL Reverse-engineering code is not recognizing the 'ROW
    ATTRIBUTES' clause, which was added at
    DB2 version 10.
    

Problem conclusion

  • File Manager DB2 component has been changed to correct the
    problem.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI29475

  • Reported component name

    FILE MANAGER Z/

  • Reported component ID

    5655Q1200

  • Reported release

    D12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-11-11

  • Closed date

    2014-11-27

  • Last modified date

    2015-01-02

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

    PI25388

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

Modules/Macros

  •    FMN2LVL  FMN2LVLJ
    

Fix information

  • Fixed component name

    FILE MANAGER Z/

  • Fixed component ID

    5655Q1200

Applicable component levels

  • RD12 PSY UI23491

       UP14/12/02 P F412

  • RD13 PSY UI23492

       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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
01 May 2020