- Shopping Bag ( 0 items )
Learn the best techniques and tricks from expert author Craig Mullins. Apply these real-world pieces of advice, undocumented tips, solutions, projects, and techniques to your own database management system. Mullins gives you what you need to take your DB2 development to the next level.
Written by a developer for developers, DB2 Developer¿s Guide, Fifth Edition provides a solutions-oriented approach to learning the foundation and capabilities of this latest version of the world¿s number one database management system.
LEARN THE CONCEPTS AND BUILD THE APPLICATIONS
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.
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. Short Summary of DB2 V4 Through V6 Changes.
Web 3. Type 1 Indexes.
Appendix A. DB2 Sample Tables.
Appendix B. DB2 Tools Vendors.
Appendix C. Valid DB2 Data Types.
Appendix D. DB2 Limits.
Appendix E. DB2 on Other Platforms.
Appendix F. DB2 Version 7 Overview.
Appendix G. DB2 Version 8 Overview.
Appendix H. Reorganizing the DB2 Catalog.
Posted November 2, 2004
[A review of the 5th EDITION 2004.] IBM invented relational databases and its DB2 is one of the company's core technologies. While it trails Oracle in market share, the capabilities as shown here by Mullins are probably at least the equal of Oracle's 10g. This book is designed for a full time DB2 administrator or developer, who needs an extensive reference on it. It's fair to say that you would not want to learn the theory of relational databases from this book. Sadly, there is only one, passing reference to E F Codd, in the context of normalisation of data. Minimal acknowledgment of the founder of relational modelling. Seek a learning of theory elsewhere. Instead, the book focuses on all the options built into DB2. By now, possibly person-centuries of IBM's programmer sweat have gone int this latest version 8. You can take advantage of this accrued expertise. Though the time needed to absorb a chapter may be nontrivial.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted April 15, 2002
This is an excellent reference. If you truly want to understand the workings of DB2 you need this book in your library. It will give you the indepth details. However,it is not a book for showing you how to do something. There are other books more suitable for that.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted May 11, 2001
This is a great book packed with lots of information on DB2 and also SQL. Although its not a SQL book it has some good examples of real world scripts. Good reference for any programmer who uses DB2, beginner or experienced.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted May 31, 2000
The latest edition of Craig Mullins DB2 Developers Guide updated to include V6. This is an excellent reference book covering all aspects of DB2. A must for anyone working with DB2. Highly recommended.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.