A fix is available
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