Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2002 @ 12:08:19 GMT

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

Subj:   Re: Datablocksize and Freepercent
From:   David Wellman

It may do, and even if it is there it's not always easy to get at using SQL. Details are;

-- there is no column in a view/table which holds this information (as far as I'm aware it is basically stored in the table headers on the amps

-- these are not directly accessible using SQL)

-- when you create a table the request string that you submit is accessible in dbc.tables.requesttext and so if you specify values for these parameters they will be shown there.

-- however, if you subsequently issues an alter table to do anything else (e.g. adding/removing columns) then the alter table request string is placed in dbc.tables.requesttext and so wipes out the datablocksize etc parameters that were initially used. Note that these values are still used by the DBMS because they're stored in the table headers, it's just that you cannot find them in dbc.tables.requesttext.


Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <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