A fix is available
APAR status
Closed as new function.
Error description
When viewing a very large table using FM/DB2, and 'ALL' is specified in the row count field, the DB2 Global temporary tablespace fills up. This can cause severe impact on critical DB2 regions.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: DB2 issues SQLCODE-904 errors on the * * temporary database when a File Manager * * DB2 user edits a DB2 object with row * * count = 0. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The File Manager DB2 editor can operate in two modes, normal and large. Large mode is selected by specifying row count = 0 on the editor function entry panel. Large mode processing uses a DB2 scrollable cursor to provide access to all rows of the result table, while minimizing the memory requirement in the user's TSO address space. DB2 might build a copy of the result table in the DB2 temporary database when a scrollable cursor is used - this can lead to SQLCODE-904 errors (unavailable resource) when processing large DB2 objects, or when the space available in the DB2 temporary database is constrained.
Problem conclusion
Temporary fix
Comments
Enhancement APAR. File Manager DB2 component has been changed to allow the product installer to disable large object support for the File Manager DB2 editor. A new FMN2SSDM macro parameter EDIT_MAX_ROWS can be specified. The default is 0, meaning that large object support is available, this preserves the existing product behaviour. Specifying EDIT_MAX_ROWS=n, n>0 has two effects: 1. Large object support is disabled. When a File Manager DB2 editor user specifies row count = 0, they instead get a normal editor session with at most n rows loaded. 2. n sets an absolute limit on the number of rows that may be loaded for any File Manager DB2 editor user. If a user sets row count = m, m>n they instead get a normal session with at most n rows. Note that the new parameter is specified as an FMN2SSDM macro parameter, therefore editor large object support can be disabled/enabled for each DB2 system defined in the FMN2POPT module. The FMN2POPT module is affected by this APAR, however the module only needs to be modified/re-created when the new EDIT_MAX_ROWS parameter is specified with a non-zero value. Publication Closing Code: DEVCHNG For the documentation changes associated with this APAR, please refer to: ftp://ftp.software.ibm.com/software/websphere/awdtools/ filemanager/fmv10apar.pdf The changes are to the following publications: PUB ID PUB NAME ------------ ---------------------------------------- SC19-2856-00 File Manager for z/OS Customization Guide Version 10 Release 1 The latest published manuals can be found at: http://www.ibm.com/software/awdtools/filemanager/library/ index.html.
APAR Information
APAR number
PM52873
Reported component name
FILE MANAGER ZO
Reported component ID
5655V5200
Reported release
A12
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-11-23
Closed date
2012-02-22
Last modified date
2012-04-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK76451 UK76452 UK76453 UK76454 PM63521
Modules/Macros
FMNASMX FMNAUDCH FMNAUDDS FMNCBIN FMNCBLX FMNCPCK FMNDB14 FMNDB88 FMNDYNTP FMNEDIT FMNEDIT1 FMNEDIT3 FMNEDIT4 FMNEDIT6 FMNED0DY FMNED0SE FMNED1EX FMNED4CE FMNED4D FMNED4EX FMNED4F FMNED4IN FMNED4LB FMNED4TM FMNESRTM FMNFILTR FMNISPF FMNLKTAB FMNLOCAL FMNLOG2 FMNPLIX FMNPPCLA FMNPPMN FMNPPNAV FMNPPTOK FMNRDCCO FMNRDFFD FMNRDFNM FMNRDFSG FMNRDFTB FMNRDMSC FMNRDR FMNRDRAR FMNRDRCV FMNRDR2 FMNRDUFD FMNRDUHX FMNRDUSG FMNRDUTB FMNRDUZD FMNRDU2V FMNRDXML FMNRD2IN FMNRMBAE FMNRMINI FMNRMPOP FMNRMR FMNRMRED FMNRMR2 FMNRMUPD FMNSCREX FMNSCRFD FMNTPBFM FMNTPDFD FMNTPEFL FMNTPEFM FMNTPEVL FMNTRTMP FMN0LVL FMN0SAF FMN2ABUF FMN2ABXT FMN2ACNM FMN2AJSQ FMN2ASQD FMN2ATXT FMN2AUDI FMN2A2IO FMN2BCNL FMN2BCTQ FMN2BDBQ FMN2BNCL FMN2BONM FMN2BUCL FMN2BUTQ FMN2CATQ FMN2CD2V FMN2CGM2 FMN2CHKI FMN2CKCN FMN2CNVR FMN2CSQI FMN2CTMP FMN2CTM1 FMN2CTM2 FMN2CTQ2 FMN2C2IO FMN2DBC FMN2DBI FMN2DBJ FMN2DBO FMN2DBOL FMN2DBP FMN2DBV FMN2DBX FMN2DBY FMN2DCIO FMN2DCMD FMN2DCRE FMN2DIUS FMN2D2C FMN2D2E FMN2D2EC FMN2D2EE FMN2D2EG FMN2D2EI FMN2D2EL FMN2D2ES FMN2D2G FMN2D2SP FMN2EDSP FMN2EDT1 FMN2EOBN FMN2ERR FMN2ETRC FMN2EXSY FMN2FBP1 FMN2FDCN FMN2FERW FMN2FMT FMN2FSQC FMN2FTJV FMN2FTPC FMN2F433 FMN2F442 FMN2GISQ FMN2HLI FMN2IDTB FMN2INTE FMN2INTJ FMN2INTP FMN2IPSU FMN2ISPF FMN2ISQ FMN2ISQG FMN2ISQI FMN2ISQS FMN2ITSV FMN2IVSU FMN2LIBS FMN2LOCL FMN2LVL FMN2LVLJ FMN2LVLK FMN2MAIN FMN2MENU FMN2MISC FMN2MJPN FMN2MKOR FMN2MXXX FMN2OPTL FMN2PD2E FMN2PFMS FMN2POPT FMN2PRVP FMN2RALI FMN2RESI FMN2RMDT FMN2RMQ FMN2RMR FMN2RMR2 FMN2RMUT FMN2SAGF FMN2SAPR FMN2SBPR FMN2SCON FMN2SCST FMN2SEDX FMN2SELS FMN2SENX FMN2SERR FMN2SHSQ FMN2SIDM FMN2SNTX FMN2SNXP FMN2SQLC FMN2SQSU FMN2SQS2 FMN2SQTB FMN2SSDM FMN2SSID FMN2SSQL FMN2SSSU FMN2STG FMN2STRP FMN2SXPM FMN2SXPX FMN2TTBL FMN2UBLD
SC19285600 |
Fix information
Fixed component name
FILE MANAGER ZO
Fixed component ID
5655V5200
Applicable component levels
RA1B PSY UK76452
UP12/02/26 P F202
RA10 PSY UK76451
UP12/02/26 P F202
RA12 PSY UK76453
UP12/02/26 P F202
RA13 PSY UK76454
UP12/02/26 P F202
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":"A12","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":"A12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
30 April 2012