OBR Vertica last good epoch check

Document ID:KM03767431
Creation Date:10-Dec-2020
Modified Date:10-Dec-2020
- Micro Focus Products:
  operations bridge reporter 10.40

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

Summary

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'