Database Attributes and Options - Teradata Administrator

Teradata Administrator User Guide
Product
Teradata Administrator
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2502
Product Category
Teradata Tools and Utilities
 

Table 12: Create Database Dialog Box and Modify Database Dialog Box Description 

Field or Control

Description

Database Name

The source database for the create, clone, modify, and drop database functions.

Owner

The user or database name of the parent (owner) of the database to create or modify. The default owner is the user name associated with the current session.

Note: The Owner field cannot be changed when the database is being modified.

Perm Space

The total number of bytes to reserve for permanent disk storage in the new or modified database.

The amount specified in this field is deducted from the available permanent disk storage of the database specified in the Owner field.

Typing the letters K, M or G into this field sets the corresponding option button.

Spool Space

The maximum number of bytes of spool space that can be used by any user created within the new or modified database.

The default value is the same as that of the database owner.

Typing the letters K, M or G into this field sets the corresponding option button.

Temp Space

The maximum number of bytes that can be used by temporary tables created within this database.

The default value is the same as that of the database owner.

Typing the letters K, M or G into this field sets the corresponding option button.

Account

The user account id associated with the new or modified database.

Default Journal

The default table for journal images of tables created in the new or modified database.

By default, the journal table is created in the user space of the new or modified database unless a database and table name is specified.

A default journal table name must be provided if a journal option is specified, but it need not reside within the database space.

Before Journal

Specifies the journaling requirement for “before” change row images as follows:

  • Yes – specifies a single journal.
  • No – specifies no journal.
  • Dual – specifies dual journals.

    • These are actual journaling requirements when specified on the Create Table dialog box, or Default values when specified on the Create Database dialog box.

    After Journal

    Specifies the journaling requirement for “after” change row images:

  • Yes – specifies a single journal on a different AMP from changed row.
  • No – specifies no journal.
  • Dual – specifies dual journals.
  • Local – specifies a single journal on the same AMP as changed row.

    • These are actual journaling requirements when specified on the Create Table dialog box, or Default values when specified on the Create Database dialog box.

    The Local option is only available for non-FallBack tables.

    FallBack

    Specifies that all tables created in this database are created, by default, with fallback protection.

    Comment

    Enter descriptive text.