Purpose
Validates that the specified table is in-sync (on all systems or on the specified systems). The optional ACTIVATE flag requests the table activation.
OBJECT VALIDATE <tablename> | id:<object id> ON <tdpid1>, <tdpid2>[,...]TIMEOUT '<timeout (seconds)>'] [ACTIVATE]
Parameters
- tablename
- The fully qualified name of the target object.
- object id
- The managed object id of the target object.
- tdpid
- Unique identifier (TDPID) of a target Teradata Database system.
- timeout
- The timeout, in seconds, for the operation.
- ACTIVATE
- Requests table activation.
Table in sync
unityadmin> OBJECT VALIDATE admin_db.ttt on 1, 2:
Operation Number : 5
Operation Name : Validating Object
User : admin
User Name : Main Administration User
Start Time : 02/22 11:06:17
Updates:
02/22 11:06:17 [-] Info: Validating table admin_db.tttt using timeout 600
02/22 11:06:24 [-] Info: Validation metric: ROWCOUNT
02/22 11:06:24 [-] Info: Validation time: 2019-02-22T19:01:43:784Z
02/22 11:06:24 [-] Info: systems: sdt13140( 1 ), sdt13141( 0 )
02/22 11:06:24 [-] Info: Table is not in Sync
02/22 11:06:24 [-] Info: Validation complete on 2 systems
02/22 11:06:24 [-] Info: Operation finished
Status : Finished (1)
Finish Time : 02/22 11:06:24