PI61578: INCORRECT VALUES INSERTED INTO DB2 FIELDS WHEN THEY ARE DEFINED AS 'NOT NULL' AND A NULL IS MAPPED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using the IBM WebSphere TX DB2 adapter on the z/OS
  platform, it may be observed that incorrect values are inserted
  into fields of a DB2 table when they are defined as 'not null'
  and a null is mapped.
  
  The map should fail but instead it may insert the value from the
  previous row.
  

Local fix

• WTXCQ - WTX00048492
  PB / PB
  As a workaround, ensure that the rules of the map are designed
  in such a way as to ensure a NULL is never the value mapped to a
  field defined in DB2 as 'not null'
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of WebSphere Transformation        *
  *                 Extender V8.3                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: INCORRECT VALUES INSERTED INTO DB2      *
  *                      FIELDS WHEN THEY ARE DEFINED            *
  *                      AS 'NOT NULL' AND A NULL IS MAPPED.     *
  ****************************************************************
  * RECOMMENDATION: Apply this maintenance                       *
  ****************************************************************
  INCORRECT VALUES INSERTED INTO DB2 FIELDS WHEN THEY ARE DEFINED
  AS 'NOT NULL' AND A NULL IS MAPPED.
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

  PI61028

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

  UI37439

Modules/Macros

• DTXCTBL  DTXCTST  DTXCXIT  DTXDPAXB DTXIMQS  DTXIMS   DTXIMSIT
  DTXISQL  DTXKTST  DTXKXIT  DTXMAPLD DTXMPULD DTXPSB1  DTXPSB2
  DTXSDK   DTXTEST  DTXTESTA DTXTESTC DTXTESTP DTX830AD DTX830CI
  DTX830DB DTX830ED DTX830IC DTX830IK DTX830IU DTX830KB DTX830KC
  DTX830KD DTX830KI DTX830KL DTX830KM DTX830KP DTX830KS DTX830KU
  DTX830KZ DTX830LD DTX830ML DTX830MP DTX830NM DTX830RK DTX830RL
  DTX830RM DTX830RS DTX830RU DTX830RZ DTX830TB DTX830TK DTX830XB
  DTX830XC DTX830XD DTX830XK DTX830XL DTX830XM DTX8304C DTX8304M
  DTX8304S DTX8305C DTX8305L DTX8305M DTX8305N DTX8305S GTXSDK
  GTXTESTA
  

Fix information

• Fixed component name

  WTX APP PGM ZOS

• Fixed component ID

  5655R9502

Applicable component levels

• R832 PSY UI37439

     UP16/05/03 P F605

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.