Book description
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
Table of contents
- Copyright
- IBM Press Series—Information Management
- About Prentice Hall Professional Technical Reference
- Foreword
- About this book
- Overview
-
Working with your data
- Designing objects and relationships
- Working with SQL: The language of DB2
-
Writing an application program
- Using integrated development environments
- Choosing programming languages and methods to use
- Preparing an application program to run
- Writing static SQL applications
- Writing dynamic SQL applications
- Using ODBC to execute dynamic SQL
- Using Java to execute static and dynamic SQL
- Using an application program as a stored procedure
- For more information
- Practice exam questions
- Answers to practice exam questions
-
Implementing your database design
- Defining tables
- Defining columns and rows in a table
- Defining a table space
- Defining indexes
- Defining views
- Defining large objects
- Defining databases
- Defining relationships with referential constraints
- Defining other business rules
- For more information
- Practice exam questions
- Answers to practice exam questions
-
Managing DB2 performance
- Understanding performance issues
- Moving data efficiently through the system
- Improving performance for multiple users: Locking and concurrency
- Improving query performance
- Learning about specific performance considerations
- For more information
- Practice exam questions
- Answers to practice exam questions
- Managing DB2 operations
- Specialized topics
- Appendixes
- Glossary
- Bibliography
- Index
Product information
- Title: Official Introduction to DB2® for z/OS®, The, 2nd Edition
- Author(s):
- Release date: May 2004
- Publisher(s): IBM Press
- ISBN: 9780131477506
You might also like
book
DB2® Version 8: The Official Guide
IBM DB2 Universal Database v8.1.2 will help you access any information, from any application, from anywhere …
book
DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition
IBM's definitive guide to writing DB2 SQL PL stored procedures, triggers, UDFs, and dynamic compound SQL …
book
DB2® Universal Database for OS/390® Version 7.1 Certification Guide
IBM's definitive, authoritative DB2 for OS/390 and z/OS reference and self-study guide! The only comprehensive IBM(r) …
book
Modernizing Applications with IBM CICS
IBM® CICS® is a mixed language application server that runs on IBM Z®. Over the 50 …