17.20 - Creating the Spool Space Reserve - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572

You should create a spool space reserve from the space available to user DBC, to ensure that there is adequate space to run queries.

System-wide use of spool can exceed the spool reserve, if necessary, as long as there is other uncommitted DBC perm space.

The following procedure sets the spool space reserve at 20% of total available DBC space. You can adjust the spool space reserve later, depending on the number of simultaneous queries and the tables sizes in the database.

  1. Determine the perm space owned by user DBC, for example:
    SELECT SUM(MAXPERM) FROM DBC.DISKSPACE WHERE DataBaseName = 'dbc';
  2. Calculate a value in bytes equal to 20% of the DBC space (the value obtained in step 1) to set aside as spool space reserve, for example:

    (6347.75 GB) *(.20) = 1269.55 GB

  3. Create the Spool Reserve database and allocate perm space according the figure you calculated, for example:
    CREATE DATABASE Spool_Reserve FROM DBC
    AS PERM = 1269.55 GB
    NO FALLBACK
    NO BEFORE JOURNAL
    NO AFTER JOURNAL ;
    Specifying spool space in a CREATE USER or CREATE PROFILE statement defines the portion of the overall available spool that is available to users or profile members.

    For information on peak spool space utilization (Peak Spool), see Teradata Vantage™ - Data Dictionary, B035-1092.