A fix is available
APAR status
Closed as program error.
Error description
sing File Manager DB2 customer issue SET CURRENT QUERY ACCELERATION = ALL and it fails with message "An invalid statement or a statement that is not dynamically was found in the statement entry area."
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 * * component. * **************************************************************** * PROBLEM DESCRIPTION: In File Manager DB2 component, unable * * to execute SQL statement * * SET CURRENT QUERY ACCELERATION * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** New SET commands were added in DB2 version 11, the keyword table in FM/DB2 that recognizes the valid SET commands was not updated.
Problem conclusion
File Manager DB2 component has been updated to correct the problem.
Temporary fix
Comments
APAR Information
APAR number
PI81813
Reported component name
FILE MANAGER Z/
Reported component ID
5655Q1200
Reported release
D12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-05-19
Closed date
2017-06-26
Last modified date
2017-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN2LVL
Fix information
Fixed component name
FILE MANAGER Z/
Fixed component ID
5655Q1200
Applicable component levels
RD12 PSY UI48296
UP17/07/04 P F707
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":"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":"D12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
02 August 2017