A fix is available
APAR status
Closed as program error.
Error description
FM/Db2 generates a template which it will use to display data in the ISPF session. A SQL SELECT * FROM owner.table_name is created, followed by a SQL PREPARE and SQL DESCRIBE. As a result of the SQL SELECT, Db2 RLF limits may be exceeded, causing FM/Db2 to return a SQLCODE -495.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All FM/Db2 users with RLF active. * **************************************************************** * PROBLEM DESCRIPTION: FM/Db2 encounters the following errors * * when the Resource Limit Facility (RLF) * * is active. * * * * 1. FM/Db2 incorrectly displays a * * warning panel indicating a Resource * * Limit Facility (RLF) limit has been * * reached. * * * * 2. Hitting cancel (PF12) on the 'DB2 * * Predictive Governor Warning' panel * * FMN2PRPW causes -206 SQL code. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** 1. FM/Db2 when creating a FM/Db2 template is getting a +495 or -495 SQLCODE preparing an SQL SELECT statement to obtain Db2 field information. FM/Db2 should be ignoring these SQL codes. 2. FM/Db2 is not exiting correctly when hitting CANCEL (PF12) on the 'DB2 Predictive Governor Warning' panel FMN2PRPW.
Problem conclusion
FM/Db2 is modified to resolve these issues.
Temporary fix
Comments
APAR Information
APAR number
PH39950
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-08-18
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