Step by Step Instructions

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"

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!