How to know the status of database?
How to know the status of database?
Hi,
Could you please help me with the command used to know the status of the database, whether its available in RW mode or not? I remember using Display database command, but not sure if this would work for getting these details.
Thanks in advance.
Could you please help me with the command used to know the status of the database, whether its available in RW mode or not? I remember using Display database command, but not sure if this would work for getting these details.
Thanks in advance.
Re: How to know the status of database?
So you remember a command but not the detail of its parameters and output. Why have you not gone to the manuals to look up the command and refresh your memory?
Regards
Nic
Nic
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: How to know the status of database?
Try the command
This will tell the status..
Also Read through the manual as Nicc suggested
Code: Select all
-DIS DB(<DATABASE NAME>) SPACE(<TABLE SPACENAME>)
Also Read through the manual as Nicc suggested
zprogrammer
Re: How to know the status of database?
Thanks Pandora.
nicc I checked the manuals and searched on "status" keyword but it returned so many results that I could not understand which result to look and which not...
nicc I checked the manuals and searched on "status" keyword but it returned so many results that I could not understand which result to look and which not...
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: How to know the status of database?
Pragrya,
Did you try the command I gave you?
Also You need to read the COMMAND manual of DB2
Did you try the command I gave you?
Also You need to read the COMMAND manual of DB2
zprogrammer
-
- Global Moderator
- Posts: 826
- Joined: Wed Sep 11, 2013 3:57 pm
Re: How to know the status of database?
laziness I supposeWhy have you not gone to the manuals to look up the command and refresh your memory?
what happened when You googled with - for example - db2 display database status
to arrive at
https://www-01.ibm.com/support/knowledg ... abase.dita
the command explanation seems pretty clear to me
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
Re: How to know the status of database?
Pandora-Box I used the command usggested by you and it worked for me. That's why I said thank in my post.Pandora-Box wrote:Pragrya,
Did you try the command I gave you?
Also You need to read the COMMAND manual of DB2
Initially I was not able to know what should I look for and I could not identify the command this is what I'm telling to nicc.
Re: How to know the status of database?
enrico yes command is clear to me now, but I did not know what is command so was confused.enrico-sorichetti wrote:laziness I supposeWhy have you not gone to the manuals to look up the command and refresh your memory?
what happened when You googled with - for example - db2 display database status
to arrive at
https://www-01.ibm.com/support/knowledg ... abase.dita
the command explanation seems pretty clear to me
Thanks all for your help.
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: How to know the status of database?
Thanks Pragya . This will help others in future who would have similar quere
zprogrammer
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute