XPost: comp.databases.ibm-db2, comp.databases.oracle.server   
   From: memmerto@nospam.yahoo.com   
      
   "z"  wrote in message   
   news:6OBnf.37054$tV6.22163@newssvr27.news.prodigy.net...   
   > How can validation testing on DBMSs such as DB2 and Oracle be performed?   
   >   
   > Is there a quick commonly used publicly available DBMS test that can be   
   > used?   
   >   
   > Could TPC-C be used?  If so, where can TPC-C be obtained?  (Is is publicly   
   > available?)   
      
   If you want to validate a database for use in your business environment, the   
   best thing to do is build a simple prototype of your business app and test   
   it on the databases you're considering.  Both DB2 and Oracle come in   
   "express" editions, and should be full-featured enough to put a prototype   
   through it's paces.  This way you can play with performance scaling, various   
   DDL options, backup/restore and other things that you're bound to do when in   
   production, and really get a feel for what works best in the intended   
   environment.   
      
   To echo someone else's comments -- using an off-the-shelf benchmark (such as   
   any of the TPC benchmarks) may not be anywhere near close to what your   
   business needs are, and thus you'd end up with something that isn't a good   
   fit.  It's much like deciding to buy a sports car because it was the fastest   
   and flashiest, and then finding out that your wife is pregnant with triplets   
   and you should have bought a mini-van :)   
      
   --   
   Matt Emmerton   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)