PI29365: DATA TRUNCATION NOT DETECTED IN ACCESS EDIT/BROWSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If a SELECT of a row of data is truncated by DB2 Optim may not
  detect this and will erroneously display partial data.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Optim for z/OS users editing or browsing DBCS DB2 data       *
  * stored in Unicode encoded tables.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Customers performing EDIT or BROWSE of DB2 data from tables  *
  * having data stored with Unicode encoding may encounter data  *
  * truncation when DB2 translates character column data from    *
  * Unicode to the CCSID of the Optim plan. This scenario may    *
  * occur only when processing DBCS data. Optim would ignore the *
  * data truncation error and not alert the user of this         *
  * condition.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the provided fix.                                      *
  ****************************************************************
  Optim for z/OS is not detecting and reporting data truncation
  resulting from translation of double-byte data from a Unicode
  code page to a code page associated with the CCSID of the Optim
  plan.
  

Problem conclusion

• Optim for z/OS processing will be changed to detect data
  truncation resulting from translation from a Unicode code page
  to a code page associated with the CCSID of the Optim plan while
  executing the Edit and Browse functions.
  A status flag of T will be shown on the ISPF panels for a row
  whose data has been truncated. Additional diagnostic information
  will be available with the HELP function.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI29364

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB30 PSY UI27548

     UP15/05/14 P F505

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.