Setting Data Block Sizes Using the DBS Control Utility - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

You can set data block sizes globally using these DBSControl fields: PermDBAllocUnit, PermDBSize, and JournalDBSize. These fields determine the maximum size of permanent data blocks that hold multiple rows. (A row that exceeds the size of a multirow data block is put into a block of its own.)

Example of Changing PermDBSize

To change the PermDBSize, you need to use the modify and write commands of the DBS Control utility. The following example changes the data block size to 254 sectors:

  1. From the command-line prompt (or the Supervisor window of the Database Window):
    dbscontrol
  2. From the DBS Control window:
    display FILESYS
  3. Use the modify command to change flag 3 (PermDBSize):
    modify FILESYS 3 = 254
  4. Write the changes to the GDO:
    write