15.00 - MODIFY - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

MODIFY

Purpose  

Modifies the value of the writable DBS Control Record fields.

Syntax  

 

Syntax Element

Description

GroupName

Indicates which of the following groups the MODIFY command is directed towards:

  • GENERAL (for general fields)
  • FILESYS (for file system fields)
  • PERFORMANCE (for performance fields)
  • CHECKSUM (for checksum fields)
  • COMPRESSION (for block-level compression fields)
  • STORAGE
  • You can type the first one or two characters of each GroupName rather than the entire name.

    field#=value

    Specifies the new value of the specified field.

    Note: Use the DISPLAY GroupName command to return the field numbers for a particular group.

    In most cases, this is a decimal value. For Boolean fields, use TRUE or T and FALSE or F. All values are checked against the valid range of values of the respective field.

    Usage Notes  

    If you omit the options, DBS Control explicitly prompts for the group name, field number, and the new value of the field.

    Note: Use of the MODIFY command alone does not affect the current system GDO. The MODIFY command indicates when any changes made will become effective, either after the next Teradata Database restart or after the DBS Control Record has been written.

    Example  

    The following example shows how to modify the Deadlock Timeout field:

    Enter a command, HELP, or QUIT:
    MODIFY GENERAL 3 = 600
     
    The DeadlockTimeout field has been modified from 240 to 600.
     
    NOTE: This change will become effective after the next DBS restart.