How to know the status of database?

[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.

[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?

[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

[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...

[zprogrammer]

Pragrya,

Did you try the command I gave you?

Also You need to read the COMMAND manual of DB2

[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

[Pragya]

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.

[Pragya]

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.

[zprogrammer]

Thanks Pragya . This will help others in future who would have similar quere