This article reprinted courtesy of DeveloperIQ.
In this simple introduction, I will walk you through IBM's DB2 UDB v8.1 database management system. Even if you are a basic MS Access user, I'll have you up and running in no time!
We shall get started by first learning which version is right for you. If you are a developer, then you should consider:
- DB2 PERSONAL DEVELOPER EDITION 8.1 FOR LINUX, WINDOWS OR UNIX.
- DB2 UNIVERSAL DEVELOPER EDITION 8.1 FOR LINUX, WINDOWS OR UNIX.
The above editions are for development, testing and evaluation only and should not be used in a production environment.
If you are a DBA and have access to large machines in your organization, then you should consider the following editions:
- DB2 ENTERPRISE WORKGROUP EDITION
- DB2 EXTENDED ENTERPRISE SERVER EDITION
In this tutorial, I will be using DB2 Personal Developer Edition v8.1 Windows.
The system requirements for the PDE (Personal Developer Edition) are as follows.
- A Pentium-class machine of 1 GHZ or more
- 256 MB RAM (512 recommended)
- 40 GB OR 80 GB
- Windows 2000 Pro, Server, Advanced Server or XP Professional
I recommend that you install DB2 on a separate partition of your hard drive in order to avoid too much memory consumption.
Once DB2 is installed and up and running on your machine, you access DB2 via IBM DB2 --> General Administration Tools --> Control Center as the figure shows below.
@9@11@9@5xe" filled="f" stroked="f">
For those of you from Oracle or SQL Server, the Control Center is like the Enterprise Manager. First the splash window...
...then the Control Center itself.
As you can see, the Control Center is similar to any administration tool for any RDBMS in the market, thereby making it quite user-friendly. What you see under Cataloged Systems is the computer name and then the default DB2 instance. Next are the various database objects present in the DB2 database. For this article, I will focus on database creation using the Control Center and the CommandCenter (which I will take you through as well). To exit the Control Center, click File --> Exit but don't shut down the DB2 tools.
Next, let us take a look at the Command Center. To access the Command Center go to Programs --> IBM DB2 --> Command Line Tools --> Command Center.
The Command Center is similar to the Query Analyzer in SQL Server or the SQL Scratch Pad in Oracle. As you can see, it is an interactive way to perform queries. The SQL Assist button you see on your right is the button that helps people with basic knowledge of SQL to select the desired information they require from a DB2 table.
We shall now learn how easy it is to create a database using the database wizard provided in the Control Center. Look at the figure below:
The following screen appears...
I have used a database name of DEVIQ. The remaining options can be left as defaults or can be changed, which I'll cover in a later article. After you go through the various screens, click on Finish.
You can view the progress of your database creation here:
After the database creation is complete, you will get the following message:
It will ask you to perform a maintenance plan; click on no.
As you can see, our DEVDB database has been created successfully. Now wasn't that a piece of cake?! We shall explore more advanced options in the coming months.
As a good DBA, your should always make sure that you shut down all the tools once you are done with the operations of the database. The final screen will show you how to perform the shutdown operations. Click on the Control Center menu and choose Shutdown DB2 Tools.
In the coming series, I shall cover creating database objects such as tables, views, stored procedures and triggers. If you have any comments, good or bad, email me at firstname.lastname@example.org.