Step by Step Instructions

Select a time of day when activity is typically quite high such as 9am, 10am, 11am, or 2pm. You will need to complete the END OF CONTEST PARTICIPANT INSTRUCTIONS at approximately the SAME time of day two weeks later. It is important that we compare "apples to apples".

mkdir contest
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.txt
db2 "get dbm cfg" > dbmcfg.txt
db2 "get snapshot for database on YOURDB" > dbsnap1.txt
db2 "get snapshot for tables on YOURDB" > tbsnap1.txt
db2 "get snapshot for tablespaces on YOURDB > tssnap1.txt

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

db2 "get snapshot for database on YOURDB" > dbsnap2.txt
db2 "get snapshot for tables on YOURDB" > tbsnap2.txt
db2 "get snapshot for tablespaces on YOURDB > tssnap2.txt

• Note: After completing these commands, make a note of the snapshot timestamps found in these files. The END OF CONTEST snapshots should be taken within five (5) minutes of the START OF CONTEST snapshots.

ZIP the eight *.txt files in the "contest" directory into a single file named:
ORG-LASTNAME-HOST-INSTANCE-DBNAME-START.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
• START = The actual word "START"

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 "CHARITY CONTEST"
10. Click the "Browse..." button to locate the ORG-LASTNAME-HOST-INSTANCE-DBNAME-START.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.
12. Click the "Submit" button.

Thank you for participating in DBI's "Tuning for Charity" Contest.