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

  UI37438

Modules/Macros

• DTXCMDSV DTXPAGE  DTXPROF  DTX830   GTXCMDSV GTXPAGE  GTXPROF
  GTX830
  

Fix information

• Fixed component name

  WTX COMMAND SER

• Fixed component ID

  5655R9501

Applicable component levels

• R831 PSY UI37438

     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.