Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 57 58 59 60 61 62 < 63 > 64 65 66 67 68 69 .. 218 >> Next


3 - 12

Teradata RDBMS Database Administration Chapter 3: Space Considerations

Gaining Space with PACKDISK

Gaining Space with PACKDISK

The PACKDISK command of the Ferret Utility reconfigures the contents of a disk, leaving a percentage of free space for cylinders within a range defined by the SCOPE command. For instructions on running the Ferret Utility and using its associated commands, see Teradata RDBMS Utilities.

Packing and Free Space Percent

PACKDISK packs either the entire disk or a single table, leaving a specified percentage of the object empty to account for subsequent insert and update operations. This is the free space percentage you specify using the tools described in "Setting Free Space Percent Limits" on page 3-5.

Packing applies only to entire logical cylinders, not to the space inside individual data blocks within those cylinders. Data block sizes are the same before and after the PACKDISK operation.

Using SHOWFSP

Use this tool before running PACKDISK to estimate which data tables qualify for packing. SHOWFSP reports all or specified data tables that will reach a Free Space Percentage limit after PACKDISK is run.

This -d option lets you specify the amount of free space you want after packing, which may be different from the current percent for the table. If you do not specify a percent, SHOWFSP uses either the current table-level free space or the value of the FreeSpacePercent field in DBSCONTROLGDO.

Mon Nov 13, 2000 16:26:38 : ShowFsp has been started

On All AMP vprocs

vproc 1 (0001) response

There are 6 tables larger than 0 cylinders on amp 1

Database Table fsp Recoverable Current

Name Name % Cylinders Cylinders

DBC TVFields 65 1 2

SYS_CALENDAR CALDATES 4 5 1 3

1 of 1 vprocs responded with the above tables fitting the criteria ShowFsp has completed

Ferret ==>

Teradata RDBMS Database Administration

3 - 19 Chapter 3: Space Considerations

Increasing Space by Giving Ownership

Increasing Space by Giving Ownership

This section describes how to transfer a database/user to another database/user. By doing this, you increase the permanent space limit of a database/user.

Transferring Ownership

The GIVE statement transfers ownership of the specified database/user, including all the databases/users owned by that database/user. In addition, you transfer the permanent space limits defined for that database/user.

When you give a database/user to another database/user in the hierarchy, only the permanent space limit for that database/user is transferred. The spool and temporary space limits remain the same (even if they are higher than the new immediate owner). All descendents of the given database/user remain descendents of that given database/user.

When you drop a database/user, its permanent space limit is credited to its immediate owner; however, its spool space and temporary space is not credited to its immediate owner (that is, the immediate owner's spool and temporary space allocation remains unchanged).

Caution: GIVE does not transfer access privileges. For performance implications, see "Transferring Privileges" on page 6-16. and the GIVE Statement under "Data Control Language Syntax" in Teradata SQL Reference, Volume 4.

For information on using ownership to change the current hierarchy, see "Removing a Hierarchy Level" on page 1-17.

Transferring Permanent Space

With CREATE, GIVE, and DROP, you can transfer the permanent space limit of one database/user to another. For example, assume the following hierarchy:

3 - 20

Teradata RDBMS Database Administration Chapter 3: Space Considerations

Increasing Space by Giving Ownership

Also, assume that:

F has a MAXPERM of 10, a MAXSPOOL of 50, and a MAXTEMP of 25.

E has a MAXPERM of 10, a MAXSPOOL of 20, and a MAXTEMP of 15.

To increase permanent space for E:

Step Action
1 From space owned by F, create temporary database X with a MAXPERM of 5: CREATE DATABASE X FROM F AS PERM = 5 ; The default is to allocate to a new database the same spool and temp space as its owning database, so MAXSPOOL for X defaults to 50 and MAXTEMP for X defaults to 25. The PERM allocation for X is taken from the space of its owning database; thus, the MAXPERM of F is reduced to 5.
2 Give X to E (use the GIVE statement to transfer ownership).
3 Drop X. This increases the MAXPERM of E to 15. The MAXSPOOL and MAXTEMP of E are unchanged at 20 and 15, respectively.

For more information on transferring ownership, see "Changing the Hierarchy with GIVE" on page 1-17.

3 - 20 Teradata RDBMS Database Administration

Chapter 3: Space Considerations

Increasing Space by Giving Ownership

3 - 20

Teradata RDBMS Database Administration Chapter 4:

Using Data Dictionary Tables and Views

The Teradata RDBMS Data Dictionary (DD), or system catalog, is a complete database composed of tables, views, and macros that reside in system user DBC. This chapter introduces you to the concept of the data dictionary and how to use and maintain it, including topics on:
Previous << 1 .. 57 58 59 60 61 62 < 63 > 64 65 66 67 68 69 .. 218 >> Next