scandisk是检查teradata数据库中逻辑块的命令,常用方法如下:
1.命令行进入cnsterm 6输入start filer
2.命令行进入cnsterm x(start filer显示出来的window)
3.输入scope all选择所有amp(默认是选择所有amp),或者scope amp号选择特定的amp
4.输入scandisk开始全部扫描
5.输入scandisk “ databasename.tablename” * 对特定表进行扫描
实例如下:
TDExpress14.10.03_Sles11:~ #
TDExpress14.10.03_Sles11:~ # cnsterm 6Attempting to connect to CNS...Completed.
Hello
I
Input Supervisor Command:
> start filer
start filer
Started 'filer' in window 2
at Thu Sep 24 10:36:20 2015
Input Supervisor Command:
> ^C
TDExpress14.10.03_Sles11:~ # cnsterm 2
Attempting to connect to CNS...Completed.
Hello
File System Debug Utility
_______
| | |
| ___ __ ____ | ____ __|__ ____
| / |/ \ ____| ____| ____| | ____|
| --- | / | / | / | | / |
| \___ | \____| \____| \____| |__ \____|
Release 14.10.03.02 Version 14.10.03.02
Filer
Waiting for Filer Slave tasks to start
FILER will run in Workload Def: WD-Default
Command has been sent to Slave tasks.
Thu Sep 24, 2015 10:36:27
2 of 2 amps have been selected
Filer ==>
> scope all
scope all
Command has been sent to Slave tasks.
Thu Sep 24, 2015 10:36:40
2 of 2 amps have been selected
Filer ==>
> scandisk
scandisk
Thu Sep 24, 2015 10:36:48 : Scandisk ALL will be started
On all AMP vprocs
Do you wish to continue based upon this scope?? (Y/N)
> y
y
Thu Sep 24, 2015 10:36:49 : Scandisk has been started
Command has been sent to Slave tasks.
Type 'ABORT' to stop the command before completion
Type 'INQUIRE' to check on progress of command
> in
Thu Sep 24, 2015 10:36:56
2 of 2 vprocs responded with no messages or errors.
Thu Sep 24, 2015 10:36:56: Scandisk Completed
Filer ==>
> scope 0
scope 0
Command has been sent to Slave tasks.
Thu Sep 24, 2015 10:37:21
1 of 2 amps have been selected
Filer ==>
> scandisk
scandisk
Thu Sep 24, 2015 10:37:45 : Scandisk ALL will be started
On AMP vproc(s) 0000
Do you wish to continue based upon this scope?? (Y/N)
> y
y
Thu Sep 24, 2015 10:37:47 : Scandisk has been started
Command has been sent to Slave tasks.
Type 'ABORT' to stop the command before completion
Type 'INQUIRE' to check on progress of command
> s
Thu Sep 24, 2015 10:37:51
1 of 1 vprocs responded with no messages or errors.
Thu Sep 24, 2015 10:37:51: Scandisk Completed
Filer ==>
> scope all
scope all
Command has been sent to Slave tasks.
Thu Sep 24, 2015 10:38:16
2 of 2 amps have been selected
Filer ==>
> scandisk "user_a.test" *
scandisk "user_a.test" *
Thu Sep 24, 2015 10:38:30 : Scandisk ALL will be started
On all AMP vprocs
Do you wish to continue based upon this scope?? (Y/N)
> y
y
Thu Sep 24, 2015 10:38:35 : Scandisk has been started
Command has been sent to Slave tasks.
Type 'ABORT' to stop the command before completion
Type 'INQUIRE' to check on progress of command
Thu Sep 24, 2015 10:38:35
2 of 2 vprocs responded with no messages or errors.
Thu Sep 24, 2015 10:38:35: Scandisk Completed
Filer ==>