Thursday 26 December 2013

Getting Started with TeraData Vmware


The first task is to make sure you have a system capable of handling VMware and VM’s. There are plenty of details on the VMware site but here are some basic requirements that you should be aware of before getting started:
  1. Since the SLES10 VM’s are 64-bit, your CPU must support 64-bit operation.
  2. Your CPU must also support Virtualization. Generally there is a BIOS setting which enables this. Google the topic for your particular CPU for more information but most recent PC’s support both 64-bit and Virtualization.
  3. After extracting VM, import the VM in VMplayer and Start it.
  4. Login into the SLES10 VM with username root and password root.
  5. Enter a cop entry in the linux hosts file (/etc/hosts accessible from the linux command line in the VMware console, ie. c:>vi /etc/hosts)
  6. Should be something like "192.168.186.128 hyperjcop1 dbccop1"
  7. Use "/sbin/ifconfig" command on linux vm to find the ipaddress
  8. Teradata is ready to come up (/etc/init.d/tpa start)
    a. The pdisks are defined, sysinit is complete, config has been run and the dip scripts are complete.
  9. Test with bteq (bteq is the standard Teradata command line query tool, it can be invoked from the Linux command line in the VMware console, ie. c:>bteq)
  10. bteq (commands)
    a. .logon dbc/dbc
    b. dbc
    c. select * from dbcinfo;
    d. quit;