Archives of the TeradataForum

Message Posted: Sat, 30 Aug 2008 @ 21:07:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

There is a DR for a possible data corruption if you were to use Alter Table and Compress together.

See Below Tech Alert

     NTA 1759 - CRITICAL  - ALTER TABLE ADD COMPRESS COLUMN may
     cause data corruption on Linux - Teradata DBS (Linux and
     Windows) - 08/28/2008

     CONFIGURATION DATA:

     Scope/Criteria:

     ALTER TABLE ADD compress columns can cause data corruption
     in the existing rows on Linux/Teradata system.

     Sample Query:

     ALTER TABLE  database1.table1
     ADD   column1 CHAR(1)  COMPRESS '0',
     ADD   column2 SMALLINT COMPRESS 0 ,
     ADD   column3 SMALLINT COMPRESS 0 ,
     ADD   column4 INTEGER  COMPRESS 0 ,
     ADD   column5 INTEGER  COMPRESS (0 ,999999 ),
     ADD   column6 SMALLINT COMPRESS 0 ,
     ADD   column7 SMALLINT COMPRESS 0 ,
     ADD   column8 INTEGER  COMPRESS 0 ;

     Exposed Releases:

     All TDBMS_6.2.0.x releases
     All TDBMS_6.2.1.x releases
     TDBMS_6.2.2.0 to TDBMS_6.2.2.49
     All TDBMS_12.0.0.x releases
     All TDBMS_12.0.1.x releases


     SYMPTOM:

     ALTER TABLE ADD COMPRESS COLUMN may cause data corruption on
     Linux platform.

     PROBABLE CAUSE:

     Software defect

     SOLUTION:

     DR 124306 has fixed this problem and the fix is available in
     the following version :

     Fix Release: TDBMS_ 6.2.2.50

     Workaround : There is no workaround.

Thanks,

Vinay Bagare

	<Prev	Next>		<<First	<Prev	Next>	Last>>