Before you start

About this tutorial

This game was developed to help you use the skills built with the "SQL and XQuery tutorial for IBM DB2" tutorial series.

The questions, topics, and prerequisites for each stage of the game are listed in this tutorial to serve as a reference. If you have difficulties with a particular stage in the game, you may find it helpful to review the related chapters in the tutorial series.

You can try and play the game without completing the tutorial series. If you find it difficult, this can help you determine where you may need to build up your database query skills.

System requirements

To play this game, you should have IBM DB2 9 installed and the DB2Game database loaded. If you have worked through the "SQL and XQuery tutorial for IBM DB2" tutorial series, you should already have DB2 9 installed on your computer, and you can skip down to "Installing the DB2 business game database."

Download DB2 Express-C 9

1. Download DB2 9 from the product download Web page.
2. Choose the appropriate image, depending on your workstation platform.
3. Click on Download, and sign in with your IBM ID. If you do not have an IBM ID, you can register one for free.
4. View your personal information and the product license. Click I confirm.
5. Select a download method ("Download Director" or "HTTP"), and click Download now.

Install DB2 Express-C 9

1. Once the download is complete, navigate to the folder containing the downloaded file.
2. Unzip the file.
3. Find setup.exe in the unzipped folder, and double-click on it. The DB2 Setup Launchpad will appear.
4. Within the DB2 Setup Launchpad, click on Install a Product from the panel on the left.
5. Click on Install New under DB2 Express.
6. In the installer, click Next to view the "License Agreement." You will need to Accept the agreement to continue, and click Next.
7. Choose a Typical installation, and click Next.
8. Confirm that you plan to "Install DB2 Universal Database Express Edition on this computer and save my settings in a response file," then click Next.
9. Verify the installation directory, and click Next.
10. In the "User Information" screen, set the Domain to None -- use local user account, using the pull-down menu. Use db2admin as the user name, and set a password.
    (Optionally, you can select the LocalSystem account, but there are limitations introduced if this option is used -- press the Help button to learn more.)
11. Make sure the checkbox "Use the Same User Name and Password for the remaining DB2 Services" is checked, and click Next.
12. In the "Configure DB2 instances" screen, click Next.
13. Click Finish to start the DB2 product installation when you reach the "Start copying files and create response file" screen.
14. When the installation is complete, a window with the message "Setup is complete" appears. Click Finish to complete the installation procedure.
15. A window entitled "DB2 First Steps" now appears. Click Create profile. Your Web browser will open a page called "DB2 First Steps." This page contains many useful links to information on DB2, but it will not be used during this tutorial.

Install the DB2 business game database

1. Ensure DB2 Express-C 9 is installed.
2. Download the DB2 business game database file from the Downloads section of this tutorial.
3. Create a directory called db2game in drive C.
4. Unzip the db2game.zip file to that directory.
5. From the Windows Start menu, choose All Programs > IBM DB2 > General Administration Tools > Control Center.
6. From the menu at the top of the interface, select Tools > Command Editor. A command editor window will pop up and allow you to enter SQL statements.
7. From the menu, select Selected > Open. From the Look in drop-down menu, select C:\, and navigate to the db2game directory. From the file list, choose db2game.txt, and click OK.
8. Click on the Execute icon (the icon looks like a "Play" button).

Run the DB2 business game

In order to run the db2game.jar file, it has to be set up to open with Java Virtual Machine (JVM) software (javaw.exe, for example). To set this up:

1. Right-click on the db2game.jar file.
2. Select Properties.
3. Select the General tab.
4. Specify "Type of file" to be "Executable Jar File."
5. "Opens with" should reflect a JVM that you have locally installed on your machine. If this is not the case, click Change....
6. From the "Open With" pop-up window, locate and select your JVM software (javaw.exe, for example).
7. Click OK.
8. Click Apply.
9. Click OK.

You can now launch the db2game.jar file: Double-click on the icon, or you can create a shortcut to the file for easier access.

Create a shortcut to the DB2 business game

To create a shortcut to the db2game.jar file on your desktop:

1. Right-click anywhere on the desktop.
2. Select New > Shortcut.
3. In the field called Type the location of the item:, type
   C:\db2game\db2game.jar.
4. Click Next.
5. In the field called Type a name for this shortcut:, type db2game (it should already appear by default).
6. Click Finish.

You are now ready to play the game!

1 of 11 | Next

Comments

Back to top

Table of contents

• Before you start
• Game scenario
• Stages of the report
• Appendix A. Database schema
• Appendix B. Sample data from the Tutors table
• Appendix C. Sample data from the Log table
• Appendix D. Sample data from the Marks table
• Appendix E. Chapters covered
• Downloads
• Resources
• About the authors

---

1 of 11 | Next

Next steps from IBM

• Try: DB2 Enterprise
• Demo: Create an electronic form solution with DB2 pureXML and Lotus Forms
• Community: DB2
• Buy: DB2 Enterprise

Dig deeper into Information Management on developerWorks

Try IBM PureSystems. No charge.

Experience today!

---

Get started with the cloud-based trial and pattern development kit.