DB2(R) Express : Easy Development and Administration,9780131463974

DB2(R) Express : Easy Development and Administration

by ; ; ; ;
Edition: 1st
ISBN13: 9780131463974
ISBN10: 0131463977
Format: Hardcover
Pub. Date: 2005-01-01
Publisher(s): IBM Press
  • Free Shipping Icon

    Receive Free Shipping To The More Store!*

    *Marketplace items do not qualify for the free shipping promotion.

List Price: $54.99

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

New Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

Buy from our Marketplace starting at $37.30

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

The authoritative guide for IBM's new 'Lite' version of DB2 - a new $500 million initiative to win small-medium sized businesses.

Author Biography

Stephen O'Connell is a member of IBM's DB2 User-Centered Design Team.

Table of Contents

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 Fix Paks
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.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.