Author Topic: How to check that the Database used in the Appserver Workload is OK  (Read 417 times)

psmith

  • Moderator
  • Newbie
  • *****
  • Posts: 3
  • Karma: +3/-0
If you'd like to know if the database you've built has the required records you can use the attached script (getDBcounts.sh) to query the database (postgresql) and compare it to the values in the attached spreadsheet: SPECJapp-DB-table-sizes.xls.  Note that some table counts include a small random variance so will not be an exact match for the value in the .xls  so an "r" next to the table name is used for these.

See script's comments for directions.