Creating new DB without TD Admin / DB Manager (Windows client)

Teradata Express Software
Formerly this board name was Cloud Computing. The name was changed to better represent the product areas covered.

Creating new DB without TD Admin / DB Manager (Windows client)

Hi All,

I have the 1TB version of TD13 running on a MacBook VMWare Fusion workstation and everything is working / starting fine. Being a newbie to the native TD toolset,
how do I create new DBs and assign space without the graphical UI like TD Admin (on Windows). As I'm in the MAC OS X as VM host I do not have access to any windows
client. I understood that I should be able to do this using BTEQ, alone the whole library doesn't reference any termin / native BTEQ syntax.

I want to set-up a DBC child named GIP2SIT with three children underneath the same labeled GIP2SIT_STG, GIP2SIT_DWH, GIP2SIT_DMT and then assign space from DBC accordingly.

Thanks for your help
Rgds
-Tom
1 REPLY
Enthusiast

Re: Creating new DB without TD Admin / DB Manager (Windows client)

Look up the CREATE USER and CREATE DATABASE statements in the Teradata SQL reference manual.