A fix is available
APAR status
Closed as program error.
Error description
When select statement: SELECT USER, GRANTOR FROM SYSIBM.SYSUSERAUTH is entered from FM/DB2 option 4.3, receive the following message - UNICODE conversion error codepage 1208 to codepage 37. Return code 4, reason code 7 from CUNLCNV routine.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager, DB2 component, * * options 4.3 and 4.4, entering free-form * * SELECT SQL statements. * **************************************************************** * PROBLEM DESCRIPTION: Unicode conversion error "UNICODE * * conversion error codepage 1208 to * * codepage 37. Return code 4, reason code * * 7 from CUNLCNV routine." displaying the * * result table for a query involving an * * SQL register and a DB2 catalog table. * * The target DB2 system is at DB2 version * * 8, new function mode or later. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The problem can be demonstrated with the following SELECT SQL statement: 'SELECT USER,NAME FROM SYSIBM.SYSCOLUMNS'. An internal reference table is built incorrectly when a special register is combined with columns of a DB2 catalog table.
Problem conclusion
File Manager DB2 component has been changed to correct the problem.
Temporary fix
Comments
APAR Information
APAR number
PM45337
Reported component name
FILE MANAGER Z/
Reported component ID
5655W4700
Reported release
B12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-08-09
Closed date
2011-11-09
Last modified date
2011-12-01
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
5655W4700
Applicable component levels
RB12 PSY UK73712
UP11/11/15 P F111
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":"B12","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":"B12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
01 December 2011