A fix is available
APAR status
Closed as program error.
Error description
Using FM DB2 Object List Utility get: DSNT408I SQLCODE = -331, ERROR: CHARACTER CONVERSION CANNOT BE PREFORMED BECAUSE A STRING, POSITION 100, CNANNOT BE CONVERTED FROM 1208 TO 5026, REASON 16 The reason for -331 has been identified to be inadequate use of "VARCHAR(RU.EXTERNAL_NAME, 128)".
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: In FM/DB2 Object List display of * * functions, SQLCODE-331 when processing * * a function definition with DBCS data in * * the EXTERNAL_NAME column. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The SQL statement used to access table SYSIBM.SYSROUTINES has a clause "VARCHAR(RU.EXTERNAL_NAME,128) AS ..". When the data in this column contains characters requiring 3 or more unicode bytes, truncation of the data may occur, resulting in the
Problem conclusion
File Manager DB2 component has been updated to correct the problems.
Temporary fix
Comments
APAR Information
APAR number
PM04796
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-01-12
Closed date
2010-07-29
Last modified date
2010-09-01
APAR is sysrouted FROM one or more of the following:
PK94525
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN2LVL FMN2LVLJ FMN2LVLK
Fix information
Fixed component name
FILE MANAGER ZO
Fixed component ID
5655V5200
Applicable component levels
RA1B PSY UK59241
UP10/08/04 P F008
RA12 PSY UK59244
UP10/08/04 P F008
RA13 PSY UK59247
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