the control center shows that the database is in inconsistent state. What does this mean exactly? I've tried to get rid of it by trying the restart database command but the control center still keeps on showing it. The database can be connected to at this time.

Any advice?
Thanks.

This means that there are Units of Work active against the database. If you disconnect all connections, you should see that the state changes to consistent.

HTH

Andy

You can ignore that message in most cases. Essentially it indicates one or more of the following conditions -
- an active transaction going on
- changes that took place in the database which have not been committed completely (active transaction!)
- changes that took place in the database which have been committed, but not flushed to the tablespace (i.e. flushed to logs only)