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
3.137.187.233