OBJECT VALIDATE Command | unityadmin | Teradata Unity - OBJECT VALIDATE - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.51
Published
May 2020
Language
English (United States)
Last Update
2020-06-01
dita:mapPath
oic1588030762460.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

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> [, <tablename>, …] ON <tdpid1>, <tdpid2>[,...]TIMEOUT '<timeout (seconds)>'] [ACTIVATE]

Parameters

ACTIVATE
Requests table activation.

Table in sync

unityadmin> OBJECT VALIDATE admin_db.ttt  on 1, 2:
Operation Number  : 5
Operation Name    : Validating Ojbect
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:17 [-] Info: Initiating EM table validation job for table admin_db.tttt
    02/22 11:06:20 [-] Info: Starting EM validation job
    02/22 11:06:21 [-] Info: Polling EM server to get the validation status
    02/22 11:06:22 [-] Info: Polling EM server to get the validation status
    02/22 11:06:24 [-] Info: Polling EM server to get the validation status
    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