A fix is available
APAR status
Closed as program error.
Error description
When accessing a DB2 V8 system (NFM) using DDF from a DB2 V9 system (NFM), with CATOWNER¬=SYSIBM, receive message: DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "ROUNDING". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: = ENCODING
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE-104 attempting to access a DB2 * * system that is prior to V9 (NFM), when * * connected to a DB2 system at DB2 V9 * * (NFM), with FMN2POPT parameter CATOWNER * * not equal to 'SYSIBM'. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** FM/DB2 is erroneously issuing SQL statements to set the CURRENT DECFLOAT ROUNDING MODE, when connected to DB2 systems that do not support this statement.
Problem conclusion
File Manager DB2 component has been updated to correct the problem.
Temporary fix
Comments
APAR Information
APAR number
PM14353
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-05-13
Closed date
2010-07-29
Last modified date
2010-09-01
APAR is sysrouted FROM one or more of the following:
PM13661
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN2LVL
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