IBM Support

PI95564: FILE MANAGER MISCELLANEOUS PROBLEMS AND FORWARD FITS FROM EARLIER FM VERSIONS.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • File Manager Miscellaneous problems and forward fits  from
    earlier FM versions.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All File Manager Users.                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR fix includes the following    *
    *                      APARs forward fitted from V13:          *
    *                      PI77162                                 *
    *                      Enhancement APAR. Provide an option     *
    *                      allowing the editor auto-commit value   *
    *                      to be set to a fixed value for all      *
    *                      users.                                  *
    *                      PI90661                                 *
    *                      In the File Manager DB2 editor,         *
    *                      SQLCODE-798 attempting to insert a      *
    *                      row.                                    *
    *                      PI90314                                 *
    *                      The File Manager DB2 component          *
    *                      editor is not updating changes to       *
    *                      columns in objects that contain XML     *
    *                      columns.                                *
    *                      PI89650                                 *
    *                      In File Manager DB2 component, the      *
    *                      Explain utilities create tables without *
    *                      certain columns added at DB2 versions   *
    *                      11 and 12.                              *
    *                      PI89351                                 *
    *                      Abend U0999 in module FMN2EXML at       *
    *                      offset X'924' after issuing an XMLEDIT  *
    *                      command.                                *
    *                      PI87273                                 *
    *                      Message FMNDC034 1 row(s) inserted      *
    *                      using the FM/DB2 BATSQL function.       *
    *                      The number of rows that should be       *
    *                      inserted is > 1.                        *
    *                      PI90030                                 *
    *                      File Manager has the following issues   *
    *                      processing large MQ records.            *
    *                      1. Viewing or maintaining MQ records    *
    *                      greater than 1677215 bytes.             *
    *                      2. When issuing the FIND view or edit   *
    *                      command File Manager is not finding     *
    *                      string values positioned after 4M in    *
    *                      an MQ record.                           *
    *                      PI89908                                 *
    *                      Specifying just the input record start  *
    *                      position on the FLD_OUT FASTREXX        *
    *                      function will only copy 80 bytes        *
    *                      from the input record, rather than      *
    *                      the remainder of the input record.      *
    *                      PI89336                                 *
    *                      When displaying data set information    *
    *                      for an SMS compressed GDG Generate      *
    *                      Data Set (GDS), the Extended and        *
    *                      SMS compressed fields may report        *
    *                      Incorrect values.                       *
    *                      PI94187                                 *
    *                      When connected to a DB2 version 12      *
    *                      system,                                 *
    *                      selecting the 'Prototype SELECT         *
    *                      statements                              *
    *                      (advanced)' option results in a         *
    *                       no-operation.                          *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    

Problem conclusion

  • PI77162
    A new FMN2SSDM macro parameter: AUTO_COMMIT
    has been added that allows the product installer to
    fix the FM/DB2 editor auto-commit value for all users.
    For the documentation changes associated with this APAR,
    please refer to the 'What's New' section in the
    File Manager V14 Knowledge Center:
    https://ibm.biz/Bdj3bE
    PI90661
    The problem occurs when one or more columns have the
    'as-generated-expression-clause'.
    File Manager DB2 component has been updated to
    correct the problem.
    PI90314
    The problem occurs when changes are made to
    columns that appear after an XML column, eg.
    An object has three columns: COL1, COL2, COL3.
    COL2 is XML, COL1 and COL3 are not. Changes to
    COL1 are saved, changes to COL3 are not
    saved.
    File Manager DB2 component has been updated to
    correct the problem.
    PI89650
    File Manager DB2 component has been updated so
    that all columns appropriate for DB2 versions 8-12 will
    be included when the explain utility is used to create
    the following user tables:
    1. PLAN_TABLE
    2. DSN_FUNCTION_TABLE
    3. DSN_STATEMNT_TABLE
    PI89351
    File Manager DB2 component has been updated to
    correct the problem. File Manager DB2 component
    will process any view where DB2 returns a valid RID for
    the following query:
    SELECT RID(<object_name>) FROM <object_name>
    WHERE ...
    The WHERE clause contains predicates that uniquely
    identify the row, typically by specifying all columns
    and corresponding values of a unique index defined
    on the base table.
    PI87273
    File Manager DB2 component has been changed so
    that the BATSQL function (TYPE=INSERT) will correctly
    handle the situation where the AUTOCOMMIT count is
    greater than the number of rows to be inserted.
    PI90030
    1. File Manager needs to be able to handle MQ records up to
     100MB.
    2. File Manager is limiting its search of strings to 4MB for MQ
    records rather than the maximum MQ record size.
    File Manager has been updated to resolve these problems.
    PI89908
    The REXX external function FLD_OUT i_length parameter
    defaults to 80 bytes and may cause data to be truncated.
    The File Manager REXX external function FLD_OUT
    i_length parameter is modified to default to the record
    length.
    PI89336
    File Manager has been updated to correct this problem
    PI94187
    An internal check for the maximum supported version of DB2
    prevents execution of the function.
    File Manager DB2 component has been updated to correct the
    problem.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI95564

  • 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

    2018-03-21

  • Closed date

    2018-04-11

  • Last modified date

    2018-05-01

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

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

    UI55135 UI55136 UI55137 UI55138 UI55139 UI55140 UI55141 UI55142

Modules/Macros

  • FMN0LVL  FMN0LVLJ FMN0LVLK FMN1DLI  FMN1LVL  FMN2D2I8 FMN2D2IA
    FMN2D2IB FMN2D2IC FMN2D2JA FMN2D2JB FMN2D2JC FMN2DATA FMN2DENP
    FMN2DENU FMN2DJPN FMN2DKOR FMN2ERRK FMN2FE4B FMN2GV20 FMN2GV21
    FMN2GV22 FMN2LVL  FMN2LVLJ FMN2LVLK FMN2MENU FMN2MJPN FMN2MKOR
    FMN2PEO6 FMN2POPT FMN2PSX2 FMN2RD45 FMN2SSDM FMN3CICS FMN3LVL
    FMNASMX  FMNCBLX  FMNDB36  FMNDF25  FMNDF92  FMNDF93  FMNMAIN
    FMNMAINZ FMNMOD1  FMNMOD16 FMNMOD2  FMNMOD2B FMNMOD2S FMNMODD
    FMNMODO  FMNMODPB FMNMODT  FMNODIRS FMNPANL  FMNPEMC  FMNPNXIT
    FMNPREP  FMNRXCOM FMNRXEX  FMNRXFUN FMNRXINI FMNRXIO  FMNSETUP
    FMNSMF
    

Fix information

  • Fixed component name

    FILE MANAGER Z/

  • Fixed component ID

    5655Q4200

Applicable component levels

  • RE10 PSY UI55135

       UP18/04/16 P F804

  • RE11 PSY UI55136

       UP18/04/16 P F804

  • RE12 PSY UI55138

       UP18/04/16 P F804

  • RE13 PSY UI55139

       UP18/04/16 P F804

  • RE14 PSY UI55141

       UP18/04/16 P F804

  • RE16 PSY UI55142

       UP18/04/16 P F804

  • RE1A PSY UI55137

       UP18/04/16 P F804

  • RE1B PSY UI55140

       UP18/04/16 P F804

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
01 May 2018