JR27081: WHILE DEBUGING NATIVE SQL SP, CAN SEE 128 BYTES STRING EVEN WHEN MAX CHARACTERS REPORTED IN LARGE VARIABLES TO 500

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 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