DB2 Universal Database for OS/390

DB2 Universal Database for OS/390 : An Introduction to DB2 OS390 Version 7

3 (1 rating by Goodreads)
By (author)  , By (author) 

List price: US$54.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


This book will be written for people who are new to the DB2 product. The readers/users will be migrating from desktop systems or coming from other popular database systems such as Oracle. Many will be also coming from other operating systems such as Windows and UNIX.show more

Product details

  • Paperback | 480 pages
  • 179.3 x 235.2 x 25.1mm | 1,133.99g
  • Pearson Education (US)
  • IBM Press
  • Armonk, United States
  • English
  • 013019848X
  • 9780130198488

Back cover copy

Specially designed for new usersUp-to-date information for Version 7 of DB2 for OS/390 Written and reviewed at the IBM lab where DB2 for OS/390 is developed Foreword by DB2 for OS/390 Architect Roger Miller DB2 for OS/390: concepts, architecture, and fundamental skillsPractical application coverage includes Web and distributed environmentsDay-to-day administration and performance optimization Spurred by DB2's powerful capabilities and performance, thousands of new users are working with DB2 on OS/390 mainframes for the first time. Now, IBM delivers an authoritative guide to DB2 in OS/390 environments for every new and prospective user. "An Introduction to DB2 for OS/390" covers all you need to know, from relational database and SQL fundamentals to design, development, deployment, administration, and optimization. Start with an overview of the DB2 for OS/390 applications and key components and how DB2 for OS/390 fits into IBM's overall data management strategy. Understand DB2 for OS/390's fundamental concepts and architecture, including databases, tables, and SQL. Next, master key skills for effective development, including object and relationship design, coding techniques, and transforming designs into effective applications. "An Introduction to DB2 for OS/390" presents extensive coverage of day-to-day database administration and performance optimization tasks in mainframe environments, as well as advanced techniques for using DB2 for OS/390 in distributed and Web-centered environments. Coverage includes: Current features and capabilitiesKey DB2 for OS/390 tools for rapid deployment, easy administration, and enhanced performanceGuidance on data modeling for relational databasesInformation about advanced topics such as data sharingReferences to even more detailed information on every key topic Whether you're a developer, administrator, manager, student, or end user, if you're new to DB2 for OS/390, this is the book to start with. And if you've worked with DB2 for OS/390 before, you can benefit from having this book as a quick reference on a variety of DB2 topics.show more

About Susan Graziano Sloan

Susan Sloan is a programmer and database administrator at IBM's Santa Teresa Laboratory in San Jose, CA, where DB2 for OS/390 was developed; Ann Kilty Hernandez is a technical writer there. They both have extensive experience working with DB2 in communications and marketing roles.show more

Table of contents

I. OVERVIEW. 1. An overview of DB2. Scenarios for using DB2. The IBM data management strategy. The DB2 Universal Database family. Open standards. For more information.2. DB2 concepts. Structured query language. DB2 data structures. Enforcing business rules. DB2 system structures.Application processes and transactions. Packages and application plans. Distributed data.3. DB2 for OS/390 architecture. OS/390 overview. DB2 in the OS/390 environment. DB2's lock manager. DB2 and the SecureWay Security Server for OS/390. DB2's attachment facilities. Distributed data facility. The Parallel Sysplex environment. For more information.II. WORKING WITH YOUR DATA. 4. Designing objects and relationships. Logical database design. Physical database design. For more information.5. SQL: The language of DB2. Executing SQL. Writing SQL queries to answer questions: the basics.Putting the rows in order: ORDER BY. For more information.6. Writing an application program. Using integrated development environments. What programming languages and methods can you use? Preparing an application program to run. Static SQL applications. Dynamic SQL applications. Using Java to execute static and dynamic SQL. Using ODBC to execute dynamic SQL. Using an application program as a stored procedure. For more information.7. Implementing your database design. Defining your tables. Defining columns and rows in a table. Defining a table space. Defining databases. Defining your views. Defining indexes. Defining relationships with referential constraints. Defining large objects. Defining other business rules. For more information.8. Managing DB2 performance. Understanding performance issues.Know the performance requirements. Moving data efficiently through the system. Improving performance for multiple users: Locking and concurrency. Improving query performance. Other performance considerations. For more information.9. Managing DB2 operations. Tools for managing DB2. Issuing commands and running utilities. Managing data sets. Authorizing users to access data. Backup and recovery.Database changes and data consistency. For more information.III. SPECIALIZED TOPICS. 10. DB2 and the Web. Architectural characteristics of Web applications. Server-side programming on the Web. Application servers on the Web. Web products and tools. Using XML. For more information.11. Accessing distributed data. Introduction to accessing distributed data. Programming techniques for accessing remote servers. Coordinating updates. Minimizing network messages. For more information.12. Data sharing with your DB2 data. Advantages of DB2 data sharing.Improves availability of data. How data sharing works. Some data sharing considerations. For more information.IV. APPENDIXES. Appendix A. Example tables in this book. Employee table. Department table. Project table. Employee-to-project activity table. Products table. Parts table.Appendix B. Notices. Trademarks.Appendix C. Glossary. Appendix D. Bibliography. Index.show more

Rating details

1 ratings
3 out of 5 stars
5 0% (0)
4 0% (0)
3 100% (1)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X