How to check DB health

April 10, 2011 at 08:37:37
Specs: Windows XP SP3, 2Gb
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.

See More: How to check DB health

Report •

April 12, 2011 at 08:27:22
More homework. First you must know the database. Then know the purpose of the application. Then you must be able to add, change and delete records. You must be able to display and print. The records should be in proper order. The fields should validate the input. The printout should display all fields and calculated output.

Report •
Related Solutions

Ask Question