OBR Vertica last good epoch check

  • KM03767431
  • 10-Dec-2020
  • 10-Dec-2020

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

OBR Vertica last good epoch check

Error

If OBR vertica is down and unoable to see LGE value

Fix

Use below:

 

echo -e "list EpochMap"|/opt/vertica/bin/vertica -D /database/Catalog/pmdb/v_pmdb_node0003_catalog  -E'batch'
echo -e "show oid <oid of epoch map>"|/opt/vertica/bin/vertica -D /database/Catalog/pmdb/v_pmdb_node0003_catalog -E'batch'
=================================================================
echo -e "list EpochMap"|/opt/vertica/bin/vertica -D /home/dbadmin/VMart/v_vmart_node0002_catalog -E'batch'
echo -e "show oid 45035996273704974"|/opt/vertica/bin/vertica -D /home/dbadmin/VMart/v_vmart_node0002_catalog -E'batch'