JR54816: TRUNCATE WHEN CONFIGURED WITH "ON CLEAR/TRUNCATE ==>DO NOT DELETE" IS NOT WORKING AS EXPECTED IN NETEZZA ENGINE

APAR status

• Closed as program error.

Error description

• Truncate when configured with "On Clear/Truncate ==>Do Not
  Delete" is not working as expected in Netezza engine.
  As a result, the truncate operations are reflected at target
  Netezza side even "Do Not Delete" option is selected.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Customers using IIDR 10.2 and Netezza.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * TRUNCATE WHEN CONFIGURED WITH "ON CLEAR/TRUNCATE ==>DO NOT   *
  * DELETE" IS NOT WORKING AS EXPECTED IN NETEZZA ENGINE.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IIDR 11.3.3.2-25 or higher.                       *
  ****************************************************************
  

Problem conclusion

• This issue is fixed by applying IIDR 11.3.3.2-25 or higher.
  

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

  IDR FOR NETEZZA

• Fixed component ID

  5725E3002

Applicable component levels

• RA20 PSN

     UP

• RB30 PSN

     UP

• RB33 PSY

     UP