The Official Introduction to DB2 for z/OS (paperback)
Home > Computing and Information Technology > The Official Introduction to DB2 for z/OS (paperback)
The Official Introduction to DB2 for z/OS (paperback)

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

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

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

Table of Contents:
Foreword. About this book. Who Should Read This Book. Conventions and Terminology Used in This Book. How to Send Comments. Acknowledgments. I. OVERVIEW. 1. An Overview of DB2. Scenarios for Using DB2. Providing Availability and Scalability to Large Businesses. Providing Information to Decision Makers. Distributing Data and Providing Web Access. The IBM DB2 Information Management Strategy. The DB2 Universal Database Family. Enterprise Servers. DB2 UDB Editions. Clusters. More Servers. The Networks: WANs and LANs. Personal, Mobile, and Pervasive Environments. Clients. Sources of Data. Management Tools. Application Development Tools. Middleware and Client APIs. The DB2 Universal Database Family Portrait. Open Standards. SQL-Related Standards. DB2 UDB for z/Os Conformance. For More Information. Practice Exam Questions. Answers to Practice Exam Questions. 2. DB2 Concepts. Structured Query Language. DB2 Data Structures. Tables. Indexes. Keys. Views. Table Spaces. Index Spaces. Databases. Enforcement of Business Rules. Referential Integrity and Referential Constraints. Check Constraints. Triggers. Application Processes and Transactions. Packages and Application Plans. Routines. Functions. Procedures. Distributed Data. Remote Servers. Connectivity. DB2 System Structures. Catalog. Active and Archive Logs. Bootstrap Data Set. Buffer Pools. Practice Exam Questions. Answers to Practice Exam Questions. 3. DB2 UDB for z/OS Architecture. z/OS Overview. DB2 in the z/OS Environment. DB2 Lock Manager. DB2 and the z/OS Security Server. DB2 Attachment Facilities. CICS. IMS. TSO. CAF. RRS. Distributed Data Facility. The Parallel Sysplex Environment. For More Information. II. WORKING WITH YOUR DATA. 4. Designing Objects and Relationships. Logical Database Design with Entity-Relationship Model. Modeling your Data. Defining Entities for Different Types of Relationships. Defining Attributes for the Entities. Normalizing Your Entities to Avoid Redundancy. Logical Database Design with Unified Modeling Language. Physical Database Design. Denormalizing Tables to Improve Performance. Using Views to Customize What Data a User Sees. Determining What Columns to Index. For More Information. Practice Exam Questions. Answers to Practice Exam Questions. 5. Working with SQL: The Language of DB2. Executing SQL. Methods of Executing SQL. Executing SQL from Your Workstation. Writing SQL Queries to Answer Questions: The Basics. Example Tables. Selecting Data from Columns: SELECT. Processing a SELECT Statement. Accessing DB2 Data that is Not in a Table. Using Functions and Expressions. Filtering the Number of Returned Rows: WHERE. Putting the Rows in Order: ORDER BY. Summarizing Group Values: GROUP BY. Subjecting Groups to Conditions: HAVING. Merging Lists of Values: UNION. Joining Data from More Than One Table. Using Subqueries. Modifying Data. Inserting New Data. Updating Data. Deleting Data. For More Information. Practice Exam Questions. Answers to Practice Exam Questions. 6. Writing an Application Program. Using Integrated Development Environments. DB2 Development Support in Integrated Development Environments. WebSphere Studio Application Developer. DB2 Development Add-In for Visual Studio.NET. Workstation Application Development Tools. Choosing Programming Languages and Methods to Use. Preparing an Application Program to Run. Writing Static SQL Applications. Overview of Static SQL. Static SQL Programming Concepts. Writing Dynamic SQL Applications. Types of Dynamic SQL. Dynamic SQL Programming Concepts. Using ODBC to Execute Dynamic SQL. Using Java to Execute Static and Dynamic SQL. SQLJ Support. JDBC Support. Using an Application Program as a Stored Procedure. Choosing a Language for Creating Stored Procedures. Running Stored Procedures. Setting Up the Stored Procedure Environment. Preparing a Stored Procedure. -Writing and Preparing an Application to Call Stored Procedures. For More Information. Practice Exam Questions. Answers to Practice Exam Questions. 7. Implementing your Database Design. Defining Tables. Types of Tables. Table Definitions. Defining Columns and Rows in a Table. Determining Column Attributes. Choosing a Data Type for the Column. Using Null and Default Value. Enforcing Validity of Column Values with Check Constraints. Designing Rows. Defining a Table Space. General Naming Guidelines for Table Spaces. Coding Guidelines for Defining Table Spaces. Segmented Table Spaces. Partitioned Table Spaces. Large Object Table Spaces. Assignment of Table Spaces to Physical Storage. A Few Examples of Table Space Definitions. Defining Indexes. Index Keys. General Index Attributes. Partitioned Table Index Attributes. Guidelines for Defining Indexes. Defining Views. Coding the View Definitions. Inserting and Updating Data through Views. Defining Large Objects. Defining Databases. Defining Relationships with Referential Constraints. How DB2 Enforces Referential Constraints. Building a Referential Structure. Defining the Tables in the Referential Structure. Loading the Tables. Defining Other Business Rules. Defining Triggers. Defining User-Defined Functions. For More Information. Practice Exam Questions. Answers to Practice Exam Questions. 8. Managing DB2 Performance. Understanding Performance Issues. Know the Performance Requirements. Design Applications with Performance in Mind. Determine the Origin of a Performance Problem. Use the Tools Available for Performance Analysis. Moving Data Efficiently through the System. Caching Data: The Role of Buffer Pools. Compressing Data. Keeping Data Organized. Improving Performance for Multiple Users: Locking and Concurrency. How Locking Works. How to Promote Concurrency. Improving Query Performance. Access Paths: The Key to Query Performance. Query and Application Performance Analysis. Learning about Specific Performance Considerations. For More Information. Practice Exam Questions. Answers to Practice Exam Questions. 9. Managing DB2 Operations. Using Tools to Manage DB2. DB2 Control Center and Related Tools. msys for Setup DB2 Customization Center. DB2 Administration Tool. Issuing Commands and Running Utilities. DB2 Commands. DB2 Utilities. Managing Data Sets. Authorizing Users to Access Data. Controlling Access to DB2 Subsystems. Controlling Data Access: The Basics. Controlling Access to DB2 Objects through Explicit Privileges and Authorities. Controlling Access by Using Multilevel Security. Controlling Access by Using Views. Granting and Revoking Privileges. Backup and Recovery. Overview of Backup and Recovery. Backup and Recovery Tools. Regular Backups and Data Checks. Database Changes and Data Consistency. Events in the Recovery Process. Optimizing Availability during Backup and Recovery. For More Information. Practice Exam Questions. Answers to Practice Exam Questions. III. SPECIALIZED TOPICS. 10. DB2 and the Web. Web Application Environment. Components of Web-Based Applications. Architectural Characteristics of Web-Based Applications. Benefits of DB2 UDB for z/OS Server. Web-based Applications and WebSphere Studio Application Developer. XML and DB2. XML Overview. XML Use with DB2. Web Services and DB2. For More Information. 11. Distributed Data Access. Introduction to Distributed Data Access. Programming Techniques for Accessing Remote Servers. Using Explicit CONNECT Statements. Using Three-Part Names. Coding Considerations. Program Preparation Considerations. Planning Considerations. Coordination of Updates. DB2 Transaction Manager Support. Servers that Support Two-Phase Commit. Servers that Do Not Support Two-Phase Commit. Network Traffic Reduction. Coding Efficient Queries. Sending Multiple Rows in a Single Message. Optimizing for Large and Small Result Sets. Improving Dynamic SQL Performance. For More Information. 12. Data Sharing with Your DB2 Data. Advantages of DB2 Data Sharing. Improves Availability of Data. Enables Scalable Growth. Supports Flexible Configurations. Leaves Application Interfaces Unchanged. How Data Sharing Works. How DB2 Protects Data Consistency. How an Update Happens. How DB2 Writes Changed Data to Disk. Some Data Sharing Considerations. Tasks That Are Affected by Data Sharing. Availability 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. IBM DB2 UDB Certification Program. Examining the DB2 UDB Version 8 Certification Roadmap. Exploring Exam 700: DB2 UDB V8.1 Family Fundamentals. The Role of a Certified Database Associate. Certification Requirements. Exam 700 Objectives. Preparing for the Exam. Study Guidelines. Exam Information Sources. Assessment Exams. Scheduling Your Exam. Earning More Advanced Certifications. Glossary. Bibliography. Index.


Best Sellers


Product Details
  • ISBN-13: 9780768682120
  • Publisher: Pearson Education (US)
  • Publisher Imprint: IBM Press
  • Language: English
  • Weight: 885 gr
  • ISBN-10: 0768682126
  • Publisher Date: 21 Nov 2007
  • Binding: Paperback
  • No of Pages: 528


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
The Official Introduction to DB2 for z/OS (paperback)
Pearson Education (US) -
The Official Introduction to DB2 for z/OS (paperback)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

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

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!