Teradata系统日常维护手册

数据仓库系统日常维护标准文档下面列表内容为日常维护检查系统的具体情况：

Tpareset –

x comments（检查WAL和session情况）

重启前只要wal基本都归零了不必要清session，只有wal有问题才需要做步骤2.

1,psh pdestate –看是不是所有节点都正常的。

??????

# cnsterm 6 open the database supervisor screen Input Supervisor Command:

??????? abort session *.* logoff

Is the data base quiescent (Verify all sessions gone.)

# /tpasw/bin/vprocmanager –s

DBS State: Logons are enabled – The system is quiescent

PDE State: TPA

on), perform a dbs coldwait restart from vprocmanager. Otherwise continue with “Bring database down”:

# /tpasw/bin/vprocmanager

Enter a command, HELP or QUIT:

restart coldwait to clear session table

Wait for the database to come up again. Is the base quiescent (Verify all sessions are gone.)

# /tpasw/bin/vprocmanager –s

DBS State: Logons are enabled – The system is quiescent

PDE State:TPA

??????? 检查wal的大小：（bteq登录，

systemfe|service）

select

currentperm

,vproc

from

where databasename = ‘DBC’

and tablename = ‘transientjournal’

order by 1 desc;