The complete IBM DB2 UDB for z/OS Version 8 tutorial The only book that covers the DB2 Fundamentals exam from a z/OS perspective From basic relational database concepts to advanced topics such as distributed data, Web applications, and data sharing For both database administrators and developers Written and reviewed by IBM experts at the laboratory where DB2 UDB for z/OS is developed The definitive tutorial for new DB2 UDB for z/OS administrators and developers This is your complete introduction to Version 8 of DB2 UDB for z/OS, the most powerful, scalable, and robust version of DB2 ever created. Here's all you need to get started with DB2 Version 8 database administration and development ... and to prepare for the new IBM DB2 Family Fundamentals exam, your first step toward DB2 certification. From basic relational database concepts to advanced topics such as data sharing, you'll find crystal-clear explanations and real-world insights, straight from the IBM lab where DB2 UDB for z/OS is developed. Coverage includes: DB2 UDB for z/OS and the DB2 family: overview and usage scenarios Data and system structures, business rules, transactions, packages, and more DB2 UDB for z/OS: architecture, facilities, and the z/OS Security Server Introduction to logical and physical database design Defining tables, table spaces, indexes, views, large objects, business rules, and more Working with SQL, the language of DB2 Writing DB2 application programs Performance: caching, compression, locking/concurrency, and query optimization Day-to-day administration, including backup and recovery Web-based applications with DB2, WebSphere(R), and z/OS Distributing and sharing data for maximum flexibility, scalability, and availability Includes practice exam questions throughout the book