【Teradata Utility】系统工具使用

时间:2021-03-01 02:07:25

List two ways in which a system utility can be started.

Explain how to use the following utilities to maintain a Teradata database:

– DBS Control
– Ferret Packdisk
– Ferret Defragment
– Ferret Scandisk
– Checktable
– Table Rebuild
– Recovery Manager
– Showlocks
– UpdateSpace
– Vprocmanager

List the order in which to execute the Checktable and Scandisk utilities.

1.utilities工具启动方式

(1)输入命令行直接启动

tpareset
pdestate
dbscontrol
vprocmanager
schmon
dip

如果提示找不到命令,可输入tdatcmd命令添加命令所在目录到当前环境变量,如下:

tdatcmd  

(2)Supervisor Window启动

cnsterm        ==>Linux(cnsterm 1-6)
cnstool ==>Windows
Remote Console ==>ViewPoint

【Teradata Utility】系统工具使用

 2.DBS Control工具

(1)查看主要内容

  • General
  • File System
  • Performance
  • Checksum
  • Compression
  • Statistics
  • Storage (used if temperature based compression is enabled or if TVS is licensed)

(2)三种启动方式

  • Command line:输入tdatcmd后,输入dbscontrol
  • Viewpoint Remote Console :选择DBS Control
  • Supervisor Window:输入START DBSCONTROL

(3)显示、帮助和退出

DISPLAY GENERAL | FILESYS | PERFORMANCE | COMPRESSION | …    ==>显示
HELP GENERAL | FILESYS | PERFORMANCE | COMPRESSION | … ==>帮助
QUIT ==>退出

(4)修改方法

display general
modify general = ==>Use the modify command to change flag (Century Break)
write ==>Write changes to the GDO

(5)参数信息

【Teradata Utility】系统工具使用【Teradata Utility】系统工具使用

【Teradata Utility】系统工具使用【Teradata Utility】系统工具使用

(6)开启并使用dbscontrol内部参数

上述描述的均为外部参数,可以使用如下命令开启并查看内部参数:

m systemfe=true
y
d i

参考文档:

Factory15 -55 System Utilities