All Forums General
spkother 18 posts Joined 07/13
21 May 2014
Space Allocation

Hi,
   Can any one explain how space will be allocated for PERM,SPOOL,TEMP space with example in teradata.
  
Thanks,
Sravanthi

Raja_KT 1246 posts Joined 07/09
22 May 2014

some examples;

CREATE DATABASE abc

   FROM def

AS

   PERM = 123456789

   SPOOL = 123456789

   FALLBACK

   ACCOUNT= 'xyz'

   NO AFTER JOURNAL

   DUAL BEFORE JOURNAL

   DEFAULT JOURNAL TABLE = abc.journals;

 

CREATE USER user2 FROM user1

       AS PASSWORD=mmmmmmm

       PERM=123456789

       SPOOL=0 /*123456789 */

       TEMPORARY=0

       ACCOUNT=''

There are lots of parameters  to arrive at allocation. I suggest you read these two since they are related. I am also reading , they are huge :) 
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1094_111A/ch15.056.01.html
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1094_111A/ch14.055.001.html

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.