Résumé
A guide to DB2 for developers and administartors this text
is intended to serve as the blueprint for implementing
optimized DB2 application systems. The book shows readers
how to build high-performance DB2 application systems;
administer and support large DB2 databases; create an
optimal organization for supporting and using DB2
proactively; and monitor and tune DB2 subsystems and
programs. This third edition is completely updated to
include the following topics: Latest versions of DB2 on MVS
and versions 4 and 5; using stored procedures; data
sharing; Sysplex check constraints; enhanced utilities;
temporary tables; dynamic SQL; and security enhancements.
Accessing DB2 via the World Wide Web, ODBC, CICS, TSO, IMS,
and the Call Attach Facility are also covered. This book
targets Database Administrators and Developers who seek to
understand the way DB2 works in.
Table of contents :
Introduction ..... xxxi
I SQL Tools, Tips, and
Tricks
- 1 The Magic Words ..... 3
2 Data Manipulation Guidelines ..... 47
3 Data Definition Guidelines ..... 81
4 Miscellaneous Guidelines ..... 157
II DB2 Application
Development
- 5 Using DB2 in an Application Program ..... 183
6 Dynamic SQL Programming ..... 235
7 Program Preparation ..... 257
8 Alternative DB2 Application Development Methods ..... 307
9 Using DB2 Stored Procedures ..... 327
10 DB2 and the Internet ..... 349
III DB2 In-Depth
- 11 The Doors to DB2 ..... 373
12 Data Sharing ..... 453
13 DB2 Behind the Scenes ..... 467
14 The Optimizer ..... 485
15 The Table-Based Infrastructure of DB2 ..... 529
16 Locking DB2 Data ..... 543
IV DB2 Performance
Monitoring
- 17 Traditional DB2 Performance Monitoring .....
577
18 Using EXPLAIN ..... 623
19 DB2 Object Monitoring Using the DB2 Catalog ..... 645
V DB2 Performance Tuning
- 20 Tuning DB's Environment ..... 673
21 Tuning DB's Components ..... 697
22 DB2 Resource Governing ..... 747
VI DB2 Utilities and
Commands
- 23 An Introduction to DB2 Utilities ..... 757
24 Data Consistency Utilities ..... 765
25 Backup and Recovery Utilities ..... 787
26 Data Organization Utilities ..... 815
27 Catalog Manipulation Utilities ..... 861
28 Miscellaneous Utilities ..... 881
29 DB2 Commands ..... 903
30 DB2 Utility and Command Guidelines ..... 929
31 DB2 Contingency Planning ..... 939
VII The Ideal DB2
Environment
- 32 Components of a Total DB2 Solution ..... 955
33 Organizational Issues ..... 1017
VIII Distributed DB2
- 34 DRDA ..... 1043
35 Distributed DB2 ..... 1055
36 Distribution Guidelines ..... 1071
37 Data Warehousing with DB2 ..... 1095
IX Appendixes
- A DB2 SQLCODE and SQLSTATE Values ..... 1119
B The DB2 Catalog Tables ..... 1167
C The QMF Administrative Tables ..... 1237
D DB2 Sample Tables ..... 1243
E DB2 Manuals ..... 1249
F Valid DB2 Data Types ..... 1271
G DB2 Limits ..... 1273
H Regional DB2 User Groups ..... 1279
I DB2 on Other Platforms ..... 1299
J Summary of Version 4 and Version 5 Changes ..... 1305
Index ..... 1309
L'auteur - Craig S. Mullins
Craig S. Mullins
is Director of DB2 Technology Planning for BMC Software, Inc. He has extensive experience in all facets of database systems development, including systems analysis and design, database and system administration, data analysis, and developing and teaching DB2 and Sybase classes. Craig has worked with DB2 since Version 1 and has experience in multiple roles, including programmer, DBA, instructor, and analyst.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Sams |
| Auteur(s) | Craig S. Mullins |
| Parution | 21/10/1997 |
| Nb. de pages | 1395 |
| EAN13 | 9780672311680 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
