Page 1 of 1
How to know the status of database?
Posted: Tue Sep 15, 2015 2:17 pm
by Pragya
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.
Re: How to know the status of database?
Posted: Tue Sep 15, 2015 4:11 pm
by nicc
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?
Re: How to know the status of database?
Posted: Wed Sep 16, 2015 8:35 pm
by zprogrammer
Try the command
Code: Select all
-DIS DB(<DATABASE NAME>) SPACE(<TABLE SPACENAME>)
This will tell the status..
Also Read through the manual as Nicc suggested
Re: How to know the status of database?
Posted: Thu Sep 24, 2015 10:06 pm
by Pragya
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...
Re: How to know the status of database?
Posted: Fri Sep 25, 2015 4:34 pm
by zprogrammer
Pragrya,
Did you try the command I gave you?
Also You need to read the COMMAND manual of DB2
Re: How to know the status of database?
Posted: Fri Sep 25, 2015 5:11 pm
by enrico-sorichetti
Why have you not gone to the manuals to look up the command and refresh your memory?
laziness I suppose
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
Re: How to know the status of database?
Posted: Wed Sep 30, 2015 2:54 pm
by Pragya
Pandora-Box wrote:Pragrya,
Did you try the command I gave you?
Also You need to read the COMMAND manual of DB2
Pandora-Box I used the command usggested by you and it worked for me. That's why I said thank in my post.
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?
Posted: Wed Sep 30, 2015 2:55 pm
by Pragya
enrico-sorichetti wrote:Why have you not gone to the manuals to look up the command and refresh your memory?
laziness I suppose
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
enrico yes command is clear to me now, but I did not know what is command so was confused.
Thanks all for your help.
Re: How to know the status of database?
Posted: Wed Sep 30, 2015 3:25 pm
by zprogrammer
Thanks Pragya . This will help others in future who would have similar quere