Dear all,
This post shows the commands of GaussDB 200.
Check the version
If you need help, you need to provide the specific version. The following three methods are used to query the version. You can select the corresponding statement as required.
1. Check the database version.
select version();
2. Check the kernel version.
su - omm -c "source ${BIGDATA_HOME}/mppdb/.mppdbgs_profile;gsql -V"
3. Check the cluster installation version.
sh /opt/huawei/Bigdata/om-server/om/sbin/queryVersion.sh
Check the cluster status
When a database fault occurs, check the cluster status first. The following describes two methods of querying the cluster status.
1 gs_om -t status --detail
2 cm_ctl query -Cvd (cm_ctl query -Cvdi Add i to query the node information.)
Thank you.