OBJECT VALIDATE Command | unityadmin | Teradata Unity - 17.00 - OBJECT VALIDATE - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

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