Slutsåld
DB2 Developer's Guide is the field's #1 go-to source for on-the-job information on programming and administering DB2 on IBM z/OS mainframes. Now, three-time IBM Information Champion Craig S. Mullins has thoroughly updated this classic for DB2 v9 a...
The purpose of this book is to give advice and direction to Db2 application developers and programmers on writing efficient, well-performing programs. If you write code and access data in a Db2 database, then this book is for you. The methods outl...
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 is a regular lecturer at industry conferences and also frequently writes for computer industry publications.
Introduction.
I. SQL TOOLS, TIPS, AND TRICKS.
1. The Magic Words.
2. Data Manipulation Guidelines.
3. Using DB2 Functions.
4. Using DB2 User-Defined Functions and Data Types.
5. Data Definition Guidelines.
6. DB2 Indexes.
7. Database Change Management and Schema Evolution.
8. Using DB2 Triggers for Integrity.
9. Large Objects and Object/Relational Databases.
10. DB2 Security and Authorization.
II. DB2 APPLICATION DEVELOPMENT.
11. Using DB2 in an Application Program.
12. Dynamic SQL Programming.
13. Program Preparation.
14. Alternative DB2 Application Development Methods.
15. Using DB2 Stored Procedures.
16. The Procedural DBA.
17. DB2 and the Internet.
III. DB2 IN-DEPTH.
18. The Doors to DB2.
19. Data Sharing.
20. DB2 Behind the Scenes.
21. The Optimizer.
22. The Table-Based Infrastructure of DB2.
23. Locking DB2 Data.
IV. DB2 PERFORMANCE MONITORING.
24. Traditional DB2 Performance Monitoring.
25. Using EXPLAIN.
26. DB2 Object Monitoring Using the DB2 Catalog and RTS.
V. DB2 PERFORMANCE TUNING.
27. Tuning DB2's Environment.
28. Tuning DB2's Components.
29. DB2 Resource Governing.
VI. DB2 PERFORMANCE UTILITIES AND COMMANDS.
30. An Introduction to DB2 Utilities.
31. Data Consistency Utilities.
32. Backup and Recovery Utilities.
33. Data Organization Utilities.
34. Catalog Manipulation Utilities.
35. Stand-alone Utilities and Sample Programs.
36. DB2 Commands.
37. DB2 Utility and Command Guidelines.
38. DB2 Contingency Planning.
VII. THE IDEAL DB2 ENVIRONMENT.
39. Components of a Total DB2 Solution.
40. Organizational Issues.
VIII. DISTRIBUTED DB2.
41. DRDA.
42. Distributed DB2.
43. DB2 Connect.
44. Distribution Guidelines.
45. Data Warehousing with DB2.
ON THE WEB.
Web 1. Special Consideration for DB2 Version 6.
Web 2. Shor...