Gain DB2 Universal Database Certification!
Includes demonstration program covering new product features
Preparation for v7.1 Fundamentals and Database Administration Certification Exams
Contains many useful tips, techniques and guidelines for DB2 administrators and developers
The only comprehensive reference guide for DB2 UDB V7.1 certification
CD-ROM contains trial version of DB2 UDB V7.1 for Windows NT, Windows 2000, and Windows 95/98
Written by DB2 experts in IBM's Toronto Lab
The #1 guide and reference for IBM's powerhouse DB2 UDB V7.1 database
New DB2 UDB V7.1 features for all platforms: UNIX, Linux Windows, and OS/2!
Complete coverage for database administrators and application developers!
Sample test questions to assist in your preparation for IBM's new DB2 UDB V7.1 exams

IBM's DB2 Universal Database Version 7.1 for UNIX, Windows, and OS/2 delivers unprecedented power, scalability, e-business support, and much more! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V7.1 — and preparing for IBM's updated DB2 UDB V7.1 certification exam!

This is IBM's definitive guide and reference for the newest, most powerful version of DB2 Universal Database ever: Version 7.1. DB2 Universal Database v7.1 for UNIX, Linux, Windows, and OS/2 Database Administration Certification Guide, Fourth Edition delivers end-to-end coverage for every DB2 UDB developer and administrator, on every platform: Windows, UNIX, or OS/2 — including the most complete IBM DB2 UDB certification review you can find.

IBM DB2 experts present a detailed overview of the DB2 UDB family of products, key DB2 concepts, and terminology, plus in-depth coverage of installation, configuration, networking, security, data integrity, optimization, and more. Coverage includes:

DB2 administration: populating tables with import and load utilities, monitoring, logging, maintenance, and tuning
Security: Controlling data access through authentication, assigned authorities, user/group privileges, and more
Database backup and recovery, step-by-step
DB2 SQL, in depth: database objects, Data Definition Language (DDL), Data Manipulation Language (DML), triggers, outer joins, OLAP SQL, table hierarchies, concurrency, and embedded SQL

Whether you're deploying DB2 UDB V7.1, managing DB2 UDB V7.1, preparing for DB2 UDB V7.1 certification, or all three, The DB2 Universal Database v7.1 for UNIX, Linux, Windows, and OS/2 Database Administration Certification Guide, Fourth Edition will be your single most valuable resource.

About the CD

The CD contains a trial version of DB2 UDB v7.1 for Windows NT, Windows 2000, and Windows 95/98. The CD also includes the demo program DB2DEMO, which enables you to demonstrate and use various SQL features of DB2.



Sample Content

Downloadable Sample Chapter

Click here for a sample chapter for this book: 0130913669.pdf

I. INTRODUCTION TO DB2 UDB.

1. Product Overview.

DB2 and e-business. DB2 Universal Database. DB2 Enterprise Edition. DB2 Workgroup Edition. DB2 Enterprise - Extended Edition. DB2 Personal Edition. DB2 Satellite Edition. DB2 Everyplace. DB2 Connectivity. DB2 Universal Database Clients. DB2 Connect. DB2 Replication. DB2 Net.Data. DB2 Relational Connect. DB2 DataJoiner. IBM WebSphere Application Server. DB2 Application Development. DB2 Universal Developer's Edition. DB2 Stored Procedure Builder. DB2 Relational Extenders. DB2 OLAP Server Starter Kit. DB2 Data Warehouse Center. DB2 Warehouse Manager. DB2 Data Links Manager. DB2 Administration. Control Center. Other Tools Available from the Control Center. Wizards. The Command Line Processor (CLP). Visual Explain. Summary.

2. Getting Started.

Product Installation. Windows and OS/2 Installation. UNIX and Linux Installation. DB2 Client Installation. Distributed Installation. The DB2 Environment. DB2 Profile Registry. Environment Variables. Using the Command Line Processor. DAS and DB2 Instances. DB2 Administration Server (DAS) Instance. DB2 Instances. Using First Steps. Summary.

3. Getting Connected.

Roadmap to Distributed Communications. DB2 Discovery. Automated Configuration Using Discovery. Automated Configuration Using Access Profiles. Manual Configuration. DB2 Directories. Examining DB2 Directories. Configuring DB2 Clients. Automated Configuration Using Discovery. Using Access Profiles. Manual Configuration. Summary of Configuring Connections. Configuring Communications. Configuring the DB2 Instance for Communications. Configuring the DAS Instance. Configuring DB2 Discovery. Binding Utilities. Binding Utilities Using the CCA. Instance Administration. Local Instance Administration. Attaching to an Instance Using the Control Center. Summary.

4. Controlling Data Access.

Security. Overview of Security. Authentication. Authorities and Privileges. Windows NT/2000 Considerations. Auditing. Summary.

II. USING SQL.

5. Database Objects.

Understanding Database Objects. Data Types. Tables. Schemas. Table Spaces. Views. Indexes. Packages. Buffer Pools. Transactions. Locks. Log Files. Creating a DB2 Database. Managing Database Objects. Using SQL Data Definition Language (DDL). Data Types. Tables. Views. ZIndexes. Database Design and Implementation. DB2CERT Database Table Descriptions. Define User-Defined Data Types. Defining Columns. Keys. Defining Primary Keys. Defining Unique Keys. Defining Foreign Keys. Summary.

6. Manipulating Database Objects.

Data Retrieval. Retrieving the Entire Table. Projecting Columns from a Table. Changing the Order of the Columns. Restricting Rows from a Table. Predicate Evaluation for UDTs. Restricting Rows Using Multiple Conditions. Selecting Columns from Multiple Tables. Using Correlation Names. Sorting Your Output. Derived Columns. DB2 Functions. Grouping Values. Eliminating Duplicates. Searching for String Patterns. Searching for Data in Ranges. Searching for Null Values. Searching for Negative Conditions. Searching for a Set of Values. Sub-Queries. Quantified Predicates. Case Expressions. Nested Table Expressions. Scalar Fullselect. Common Table Expressions. Set Operators. Data Modification. Inserting Data Records. Updating Data Records. Removing Data. View Classification. Deletable Views. Updatable Views. Insertable Views. Read-Only Views. Inoperative Views. Summary.

7. Advanced SQL.

Triggers. Trigger Usage. Trigger Activation. Trigger Example (After Trigger). Trigger Example (Before Trigger). Recursive SQL. Outer Join. Left Outer Join. Right Outer Join. Full Outer Join. Combining Outer Joins. OLAP Features. STAR Schemas. OLAP Indexes. STAR Joins. Super Grouping. Moving Functions. Advanced CASE Expressions. Using CASE Expressions to Group Values. Using CASE Expressions in Functions. Structured Types and Typed Tables. Creating Structured Types. Altering Structured Types. Creating Typed Tables. Dropping Typed Tables. Inserting Rows into a Typed Table. Selecting a Row from a Typed Table. Updating and Deleting Rows from Typed Tables. Physical Implementation of Typed Tables. Reference Columns. View Hierarchies. SQL Functions for Typed Tables and Typed Views. TYPE Predicate. Considerations When Using Typed Tables and Views. Examples of a Typed Table Hierarchy. Summary Tables. Creating a Summary Table. CURRENT REFRESH AGE Special Register. Considerations of Using Summary Tables. System Catalog Information for Summary Tables. Summary.

8. Concurrency.

Concurrency. Concurrency Considerations. Isolation Levels. Uncommitted Read. Cursor Stability. Read Stability. Repeatable Read. Choosing an Isolation Level. Locking. Lock Attributes. Lock Conversion. Lock Escalation. Lock Wait Behavior. Lock Table Statement. LOCKSIZE parameter of ALTER TABLE statement. Summary.

III. DB2 UDB ADMINISTRATION.

9. Data Storage Management.

Processor, Memory, and Disk Resources. Processors. Memory. Disk. DB2 Storage Model. Buffer Pool. Table Spaces. Containers. Table Space Design. Regular Table Space. Long Table Space. System Temporary Table Space. Extentsize. Pagesize. Performance Considerations. Long Field Data. Large Object Data. Implementation Examples. Creating a Database. Creating Buffer Pools. Creating Table Spaces. Creating Tables. Dropping Table Spaces. Dropping Buffer Pools. Dropping a Database. Creating Table Spaces Using the Control Center. Table Space Maintenance. Database Files. Listing Table Spaces. Listing Table Space Containers. Table Space States. System Catalog Information About Table Spaces. Adding Containers to DMS Table Spaces. Summary.

10. Maintaining Data.

Moving Data. Delimited ASCII Files. Non-Delimited ASCII Files. PC/IXF Files. Worksheet Format Files. Data Movement Utilities. The Export Utility. The IMPORT Utility. The Load Utility. The LOAD QUERY Command. The SET INTEGRITY Statement. The DB2MOVE Utility. The DB2LOOK Utility. Data Maintenance. Analyzing Data's Physical Organization. Table Reorganization. Generating Statistics. The Rebind Utility. Data Maintenance Process. Modeling a Production Environment. Summary.

11. Database Recovery.

Database Recovery Concepts. Unit of Work. Transaction. Types of Recovery. Crash Recovery. Version Recovery. Roll-Forward Recovery. Recovery Strategies. Recoverable and Nonrecoverable Databases. Online and Offline Access. Use of Log Files. Log Buffers. Primary and Secondary Log Files. Types of Logging. Log File Usage. Version Recovery Using Backup and Restore. Roll-Forward Recovery. Managing Log Files. Other Recovery Considerations. Summary.

12. Monitoring and Tuning.

Elements of Performance. Tuning Guidelines. Performance Improvement Process. How Much Can a System Be Tuned? A Less-Formal Approach. DB2 Architecture Overview. Process Model. Query Parallelism. DB2 Memory Usage. SQL Compiler Overview. DB2 Sorting Methods. Database Monitoring. Obtaining Database Access Information. Database Monitors. Snapshot Monitoring. Event Monitoring. Visual Performance Monitors. DB2 Governor. SQL Monitoring. Explain Tables. Gathering Explain Data. Examining Explain Data. Guidelines on Using Explain Output. Index Advisor Facility. Configuring Database Resources. Configuring Intra-Partition Parallelism. Performance Tuning Scenario. Diagnostics and Problem Determination. Error Messages and SQL Codes. Tracing Problems in DB2 Universal Database. Summary.

IV. DEVELOPING APPLICATIONS.

13. Application Development Overview.

DB2 Application Development Environment. Software Requirements. DB2 Programming Interfaces. Embedded SQL. Call Level Interface and ODBC. Java Interfaces (JDBC and SQLJ). Native DB2 APIs. Microsoft Data Objects (DAO, RDO, ADO, OLE-DB). Other Interfaces and Tools. Summary.

14. Development Considerations.

Embedded SQL Overview. Creating Packages. Binding Applications. Support for CLI and ODBC Programming. Embedded Dynamic Versus Call Level Interface. ODBC Versus CLI. Setting Up the CLI Environment. Support For Java Programming. JDBC Programming. SQLJ Programming. Stored Procedure Builder. Summary.

15. Development SQL.

User-Defined Functions. SQL-Bodied Scalar Functions. SQL-Bodied Table Functions. Structured Datatypes. Schemas and Aliases. Schema. Alias. COMMIT and ROLLBACK. Summary.

V. APPENDICES.

DB2 UDB V. Certification Test Objectives.
DB2 Family Fundamentals (512).
DB2 for OS/2, Windows, and UNIX Database Administration (513).
Sample Questions (Fundamentals - Exam 512).
Sample Questions (Administration - Exam 513).
Answers.
CD-ROM Installation.
DB2DEMO.
Index.

Preface

This book is a complete guide to the IBM's relational database servers, known as DB2 Universal Database Version 7.1. DB2 Universal Database (DB2 UDB) Version 7.1 is available on many operating systems, and the book has been written with this in mind. Any significant differences in the implementation of DB2 UDB on various operating systems are highlighted. If you are planning to become certified, or you would simply like to understand the powerful new DB2 UDB database servers from IBM, then read on. Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of this book.

The book is divided into four parts:

Part 1—Introduction to DB2 UDB (Chapters 1-4).: Installing and configuring DB2 UDB servers and clients are covered in Chapters 1, 2, 3, and 4.
Part 2—Using SQL (Chapters 5-8).: The Structured Query Language (SQL) is discussed in Chapter 5, 6 and 7. Database concurrency is discussed in Chapter 8.
Part 3—DB2 UDB Database Administration (Chapters 9-12).: Creating a DB2 UDB database and its related table spaces is covered in Chapter 9. The common administration tasks are discussed in Chapters 10 and 11. Database monitoring and performance considerations are discussed in Chapter 12.
Part 4—Developing Applications with DB2 UDB (Chapters 13-14).: An introduction to application development for DBAs is given in Chapter 13. Chapter 14 deals with some of the DBA activities that are related to application development. SQL used in a programming environment is discussed in chapter 15.

This book can be used as a self-study guide to help you prepare for the DB2 Universal Database V7.1 certification exams or as a guide to DB2 Universal Database V7.1.

The test objectives are provided in Appendix A. These should be used as a guide to ensure that you are fully prepared to take the DB2 UDB V7.1 exams.

Experience with DB2 Universal Database Version 7.1 is the best way to prepare for any of these DB2 UDB V7.1 certification exams. Use this Certification Guide in conjunction with your day-to-day use of DB2 UDB V7.1 to assist you in preparing for exams 512 and 513. A companion book, DB2 Universal Database Version 7.1 Application Development Certification Guide, will help you prepare for exam 514.

The DB2 Family Fundamentals (512) exam covers these skills:

Understanding DB2 products and components
Creating database objects
Understanding various DB2 data types
Using SQL to manipulate database objects
Describing DB2 concurrency

For more details on the test objectives of this exam, see "DB2 Family Fundamentals (512)" on page 744.The DB2 for OS/2, Windows, UNIX, and Linux Database Adminstration (513) exam covers these skills:

Managing DB2 instances
Creating and maintaining database objects
Managing table spaces
Using utilities: IMPORT, LOAD, REORG, RUNSTATS
Managing recovery procedures (BACKUP/RESTORE)
Analyzing resource problems

For more details on the test objectives of this exam, see "DB2 for OS/2, Windows, and UNIX Database Administration (513)" on page 746.

Note: More information about DB2 UDB certification can be found at

http://www.ibm.com/certify



Updates

Submit Errata



More Information



InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Privacy Notice

Overview

Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security

Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children

This site is not directed to children under the age of 13.

Marketing

Pearson may send or direct marketing communications to users, provided that

Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
Such marketing is consistent with applicable law and Pearson's legal obligations.
Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out

Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

As required by law.
With the consent of the individual (or their parent, if the individual is a minor)
In response to a subpoena, court order or legal process, to the extent permitted or required by law
To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
To investigate or address actual or suspected fraud or other illegal activities
To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links

This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020

Email Address

DB2 Universal Database v7.1 for UNIX, Linux, Windows and OS/2 Database Administration Certification Guide, 4th Edition

Book

About

Features

Description

Sample Content

Downloadable Sample Chapter

Table of Contents

Preface

Preface

Updates

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

Overview

Collection and Use of Information

Questions and Inquiries

Online Store

Surveys

Contests and Drawings

Newsletters

Service Announcements

Customer Service

Other Collection and Use of Information

Application and System Logs

Web Analytics

Cookies and Related Technologies

Do Not Track

Security

Children

Marketing

Correcting/Updating Personal Information

Choice/Opt-out

Sale of Personal Information

Supplemental Privacy Statement for California Residents

Sharing and Disclosure

Links

Requests and Contact

Changes to this Privacy Notice

Other Things You Might Like