Official Introduction to DB2 for z/OS (paperback), The - Softcover

Sloan, Susan Graziano

9780768682120: Official Introduction to DB2 for z/OS (paperback), The

Softcover

ISBN 10: 0768682126 ISBN 13: 9780768682120

Publisher: IBM Press, 2004

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

"synopsis" may belong to another edition of this title.

From the Back Cover:

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

About the Author:

SUSAN GRAZIANO SLOAN is an Advisory Software Engineer at IBM Silicon Valley Laboratory, San Jose, CA, where DB2 UDB for z/OS is developed. She has been team lead of the DB2 UDB for z/OS writing team since 2001, when she co-authored An Introduction to DB2 for OS/390, which earned a Merit Award in the Society for Technical Communication's Northern California competition.

"About this title" may belong to another edition of this title.