DB2 Developer's Guide

by
Edition: 4th
Format: Hardcover
Pub. Date: 2000-05-01
Publisher(s): Macmillan Computer Pub
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $63.00

Rent Book

Select for Price
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

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

DB2 Developer's Guide, Fourth Edition is completely revised and updated, covering all the new features for Version 6 for OS/390. It includes a special chapter on how changes to the product impact its use. This book clarifies complex DB2 topics, provides performance and procedural advice for implementing well-designed DB2 applications, and describes what DB2 does behind the scenes. An entire chapter on Internet-related features is included.

Table of Contents

Introduction 1(2)
Preface 3(6)
Part I SQL Tools, Tips, and Tricks 9(298)
The Magic Words
11(48)
Data Manipulation Guidelines
59(44)
Using DB2 Functions
103(18)
Using DB2 User-Defined Functions and Data Types
121(30)
Data Definition Guidelines
151(92)
Using DB2 Triggers for Integrity
243(18)
Large Objects and Object/Relational Databases
261(20)
Miscellaneous Guidelines
281(26)
Part II DB2 Application Development 307(234)
Using DB2 in an Application Program
309(60)
Dynamic SQL Programming
369(26)
Program Preparation
395(56)
Alternative DB2 Application Development Methods
451(22)
Using DB2 Stored Procedures
473(30)
The Procedural DBA
503(8)
DB2 and the Internet
511(30)
Part III DB2 In-Depth 541(228)
The Doors to DB2
543(82)
Data Sharing
625(18)
DB2 Behind the Scenes
643(24)
The Optimizer
667(50)
The Table-Based Infrastructure of DB2
717(16)
Locking DB2 Data
733(36)
Part IV DB2 Performance Monitoring 769(108)
Traditional DB2 Performance Monitoring
773(50)
Using EXPLAIN
823(26)
DB2 Object Monitoring Using the DB2 Catalog
849(28)
Part V DB2 Performance Tuning 877(102)
Tuning DB2's Environment
881(26)
Tuning DB2's Components
907(60)
DB2 Resource Governing
967(12)
Part VI DB2 Utilities and Commands 979(226)
An Introduction to DB2 Utilities
981(8)
Data Consistency Utilities
989(28)
Backup and Recovery Utilities
1017(34)
Data Organization Utilities
1051(54)
Catalog Manipulation Utilities
1105(20)
Miscellaneous Utilities
1125(26)
DB2 Commands
1151(28)
DB2 Utility and Command Guidelines
1179(12)
DB2 Contingency Planning
1191(14)
Part VII The Ideal DB2 Environment 1205(78)
Components of a Total DB2 Solution
1207(52)
Organizational Issues
1259(24)
Part VIII Distributed DB2 1283(84)
DRDA
1287(12)
Distributed DB2
1299(20)
Distribution Guidelines
1319(24)
Data Warehousing with DB2
1343(24)
Part IX: Appendixes 1367(210)
A DB2 SQLCODE and SQLSTATE Values
1369(60)
B The DB2 Catalog Tables
1429(96)
C The QMF Administrative Tables
1525(6)
D DB2 Sample Tables
1531(8)
E DB2 Manuals
1539(6)
F Type 1 Indexes
1545(8)
G Valid DB2 Data Types
1553(4)
H DB2 Limits
1557(6)
I DB2 on Other Platforms
1563(6)
J Summary of V4, V5, and V6 Changes
1569(8)
Index 1577

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.