DB2 Developer's Guide

by Mullins, Craig

• ISBN13: 9780672318283
• ISBN10: 0672318288
• Edition: 4th
• Format: Hardcover
• Copyright: 2000-05-01
• Publisher: Macmillan Computer Pub

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