01 什么是Teradata Express
「Teradata Express for VMware Player」是在VMware虚拟机软件上可以直接导入并启动的虚拟机文件，方便用户在没有Teradata硬件的情况下，使用普通PC就可以启动Teradata数据库实例并进行功能的测试。该虚拟机文件中，包含一个SUSE Linux发行版和安装在Linux上的Teradata数据库和数据库客户端软件。
从Teradata官网即可下载此虚拟机文件，下载的链接如下：
https://downloads.teradata.com/download/database/teradata-express-for-vmware-player
进入下载页面需要注册一个免费账号，登陆之后可以看到具体可以下载的版本。如下图，我这边测试使用的是16.20
，即红框内的版本。
对应的User Guide文档中提供了此虚拟机中操作系统和数据库的密码，以及这个虚拟机可以支持多大的数据运算。
The image contains one PE and two AMPs with two virtual disks that support 40 GB database size.
4GB RAM if Viewpoint is not running.
8GB RAM with Viewpoint running.
If only 4GB RAM is available, both Teradata Vantage and Viewpoint cannot be run at the same time.
02 启动数据库
将下载的虚拟机文件TDExpress16.20_Sles11_20200123160656.7z
解压后得到如下图的文件夹。
我们可以使用VMware Player（版本6以上）或VMware Workstation（版本12以上）的「文件>打开」命令导入后缀为vmx的虚拟机文件，然后可以在VMware窗口中看到此虚拟机的相关信息。
在编辑虚拟机选项中，根据宿主机的配置，可以对内存和处理器的大小进行调整。
通过点击「开启此虚拟机」按钮进行启动，启动过程中在GRUB阶段，按照默认的选项敲击回车即可。
在操作系统登陆界面，使用root账号登录，密码也是root。
登录之后，打开终端工具「Gnome Terminal」，在提示符下输入以下命令查看pde的状态。
TDExpress1620_Sles11:~ # pdestate -a
PDE state is RUN/STARTED.
DBS state is 5: Logons are enabled - The system is quiescent
TDExpress1620_Sles11:~ # vprocmanager
_______
| | |
| ___ __ ____ | ____ __|__ ____
| |/ \ ____| ____| ____| | ____|
| --- | | | | | |
| \___ | \____| \____| \____| |__ \____|
Release 16.20.32.23 Version 16.20.32.23
VprocManager Utility (Sep 98)
Enter a command, HELP or QUIT:
status
SYSTEM NAME: localhost 20/11/30 11:45:11
DBS LOGICAL CONFIGURATION
-------------------------
Global Rcv
Map Jrnl/
Vproc Rel. Node Can Crash Vproc Config Config Cluster/ Host TVS
Number Vproc# ID Move Count State Status Type Host No. Type Vproc
------ ------ ------- ----- ----- ------- -------- ------ -------- ----- -----
0* 1 1-01 Yes 0 ONLINE Online AMP 0 On 28671
1 2 1-01 Yes 0 ONLINE Online AMP 0 On 28671
26623 5 1-01 No 0 ONLINE N/A RSG 0 N/A N/A
22528 4 1-01 No 0 ONLINE N/A GTW 1 COP N/A
28671 6 1-01 Yes 0 ONLINE N/A TVS 0 N/A N/A
30719 3 1-01 Yes 0 ONLINE Online PE 1 COP N/A
---------------------------------------------------------------------------------
* DBS Control AMP
DBS State: Logons are enabled - The system is quiescent
DBS RestartKind: COLD
MAP CONFIGURATION
-----------------
Slot 0: TD_GlobalMap
MAP State: Online
Slot 1: TD_DataDictionaryMap
MAP State: Online
Slot 2: TD_Map1
MAP State: Online
Slot 0 Slot 1 Slot 2
AMP Cluster Cluster Cluster
Number No No No
------ ------- ------- -------
0 0 0 0
1 0 0 0
------------------------------------------------------------------------------
PDE PHYSICAL CONFIGURATION
--------------------------
Node Node Clique Memory
ID State Number CPUs (MB) CHANs LANs AMPs Node Name
------- ------- ------ ---- ------ ----- ---- ---- ---------------------------
1-01 ONLINE 0 1 5367 0 1 2 localhost
------------------------------------------------------------------------------
PDE State: RUN/STARTED
TDExpress1620_Sles11:~ # bteq
Teradata BTEQ 16.20.00.08 (32-bit) for LINUX. PID: 10463
Copyright 1984-2018 Teradata. All rights reserved.
Enter your logon or BTEQ command:
.logon 127.0.0.1/dbc
.logon 127.0.0.1/dbc
Password:
*** Logon successfully completed.
*** Teradata Database Release is 16.20.32.23
*** Teradata Database Version is 16.20.32.23
*** Transaction Semantics are BTET.
*** Session Character Set Name is 'ASCII'.
*** Total elapsed time was 1 second.
BTEQ -- Enter your SQL request or BTEQ command:
select * from dbc.dbcinfo;
select * from dbc.dbcinfo;
*** Query completed. 3 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
InfoKey InfoData
------------------------------ --------------------------------------------
LANGUAGE SUPPORT MODE Standard
RELEASE 16.20.32.23
VERSION 16.20.32.23
03 连接数据库
命令行方式
首先使用bteq命令行的方式连接到数据库，dbc的默认密码是dbc
。
TDExpress1620_Sles11:~ # bteq
Teradata BTEQ 16.20.00.08 (32-bit) for LINUX. PID: 10463
Copyright 1984-2018 Teradata. All rights reserved.
Enter your logon or BTEQ command:
.logon 127.0.0.1/dbc
.logon 127.0.0.1/dbc
Password:
*** Logon successfully completed.
*** Teradata Database Release is 16.20.32.23
*** Teradata Database Version is 16.20.32.23
*** Transaction Semantics are BTET.
*** Session Character Set Name is 'ASCII'.
*** Total elapsed time was 1 second.
BTEQ -- Enter your SQL request or BTEQ command:
select * from dbc.dbcinfo;
select * from dbc.dbcinfo;
*** Query completed. 3 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
InfoKey InfoData
------------------------------ --------------------------------------------
LANGUAGE SUPPORT MODE Standard
RELEASE 16.20.32.23
VERSION 16.20.32.23
图形工具方式
使用虚拟机中自带「Teradata Studio Express」工具。
双击打开
新建连接，选择Teradata
连接配置信息
连接后执行查询
04 总结
可以使用Teradata Express for VMware快速搭建测试或开发实验环境。
