Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 1, 2008

Understanding DB2: Learning Visually with Examples - Page 6

By DatabaseJournal.com Staff

1.9 IBM WebSphere Federation Server and WebSphere Replication Server

IBM WebSphere Federation Server provides federated support by making remote data sources from IBM or different vendors appear as if they were part of the same database. The Federation server uses wrappers to communicate with and retrieve data from those other data sources; it encapsulates any conversions required from the source database and presents them to the target database as tables.

IBM WebSphere Replication Server provides replication support from one data server to another, even if they are not part of the IBM family. Replication Server includes both Q-replication and SQL replication (SQL replication is free with DB2 Enterprise).

IBM WebSphere Federation and Replication server software were formerly called WebSphere Information Integrator.

1.10 Special Package Offerings for Developers

The Database Enterprise Developer's Edition (DEDE) provides developers with a package that includes several DB2 editions and features, Informix products, and DB2 Connect. This package is offered at a reduced price, and is restricted to the development, evaluation, demonstration, and testing of application programs. The package is licensed on a per developer basis.

1.11 DB2 Syntax Diagram Conventions

DB2 supports a comprehensive set of statements for data access and manipulation. These state-ments are documented online in the DB2 Information Center, which gives you access to all information about DB2 as well as major DB2 features and components. It can be conveniently accessed by using a browser, as shown in Figure 1.15. The DB2 Information Center is also available at http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp.

Figure 1.15
The DB2 Information Center

You can find the syntax of any commands or statements we introduce in this book in the DB2 Information Center. Understanding how to read the syntax diagrams will help you use the numerous options available with many of the statements.

Syntax diagrams are all read from left to right and top to bottom, following the path of each line. Table 1.6 summarizes a few of the most commonly used symbols in a syntax diagram.

Table 1.6 Summary of Some Symbols Used in Syntax Diagrams




Indicates the beginning of a syntax diagram.


Indicates that the syntax is continued on the next line.


Indicates that the syntax is continued from the previous line.


Indicates the end of a syntax diagram.

When a mandatory field is required, it appears on the horizontal line (the main path) like this.


Optional fields appear below the main path.


If an optional field appears above the main path, it means that it is the default option.


If two or more mandatory choices are available, one of the mandatory choices will appear in the main path, and the rest will appear in a stack. You must choose one of these options.


An arrow returning to the left, above the main line, indicates an option can be repeated. In this example, repeated options are separated by one or more blanks.

           V                   |

If the repeat arrow contains a comma, you must separate repeated items with a comma.

           V                 |

You should now feel comfortable reading syntax diagrams in the DB2 documentation. Browse through the DB2 online documentation and review some examples there.

1.12 Case Study

John recently graduated from Pennsylvania State University, where he learned DB2 as part of the IBM Academic Initiative program, a program that provides DB2 and other IBM software for free to teach database skills.

While at school, he worked with a DB2 Enterprise Server Edition installed on a System p machine at the university computer lab. He was given SYSADM authority, and was able to see connections from many different clients to all created databases using the list applications command. John wanted to develop a Java application using the JDBC Type 4 driver, so he downloaded and installed on his laptop the 90-Day Try-and-Buy version of DB2 Personal Edition. With this edition, he was able to build, test, and run his application and connect to the database created on his laptop. Since the client and data server were both on his laptop, he was dealing with a local client connection.

John wanted to test whether his application would work as a remote client, so he used the client software that comes with DB2 Personal Edition to test his application against the database he had created earlier on the university's System p machine. This also worked, and John was feel-ing like a DB2 guru.

Eager to show his program to his colleagues, he e-mailed the executable to his friend Peter, who had just bought a new laptop with Microsoft Windows Vista installed. Peter detached the file and tried to run the application against John's database on the University's pSeries server. After spending a few hours trying to figure out why he couldn't, he dropped by John's place. John realized that Peter had to download and install either an IBM Data Server Runtime client, an IBM Data Server client, or just the IBM Data Server JDBC and SQLJ driver, as he needed the JDBC Type 4 driver on his laptop. Given that Peter was neither going to develop a new program nor administer a database, John asked Peter to download just the IBM Data Server JDBC and SQLJ driver from the IBM Web site, and after installation, voil !, the program successfully ran. Peter then asked John to perform the test from his laptop against the database on John's laptop, but John said it would not work because he had installed DB2 Personal Edition, which is not a database server, and it cannot accept inbound remote client connections.

After the graduation ceremony, John received a PDA as a gift from his dad. His dad had heard John praise DB2, so he had had DB2 Everyplace installed on the PDA. Since John was going to take six months off to travel before looking for a job, John decided to take his PDA with him rather than his laptop. John's account at the university was going to be active for the next eleven months, so while he was traveling he could connect to his "old" database on the System p server and use his application (which he had installed on his PDA) to transfer information about all the friends he met and places he visited during his trip. This way he was able to save information in another place should he lose his PDA.

After his trip, John applied for a position at a medium-sized company in his hometown. To prepare for his interview, John again tested the program he had written against his laptop database, but the Try-and-Buy evaluation period had expired. John figured that he would always need DB2 on his laptop, so he decided to buy the permanent license. When John received the license file after the purchase, he installed it on his laptop with the command db2licm -a filename. Once this problem was resolved, John demonstrated his program during the job interview and was immediately hired.

Company ABC, which was using DB2 Workgroup Server Edition, asked John to modify his application so that it would connect to a DB2 for z/OS host machine. John responded that he did not need to make any modifications, but since DB2 Workgroup Server Edition does not come with the DB2 Connect software component, the company could purchase this software, or get the Database Enterprise Developer Edition (DEDE), as it would be cheaper and has most of the software for all DB2 editions. DEDE is licensed per developer, and this company did not have that many developers, so DEDE was good for them. If Company ABC wanted to use DB2 in a production environment, they would not be able to use DEDE, but would have to buy the appropriate edition and license.

Company ABC was also interested in the DB2 Express-C Edition, because it was free, and one of their applications needed a database to be embedded as part of their solution. Other than John, there were not many skilled DB2 personnel in the company, so DB2 Express-C was also ideal because of its ease-of-use features. John indicated that whilst DB2 Express-C was free, it would not have 24/7 IBM support unless the 12-month subscription license was purchased. Without this license, questions could be posted in a free community-based forum, but community participation was voluntary.

Three months after John was hired, he was promoted. John is well on his way to a very success-ful career with DB2!

1.13 Summary

This chapter introduced DB2 and its history. IBM pioneered relational database management systems and invented SQL. IBM's technology in the relational database management system area has been around for more than twenty years. Its legacy is visible in the Information Management product line that includes database management software, data warehousing and business intelligence software, enterprise content management and discovery software, and information integrator software.

This chapter also discussed the types of clients and servers available with DB2. Although different editions are available to provide varying functionality, the core DB2 product is the same; therefore, application development on any edition will work on all editions. The various editions allow you to choose the functions that best suit your needs.

In addition, the chapter explained federated support, replication, the WebSphere Federation Server, the WebSphere Replication server, and packaging options available for application developers. These packaging options allow developers to obtain DB2 software at a reduced price.

1.14 Review Questions

  1. IBM added the term "Universal" to the DB2 name with Version 5 of the product. Why was this term added?

  2. Which five software brands support the IBM on-demand strategy?

  3. Can an application developed for DB2 Personal Edition work with DB2 Enterprise Server Edition?

  4. Is DB2 Connect required to connect from a DB2 for z/OS client to a DB2 for Linux, UNIX, and Windows server?

  5. What is the term used to describe DB2 9's unique support for XML?

  6. Is IBM WebSphere Federation server required to set up a federation environment between a DB2 server and an Informix server?

  7. Provide an example when replication support may be required.

  8. Does DB2 for Linux, UNIX, and Windows have one single file that is used for installa-tion in any of these platforms?

  9. What does the Database Partitioning Feature (DPF) allow you to do?

  10. What should you do when your Try-and-Buy license period expires and you would like to buy a permanent license?

  11. Which of the following products is the minimum required on the Windows client to run a DB2 application accessing a DB2 database on UNIX?

    1. DB2 Enterprise

    2. DB2 Personal Edition

    3. DB2 Connect

    4. IBM Data Server Runtime Client

  12. Which of the following products is the minimum required to run a DB2 application using JDBC Type 4?

    1. IBM Data Server Client

    2. IBM Data Server Runtime Client

    3. Data Server Driver for JDBC and SQLJ

    4. Data Server Client

  13. Which of the following products does not allow applications to connect to its databases from remote clients?

    1. DB2 Express

    2. DB2 Personal Edition

    3. DB2 Enterprise Server Edition

    4. DB2 Workgroup

  14. Which of the following products is not considered a DB2 server?

    1. DB2 Workgroup Server Edition

    2. DB2 Express-C

    3. DB2 Personal

    4. DB2 Enterprise

  15. Which of the following DB2 clients provide the DB2 graphical administration tools?

    1. Thin client

    2. IBM Data Server client

    3. Thick client

    4. IBM Data Server Runtime client

  16. Which of the following DB2 editions is the most appropriate for sales personnel who need a basic database to store contacts and business leads made during business trips?

    1. DB2 Everywhere

    2. DB2 Satellite Edition

    3. DB2 Everyplace

    4. DB2 Personal Edition

  17. A software development company would like to test an application that connects to both DB2 for LUW as well as DB2 for z/OS. Which of the following would suit its needs the best?

    1. DB2 Enterprise Server Edition

    2. DB2 Workgroup Server Edition

    3. DB2 Connect Enterprise Edition

    4. DEDE

  18. Which of the following data servers can run on a System z server?

    1. DB2 for Linux, UNIX, and Windows

    2. DB2 for iSeries

    3. DB2 Connect

    4. IBM Websphere Information Integrator

  19. Which of the following products allows ten clients to connect from DB2 LUW to DB2 for z/OS?

    1. Database Enterprise Developer's Edition

    2. DB2 Universal Developer's Edition

    3. DB2 PE

    4. DB2 LUW

  20. Which of the following products can be used to collect, prepare, and analyze your data to allow you to make better business decisions?

    1. DB2 Content Manager

    2. DB2 Warehouse Manager

    3. IBM DB2 WebSphere Federation Server

    4. DB2 LUW


[1] Distributed platforms, also referred to as open system platforms, include all platforms other than main-frame or midrange operating systems. Some examples are Linux, UNIX, and Windows.

Check out the new IBM Press Special Promotion for DB2 and Information Management Books including a free 200-page eBook for download.

Understanding DB2: Learning Visually with Examples, 2nd Edition
Authors: Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
Publisher: IBM Press
Pub Date: December 29, 2007
Print ISBN-10: 0131580183
Buy this book

Copyright © 2007 Pearson Education. All rights reserved.

DB2 Archives