Got it

Some Commands of GaussDB 200 - Version and Status

Latest reply: Nov 26, 2021 13:33:56 766 29 4 0 0

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();

GaussDB 200

2. Check the kernel version.

su - omm -c "source ${BIGDATA_HOME}/mppdb/.mppdbgs_profile;gsql -V"

GaussDB 200

3. Check the cluster installation version.

sh /opt/huawei/Bigdata/om-server/om/sbin/queryVersion.sh

GaussDB 200

Check the cluster status

When a database fault occurs, check the cluster status first. The following describes two methods of querying the cluster status.

gs_om -t status --detail

GaussDB 200

cm_ctl query -Cvd  (cm_ctl query -Cvdi  Add i to query the node information.)

GaussDB 200

 Thank you.



  • x
  • convention:

Axe_Z
Created Jan 18, 2021 08:48:43

Thank you.
View more
  • x
  • convention:

little_fish
little_fish Created Jan 18, 2021 09:03:42 (0) (0)
 
azkasaqib
azkasaqib Created Jan 18, 2021 16:20:04 (0) (0)
 
azkasaqib
azkasaqib Created Jan 26, 2021 16:54:18 (0) (0)
 
azkasaqib
azkasaqib Created Jan 26, 2021 16:54:34 (0) (0)
 
Unicef
MVE Created Jan 18, 2021 09:00:52

Thanks for sharing
View more
  • x
  • convention:

little_fish
little_fish Created Jan 18, 2021 09:04:21 (0) (0)
Thank you for your support.  
Unicef
Unicef Reply little_fish  Created Jan 18, 2021 09:35:26 (0) (0)
 
wissal
MVE Created Jan 18, 2021 16:02:42

Very useful.
View more
  • x
  • convention:

little_fish
little_fish Created Jan 19, 2021 07:32:08 (0) (0)
Thank you for your support.  
Irshadhussain
Created Jan 18, 2021 16:19:09

Thanks for sharing
View more
  • x
  • convention:

Ayeshaali
Ayeshaali Created Jan 18, 2021 16:21:29 (0) (0)
 
little_fish
little_fish Created Jan 19, 2021 07:32:17 (0) (0)
 
Irshadhussain
Irshadhussain Reply Ayeshaali  Created Jan 19, 2021 17:04:00 (0) (0)
 
Irshadhussain
Irshadhussain Reply little_fish  Created Jan 19, 2021 17:04:07 (0) (0)
 
azkasaqib
azkasaqib Created Jan 23, 2021 16:59:42 (0) (0)
 
Irshadhussain
Created Jan 18, 2021 16:19:15

Nice
View more
  • x
  • convention:

azkasaqib
azkasaqib Created Jan 18, 2021 16:20:10 (0) (0)
 
Ayeshaali
Ayeshaali Created Jan 18, 2021 16:21:05 (0) (0)
:@  
little_fish
little_fish Created Jan 19, 2021 07:32:25 (0) (0)
 
azkasaqib
azkasaqib Created Jan 23, 2021 16:59:37 (0) (0)
 
azkasaqib
Created Jan 18, 2021 16:19:48

Thankks for sharing dear
View more
  • x
  • convention:

azkasaqib
Created Jan 18, 2021 16:19:55

:_)
View more
  • x
  • convention:

little_fish
little_fish Created Jan 19, 2021 07:32:32 (0) (0)
Thank you for your support.  
azkasaqib
azkasaqib Reply little_fish  Created Jan 19, 2021 17:10:42 (0) (0)
 
azkasaqib
azkasaqib Reply little_fish  Created Jan 19, 2021 17:10:49 (0) (0)
 
Zebra
Created Jan 21, 2021 14:43:52

very helpful. Thanks for sharing
View more
  • x
  • convention:

little_fish
little_fish Created Jan 22, 2021 00:47:33 (0) (0)
cool  
Anno7
Author Created Nov 26, 2021 13:33:56

beneficial content...
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.