1.

How To Run Gpcheckcat?

Answer»

The gpcheckcat tool is used to check catalog inconsistencies between master and segments. It can be found in the
$GPHOME/bin/lib directory:
Usage: gpcheckcat <OPTION> [dbname]
-?
-B parallel: NUMBER of worker threads
-g dir : generate SQL to rectify catalog corruption, put it in dir
-h host : DB host name
-p PORT : DB port number
-P passwd : DB password
-o : check OID consistency
-U uname : DB User Name
-v : VERBOSE

Example: gpcheckcat gpdb >gpcheckcat_gpdb_logfile.log

The gpcheckcat tool is used to check catalog inconsistencies between master and segments. It can be found in the
$GPHOME/bin/lib directory:
Usage: gpcheckcat <option> [dbname]
-?
-B parallel: number of worker threads
-g dir : generate SQL to rectify catalog corruption, put it in dir
-h host : DB host name
-p port : DB port number
-P passwd : DB password
-o : check OID consistency
-U uname : DB User Name
-v : verbose

Example: gpcheckcat gpdb >gpcheckcat_gpdb_logfile.log


Discussion

No Comment Found

Related InterviewSolutions