Official Introduction to DB2 for z/OS (paperback), The (IBM Press Series - Information Management) - Tapa blanda

Reseña del editor

The Official Introduction to DB2 UDB for z/OS provides a comprehensive overview of Version 8 of the DB2 UDB for z/OS product. The book serves a dual purpose: it gives new and prospective users a solid introduction to key product features and it covers material contained in the DB2 Family Fundamental exam, the first exam in the DB2 certification series. The book explains basic relational database concepts, the basics of the structured query language (SQL), and gives a solid overview of the various user tasks that are associated with this product. It includes introductory information about designing databases, creating relational objects, managing DB2 on a day-to-day basis, and writing application programs that use DB2 data. It also introduces new users to some of the more complex capabilities of DB2, such as, DB2 in the Web environment, distributed data, and data sharing. Introductory book for the DB2 mainframe audience, parallels Baklarz audience (ISBN 0130463612). Well-written (The Society of Technical Communication recognized the first edition of this book with a Merit award in the Northern California Technical Communication Competition.) Most current coverage of Version 8 of DB2 UDB for z/OS, the single largest release of this product since its inception in 1983-- Includes 8.2

Contraportada

• 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