Fixes are available
DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 4 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
Env: DWB 9.1 and DB2 V9 on z/os Problem Desc: When Customer try to debug the Native SQL SP, they find that they only can see 128 bytes string even when they set MAXIMUM numbers characters reported in large variables to 500. Is this the tools limitation or anywhere they can configure to see more characters for large variable? There are actually two problems. There is a setting in DWB for the maximum length of a variable value to show. DWB ignores the variable length setting and always truncates variables to 127 characters. The debug server also ignores the value and truncates the variable values to 254 characters. Both problems will need to be fixed.
Local fix
Not yet available
Problem summary
Users affected - All Problem Description - When trying to debug the Native SQL SP, only can see 128 bytes string even when set MAXIMUM numbers characters reported in large variables to 500, Problem Summary - When Customer try to debug the Native SQL SP, they find that they only can see 128 bytes string even when they set MAXIMUM numbers characters reported in large variables to 500. Is this the tools limitation or anywhere they can configure to see more characters for large variable?
Problem conclusion
First fixed in DB2 UDB Version 9.1, FixPak y4
Temporary fix
Comments
APAR Information
APAR number
JR27081
Reported component name
DB2 CUE WINDOWS
Reported component ID
5724B6201
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-07-18
Closed date
2007-11-27
Last modified date
2007-11-27
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 CUE WINDOWS
Fixed component ID
5724B6201
Applicable component levels
R910 PSY
UP
Document Information
Modified date:
07 January 2022