Changing the Permanent Space - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
gnf1527114222337.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Before proceeding, connect to a Teradata Database, and perform an export operation. See Connect to a Teradata Database and Export Methods and Options.

Teradata SET uses a formula to automatically calculate the permanent space (also called permspace) required for creating a database. Permanent space calculations are based on the number of objects selected and the space required for creating child databases. However, the amount of space calculated can be more or less than the system can spare. Follow the permanent space messages to correct this situation.

Permanent space requirements can be specified before importing objects from a target system. Change the permanent space allotment to avoid messages about permanent space.

  1. From the Import window, click . The Change PermSpace dialog box appears.


    Existing databases are highlighted in blue. Space cannot be specified for existing databases.

    The only editable box is Scale Factor(KB). The only editable column is User Specified Space(KB).

    Option Description
    Information Information about using the dialog box.
    Warnings For rows shown in bold, warnings about the database or QCD.
    Scale Factor(KB) Integral number used to automatically calculate space required to create the objects in a database. Change Scale Factor(KB) to a number between 1 and 100. The default is 32.

    Scale Factor(KB) has an effect on the value displayed in the Calculated Space(KB) column.

    Databases Space requirements for the databases in the left pane (import tree).
    Query Capture Databases Space requirements for the QCDs in the left pane (import tree).
    Database Name or Query Capture Database Name of the database that will be created during the import operation.
    The column label (Database Name or Query Capture Database) is determined by whether Databases or Query Capture Databases is selected.
    Calculated Space(KB) Space required to create the database, based on the number of objects selected in the left pane (import tree), including the calculated or user-specified space of any child databases.

    The space requirements for each database are based on the number of tables and objects selected in the left pane (import tree) and the space required for creating child databases.

    An approximation of the deficit space, determined by comparing the calculated space and the available space, appears in this column.

    User Specified Space(KB) Calculated space for the new database. If entered, this number overrides the Calculated Space(KB) value. If a discrepancy is found, a warning appears recalculated.

    If specifying space for a child database, it is considered when calculating the space required for the parent database.

    Minimum value is 0 KB. Maximum value is 2,097,151 KB.

    Right-click in this field for more options.

    Space cannot be specified for an existing database.
    Available Space (Existing Databases) MaxPerm-CurrentPerm(KB) Available permanent space for the database if it already exists on the system. Existing databases are highlighted in blue.
    Parent Database Immediate parent database of the database that will be created.
    Available or Required Parent Database Space(KB) If parent database does not exist, the projected space required to create the child databases and any objects within the parent database.

    If parent database exists, the available space (MaxPerm - CurrentPerm) for the parent database.

    Import Parent Database(KB) Owner for the databases created during the import operation. This is specified in the Parent Database box of the Import Options dialog box.
    Space Available(KB) Available space (MaxPerm - CurrentPerm) for the import parent database.
    Space Required(KB) If Databases is selected, the space required to create the databases.

    If Query Capture Databases is selected, the space required to create the QCDs.

    Selecting stored procedures in the left pane (import tree) does not affect the permanent space calculation.
  2. [Optional] If Databases is selected, right-click in the User Specified Space(KB) column and choose a command from the shortcut menu.
    Command Description
    Check user specified space against child database(s) space Determine if the child databases can be accommodated in the user-specified space. Teradata SET displays a warning if space cannot be accommodated.
    Check and update parent database(s) space Determine if the user-specified space for a database can be accommodated by each parent database. If the calculated space for the parent database cannot accommodate the space specified, Teradata SET attempts to update the parent database space. Teradata SET displays a message if either the existing parent or user-specified database space is insufficient.
    Clear user specified space Clear the user-specified space for a database.
  3. [Optional] If Query Capture Databases is selected, right-click in the User Specified Space(KB) column and choose a command from the shortcut menu.
    Command Description
    Check total QCD space against available Parent space Check if there is enough available space in the parent database to accommodate the creation of the QCDs.
    Check user specified space against calculated space for QCD Check the user-specified space against the calculated space for a QCD.
    Clear user specified space for QCD Clear the user-specified space for a QCD.
  4. Click Recalculate to recalculate the space for each parent database.
    The recalculation is based on the amount in the User Specified Space(KB) column, the Calculated Space(KB) column of the child databases, and the current scale factor.
  5. Do one of the following:
    • Click Cancel to ignore changes and close the dialog box.
    • Click OK to accept the changes and close the dialog box.
  6. [Optional] Click to start the import operation.