Contest Prizes

  All Expenses Paid badges and trips to IBM IOD Conference

  Free DBI Software Licenses for 1 year

Awards for:

  Most Improved Database

  Best Tuned Database

  Best Performance Improvement, overall, multiple databases

Bonus!

  Participants demonstrating performance improvement may earn DBI Certified Performance Hero status complete with:

  • Certificate of Achievement
  • Certified Performance Hero T-shirt

 


 

DBI is an IBM Advanced Business Partner

 


The Biggest Loser:
Cutting Costs with IBM DB2 & DBI

Charity Event & Contest


END OF CONTEST
PARTICIPANT INSTRUCTIONS

[ Contest Home ]

Step by Step Instructions

These instructions assume basic working knowledge of DB2 LUW in UNIX, Linux, and Windows environments. Please execute the commands and deliver the results to DBI as directed below. Good luck to all participants!

Refer to the timestamps provided in the DB2 snapshot files that you sent to DBI at the START OF CONTEST. You must complete these END OF CONTEST snapshots during the same timeframe approximately two weeks after the contest start. Please notice that the "contest" directory is re-used and the file names have changed.

cd contest
db2 "update monitor switches using bufferpool on sort on uow on table on timestamp on"
db2 "connect to YOURDB"
db2 "get db cfg for YOURDB" > dbcfg-end.txt
db2 "get dbm cfg" > dbmcfg-end.txt
db2 "get snapshot for database on YOURDB" > dbsnap3.txt
db2 "get snapshot for tables on YOURDB" > tbsnap3.txt
db2 "get snapshot for tablespaces on YOURDB > tssnap3.txt

STOP! PATIENTLY WAIT 15 MINUTES, THEN CONTINUE. (on UNIX/Linux systems, "sleep 900")


db2 "get snapshot for database on YOURDB" > dbsnap4.txt
db2 "get snapshot for tables on YOURDB" > tbsnap4.txt
db2 "get snapshot for tablespaces on YOURDB > tssnap4.txt

ASCII FTP, or otherwise transfer, the files to your desktop or a machine with ZIP software.

ZIP the sixteen *.txt files in the "contest" directory into a single file named:
ORG-LASTNAME-HOST-INSTANCE-DBNAME-END.zip
Where:

  • ORG = CompanyName
  • LASTNAME = The Lastname of the contest participant
  • HOST = The hostname of the database (an alias may be used if necessary)
  • INSTANCE = The DB2 instance name
  • DBNAME = The name of the database that is participating in the contest
  • END = The actual word "END"
Launch a web browser, and go to the DBI Support Request Form:
www.dbisoftware.com/suptreq.php
  1. On the DBI Support Request form, provide your name, company name, phone number, and email address.

  2. For request type, choose "Trial Key"
  3. For requested priority, choose "5 - None"
  4. For Product, choose "All 3 DB2 Performance Tools"
  5. For Database Server, choose "DB2 LUW"
  6. For Database Server Version, enter the version for your database (e.g. V8 FP16)
  7. Select the OS corresponding to your database's operating system
  8. Leave Web Server Blank
  9. For Short Description, enter "CONTEST END"
  10. Click the "Browse..." button to locate the ORG-LASTNAME-HOST-INSTANCE-DBNAME-END.zip file that you created earlier.
  11. In the "Describe Problem or Enhancement in Detail" text box, please briefly describe your database such as "SAP OLTP database" and add any information you feel DBI should know. Go ahead and brag about your tuning success if you like.
  12. Click the "Submit" button.

Thank you for participating in DBI's "Tuning for Charity" Contest. Be sure to participate in the final Webinar to find out who won!

Database Tuning
for CHARITY


  For each contest participant, DBI will donate $25 to the charity pool

  1% of DBI Q2 2008 new license sales will be donated to the charity pool

  Contest participants will "Vote" for their favorite charities, and the charity pool funds will be distributed to the charities on a pro rata basis according to the participant votes

 


The Charities


  American Diabetes Association

  Juvenile Diabetes Research Foundation

  American Cancer Society

  American Red Cross

  American Heart Association

  Big Brothers Big Sisters

 


Questions


Please email questions regarding this charity contest to:
charity.event
"at"
dbisoftware.com