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 :x

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 :x

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