Teradata Express for Windows - where are database files?

Database
Fan

Teradata Express for Windows - where are database files?

Sorry if this is not the right forum.

I am a complete newbie to Teradata. I installed Teradata Express on Windows 7 and I was wondering what filetypes Teradata Express databases are stored in? For example, SQL Server Express uses MDF and LDF files. What does Teradata Express use?  Thanks.

Tags (2)
4 REPLIES
Enthusiast

Re: Teradata Express for Windows - where are database files?

Teradata is not a file based database engine. It will not create any such files specific to any database. TD have its own internal file system that supports shared nothing architecture. Please refer to Teradata fundamentals to understand more on the architecture. FYI.

Enthusiast

Re: Teradata Express for Windows - where are database files?

Teradata Express for Windows is a special case.  It has a modified file system that is built inside regular Windows files.  I don't know what the files are named, but there will be exactly two of them--one for each AMP.  All other Teradata systems use raw partitions or dedicated devices.

Fan

Re: Teradata Express for Windows - where are database files?

Thanks. I know that "real" Teradata is different. I was specifically referring to Teradata Express.

Fan

Re: Teradata Express for Windows - where are database files?

Turns out that they are stored in files with names like:

Amp?-Pdisk0 (no extension), and

pdesegments?.dat

e.g.,

Amp0-Pdisk0

pdesegments0.dat

I don't know if there is any system to it.