GP - check if the db server is up
SQL= SELECT COUNT(*) FROM gp_toolkit.gp_pgdatabase_invalid;
SQL= SELECT * FROM gp_toolkit.gp_pgdatabase_invalid;
SQL=
SELECT time as \"Timestamp\", dbid as \"DB Id\", \"desc\" as \"Description of change\"
FROM gp_configuration_history
WHERE dbid IN (SELECT dbid FROM gp_segment_configuration WHERE status='d')
ORDER BY time desc;
Comments
Post a Comment