Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 04 Aug 2011 @ 08:59:30 GMT

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

Subj:   Re: MVC, VARCHAR, v13.10, error 9471
From:   Ulrich Arndt


I guess you upgraded your system to 13.1?

Did you change the No13dot0Backdown dbs controll parameter?

System documentation does not list Varchar compression but I guess it is (see docu extract below)

On a new installed system it works from the beginning.

Never the less I faced some other issues with longer compression lists. So keep testing...



No13dot0Backdown Purpose

Field Group Valid Settings


Enables several 13.10 features which, if enabled, prevent an upgraded system from being backed down to release 13.0 without a sysinit.


TRUE: Enables several 13.10 features and prevents Teradata Database 13.10 from being backed down to release 13.0 database management software without a sysinit on 13.0.

FALSE: On systems that have been upgraded from Teradata Database 13.0 to 13.10, several features are disabled. As long as this setting remains FALSE, the system can be backed down to release 13.0 database management software.

On systems that have been initialized (sysinited) on Teradata Database 13.10, the default setting is TRUE, and cannot be changed.

On systems that have been upgraded to 13.10 from a prior release, the default setting is FALSE.



Changes Take Effect

Usage Notes

After the DBS Control Record has been written.

Use of the following 13.10 features requires this setting to be TRUE, and therefore precludes backdown on upgraded systems:

. . . . . .

Algorithmic compression for column values Data block compression Data block merging during full table operations Temporal table support Timestamp-based partition elimination Time zone strings

Ulrich Arndt

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023