MODIFY - Teradata Database

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.