DB2 Universal Database v7.1: Application Development Certification Guide by Steve Sanyal, Michael Kyprianou, Kevin Gashyna, David Martineau |, Multimedia Set | Barnes & Noble
DB2 Universal Database v7.1: Application Development Certification Guide

DB2 Universal Database v7.1: Application Development Certification Guide

by Steve Sanyal, Michael Kyprianou, Kevin Gashyna, David Martineau
     
 
  • Start-to-finish coverage of application development with DB2 UDB V7.1
  • Authoritative preparation for IBM's new DB2 UDB Certification Exam for Application Development!
  • Features, strategies, and interfaces — including SQL, CLI/ODBC, JDBC, and SQLj
  • Easy Web application development with Net.Data
  • DB2 Extenders: Adding

Overview

  • Start-to-finish coverage of application development with DB2 UDB V7.1
  • Authoritative preparation for IBM's new DB2 UDB Certification Exam for Application Development!
  • Features, strategies, and interfaces — including SQL, CLI/ODBC, JDBC, and SQLj
  • Easy Web application development with Net.Data
  • DB2 Extenders: Adding functionality for text, search, multimedia, and XML
  • By the DB2 experts at IBM's Toronto Lab
  • Covers every DB2 V7.1 programming interface and strategy
  • Includes practical application development troubleshooting techniques
  • Great DB2 certification preparation: Includes a complete sample exam to assist in preparation, plus CD-ROM library of programming exercises

For application developers, IBM's DB2 Universal Database Version 7.1 delivers unprecedented power and flexibility. In this book, a team of IBM experts present every skill and technique you need to build enterprise, Web, and eBusiness applications with DB2 UDB V7.1 — and gain IBM's coveted Certified Solutions Expert certification for DB2 application development!

Start by understanding the DB2 client-server environment, database objects, the role of SQL, and the basic structure of a DB2 application. Compare the multiple programming interfaces available for DB2 application development, identifying the ones most appropriate to each project. Review IBM DB2 7.1 features and strategies for maximizing application performance and scalability, and master advanced techniques such as triggers and stored procedures.

Master embedded SQL programming within DB2; development with CLI/ODBC, and OLE DB development — including Microsoft's ActiveX Data Objects (ADO). Next, take advantage of the powerful DB2 Administration and Context Management API, which allows you to handle a wide variety of database administration tasks from within your application code. Coverage also includes:

  • JDBC and SQLj: how and when to use each
  • Using IBM's Net.Data scripting language to build powerful Web applications that access data from DB2 and other sources
  • Accessing DB2 databases using Perl DBI
  • Extending DB2 functionality using DB2 Extenders: Text Extender, Net Search Extender, Audio, Image and Video Extenders, and XML Extender.

Whatever your DB2 application, whatever your environment — UNIX, Windows, or OS/2 — this is the most thorough, authoritative development guide you can find.

About the CD-ROM

The accompanying CD-ROM contains an extensive library of hands-on programming exercises, plus the complete DB2 UDB V7.1 Enterprise Edition Try-and-Buy Version, Extenders, Perl DBI drivers, OLE DB Driver, and Net.Data V7.1 (English language versions).

Editorial Reviews

Booknews
A group of IBM experts presents the skills and techniques needed to build enterprise, Web, and e-business applications with DB2 UDB V7.1 and gain the IBM Certified Solutions Expert certification for DB2 application development. CD-ROM includes a library of programming exercises, the complete DB2 UDB V7.1 Enterprise Edition Try-and-Buy Version, Extenders, Perl DBI drivers, OLE DB Driver, and Net.Data V7.1 (English language version). Annotation c. Book News, Inc., Portland, OR (booknews.com)

Product Details

ISBN-13:
9780130913678
Publisher:
Pearson Education
Publication date:
12/01/2000
Series:
IBM DB2 Series
Edition description:
BK&CD-ROM
Pages:
320
Product dimensions:
6.96(w) x 9.32(h) x 0.98(d)

Read an Excerpt

Chapter 1: Introduction to Database Applications for DB2

The relational database of choice for modern distributed applications is IBM's widely popular DB2 Universal Database (UDB). DB2 UDB V7.1 provides high-performance data access, reliability, and an abundance of advanced features. Whether your application is an e-commerce site on the Web or a directory service such as a Lightweight Directory Access Protocol (LDAP) server, the overall concepts for all database applications remain the same. Data-base applications mostly perform two major tasks, and are categorized as such. Applications that modify the contents of databases and perform transaction processing are known as Online Trans-action Processing (OLTP) applications. Applications that perform ad hoc queries to analyze the contents of databases are known as Decision Support Systems (DSS), or Online Analytical Processing (OLAP) applications.

All applications communicate with DB2 in a client/server environment using the Struc-tured Query Language (SQL) within the context of one or more programming interfaces such as embedded SQL, JDBC, and the Perl DBI (Database Interface). Different interfaces also provide additional features that you may find useful. This is why it is important to understand the options available to you as an application developer.

In this chapter, we introduce fundamental DB2 concepts and describe how applications connect to DB2 and use SQL statements to access and modify data in a DB2 UDB database. We assume that you already know about database objects such as tables and indexes, and that you are also familiar with SQL from the companion to this guide, The DB2 V7.1 Administration Certification Guide. We still cover each of these topics briefly within this chapter to ensure you have an understanding of them for the purposes of the certification exam.

You can find a complete reference for SQL and DB2 database objects in the SQL Reference, which is included among the DB2 online books. The SQL Getting Started guide is another online book that includes a good tutorial on SQL. If you require information about installing DB2, please refer to the DB2 Quick Beginnings books applicable to your environment, or read Chapter 2 of The DB2 V7.1 Administration Certification Guide.

1.1 Objectives

In each chapter, we will begin with a set of goals for the reader. These goals will describe the concepts you should be familiar with after reading the chapter and completing the exercises. After reading the first chapter, you should have a general understanding of:
  • The DB2 UDB client server environment.
  • Database objects that will be relevant to you as an application developer.
  • How SQL is used to interact with DB2 databases.
  • The common programming structure of all database applications.
We begin by giving you an understanding of how DB2 UDB V7.1 is organized.

1.2 DB2 UDB Server Instances and Databases

A database is simply an organized collection of related data. High-end Relational Database Management Systems (RDBMS) such as DB2 UDB provide an encapsulated client server environment where a persistent database server process serves requests from external client applications. Every DB2 instance is an RDBMS engine process that is uniquely named on a particular system. A DB2 database is created within the context of a specific DB2 instance. To create a DB2 database, you need to install a DB2 UDB V7.1 server product. The DB2 UDB V7.1 product packages are as follows:
  • Satellite Edition (SE) – A special RDBMS engine with a small footprint that is intended for occasionally connected systems. It will not accept incoming database requests from remote clients.

  • Personal Edition (PE) – An RDBMS engine that will not accept incoming remote database requests. Available on Windows NT, Linux, and OS/2 only.

  • Workgroup Edition (WE) – An RDBMS engine that will accept incoming database requests from remote clients. Available on Windows NT, Linux, and OS/2 only.

  • Enterprise Edition (EE) – Similar to Workgroup Edition, but also allows remote and local clients to access data on a host database such as DB2/390 or DB2/400.

  • Enterprise Extended Edition (EEE) – Similar to Enterprise Edition, with additional support for clusters of database servers in a partitioned database environment. Available on AIX, Windows NT, Solaris, and HP-UX.
Using any of these products, you can create one or more DB2 server instances. Every instance has a name unique to the system on which it is installed, and this name is specified when creating the instance. Each DB2 server instance is a separate DBMS (Database Management System) process within whose context you can create and manage one or more DB2 databases. Every instance can also be configured with regard to memory usage and other parameters in the database manager configuration and DB2 profile registry.

If your server instance has remote client functionality, you can also configure one or more network protocol listeners for the instance to accept incoming database requests from remote clients. Each server instance on a system must have a unique protocol listener. For example, if you have two server instances on your Windows NT system and you want them to be accessible to remote TCP/IP clients, you must configure each to listen on a unique TCP/IP service or port.

1.2.1 DB2 UDB Client Instances

Each DB2 UDB V7.1 product package installation also includes three common client components:
  • DB2 Runtime Client – Includes DB2 runtime libraries that allow applications to access local and remote DB2 databases.

  • DB2 Administration Client – Similar to the Runtime Client, but also provides graphical DB2 UDB administration tools, as well as additional utilities and DB2 bind files.

  • DB2 Application Development (AD) Client – Similar to the Administration Client, but provides DB2 developer tools such as the Stored Procedure Builder (SPB), program precompilers, static libraries, and numerous samples.
Figure 1-1 shows the various DB2 client and server components and their hierarchical nature. By viewing this diagram, you should be aware that DB2 client components are also present in each DB2 server instance. Thus, when we use the term "DB2 client," we may be referring to either a client-only install or the client component on a DB2 server. You can deter-mine which we are referring to based on the following definitions. All DB2 clients are freely downloadable from the official DB2 Web site.

If an application connects to a database within the same instance from which it runs, the application is known as a local client. In this case, there is no need to install an additional DB2 Runtime Client since this component is also included within the libraries of the DB2 server instance. On the other hand, if the application is installed on a system other than the DB2 UDB server, or run on a different instance on the same system, the application is known as a remote client. The DB2 Runtime Client component must be installed on each remote workstation or system executing the application.

In some cases, you may have installed a DB2 server product on one platform and will be running an application on a different platform. For example, you may have DB2 UDB V7.1 EE installed on AIX, but your SQLj applications will run on Windows NT. In this case, you will need to obtain a DB2 UDB AD client for Windows NT. When you install any DB2 UDB client on a Windows 95/98/NT workstation, a client instance called "DB2" will be automatically...

Meet the Author

Steve Sanyal is a software developer for the DB2 UDB Application Development Team at the IBM Toronto Lab. He is a certified IBM Solutions Expert as a DB2 UDB Application Developer and Administrator. Steve specializes in JDBC, SQLj, and CLI/ODBC on the UNIX and Intel platforms and is the Web sphere focal point on the team. Steve is also leading a project to develop Java and XML-based tools for troubleshooting application performance and problem determination.

David Martineau is a staff software developer at the IBM Toronto Lab, providing technical support for the DB2 UDB Application Development Team. David has provided sample code for DB2 UDB using interfaces such as ADO, CLI, and Net.Data. Prior to 1998, David was a developer within the DB2 UDB Connect group for one year, where he primarily worked on projects to enhance the performance of ODBC. Prior to joining IBM, David was developing database engines since 1994. His work includes developing support for stored procedures, user-defined functions, and 64-bit integer support.

Kevin Gashyna has been working with DB2 UDB and its predecessors since 1997. He is a certified DB2 UDB V7.1 Database Administrator, Application Developer, and Advanced Technical Expert in DRDA. Kevin is currently a staff software developer with the DB2 UDB Extended Enterprise Edition (EEE) Support Team in the IBM Toronto Lab. He has been involved in several aspects of DB2 on the UNIX and Intel platforms, including application development, connectivity, and clustered environments. Kevin also participated in the creation of the DB2 UDB V7.1 Application Development Certification Exam.

Michael Kyprianou has been working with DB2 UDB and its predecessors since 1995. He is an IBM Advanced Technical Expert in DB2 DRDA and is certified in DB2 UDB Database Administration and Application Development. Michael is currently a staff programmer analyst with the DB2 UDB Application Development Team, prior to which he was team lead for the DB2 UDB Connectivity Group for two years. In these roles, Michael provided technical marketing, electronic, and on-site support to customers all over the world. Michael has also assisted at IDUG conferences offering the DB2 UDB Certification Exam.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >