Before you start
This series is for novices who want high-level overviews of various IBM software products. The modules are designed to introduce the products, and draw your interest for further exploration. The exercises only cover the basic concepts, but are enough to get you started.
This tutorial will introduce you to some more advanced features and concepts in IBM DB2 for Linux, UNIX, and Microsoft Windows, such as database concurrency, database recovery, database security, and database configuration. The exercises will show you how to tune the database configuration, will illustrate the concept of locking and isolation level, and will demonstrate how to recover your database using DB2 recovery utilities.
This tutorial is designed for developers with little or no knowledge of DB2. Before you begin, however, you need to complete the seventh tutorial in this series, DB2 for Linux, UNIX, and Windows: Introduction to the basic features and concepts.
Before starting this tutorial, make sure DB2 Express 9 is installed. Download a no charge version of DB2 Express-C 9.
You also need to have available the database HWLD that you created in the exercises in the previous tutorial in this series.
If this is your first encounter with a developerWorks tutorial that includes demos, here are a few helpful hints:
- Demos are an optional way to see the same steps described in the tutorial. To see an animated demo, click the Show me link. The demo opens in a new browser window.
- Each demo contains a navigation bar at the bottom of the screen. Use the navigation bar to pause, exit, rewind, or fast forward portions of the demo.
- The demos are 800 x 600 pixels. If this is the maximum resolution of your screen, or if your resolution is lower than this, scrolling is necessary to see some areas of the demo.
Watch the demo before you start the associated exercise to gain a clearer understanding of the tasks at hand.