Archives of the TeradataForum

Message Posted: Wed, 23 Oct 2002 @ 14:01:19 GMT

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

<-- Anonymously Posted: Wednesday, October 23, 2002 10:00 -->

It is not necessary to set the PermDBSize global parameter to 128K, you can leave this as the default of 64K, and then set each table independently, using the blocksize variable.

For example

CREATE SET TABLE SampDb.PhoneList
,NO FALLBACK
,NO BEFORE JOURNAL
,NO AFTER JOURNAL
,MAXIMUM BLOCKSIZE
(
Number CHAR(10) TITLE 'Number' NOT NULL
)
UNIQUE PRIMARY INDEX( Number );

Will immediately set the blocksize to the maximum allowed, which under V2R4.1 would be 128K.

You can also set the value within the create statement.

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