I am not DBA and neither I am developer. I am tester. My team is testing application which works with MS SQL, DB2 and Oracle. My goal is quite simple: install db and provide other testers configuration data to connect to that db.
Sometime testers have a problem with application and first thing they ask me: "could you check db? Is it OK, up and running and in good health?".
I can't answer those questions since as I mentioned I'm not DBA but I'd like to give at least some general / helpful answer about the health of db.
I found that for MS SQL I could run 'DBCC CHECKDB' and expect that no errors let me know that db is 'healthy' .
What you could recommend for the same purpose to run to check the health of Oracle and DB2 db's?
Thanks in advance.