PI59783: LUA OPTIM.MASK MAY TRUNCATE OUTPUT IF TABLE DATATYPE IS DECIMAL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Truncation of target values may occur from returned values in an
  optim.mask call when the DB2 table data type is packed decimal,
  and data type specified in optim.mask request is zero delimited
  variable character.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Clients running Lua procs that call Optim Data Privacy       *
  * Providers calling the optim.mask function.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Truncation of target values may occur from returned values   *
  * in an optim.mask call when the DB2 table data type is packed *
  * decimal, and data type specified in optim.mask request is    *
  * varchar_sz.                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply this fix.                                              *
  ****************************************************************
  The optim.mask function was asked to use character value in a
  transformation request, but Lua was picking up the size of the
  target from the table definition. If the table data type is
  decimal, the length value returned to Lua will be the number of
  bytes needed for a packed decimal value, which in many cases
  will be too small to hold a valid result.
  

Problem conclusion

• Code will be changed to use the length based on length field
  specified on the optim.mask request input value, or returned Lua
  target value, whichever is larger.
  

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:

  UI36755

Modules/Macros

• FOPCXLIB FOPZFMMN FOPMCOLP FOPMMUNU
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB30 PSY UI36755

     UP16/04/07 P F604

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.