【Teradata】磁盘碎片整理(ferret工具)

时间:2022-04-18 17:19:32

DEFRAGMENT
combines free sectors and moves them to the end of a cylinder.
PACKDISK
fill (or packs) cylinders up to the FSP (Free Space Percentage)

1.使用vncciewer登陆SWS并登录节点并查看数据库状态

登陆SMP001-8节点21.*.*.*
psh pdestate -a
psh sar
检查数据库状态是否为:tpa is running/started,检查系统繁忙程度正常

2.运行ferret

cnsterm
>start ferret
ctrl+c 退出

3.开始packdisk

开始packdisk
cnsterm
>packdisk fsp=10 ==>(where fsp = free space percent and nnn equals the percentage of cylinder free space) 
>y 查看packdisk进度
cnsterm
>inquire 终止packdisk
>abort 检查cylinder使用率
>showspace 退出
>quit
ctrl+c