A fix is available
APAR status
Closed as program error.
Error description
On panel FMN2PEO7 the settings for the following two options are swapped: 1. Edit locking option (locking) 2. Keep locks option Thus if the user specifies '2' for "Keep locks option" the effect is actually to lock the table in share mode. The recommended settings for minimal locking are as follows: 1. Read-only access OFF 2. Commit after data fetch ON 3. Concurrency No with clause (1) 4. Locking None (1) 5. Keep locks option Use/keep share locks (1)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: FM/DB2 is not adding the "WITH UR" * * clause to the SELECT statement used * * to access DB2 data for browse and view * * only, even though the appropriate * * editor option is set for uncommitted * * read. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** File Manager DB2 is ignoring the 'WITH UR' option in browse and view modes.
Problem conclusion
File Manager DB2 component has been updated to correct the problem. The APAR also introduces a small enhancement allowing explicit table locking in an FM/DB2 editor session to be disabled for all users. The enhancement is implemented by the addition of a new parameter (TABLE_LOCKING) to the FMN2SSDM macro. The default for this new option is TABLE_LOCKING=YES. Should a user require that explicit table locking be disabled for a particular DB2 system, the FMN2POPT module would need to be modified by the addition of TABLE_LOCKING=NO to selected FMN2SSDM macro specifications, followed by re-application of the appropriate usermod. Publication Closing Code: DEVCHNG For the documentation changes associated with this APAR, please refer to: ftp://ftp.software.ibm.com/software/websphere/awdtools/ filemanager/fmv9apar.pdf The changes are to the following publications: PUB ID PUB NAME ------------ ---------------------------------------- SC19-2856-00 File Manager for z/OS V10R1 Customization Guide The latest published manuals can be found at: http://www.ibm.com/software/awdtools/filemanager/library/ index.html.
Temporary fix
Comments
APAR Information
APAR number
PM07702
Reported component name
FILE MANAGER ZO
Reported component ID
5655V5200
Reported release
A12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-02-17
Closed date
2010-07-29
Last modified date
2010-09-01
APAR is sysrouted FROM one or more of the following:
PK95961
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN2LVL
SC19285600 |
Fix information
Fixed component name
FILE MANAGER ZO
Fixed component ID
5655V5200
Applicable component levels
RA12 PSY UK59244
UP10/08/04 P F008
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:
01 September 2010