ISBN:0130913677From the Inside Flap
Preface
Welcome to the DB2 UDB (Universal Database) V7.1 Application Development Certification Guide for IBM's popular relational database servers. Whether you intend to become an IBM Certified Professional, or are looking for a hands-on resource for developing applications for DB2, read on. This book is an entirely new publication in the DB2 UDB Certification Series, and replaces the application development chapters in the previous editions of the DB2 UDB Certification Guide. Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of each chapter. We also provide exercises and examples with this book, to develop hands-on skills with database development.
Since the focus of this book is developing database applications, it also serves as a companion to the DB2 UDB V7.1 Administration Certification Guide. However, we will also cover the fundamentals of the DB2 client/server environment, database objects, and the Structured Query Language (SQL).Organization
This book consists of ten chapters and several appendices. Each chapter has a set of objectives that are presented at the beginning. We also provide additional resources for many chapters when applicable. Here is a summary of the contents of this book:
Chapter 1 Introduction to Database Applications for DB2—Introduces you to the DB2 client/server environment, database objects, SQL, and the basic structure of a database application.
Chapter 2 DB2 Programming Roadmap—Discusses the various programming interfaces that you can use to develop applications with DB2.
Chapter 3 DB2 Programming Features and Strategies—Explores features and strategies that you can use to maximize your performance, and how to utilize DB2's advanced features such as triggers and stored procedures.
Chapter 4 Embedded SQL Programming—A guide to embedded SQL programming within DB2.
Chapter 5 Administration API—A discussion of the DB2 administrative and context management APIs that allow you to perform tasks such as back up, restore, and load from within your application code.
Chapter 6 CLI/ODBC and OLE DB Programming—We examine the DB2 CLI/ODBC driver and also discuss programming in OLE DB (Oblect Linking and Embedding Database), using interfaces such as ADO (ActiveX Data Objects).
Chapter 7 Java Programming—A detailed discussion of JDBC and SQLj, and how to use each. We also discuss how to write Java stored procedures and User-Defined Functions (UDFs).
Chapter 8 Net.Data—An introduction to programming with an easy-to-use Web application development environment provided with DB2.
Chapter 9 Perl Programming—Discusses writing Perl scripts to access DB2 databases using the Perl DBI (Database Interface).
Chapter 10 DB2 Extenders—A guide to extending DB2 functionality using DB2 Extenders products. This includes Text Extender, Net Search Extenders, Audio, Image, and Video (AIV) Extenders, and XML Extender.
Appendix A Test Objectives
Appendix B Sample Exam
Appendix C DB2MALL Database
Appendix D Troubleshooting Techniques
Exercises are provided for many of the chapters on the companion CD-ROM. Unfortunately, due to time constraints, we were not able to provide these exercises in the book. Please be sure to examine the CD-ROM for the exercises and samples, which illustrate many DB2 features that we discuss in this book.Certification Exam
This book can be used as a self-study guide to prepare for the DB2 UDB Certification Exam for Application Development.
Experience with DB2 UDB V7.1 is the best way to prepare for any of these certification exams. The exam for DB2 UDB focuses on general concepts covered in this book. We have included additional detail for your benefit, but this is not needed for the exam.NoteMore information about DB2 UDB certification can be found at ibm/certify.Contents of CD-ROM
We have included a CD-ROM with DB2 trial software and additional development tools. Please refer to the readme.txt file on the CD-ROM for details on each item. Included on the CD-ROM are the following software packages:
DB2 UDB V7.1 Enterprise Edition Try-and-Buy Version
DB2 UDB V7.1 Text Extender
DB2 UDB V7.1 Net-Search Extender
DB2 UDB V7.1 Audio, Image, and Visual Extenders
DB2 UDB V7.1 XML Extender
DB2 Perl DBI Driver, DBD::DB2 Version 0.73
DB2 OLE DB Driver
Net.Data V7.1
To fit all of these packages onto a single CD-ROM, we only included the U.S. English versions of each piece of software. In addition, we included chapter-specific samples and exercises under the Book directory structure.DB2 Mall Database
We created a database for an online mall to be used with this book. The name of the database is DB2MALL, and in Appendix C, we describe how to create this database. We also provide a description of all the tables. All of our samples and exercises reference this database, so please familiarize yourself with it. We simplified many of the tables for simplicity and clarity.Using the DB2 Online Books
Throughout this book, we will often refer to the DB2 online books that are installed with every DB2 product. They can also be downloaded in PDF format from the DB2 Product and Service Technical Library at:software.ibm/data/db2/library
These books provide a wealth of information about configuring and using DB2. Take advantage of them, since they are provided for free. If you are not sure where to look for an answer to a question, there is also a search feature provided with the online books, which is also available on the above Web site.
We will often refer you to the DB2 online books for further background, to allow us to concentrate on more detailed explanations of other topics and to describe advanced concepts.DB2 Resources on the Internet
Here are several resources on the Internet that are invaluable for DB2 documentation and product support:Sites
Official DB2 site at IBM:
software.ibm/data/db2
DB2 Technical Library:
software.ibm/data/db2/library
International DB2 Users Group:
idug
DB2 Magazine:
db2magFTP
DB2 Fixpaks:
ftp://ftp.software.ibm/ps/products/db2/fixes
DB2 Tools:
ftp://ftp.software.ibm/ps/products/db2/tools
DB2 Extenders Fixpaks:
ftp://ftp.software.ibm/ps/products/db2extenders/fixes/
news.software.ibm
ibm.software.db2.scholars
ibm.software.db2.udb.eee
ibm.software.db2.udb.windows2000
Usenet
comp.databases.ibm-db2How This Book Was Created
The four authors of this book are DB2 service analysts at the IBM Toronto Lab. From our experience with tackling thousands of questions and technical problems from DB2 customers, we strived to put together a publication that will help readers reduce the learning curve of DB2. In addition, using our experience with the DB2 UDB product, we have demonstrated useful techniques and highlighted features that will increase the functionality and performance of your database applications.
Most of the material in this book is newly written; however, some of the contents include updated portions from the DB2 UDB V6.1 Certification Guide.About the Authors
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 technic/p>
Reviews From AMAZON.COM
Better than Nothing
Unfortunately, this seems to be the only book available to specifically prepare for this exam. While the material is probably covered, the examples and practice test (which is identical to the online practice test at ICE) in this book are so much easier than the actual exam, that I felt I was ready for the real exam when I got scores over 90 on the practice exam, but flunked the real one. Sybex knows how to do certification books right, but they don't have any for DB2.
Certification Guaranteed!
This book made the difference between a PASS/FAIL on the IBM-514 DB2 UDB V7.1 Family Application Development exam. I have extensive experience in developing DB2 applications on the OS/390 platform but none in the Linux/Unix/Windows environments. Having taken the sample certification exam I knew I needed to "bone-up" on the JDBC/SQLJ, CLI/ODBC and dynamic sql topics to guarantee a first-time pass. Personally, I concentrated on the corresponding chapters in this book (3 through 7) and this proved more than sufficient to make the grade. If your goal is to pass the 514 exam and you already feel comfortable with developing DB2 SQL applications then I would strongly suggest limiting your study purchases to this book. Incidentally, good luck in the exam (if applicable)!