Sams Pub.
This comprehensive guide to DB2, written by a noted DB2 authority, is intended for database administrators and application programmers. It serves as the complete outline for implementing optimized DB2 application systems. "Covers coding, SQL, DBA, and the DB2 utilities. Includes guidelines for using query I/O Parallelism, V3 data compression, and partition independence. Provides updated information on bufferpools and SYSDDF tables". Covers Version 3.


From Book News, Inc.
New edition of a text that provides a solutions-oriented approach to learning the foundation and capabilities of the latest version of the DB2 database system. The 42 chapters describe how to master the details of DB2 for OS/390; create, administer, and manage efficient DB2 databases and applications; handle new database features of DB2 V6, including large objects, DDL and utility changes, Java, triggers, UDFs, and more; understand the fundamentals of DB2 data sharing; save time and improve performance using DB2 utilities; implement efficient dynamic and static SQL applications for DB2; build effective DB2 stored procedures and utilize them appropriately; and access DB2 data using Java.Book News, Inc.®, Portland, OR


Book Description
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


Download Description
DB2 Developer's Guide, Fourth Edition is completely revised and updated, covering all the new features for Version 6 for OS/390. It includes a special chapter on how changes to the product impact its use. This book clarifies complex DB2 topics, provides performance and procedural advice for implementing well-designed DB2 applications, and describes what DB2 does behind the scenes. An entire chapter on Internet-related features is included.

FROM THE PUBLISHER