The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Hello World: DB2 for Linux, UNIX, and Windows

Introduction to basic features and concepts, Part 2

Claire Hong, Advisory Software Developer, IBM Toronto Lab

Claire Hong is a Software Developer with eight years experience at IBM Toronto Software Development Lab, working on the design, implementation, performance tuning and L3 advanced support of DB2 database kernel areas including index, recovery, and locking. From DB2 Version 6 to Version 9, she has delivered features such as Async Index Cleanup, Online Index Creation, Online Index Reorg, HADR Index Support, as well as numerous index performance tuning features. Currently, Claire is working for the DB2 Continuing Engineering Team, Kernel area, and is responsible for Index Manager as well as Data Protection Service components. Her most recent interests are to transfer her DB2 knowledge to external DB2 user communities and help improve the DB2 user experience.

Renata Kupresak, Staff Software Developer, IBM Toronto Lab

Renata Kupresak is a Software Developer for DB2 currently working in the FVT Kernel team where she is responsible for Quality Assurance of different product components. Prior to that she worked on the Data Movement team where she was the component owner of Import and Export Utilities. She was also involved in introducing XML support for these utilities. Renata graduated from York University with a Bachelor in Science, Combined Honours in Computer Science and Applied Mathematics as well as Bachelor of Education in Intermediate/Senior Division.

Summary: This tutorial is the second part of the introduction to DB2® on Linux®, UNIX®, and Microsoft®Windows® platforms. You'll learn how to configure DB2 databases, how locking and isolation levels work within DB2, and how to recover a corrupted database. (You might want to read Part 1 before continuing.) You'll learn about how to configure DB2 databases, how locking and isolation levels work within DB2, and how to recover a corrupted database.

View more content in this series

Date: 30 Jan 2007
Level: Introductory
PDF: A4 and Letter (439 KB | 31 pages)Get Adobe® Reader®

Activity: 9115 views
Comments:

Before you start

About this series

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.

About this tutorial

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.

Prerequisites

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.

System requirements

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.

To view the demos included in this tutorial, enable JavaScript in your browser and install Macromedia Flash Player 6 or higher. Download the latest Flash Player at http://www.macromedia.com/go/getflashplayer/.

Animated demos

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.