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

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.

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.