Comments for TeraData Tech

Comment on Teradata Space Management by Newbie01

Newbie01 — Sun, 20 May 2012 06:59:04 +0000

1 Question to Admin:

There are 3 users created under database which has PERM space 50 GB. Each user is allocated 5 GB PERM space & 20 GB Spool space.

Now, the PERM Space left in database- 35 GB.

I’ve created the another user for whom i allocated 20 GB PERM space.

Now, the PERM Space left in database- 15 GB ==> UNUSED space.

Even though i allocated 20 GB spool space to each user, if i submit a sql query which takes more than 15 GB should be aborted since the unused space is only 15 GB ?? Am i missing out some thing here?

Comment on Secondary Index in Teradata by admin

admin — Thu, 17 May 2012 15:56:59 +0000

Hi Readers,

I’ll highly appreciate if you leave your feedback as comments after reading this post

Thanks
Nitin

Comment on Teradata 12 Basics Certification (TEO-121) – Sample paper 1 by ravisankar

ravisankar — Thu, 17 May 2012 08:55:12 +0000

hi,

Am fresher 5 months exp in teradata. Am planing to write certification on teradata.

Please help me in suggesting the books passing teo-121 basic.

Thank U Advance
ravi sankar.

Comment on Teradata Tutorial by admin

admin — Thu, 17 May 2012 06:28:15 +0000

http://www.teradatatech.com/?p=815

Comment on Secondary Index in Teradata by Secondary Index in Teradata » TeraData Tech » BlinkMoth Software Industries | BlinkMoth Software Industries

Wed, 16 May 2012 19:59:29 +0000

[...] Teradata Blog Post From Teradata – Google Blog Search: Teradata runs extremely well without secondary indexes, but since secondary indexes use up space [...]

Comment on Limitations of FAST LOAD by admin

admin — Mon, 14 May 2012 09:10:06 +0000

if somehow fastload fails and our table has been locked by that session -
RDBMS error 2652: Operation not allowed: _db_._table_ is being Loaded.

then there is 1 possible things which we can do to release fastload lock without dropping the actual table
Run the dummy fastload script which contains only begin loading and end loading. e.g.
logon serverid/username,password;
begin loading ……. ;
end loading;
logoff;

Comment on Teradata Architecture by venu

venu — Mon, 14 May 2012 07:30:20 +0000

It’s very detailed and easily understandable for beginners

Comment on Limitations of FAST LOAD by KrisV

KrisV — Sun, 13 May 2012 20:50:04 +0000

How to release a fastload lock on a table without the table being dropped and recreated.

Comment on Limitations of FAST LOAD by KrisV

KrisV — Sun, 13 May 2012 20:49:14 +0000

How to release a fastload lock on a table without the table being dropped and recreated?

Comment on Join Indexes by Anith Babu

Anith Babu — Sun, 13 May 2012 17:24:00 +0000

Thats a good and simple explanation!!!
Thanks a lot