A fix is available
APAR status
Closed as program error.
Error description
SQLCODE-514 or -518 in an FM/DB2 editor session with row count = ALL, after issuing an EXPORT editor primary command.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE-518 and SQLCODE-514 in an * * FM/DB2 editor session, with the * * following conditions: * * 1. The editor row count value is set * * to ALL (also 0, *). * * 2. The EXPORT editor primary command * * is issued. * * 3. A large scroll command is issued, * * eg to the top or bottom of the * * result table. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The EXPORT process issues a DB2 COMMIT, which closes the scrollable cursor used by the FM/DB2 editor in "large" mode. After the export is complete subsequent attempts to scroll result in the SQLCODE-518 and SQLCODE-514 errors.
Problem conclusion
File Manager DB2 component has been changed to correct the problem. This APAR resolves internally-reported problem PFM06034. Publication Closing Code: DEVCHNG For the documentation changes associated with this APAR, please refer to: ftp://public.dhe.ibm.com/software/websphere/awdtools/ filemanager/fmv12apar.pdf The changes are to the following publications: PUB ID PUB NAME ------------ ---------------------------------------- SC19-3675-00 File Manager for z/OS V12R1 User's Guide and Reference for DB2 Data 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
PM72194
Reported component name
FILE MANAGER Z/
Reported component ID
5655W6800
Reported release
C12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-09-04
Closed date
2012-11-20
Last modified date
2012-12-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
128AC7
Modules/Macros
FMN2LVL
Fix information
Fixed component name
FILE MANAGER Z/
Fixed component ID
5655W6800
Applicable component levels
RC12 PSY UK83656
UP12/11/24 P F211
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":"C12","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":"C12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
04 December 2012