T e r a t a系统日常维护
手册
Document serial number【NL89WT-NY98YT-NC8CB-NNUUT-NUT108】
数据仓库系统日常维护标准文档下面列表内容为日常维护检查系统的具体情况：
1,psh pdestate –看是不是所有节点都正常的。

登出所有用户：（登出前跟客户联系一下。

）
# cnsterm 6 open the database supervisor screen Input Supervisor Command:
abort session *.* logoff
Is the data base quiescent (Verify all sessions are gone.)
# /tpasw/bin/vprocmanager –s
DBS State: Logons are enabled – The system is quiescent
PDE State: TPA
If system is not quiescent (still users are logged 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 data 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;
4,
# vprocmanager
> status not
> quit
---应该没有amp显示出来。

5,
# ctl (Linux)。