Jump Start of DB2 Database Part1

Some Features of DB2:

1.    DB2 is a multi-platform scalable, object-relational database server.
2.    This tutorial is for people with little or no experience with DB2.
3.    DB2 GUIS Over-View.
4.    Step by Step approach of how to accomplish some of the most important database tasks.
5.    Database tasks can be achieved in various ways, in this tutorial, the focus is on using the GUI tools
6.    Glossary is provided at the end, for the terms used in DB2.

Key Capabilities and Benefits

1.   Superior scalability
a.   DB2 Universal Database can run on everything from laptops supporting mobile users to massively parallel systems with terabytes of data and/or thousands of users.
2.   Multimedia extensibility
3.   It allows to extend the capabilities of the database to meet your specific organizational requirements. This includes the ability to support more advanced applications involving multimedia data such as documents, images, audio, video, and spatial data.
4.   Complete web-enablement
5.   One of the key new application areas is e-business. DB2 Universal Database is fully integrated with web technology so that data can be easily accessed from the Internet or from the company intranet
6.   Universal access
DB2 Universal database can be accessed from almost any client workstation over almost any network.
7.   Multi-platform support
DB2 Universal database is one of the most open database platforms available. It runs on the most popular UNIX and Intel server platforms, including AIX, HP-UX, Solaris, Linux, NUMA-Q, OS/2, and Windows.

IBM DB2 - Menus

After you have installed DB2,these are various options you will see if you go to IBM DB2 in the main programs. To reach the various GUIS, go to All Programs IBM DB2Various options.

The Command Editor

This tool allows the user to input SQL statements or DB2 commands in an interactive window and see the results.

Development Center
Currently for class-projects you wont need to use the Development center as this is the tool that the administrator uses it to create stored-procedure or UDF (User define function). It is used for creating objects, the source code is copied on the server and the object is registered in the catalog table. when a Java object is built, it is complied on the Client application.

Control Center
This is without a doubt the most important DB2 GUI tool. It provides you with a whole picture of your instances and databases, and allows the user to perform most database operations in DB2.

Health Center
Use the Health Center GUI tool to set up thresholds that, when exceeded, will prompt alert notifications, or even actions to relieve the situation. In other words, you can have the database manage itself!

Configuration Assistant
If a user has DB2 UDB installed on the desktop in College Station, but would like to connect to a DB2 Server in Germany. How can the user connect to this remote server? The Configuration Assistant GUI tool can help with the set up and testing of the connection,