Teradata Corporation is pleased to announce the availability of new Teradata Express versions based on our recently released version 14.0 of the Teradata database. The Teradata Express program is a freely licensed virtual instance of the Teradata database. It is fully functional for evaluation, test and development purposes.

1. What does Teradata Express 14.0 for VMware include?

Teradata Express14.0 for VMware includes the following:

  • Teradata Database 14.00.00.01
  • Teradata Tools and Utilities 14.0
  • Teradata Viewpoint 14.0 (installed, but inactive by default)
  • Teradata Studio Express

There are 3 different images available that have different database sizes (4 GB, 40GB, and 1 TB). The images are 64 bit SUSE Linux 10 SP 3. They are configured as a 2 AMP SMP. The username and password are root/ root.

2. What are the differences between Teradata Express 14.0 for VMware and Teradata Database 14.0?

  • Teradata Express 14.0 for VMware is restricted to the 3 different database sizes whereas the production Teradata 14.0 can scale as large as you like. The VM defaults to 1 GB memory.
  • All features are enabled, including Columnar Partitioning, Row Level Security, Temporal, etc. 
  • Learn about all of the new Teradata 14.0 features via Teradata Education Network training.
  • There is no upgrade path from previous versions of Teradata Express as is found with Teradata Database. Each new Teradata Express you download is a fresh instance of the database.
  • Teradata Express 14.0 for VMware uses underlying host system files for the database storage instead of raw disk partitions.

3. What are the hardware requirements for Teradata Express 14.0 for VMware?

Teradata Express 14.0 for VMware is a Linux version of the Teradata Database and may be hosted on a number of 64-bit platforms including Linux and Windows. Minimum system requirements: x64 CPU, 2 GB memory.

  • The images require the following free space for installation:
    • 4GB requires 13GB disk space
    • 40GB requires 18GB disk space
    • 1TB requires 35GB disk space
       
  • To run the Viewpoint tool the following Memory sizes must be allocated to VMware.
    • 4GB requires 2.0GB Memory
    • 40GB requires 2.5GB Memory
    • 1 TB requires 4.0GB Memory

The VMware® web site provides a Processor Check for 64-Bit Compatibility tool. This can be used to verify that the system is 64 bit. You can download the tool here.

There is also a BIOS setting to enable virtualization. Instructions to turn on hardware virtualization in a PC BIOS are specific to OEM models. It is important that after changing the BIOS settings the PC is completely shut down at the power switch before restarting so that the new BIOS settings can take place.

4. What are the software requirements for Teradata Express 14.0 for VMware?

Minimum 64-Bit system requirements:

  • Microsoft Windows (XP, 7, Vista)
  • Linux
  • Mac OS X. Must use VMware Fusion from VMware. (Not free)

VMware Software:

  • VMware Player on Windows or Linux hosts
  • VMware Workstation on Linux or Windows hosts
  • VMware Fusion on Mac OS X
  • VMware Workstation and VMware Fusion are licensed products. VMware Player can be freely downloaded here

5. What other software do I need?

  • The VMware image was compressed using 7-zip, which can be downloaded for various platforms here.
    • For Mac OS X, we recommend using the Keka tool to unzip. 

6. How do I get Teradata Express 14.0 for VMware?

Visit the Teradata Express for VMware download page.

Please note that Teradata Express for VMware is not an officially supported product. However, for unofficial community support, please visit the Database or Cloud Computing forums.

Discussion
graebige 3 comments Joined 10/11
20 Jun 2012

there is no 1TB Version on the download page?

Cliff L 27 comments Joined 04/12
21 Jun 2012

Not yet. We're finalizing the 4GB and the 1TB versions and will be doing a refresh of the 40GB in a couple of days.

graebige 3 comments Joined 10/11
21 Jun 2012

thanks for the update

superjuanito88 1 comment Joined 05/12
26 Jun 2012

no existe un VMWARE a 32 bits para trabajar.

graebige 3 comments Joined 10/11
01 Jul 2012

now i get an error when trying to unzip the files - on 2 different boxes?

Cliff L 27 comments Joined 04/12
02 Jul 2012

Are you using 7-zip from:

http://www.7-zip.org/

WinZip and others will not work.

BruceHohman 2 comments Joined 07/09
03 Jul 2012

When will the Teradata Express 14.0 Tool and Utilities for Windows be available?

padhia 11 comments Joined 06/10
18 Jul 2012

Can the images be made to work with VirtualBox? Free version of VB has features that are not available unless one upgrades to paid version of VMWare Workstation.

Cliff L 27 comments Joined 04/12
18 Jul 2012

The images will run with VirtualBox. However, some configuration work will need to be done such as mapping the disks to the appropriate controllers.

padhia 11 comments Joined 06/10
25 Jul 2012

For anyone trying to run this image using VBox, I was able to run the image after I uninstalled VMWare tools and installed VBox guest additions in its place.

bdgeise 1 comment Joined 01/12
29 Aug 2012

How does patching work with Suse Linux Enterprise Server if someone needs to patch the server? Does the subscription fall under the agreement Teradata has with Suse or is the individual required to purchase this separately?

Cliff L 27 comments Joined 04/12
29 Aug 2012

These free images are for evaluation only. They are not intended to be patched or updated by users. We will periodically release updated images if necessary.

pakunuru 1 comment Joined 08/12
13 Sep 2012

Hi Guys,

Did anyone try to get this working with Virtual Box on MAC? If so can anyone suggest me how to go about it?

Alex543 2 comments Joined 07/12
01 Oct 2012

Here are short instructions for VirtualBox:
1) Create VM, attach lsilogic scsi controller, attach disks to it in the following order:
scsi0:0.fileName = "Disk sda.vmdk"
scsi0:1.fileName = "Disk sdb.vmdk"
scsi0:2.fileName = "Disk sdc.vmdk"
scsi0:3.fileName = "Disk sdd.vmdk"
scsi0:4.fileName = "Amp0-Pdisk0.
scsi0:5.fileName = "Amp1-Pdisk0.vmdk"
scsi0:6.fileName = "LS10_TD1310_01_4GB.vmdk"
2) Boot it, choose FailSafe mode;
3) Uninstall vmware-tools with vmware-tools-uninstall.pl, reboot, boot to normal mode;
4) Run YAST, remove VMware network adapter in Network Card config.
5) If you want to connect to it from host OS (with Teradata Studio or SQLA) - in VirtualBox attach to VM host-only adapter.
Done.

jb999999 4 comments Joined 09/10
03 Oct 2012

I fully appreciate that the VMWare images are SuSE Linux. But we have a requirement to run Teradata Express on Red hat / Cent OS for some testing. Cliff L do you know if this is technically possible? Obviously we'd have to engage properly with Teradata to take this further forward.

Cliff L 27 comments Joined 04/12
03 Oct 2012

Inside the image is Suse Linux, but TD Express as a package runs on top of VMware Player. There are VMware Player images for Linux here:

https://my.vmware.com/web/vmware/free#desktop_end_user_computing/vmware_player/5_0

If you are asking if Teradata can run on top of Red Hat / Cent o/s, then the answer is no.

sg186048 4 comments Joined 09/12
09 Oct 2012

Hi,

I am using the software from 7ZIP.org and still getting problems unzipping it. The error goes something like "cannot open /filename.7z as archive" , I have downloaded both the 4GB and 40GB version atleast 3 times and it still gives me the same issue. Please assist on this asap.

Thanks'

gm186004 1 comment Joined 11/11
26 Oct 2012

I am trying to use the viewpoint using firefox. I am getting an error
Unable to connect

Firefox can't establish a connection to the server at localhost.

* The site could be temporarily unavailable or too busy. Try again in a few
moments.

* If you are unable to load any pages, check your computer's network
connection.

* If your computer or network is protected by a firewall or proxy, make sure
that Firefox is permitted to access the Web.

gryback 132 comments Joined 12/08
27 Oct 2012

Can you ping the IP address? Does a different browser work (like IE)?

grommel 2 comments Joined 09/09
05 Nov 2012

I have installed the 40GB image of TD Express 14.0 for VMware , using VMware Player 5.0.0 build-812388. It has 2.5GB memory, as recommended. The database is running, but many operations are painfully slow. For instance, from the time I enter "bteq" at the command line to the time bteq comes back with "Teradata BTEQ for Linux...Enter your logon or BTEQ command" is 20 seconds! TD Studio Express takes 1 min 35 sec to start and is very slow thereafter as well. Surely this can't be normal?...

BruceHohman 2 comments Joined 07/09
06 Nov 2012

I tried the 40gb version on a laptop with 4gb of memory and had the same issue. There was a lot of memory paging going on. I switched to the 4gb version and everything works ok. It requires 2gb of memory vs 2.5 for the 40gb version, if I remember right it's due to the Viewpoint requirements in the image.

The 40gb version works ok on another laptop I have with 8gb of memory.

grommel 2 comments Joined 09/09
06 Nov 2012

I think you're right, Bruce. The 4GB version seems fine. (My laptop has 6GB of RAM.)

Cliff L 27 comments Joined 04/12
06 Nov 2012

If you are not using Viewpoint, try turning it off from the desktop icon in the VM. The Viewpoint services take a lot of resources.

chtshop 1 comment Joined 12/12
17 Dec 2012

I'm running the 40gb version on a 16gb laptop with a SSD drive. It's extremely slow like others reported. Strangely, there's very little CPU and disk activity, so I don't see any bottlenecks.

Cliff L 27 comments Joined 04/12
17 Dec 2012

Don't know if this will work or not. Try increasing the virtual RAM to 4 GB in the Virtual Machine Settings for VMware Player. Let us know if that helps.

Cliff L 27 comments Joined 04/12
17 Dec 2012

Also, since you have enough physical resources in the laptop, you could try the 1 TB version. It has bigger RAM.

cyberbond 1 comment Joined 07/12
09 Jan 2013

I am running 4 GB linux version on windows 7. Now I want to connect Sql assistant which is installed on windows 7 to teradata. Can anyone help me on that?

vnaicker 1 comment Joined 01/13
08 Mar 2013

I installed TD Express 14 for VM Player. But there are no databases. Not even DBC visible in Studio. All that I have on the desktiop is Teradata Tools, Start/Stop Viewpoint, Teradata Studio.
Thanks.
Venky

imeanit 1 comment Joined 11/06
15 Apr 2013

I had the same issue with 1TB.
 
I tried to modify the Network Card and add the hostname and domain name, it seems to resolve the issue. Give it a try.
 
Cheers!

03 May 2013

Hi
 i tried to connect viewpoint it's nt working
i used this command to open the viewpoint "firefox &" i am getting an error
TDExpress14.0_Sles10:~ # firefox &
[1] 8131
TDExpress14.0_Sles10:~ # ALSA lib confmisc.c:672:(snd_func_card_driver) cannot find card '0'
ALSA lib conf.c:3492:(_snd_config_evaluate) function snd_func_card_driver returned error: No such device
ALSA lib confmisc.c:392:(snd_func_concat) error evaluating strings
ALSA lib conf.c:3492:(_snd_config_evaluate) function snd_func_concat returned error: No such device
ALSA lib confmisc.c:1072:(snd_func_refer) error evaluating name
ALSA lib conf.c:3492:(_snd_config_evaluate) function snd_func_refer returned error: No such device
ALSA lib conf.c:3961:(snd_config_expand) Evaluate error: No such device
ALSA lib pcm.c:2111:(snd_pcm_open_noupdate) Unknown PCM default
 
--->i am getting above error forefox is opened but is not going to viepoint home page..please help me out...

hi

Cliff L 27 comments Joined 04/12
03 May 2013

The error you list is linux looking for a sound card. This error started happening to me and I have no idea why it started.
Try shutting down firefox and starting viewpoint services and try again.
To start Viewpoint services, go to the linux prompt and run the following command.
/etc/init.d/viewpoint start
Let me know what happens.

pomazen 1 comment Joined 05/13
14 May 2013

I would like to use this TD Express to set up a box in our labs in order to run automated tests of our software against Teradata. Unfortunately, I'm not sure about the licence agreement of this version, particularly about the grant during 90 days only. Please note that I absolutely have no need to keep the data indefintely as they will be recreated from scratch regularly (even a re-initialization of the VM is fine with my needs).
Can anyone clarify the licence agreement in my case since I'm not evaluating the software but using it for tests purpose?

Cliff L 27 comments Joined 04/12
14 May 2013

You will need to download another copy to initiate another 90 day period.

dyilma 2 comments Joined 06/13
17 Jun 2013

Hello,
 
 I downloaded TD express for windows and not able to find the default windows 2008 administrator password. Anywone has any idea

Cliff L 27 comments Joined 04/12
18 Jun 2013

We no longer offer TD Express for Windows. All are VMware Player. Are you referring to TD Tools and Utilities?
Otherwise, the root login and password is root/root.

dyilma 2 comments Joined 06/13
18 Jun 2013

Thank you for your reply. I am refering to TD Express in windows 2008 vm . After I installed the TD Express, and vm player the windows 2008 user is Administrator but not able to log in. I tried many combinations, blan, password, admin etc.
 
   Thank You 

bmkumar 2 comments Joined 11/06
20 Jun 2013

Hi All,
 
Currently i have TD 12 Express VMware Edition. I'm planning to replace that with TD 14 Express VMWare Edition.
For TD 12 and 13, the license is free for life time for Testing activities. Do we have the same for TD14 also? Is the License is need to renewed within the certain time frame?
Please share the validity info for TD 14 Express Edition on Vmware.
 
Thanks,
Mohan

Thanks & Regards, B Mohan Kumar Teradata Certified Master

Cliff L 27 comments Joined 04/12
20 Jun 2013

The license term is 90 days. Download another image to reset the 90 day clock.

bmkumar 2 comments Joined 11/06
20 Jun 2013

Thanks Cliff.
Is there any new version is expected to install to Windows 8.
Beacuse i have the windows 8 version, shall i able to install to Windows 8 OS?
Thanks,

Thanks & Regards, B Mohan Kumar Teradata Certified Master

MarkMarsh 5 comments Joined 03/10
18 Jul 2013

When can we expect a 14.10 VM?
Thanks,
Mark

Cliff L 27 comments Joined 04/12
18 Jul 2013

Our goal is GCA + 60 days for the VM images. GCA for 14.10 was 6/30, so expect images before 9/1. We are currently in a build and test cycle.

priyankaduggal 1 comment Joined 07/13
05 Aug 2013

Hi
 
i am new to Teradata and have been assigned a POC for Teradata. While installing teradata on VM, I am facing some issues:-
 
1).Followed http://developer.teradata.com/database/articles/introduction-to-teradata-express-for-vmware-player
2). Followed http://developer.teradata.com/database/articles/teradata-express-14-0-for-vmware-user-guide but I am unable to launch Viewpoint. Is Viewpoint necesary?
3). I try to connect to Teradata express but get teh following error:-
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.00.00.01] [Error 1000] [SQLState 08S01] Login failure for Connection to testDB Mon Aug 05 00:51:48 EDT 2013 socket orig=testDB cid=1997c457 sess=0 java.net.UnknownHostException: testDB  at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)  at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)  at java.net.InetAddress.getAddressFromNameService(Unknown Source)  at java.net.InetAddress.getAllByName0(Unknown Source)  at java.net.InetAddress.getAllByName(Unknown Source)  at java.net.InetAddress.getAllByName(Unknown Source)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:182)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116)  at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:579)  at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:94)  at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:208)  at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)  at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)  at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130)  at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120)  at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220)  at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153)  at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277)  at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121)  at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)  at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)  at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)  at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)  at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)  at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360)  at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)  at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)  at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
                at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)
                at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)
                at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:206)
                at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:61)
                at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:137)
                at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116)
                at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:579)
                at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:94)
                at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:208)
                at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)
                at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)
                at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130)
                at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120)
                at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220)
                at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153)
                at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277)
                at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121)
                at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
                at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
                at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)
                at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)
                at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
                at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360)
                at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
                at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
                at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: java.net.UnknownHostException: testDB
                at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
                at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)
                at java.net.InetAddress.getAddressFromNameService(Unknown Source)
                at java.net.InetAddress.getAllByName0(Unknown Source)
                at java.net.InetAddress.getAllByName(Unknown Source)
                at java.net.InetAddress.getAllByName(Unknown Source)
                at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:182)
                at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281)
                at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130)
                ... 21 more
 
 
 
Can you please help me ASAP?
 
 

Cliff L 27 comments Joined 04/12
05 Aug 2013

Hi,
No need to run Viewpoint to use the database. If you do need to then the recommendation is to use a machine with at least 8GB of physical RAM and use the 1TB image.
Are you trying to connect from outside the host where the VM is running? If yes, you need to set up the network connectivity. The VM starts up with a local IP address.
Cliff

scootjam 2 comments Joined 08/13
06 Aug 2013

Just installed TD Express, but I get connection issues.  Here is the message I'm getting.  I have rebooted the entire VM with no luck.
 

TDExpress14.0.3_Sles10:~ # bteq

 

 Teradata BTEQ 14.00.00.05 for LINUX.

 Copyright 1984-2012, Teradata Corporation. ALL RIGHTS RESERVED.

 Enter your logon or BTEQ command:

.logon 127.0.0.1/dbc

 

.logon 127.0.0.1/dbc

Password:

 

 *** Warning: RDBMS CRASHED OR SESSIONS RESET.  RECOVERY IN PROGRESS.

 

"bteq" gets stuck on this and will not proceed beyond the RDBMS CRASHED message.

 

Any help is deeply appreciated.

 

Thanks,

    Jesse

Cliff L 27 comments Joined 04/12
06 Aug 2013

Hi Jesse,
Which image are you using? 4GB, 40GB or 1TB?
The database is stopped. To restart it
/etc/init.d/tpa start
Let me know.
Cliff

scootjam 2 comments Joined 08/13
06 Aug 2013

Cliff,
 
Regarding the "Warning: RDBMS CRASHED OR SESSIONS RESET.  RECOVERY IN PROGRESS.".  There does appear to be some activity on the system.
 

 

07:12:44 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle

07:12:45 PM     all     16.00      0.00     34.00      0.00      0.00     50.00

07:12:46 PM     all     11.50      0.00     38.50      0.00      0.00     50.00

07:12:47 PM     all     13.00      0.00     37.00      0.00      0.00     50.00

07:12:48 PM     all     12.00      0.00     38.00      0.00      0.00     50.00

07:12:49 PM     all     10.89      0.00     39.60      0.00      0.00     49.50

07:12:50 PM     all     11.11      0.00     38.89      0.00      0.00     50.00

07:12:51 PM     all     14.78      0.00     35.96      0.49      0.00     48.77

07:12:52 PM     all     13.00      0.00     37.00      0.00      0.00     50.00

 

The system is dedicated to my use and should more or less idle since I'm the only one logged in.  When I check the process listing to see who is consuming the time, the only process that is changing time significantly from interval to inteveral is "bteq".  Appears for whatever reason the database is doing some type of recovery work.

 

TDExpress14.0.3_Sles10:~ # ps -e | grep bteq

 7219 pts/0    00:17:18 bteq

TDExpress14.0.3_Sles10:~ # ps -e | grep bteq

 7219 pts/0    00:25:08 bteq

TDExpress14.0.3_Sles10:~ #

 

Maybe I should consider deleting the TD VM from my VM library and attempt to create a fresh one.

 

Thanks,

    Jesse

 

 

rparman 1 comment Joined 07/13
16 Aug 2013

There are VMWare versions of Teradata Express 12.0, 13.0 and 13.10 still listed on the Teradata Express page.  Are these "lifetime" licenses as opposed to 14.0 which is a 90 day license

Albi 1 comment Joined 08/11
28 Aug 2013

Hello,
I have exact same issue as scootjam.
TD14_0.0.3  (4GB) version is crashing when bteq logon commands are issued.
I get a message:#PdeMain NOT started, PANIC-LOOP-DETECTED. Please delete file /var/opt/teradata/tdtemp/PanicLoopDetected
I couldn't located this folder.
Can anyone advice how to solve this issue?
Many thanks!

Cliff L 27 comments Joined 04/12
28 Aug 2013

Delete the PacicLoopDetected file in the /var/opt/teradata/tdtemp directory.
Then restart the database with /etc/init.d/tpa start

haribabutd12 1 comment Joined 09/13
04 Oct 2013

I am trying to use the viewpoint using firefox. I am getting an error
Unable to connect
Firefox can't establish a connection to the server at localhost.
* The site could be temporarily unavailable or too busy. Try again in a few
moments.
* If you are unable to load any pages, check your computer's network
connection.
* If your computer or network is protected by a firewall or proxy, make sure
that Firefox is permitted to access the Web.

 

himan20m 1 comment Joined 09/13
06 Oct 2013

Hi Cliff,
Currently I am working for a service based vendor organization.
We are planning to have TeraData 14 VMware edition as our test and Dev environments for one of our clients. Could you please help me to highlight the drawbacks or limitations while using this edition in real time.
Thanks in Advance
H

sarang_rk 6 comments Joined 04/13
12 Oct 2013

Hi,
I am from mainframes background, so bit alien to installation. I have successfully installed VMware player and Teradata express. But whenever I start studio express from VMware, it asks me to establish connection. For which it asks me DSN and User and Password. What values should I give so that I can see the tables and start practicing queries on it. 

Cliff L 27 comments Joined 04/12
14 Oct 2013

You should use 127.0.0.1
User is dbc
Password is dbc
 

Cliff L 27 comments Joined 04/12
14 Oct 2013

Limitations of TD Express on VMware Player are pretty much limited to the inability to patch to the latest Teradata patch level and performance. They are all 2 AMP/2 Disk configurations and will be slowed down by running on VMware Player and whatever limitations the compter you are using has. Otherwise, it performs like a real Teradata system.

sarang_rk 6 comments Joined 04/13
15 Oct 2013

Hi,
Thanks for replying, got it connected, working fine. I am able to use Teradata Studio Express with Teradata Express. One more question, where can I find other utilities for Teradata like SQL Assitant, TPT, Multiload and fastload so that I can use with Teradat Express.
Thanks in advance
Sarang_rk

Cliff L 27 comments Joined 04/12
15 Oct 2013

A set of TTU tools can be found here:
http://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package
Check the download page for others.
 

bo 1 comment Joined 02/11
16 Oct 2013

Hi
I got the same "Unable to connect" error as what haribabutd got a week ago. My VMware image is TDExpress14.0.3_Sles10 4GB. 
 

I have tried the following in Firefox. 127.0.0.1 and localhost are mapped in my hosts file.

http://localhost

http://127.0.01

http:/localhost/c

 

I also pinged 127.0.01 which shows

TDExpress14.0.3_Sles10:/opt/teradata/viewpoint/bin # ping 127.0.0.1

PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data.

64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.083 ms

64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.037 ms

 

After clicking on the icon "Start Viewpoint" all the services started.

enabling viewpoint services at boot

Starting PostgreSQL                                                  done

starting viewpoint services

Starting Teradata ActiveMQ                                            done

Starting Teradata Alert Service                                       done

Starting TMSMonitor                                                   done

Starting DCS                                                          done

Starting Viewpoint                                                    done

viewpoint services started

 

The VMware image only provides Firefox browser and I don't have IE to try.

 

Can anyone help? Much appreciated!

 

Bo

 

dcline 1 comment Joined 11/13
12 Nov 2013

Hi Cliff,
Any word on when a 14.10 image will be available?  Also, do most people run VMware or the Eclipse plug-in?  thx 

smazingo 16 comments Joined 04/09
12 Nov 2013

it's there. you need to be logged in to see it (for some reason):
 

TDE 14.10.00.02 SLES 11 for VMware (40GB)

Version:

14.10.00.02

Released:

09 Sep 2013

OS:

Linux VMware x86 64-bit

Teradata:

14.10

 

 TDExpress14.10.00.02_Sles11_40GB.7z

TDE 14.10.00.02 SLES 10 with Viewpoint for VMware (1TB)

Version:

14.10.00.02

Released:

11 Sep 2013

OS:

Linux VMware x86 64-bit

Teradata:

14.10

 TDExpress14.10_Sles10_1TB_VP_30cache.7z

 

philos188 2 comments Joined 11/13
14 Nov 2013

Hi Cliff,
 
I am attempting to run a query from the SQL Assistant and the moment I hit the RUN button I am being prompted to provide the DSN name. Below it states the following:
Select the file data source that describes the driver that you wish to connect to. You can use any file data source that refers to an ODBC driver which is installed on your machine.
What is the name of this DSN file and where can I find it?
Thank you in advance.
M
 

smazingo 16 comments Joined 04/09
14 Nov 2013

assuming you are running sql assistant on your host windows machine, you need to set up a connection in sql assistant. go to tools, define odbc source to define it, add, teradata. enter a name of your choice, and then the ip address for your virtual machine. go back the teradata prompt and enter the following:
ipconfig
 
and look for the inet address. enter this in the sql assistant "teradata server info box. enter dbc for user name and password and hit ok.

philos188 2 comments Joined 11/13
16 Nov 2013

Thank you smazingo for your help. My knowledge of Teradata is very limited and I am having difficulty understanding some of your instructions. Can you please respond to the questions below.
 
1) What’s the IP address of the virtual machine? Is it 192.168.47.128?
2) Where can I find the ‘Teradata prompt’ you are referring to? How do I get there?
3) Where I am supposed to be looking for the ‘inet address’? Is it supposed to be on my C drive? Which folder?
 
The more detailed information you would be able to provide the better.
 
Thank you in advance.
M

td_bharat1 1 comment Joined 11/13
07 Dec 2013

Hi, I need to install teradata in my personal laptop which is Windows 8 64 Bit and want to use all features of Teradata like SQL assistant, Fast Load, Multi Load etc.. any there any sequence of software i need to install like first install TTU and then TD express.. please guide as I am new teradata..  but again main requirement is to install TD in laptop Window 8 64 BIT.... Any help is appreciated.

smazingo 16 comments Joined 04/09
09 Dec 2013

responding to philos188 and the question about the teradata prompt... assuming you are seeing a blue screen with a couple of icons, you need to look down on the line at the bottom and see if there is a window to click on to open (terminal) and the teradata prompt should be there. let me know if this helps. sorry about the delay. 

smazingo 16 comments Joined 04/09
09 Dec 2013

to td_bhart1, first off we haven't tested window 8 at this point. aside from that, the windows ttu download package runs natively in windows and can be installed at any time. The teradata express version of the teradata database runs using vmware player that is hosted on the windows system. so you'd need to download and install vmware player for windows and install that on the windows system and then instantiate teradata express from within player.

DarcyVoorhees 5 comments Joined 12/13
10 Dec 2013

I'm trying to get Express to load on my Mac laptop, but the VM stuff is not quite clear here. I've downloaded VM Fusion and it gives me a plethera of options to install on my laptop.  I can do Windows partitions, Mac partions, Linux partitions, etc.  However, I don't see anywhere on these forums what exactly is required for that VM partition, so that I can run Teradata Express.  Perhaps I'm just reading the posts incorrectly, but could you help me understand the VM Fusion requirements, so that I can load Teradata?  Do you want that partition to be OS X, Windows, other?
Thanks.

dnoeth 69 comments Joined 11/04
10 Dec 2013

Teradata Express is a pre-configured VMWare image. When you installed VMWare Fusion you're done.
Unzip Express into a folder and double-click the file (which actually is a folder) TDExpress14.0_Sles10_40GB (or whatever is the name). This should open Fusion and automatically start the VM. 

Dieter

soken 1 comment Joined 04/12
10 Dec 2013

Hi,
About the file TDExpress14.10_Sles10_1TB_VP_30cache.7z,
what dose "_30cache" mean ?
soken

DarcyVoorhees 5 comments Joined 12/13
11 Dec 2013

Thanks for the tip on firing up VMWare that worked great.  However, I'm on to the next problem.  I double click on the TDExpress14.10_Sles11.vmx file to start up the instance of Teradata and I can see it fire up VMFusion. It starts the loading processing and then about 2 minutes in it gets an error "cannot find a valid peer process to connect to".  Any thoughts?

platonsan 2 comments Joined 01/14
28 Jan 2014

I am using Express to test SAS/ACCESS for Teradata.

 

The first step in installing the SAS components in Teradata, is to run the DIPGLOB script.

 

But, DIPGLOB is not on the list of DIP utilities:

 1. DIPERR     - Error Messages

 2. DIPDEM     - UDF/UDT/XSP/SPL Macros

 3. DIPRSS     - ResUsage Tables

 4. DIPVIEWS   - System Views

 5. DIPOLH     - Online Help

 6. DIPSYSFE   - System FE Macros

 7. DIPACR     - Access Rights

 8. DIPCRASH   - CrashDumps Database

 9. DIPRUM     - ResUsage Views/Macros

10. DIPCAL     - Calendar Tables/Views

11. DIPCCS     - Client Character Sets

12. DIPOCES    - Cost Profiles

13. DIPUDT     - UDT Macros

14. DIPSYSFNC  - System Functions

15. DIPSQLJ    - SQLJ Views/Procedures

16. DIPPWRSTNS - Password Restrictions

17. DIPRCO     - Reconfig

18. DIPTDWM    - TDWM Configuration

19. DIPSTATS   - Automated Stats Mgmt

20. DIPALL     - All of the above

21. DIPPDCR    - PDCR Tables/Views

22. DIPACC     - Access Logging

23. DIPPATCH   - Stand-alone patches

 

 

Is this a limitation in Express ?    Is there another way to run DIPGLOB ?

 

 

Steen

 

smazingo 16 comments Joined 04/09
28 Jan 2014

Here is the procedure (in brief, please refer to Teradata Utilities manuals for more details including DBSCONTROL):
 
1.            Enable the DIPGLOP menu item
                -              Start DBSSONTROL
                -              Enable display of internal flags:    "m i = true"
                -              Set internal flag 263 " DisplayDIPGLOPMenu" to TRUE and write:    "m i 263 = true" followed by "w"
                -              Display internal flags to confirm setting, look for #263= TRUE:   "d i"
                -              Disable display of internal flags:   "m i = false"
2.            Run DIPGLOP
                -              Start DIP
                -              Enter DBC password
                -              Choose DIPGLOP from menu (#27 on Teradata 14.10)
3.            Restart Teradata after DIPGLOP
 
Then proceed with installing and configuring SAS In-Database components.

platonsan 2 comments Joined 01/14
29 Jan 2014

It looks like there is only 259 internal flags available ?
 

  258. NLBGroupRowsByAMP = 0 ( 0/1 = Disabled/Enabled )   *defaulted*

  259. ARCSaveBLCStatus = FALSE (default FALSE)

 

 

Enter a command, HELP, or QUIT:

m i 263 = true

 

Value is out of range for Internal field! Valid range is 1 to 259.

 

30 Jan 2014

Hi,
Is there any option to start teradata similar to Teradata service control in Teradata12.0. ?
Kindly let me know about this option ?
 
Thanks in advance
Manjunath

smazingo 16 comments Joined 04/09
31 Jan 2014

i assume that you're talking about a version running in a native windows environment vs via vmware player. is that correct. all recent versions of express run via vmware player.

hyst55 1 comment Joined 02/10
06 Feb 2014

Hi,

 

There is one thing to clarify. After the liscense term period (90 days), should I back up and copy database objects like tables from prior-downloaded vm image to new one or just download another image to continue to use the old one?

 

Many thanks

Yoshito

vthirugnanam 2 comments Joined 04/14
14 Apr 2014

Can i run the 40G image on ESXi 5.5 ? Tried to register the .vmx and getting an invalid error.
 
thanks
-Vijay

Cliff L 27 comments Joined 04/12
14 Apr 2014

The image Teradata supplies is VMware Player format. It cannot be run in it's current form on ESXi.
Regards,
Cliff

vthirugnanam 2 comments Joined 04/14
14 Apr 2014

Can i convert it from VMware Player format? Not sure if anyoned tried and succeeded.
-Vijay

Cliff L 27 comments Joined 04/12
14 Apr 2014

It has been done, but I cannot help you. Remember the license is for Test and Dev only.
Cliff

pindiganti2 2 comments Joined 05/14
10 May 2014

I am new to Teradata. Recently I installed TTU 14 in my lap.
System config: Windows7 64bit, 4gb ram, 500GB hd..
While trying to connect teradata SQL assistant it is throwing error like connection refused..
 
Please guide me

swatisvl12 1 comment Joined 05/14
10 May 2014

Is the Teradata Express 14 availble for Windows 7 32bit ? with Teradata Database version 14.

pindiganti2 2 comments Joined 05/14
14 May 2014

I installed Teradata Express 14.0 for VMware 40gb
 
While connecting teradata studio express it is giving error saying that cannot create connection. Can someone help me out to connect 

Cliff L 27 comments Joined 04/12
15 May 2014

See smazingo comment from 14 Nov. You need to get the ip address from within the VM by running ifconfig from the linux prompt. This will give you the ip address to set up Studio Express.

Mudassir 1 comment Joined 04/12
04 Jun 2014

Hi Cliff,
I have downloaded VMware Player and TD Express 14.0.3 4 GB version. When I am trying to connect through ODBC, I am getting an error message that teradata is not accepting connections. I have tried many options of configuring VM Network adapter steeings but in vain. Can you suggest the steps I should take in order to be able to connect to teradata using TTU 15?
 
Thanks.

smazingo 16 comments Joined 04/09
04 Jun 2014

one thing to check first if this isn't working is the security groups launch wizard for your instance in EC2. You need to have the various inbound ports set up  80, 1025,  8080, 22, 443. If it's not obvious how to set them up, look at the other launch wizards to see how they are set up. hope this will help.

1 month ago

Are all the TASM and Priority Scheduller tools included in this VM version SL10 + viewpoint?

regards,

Carlos G. Varela
Freelance - BI Project Manager / Solutions Architect
+34 616307704
carlos@varela.com

You must sign in to leave a comment.