![DB2 Universal Database v7.1: Application Development Certification Guide](http://prodimage.images-bn.com/pimages/9780130913678_p0_v1_s192x300.jpg)
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 /li>/li>/li>/li>
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
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.
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.
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.
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...
Customer Reviews
Average Review: