Wednesday, June 18, 2008

Red Alert : DB2 for z/OS V8 and V9 potential loss of data

I hope it's just my impression but are the Red Alerts coming faster the last couple of months ? The full title of this one goes : 'DB2 for z/OS V8 and V9 potential loss of data during update of fixed length rows'.

The description :
A defect was introduced by APAR PK63401. If either PTF UK35464 or UK35465 is applied, then a potential loss of data can occur in a DB2 V8 or DB2 V9 environment. The loss may occur in a fixed length row update where the length of updated data is greater than 256 bytes. A fixed length table is one that does not contain any VARCHAR, LONG VARCHAR or ROWID columns.The exposure exists only if subject table space or partition is not compressed, and no EDIT procedures exists on the table. Apar PK66997 has been created to resolve this problem. Please refer to the APAR text for further details.
Recommended action :
Remove PTFs UK35464 or UK35465 or apply the solution for PK66997.

No comments: