Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
-
All (9)
from
$1.99
-
-
Used (9)
from
$1.99
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since Sat Jan 01 01:01:01 EST 2011
Used books may not include access codes or one time use codes. Proven Seller with Excellent Customer Service. Choose expedited shipping and get it FAST.
Ships from: Conway, AR
Usually ships in 1-2 business days
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$1.99
Seller since Tue Oct 07 09:36:38 EDT 2014
Book has some visible wear on the binding, cover, pages. Biggest little used bookstore in the world.
Ships from: Reno, NV
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$1.99
Seller since Sun Jan 01 01:01:01 EST 2006
Shows some signs of wear, and may have some markings on the inside. 100% Money Back Guarantee. Shipped to over one million happy customers. Your purchase benefits world literacy!
Ships from: Mishawaka, IN
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$1.99
Seller since Sun Jan 01 01:01:01 EST 2006
Great condition for a used book! Minimal wear. 100% Money Back Guarantee. Shipped to over one million happy customers. Your purchase benefits world literacy!
Ships from: Mishawaka, IN
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$1.99
Seller since Sun Jan 01 01:01:01 EST 2006
Former Library book. Shows definite wear, and perhaps considerable marking on inside. 100% Money Back Guarantee. Shipped to over one million happy customers. Your purchase
...
benefits world literacy!
Read more
Show Less
Ships from: Mishawaka, IN
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$1.99
Seller since Thu Jan 01 01:01:01 EST 2009
Our feedback rating says it all: Five star service and fast delivery! We have shipped four million items to happy customers, and have one MILLION unique items ready to ship today!
Ships from: Toledo, OH
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$1.99
Seller since Sun Jan 01 01:01:01 EST 2006
Some wear on book from reading, some spine creases, wear on binding and pages, we guarantee all purchases and ship all items via USPS mail.
Ships from: Toledo, OH
Usually ships in 1-2 business days
- •Standard, 48 States
- •Standard (AK, HI)
$12.99
Seller since Tue Oct 07 09:42:27 EDT 2014
Buy with Confidence. Excellent Customer Support. We ship from multiple US locations. No CD, DVD or Access Code Included.
Ships from: Fort Mill, SC
Usually ships in 1-2 business days
$14.95
Seller since Fri Sep 05 22:29:11 EDT 2014
Upper Saddle River, NJ 2000 Trade paperback Good. Trade paperback (US). Glued binding. 480 p. Contains: Illustrations. IBM DB2 Certification Guides.
Ships from: Pueblo West, CO
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
More About This Textbook
Overview
Foreword by DB2 for OS/390 Architect Roger Miller
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:
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.
Editorial Reviews
Booknews
Data processing professionals, whether developers, managers, administrators, students, or end users new to DB2 for OS/390, are the desired audience here. DB2 for OS/390, its applications, key components, and how it fits into IBM's overall data management strategy are described before key concepts and architecture are introduced, including databases, tables, and SQL. Based on this, object and relationship design, coding techniques, and transforming designs into effective applications are described, with guidance provided for data modeling for relational databases, information on data sharing, and extensive references for further information. The authors are affiliated with IBM. Annotation c. Book News, Inc., Portland, OR (booknews.com)Product Details
Related Subjects
Meet the Author
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.
Read an Excerpt
About this book
This book provides a comprehensive introduction to IBM DB2 Universal Database(TM) for OS/390. It explains the basic concepts that are associated with relational database management systems in general, and with DB2 Universal Database for OS/390 in particular.
Part One of the book begins with "Chapter 1. An overview of DB2." This chapter describes how different types of organizations use DB2 Universal Database for OS/390 and the other products in the DB2 Universal Database family. You will also read about the many other products that work with DB2 Universal Database for OS/390 to contribute to the IBM data management strategy.
"Chapter 2. DB2 concepts" provides an overview of relational database concepts. You will read about SQL, the language you use to access data in DB2. You will also learn about databases and tables, which are key structures that store DB2 data.
The next chapter, "Chapter 3. DB2 for OS/390 architecture," explains some of the other products that coexist with DB2 in the OS/390 environment.
Part Two of the book provides introductory information about a variety of tasks that DB2 users perform. You can read some or all of these chapters, depending on your areas of interest and your needs:
Part Three of the book provides information about some specialized topics, inparticular:
Most chapters in this book conclude with a list of useful citations to Web information and books that provide the next level of detail. (The only exception is "Chapter 2. DB2 concepts," which doesn't have this section because every topic it introduces is also explained in more detail in subsequent chapters.) For example, "Chapter 4. Designing objects and relationships" gives an overview of the task of designing a database and concludes with a list of references to more advanced database design information. In some cases, these sections also provide references to similar information about DB2 in other operating systems (such as Windows(R), AIX(R), OS/2(R), OS/400(R), VM, and VSE).
"Appendix A. Example tables in this book" shows you the example DB2 tables that this book uses to illustrate different concepts.
After reading this book, you will understand basic concepts about DB2, and you will know where to look for additional details about individual topics that this book describes.
Who should read this book
If you are new to DB2 for OS/390, this book is for you. Perhaps you have worked with DB2 on other operating systems (Windows, AIX, OS/2, OS/400, VM, or VSE). Perhaps you have worked on non-IBM database management systems (DBMSs) or on the IBM hierarchic DBMS, which is called Information Management System (IMS). Perhaps you have never worked with DBMSs, but you want to work with this product, which many companies use for mission-critical data and application programs. Regardless of your background, if you want to learn about DB2 for OS/390, this book will help you.
If you will be working with DB2 for OS/390 and already know what specific job you will have, begin by reading Part One (Chapters 1 through 3). Then, you can consider what your role will be when you choose to read all or only a subset of the remaining chapters. For example, assume that you know you will be a database administrator (DBA) for an organization that has some distributed applications and is beginning to plan for e-business. In this case, you would probably want to read at least Chap-ters 4, 7, 10, and 11.
The authors of this book assume that most readers are data processing professionals.
How to send your comments
Your feedback helps IBM to provide quality information. If you have any comments about this book:
- Send your comments from the Web. Visit the following Web site, which has a feedback page that you can use to send comments:
- Send your comments by e-mail to
- Send a letter with your comments. Be sure to include the title of the book, the order number of the book, and the version of DB2 for OS/390. If you are commenting on specific text, please list the location of the text (for example, a page number or table number). Mail the form to:
IBM Corporationwww.ibm.com/software/db2os390db2pubs@vnet.ibm.com. Be sure to include the title of the book, the order number of the book, and the version of DB2 for OS/390. If you are commenting on specific text, please list the location of the text (for example, a page number or table number).Department HHX/H3
P.O. Box 49023
San Jose, CA 95161-9023
U.S.A.
If you are sending your letter from a country other than the United States, give it to your local IBM branch office or IBM representative for mailing.
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.
Preface
About this book
This book provides a comprehensive introduction to IBM DB2 Universal Database(TM) for OS/390. It explains the basic concepts that are associated with relational database management systems in general, and with DB2 Universal Database for OS/390 in particular.
Part One of the book begins with "Chapter 1. An overview of DB2." This chapter describes how different types of organizations use DB2 Universal Database for OS/390 and the other products in the DB2 Universal Database family. You will also read about the many other products that work with DB2 Universal Database for OS/390 to contribute to the IBM data management strategy.
"Chapter 2. DB2 concepts" provides an overview of relational database concepts. You will read about SQL, the language you use to access data in DB2. You will also learn about databases and tables, which are key structures that store DB2 data.
The next chapter, "Chapter 3. DB2 for OS/390 architecture," explains some of the other products that coexist with DB2 in the OS/390 environment.
Part Two of the book provides introductory information about a variety of tasks that DB2 users perform. You can read some or all of these chapters, depending on your areas of interest and your needs:
Part Three of the book provides information about some specialized topics,inparticular:
Most chapters in this book conclude with a list of useful citations to Web information and books that provide the next level of detail. (The only exception is "Chapter 2. DB2 concepts," which doesn't have this section because every topic it introduces is also explained in more detail in subsequent chapters.) For example, "Chapter 4. Designing objects and relationships" gives an overview of the task of designing a database and concludes with a list of references to more advanced database design information. In some cases, these sections also provide references to similar information about DB2 in other operating systems (such as Windows(R), AIX(R), OS/2(R), OS/400(R), VM, and VSE).
"Appendix A. Example tables in this book" shows you the example DB2 tables that this book uses to illustrate different concepts.
After reading this book, you will understand basic concepts about DB2, and you will know where to look for additional details about individual topics that this book describes.
Who should read this book
If you are new to DB2 for OS/390, this book is for you. Perhaps you have worked with DB2 on other operating systems (Windows, AIX, OS/2, OS/400, VM, or VSE). Perhaps you have worked on non-IBM database management systems (DBMSs) or on the IBM hierarchic DBMS, which is called Information Management System (IMS). Perhaps you have never worked with DBMSs, but you want to work with this product, which many companies use for mission-critical data and application programs. Regardless of your background, if you want to learn about DB2 for OS/390, this book will help you.
If you will be working with DB2 for OS/390 and already know what specific job you will have, begin by reading Part One (Chapters 1 through 3). Then, you can consider what your role will be when you choose to read all or only a subset of the remaining chapters. For example, assume that you know you will be a database administrator (DBA) for an organization that has some distributed applications and is beginning to plan for e-business. In this case, you would probably want to read at least Chap-ters 4, 7, 10, and 11.
The authors of this book assume that most readers are data processing professionals.
How to send your comments
Your feedback helps IBM to provide quality information. If you have any comments about this book:
- Send your comments from the Web. Visit the following Web site, which has a feedback page that you can use to send comments:
- Send your comments by e-mail to
- Send a letter with your comments. Be sure to include the title of the book, the order number of the book, and the version of DB2 for OS/390. If you are commenting on specific text, please list the location of the text (for example, a page number or table number). Mail the form to:
IBM Corporationwww.ibm.com/software/db2os390db2pubs@vnet.ibm.com. Be sure to include the title of the book, the order number of the book, and the version of DB2 for OS/390. If you are commenting on specific text, please list the location of the text (for example, a page number or table number).Department HHX/H3
P.O. Box 49023
San Jose, CA 95161-9023
U.S.A.
If you are sending your letter from a country other than the United States, give it to your local IBM branch office or IBM representative for mailing.