How does Fishpond Work?

Shop over a million Toys in our Huge New Range

DB2 Developer's Guide

New or Used: $95.25
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 *Implement innovative shortcuts, tips, tricks, techniques, and development guidelines to optimize all facets of DB2 development and administration *Understand the guidelines for binding DB2 application plans and packages *Use expert advice to implement distributed DB2 applications *Connect your DB2 databases to the World Wide Web *Review exhaustive coverage of V6 topics including triggers, user-defined functions, stored procedure extensions, predictive governing, hiperspace bufferpools, the REBUILD utility, the DSSIZE parameter, user-defined distinct types, auxiliary tables, and more *Read implementation information and guidance for large objects to store multimedia data such as audio, video, and images in your DB2 for OS/390 databases (BLOBs, CLOBs, DBCLOBs, and DB2 extenders) *Learn how and why to use the new EXPLAIN tables - DSN_STATEMNT_TABLE and DSN_FUNCTION_TABLE *Discover how to implement a procedural DBA function to manage triggers, stored procedures, and UDFs
Product Details

Table of Contents

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. Short Summary of DB2 V4 Through V6 Changes. Web 3. Type 1 Indexes. IX. APPENDIXES. 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. Index.

Promotional Information

Marketshare for DB2 has been growing steadily over the past 5 years and with the announcement of DB2 Universal Database V8 (T-Rex), the product has never had more momentum. DB2 owns about 30 percent of the database market--the same as Oracle. Not only is the product used in many Fortune 500 companies, but it is becoming very popular in small to medium sized businesses as well. This book provides the reader with a comprehensive reference and research tool for DB2 for the mainframe. Official material is awkwardly written, spans over a dozen manuals in PDF format, and lacks real-world guidance. Author, Craig Mullins, consistently hears from readers of past editions that they rely on this book as their primary reference for DB2. Craig Mullins is constantly being asked when it will support a new release. "This is an excellent book . . . It is chock full of DB2 technical information, design and tuning approaches and database administration guidelines . . .Mullins seems to have dumped his entire DB2 life experience into DB2 Developer's Guide."- Jonathon Sayles in Relational Database Journal.

About the Author

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.

How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling DB2 Developer's Guide on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond World Ltd.
Back to top