Can anyone tell me the command to know the exact 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 sort of details.
Well, you might try the display command and see if it returns what you want.
Which database product? Running on which Operating System?
Try the following on 7 th option in DB2I (DB2 interactive menu)
-DISPLAY DATABASE(dbname) SPACE(*) RESTRICT