A fix is available
APAR status
Closed as program error.
Error description
Users of DB2 Administration Tool for z/OS who wish to display the SQL statements of a TRIGGER from Admin panel ADB21K , Packages panel, receive unreadable characters in panel ADB21KSE Extracted SQL display. Unreadable characters occur when running Admin in a DB2 v10 COMPAT mode ( CM ) environment.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use the 'SQ - Show the SQL * * statements' line command on panel ADB21K * * 'Packages'. * **************************************************************** * PROBLEM DESCRIPTION: When a Trigger is created on DB2 10 * * Compatibility Mode (CM) 8 or * * Compatibility Mode (CM) 9, or a * * Trigger package is rebound on DB2 * * 10 Compatibility Mode (CM) 8 or * * Compatibility Mode (CM) 9, the 'SQ - * * Show the SQL statements'' line * * command on panel ADB21K can not * * extract the SQL statement resulting in * * UNICODE characters being displayed * * instead of the SQL, for example: * * * * -- SQL statements in TRIGGER * * :trigger_name.() * * -- SQL in stmt: 1 * * + + (&+! * * -- SQL in stmt: 2 * * < (& + (&+! * **************************************************************** * RECOMMENDATION: * **************************************************************** Program is missing logic to perform UNICODE conversion for Trigger packages when using DB 10 Compatibility Mode (CM) 8 or Compatibility Mode (CM) 9.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM63875
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-05-03
Closed date
2012-07-05
Last modified date
2012-08-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK80060
Modules/Macros
ADB21KSQ
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK80060
UP12/07/08 P F207
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 August 2012