DB2 Developer's Guide

Front Cover
Sams Publishing, 1992 - Database management - 1130 pages
0 Reviews
Written for technical users of DB2, this reference book provides hard-to-find information about this database. Packed with tips and experience-based techniques, this book also delivers information on coding efficient SQL, monitoring, and tuning DB2 performance.

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

SQL Tools Tips and Tricks 1
3
m
11
Complex SQL
23
Definition of DB2 Data Structures
31
Dynamic SQL
37
Data Manipulation Guidelines
47
Synopsis
69
Miscellaneous Guidelines 235
135
DB2 Performance Tuning
577
Tuning DB2s Components
607
DB2 Resource Governing
649
DB2 Utilities and Commands
659
Backup and Recovery Utilities
693
Data Organization Utilities
721
Catalog Manipulation Utilities
751
DB2 Commands
791

DB2 Application Development
149
Dynamic SQL Programming
211
Program Preparation
233
Program Preparation Using Multiple Methods
251
Alternative DB2 Application Development Methods
277
DB2InDepth
289
DB2 Behind the Scenes
385
What Makes DB2 Tick
397
The Optimizer
403
Locking DB2 Data
461
DB2 Performance Monitoring
479
Using EXPLAIN
531
DB2 Object Monitoring Using the DB2 Catalog
553
DB2 Utility and Command Guidelines
817
DB2 Contingency Planning
829
The Ideal DB2 Environment
843
Organizational Issues
905
Appendixes
929
The QMF Administrative Tables
1023
DB2 Sample Tables 2033
1033
E DB2 Manuals 2042
1042
F Valid DB2 Data Types 2 069
1069
H One VIEW Per Base Table? Dont Do It 2075
1075
Index 2083
1083
Copyright

Other editions - View all

References to this book

About the author (1992)

Mullins is vice president of Marketing and Operations for the database tools division of PLATINUM technology, inc. He graduated cum laude with a degree in Computer Science and Economics from the University of Pittsburgh.

Bibliographic information