DB2 Express Easy Development and Administration (paperback)

by Yip, Paul; Cheung, Kit Man; Gartner, Jason; Liu, Clara; O'Connell, Stephen J

Edition: 1st

ISBN13: 9780137020812

ISBN10: 0137020813

Format: Paperback

Pub. Date: 2004-09-28

Publisher(s): IBM Press

Availability: This title is currently not available.

Other versions by this Author

This Item Qualifies for Free Shipping!*

*Excludes marketplace orders.

List Price: ~~$59.99~~

Rent Book

Select for Price

Add to Cart

There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

This authoritative guide for IBM's new "Lite" version of DB2--a new $500 million initiative to win small-medium sized businesses--teaches best practices for developing GUI driven applications using the most popular languages in the industry: Java and Microsoft Visual Basic.

Author Biography

Paul Yip is a database consultant at IBM Canada. As a member of IBM s Channel and Partner Enablement Team, he works closely with partners, ISVs, and integrators to develop and tune third-party products for DB2. He coauthored DB2 SQL Procedure Language for Linux, UNIX and Windows (Prentice Hall, 2003) with Clara Liu.

Kit Man Cheung, member of IBM's DB2 Tools Development Team, has deep technical insight into DB2 Version 8.2's new GUI tools.

Jason Gartner, member of IBM's DB2 Tools Development Team, has deep technical insight into DB2 Version 8.2's new GUI tools. He is Development Manager for DB2 administration tools.

Clara Liu is a database consultant at the IBM Toronto Lab. She works with a variety of IBM partners and customers on projects utilizing DB2 Universal Database.

Stephen O'Connell, member of IBM's DB2 User-Centered Design Team, has worked on the DB2 Web client and many other IBM-wide DB2 initiatives.

Dedication and Acknowledgments
Foreword
DB2 Express Book Web Site
Introduction
About This Book
Who Should Read This Book
What Is DB2 Express?
What's Cool about DB2 Express v8.2
Learning Objectives
Book Conventions
Book Web Site 7
Getting Started
Introduction
Installing DB2 Express
First Steps
DB2 Graphical Tools
Creating a Database
DB2 Command Editor
DB2 Information Center
Supplemental: Installing DB2 Clients from a Server CD
Summary
The L8NITE Database Application
Introduction
Late Night Convenience Store Requirements
The Data Model
The Point-of-Sale Application Interface
Summary
Database Objects
Introduction
Schemas
Data Types
Tables
Retrieving Data from the Database
Table Relationships
Views
Indexes
Supplemental
Altering the Definition of a Table
Summary
Chapter Exercises
Visual Basic .NET Application Development
Introduction
What Are .NET and ADO.NET?
.NET Support in DB2
A Tour of DB2 Tools in Visual Studio .NET 2003
Getting Started with the L8NITE Application
Adding the DB2 .NET Data Provider Reference
Establishing a Database Connection
Executing Queries
Displaying Data in the User Interface
Making Changes to Data in the Database
Learning More about DataSet, DataTable, and DataRow
Controlling a Transaction
Catching Errors with Exception Handlers
Troubleshooting Using DB2 CLI Tracing
Summary
Exercises
Java Application Development
Introduction
Why Java?
JDBC in DB2
Designing a Java Application
Building the Application Using JDBC
Retrieving Data Using SQLJ
Online Resources
Summary
Exercises
Maximizing Concurrency
Introduction
Transactions
DB2's Concurrency Model
Transaction Design
Improving the User Experience
Summary
Exercises
Working with Functions, Stored Procedures, and Triggers
Introduction
The DB2 Development Center
User-Defined Functions
Stored Procedures
Triggers
Supplemental: Creating UDFs, Stored Procedures, and Triggers Using VS.NET
Summary
Exercises
Working with Data
Introduction
The LOAD and IMPORT Utilities
Generating Sample Data
Generating Large Data Sets Using LOAD FROM CURSOR
Exporting Data
Importing DB2 Data into Spreadsheets
Creating Reports Using Microsoft Excel
Summary
Exercises
Performance Tuning
Introduction
Performance Tuning
Optimizing Configuration Using the Configuration Advisor
Analyzing SQL Using Visual Explain
Optimizing SQL Performance with the Design Advisor
Summary
Chapter Exercises
Implementing Security
Introduction
Database Users
Defining the SYSADM Authority
Application Users
Authentication and Authorization
Group Privileges
The PUBLIC Group
Authentication Modes
Data Encryption
Data Communications Encryption
Summary
Deploying to Production
Introduction
Extracting DDL from the Database
Scripting
Important Deployment Considerations
Supplemental: Implementing Silent DB2 Installation
Summary
Automating Maintenance in Production
Introduction
Database Operational View
Backups
Disaster Recovery
Database Log Management
Table Reorganization
Statistics
Notification and Contact List
Automating and Scheduling Maintenance
Health of the Database
Storage Management
Supplemental: High Availability and Disaster Recovery
Summary
Exercises
Troubleshooting Tools
Introduction
Interpreting Error Codes
DB2 Defects and Applying FixPaks
The DB2 Administration Server
DB2 Journal
Activity Monitor
Diagnosing Locks
Event Monitors
Other Sources of Help
Summary
Development Center
Introduction
Installing the DB2 Development Center
Using the Development Center for the First Time
Development Center Views
Customizing the Development Center
Running Procedures
Debugging Stored Procedures
Working with Projects
Summary
Index
Table of Contents provided by Publisher. All Rights Reserved.