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