DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins.

Format:

Book

Author/Creator:

Saraswatipura, Mohankumar, author.

Collins, Robert, author.

Language:

English

Subjects (All):

IBM Database 2--Examinations--Study guides.

IBM Database 2.

Database management--Examinations--Study guides.

Database management.

Physical Description:

1 online resource (1248 p.)

Edition:

First edition.

Place of Publication:

Boise, ID : MC Press Online, LLC, [2015]

Language Note:

English

Summary:

Written primarily for readers who work with the DB2 system, this book covers everything they need to know in order to pass the exam to become IBM-certified database administrators for DB2 10.1 or DB2 10.5 for Linux, UNIX, and Windows. This comprehensive study guide goes step by step through all of the topics on the test. Each chapter contains an extensive set of practice questions along with carefully explained answers, and a complete practice test that closely models the actual exam is included with an answer key. The book discusses server management, activity monitoring, high availability, security, and connectivity and networking, among other issues.

Contents:

Front Cover; Title Page; Copyright; About the Authors; Acknowledgments; Contents; Foreword; 1: IBM DB2 10.1 Certification; DB2 10.1 Certification Roles; DB2 10.1 Certification Tracks; The Certification Process; Taking an IBM Certification Exam; 2: DB2 Server Management; Exam Objectives; Working with Instances; Configuring the DB2 System Environment; Configuring DB2 Instances and Databases; DB2 Autonomic Computing Features; Automatic Storage; Data Compression; Automatic Database Maintenance; The Configuration Advisor; Adaptive Utility Throttling; Taking Control of a DB2 Server

Working with IBM Data StudioConnecting to Instances and Databases; Generating Data Definition Language Scripts; Performing Database Administration Tasks; Performing Database Development Tasks; Scheduling Database Jobs; Analyzing SQL Queries; Chapter Summary; Practice Questions; Answers; 3: Physical Design; Exam Objectives; Servers, Instances, and Databases; DB2 Database Objects; Creating a DB2 Database; A Complete CREATE DATABASE Command; Design Aspects of Databases; Buffer Pools; Table Spaces; Reclaimable Storage; Storage Groups; Schemas; Range Clustering and Range Partitioning Tables

Range Clustered TablesRange Partitioned Tables; Multi-temperature Storage; Time Travel Query Using Temporal Tables; Utilities, Tools, and File Type Modifiers; Restrictions for System-Period Temporal Tables; Application-Period Temporal Tables; Bitemporal Period Tables; Working with XML Data; Data Compression; DB2 9.7-Increasing the Compression Landscape; Chapter Summary; Practice Questions; Answers; 4: Business Rules Implementation; Exam Objectives; Business Rules; Not Null Constraints; Default Constraints; Check Constraints; Unique Constraints; Referential Integrity Constraints

Informational ConstraintsThe Set Integrity Command; Creating Tables and Constraints; Creating Views with the Check Option; Creating and Using Triggers; Chapter Summary; Practice Questions; Answers; 5: Monitoring DB2 Activity; Exam Objectives; The Database System Monitor; The Snapshot Monitor; Table Functions for Monitoring; Functions Quick Reference; Administrative Views for Monitoring; Buffer Pool Hit Ratio and I/O Response Time; Currently Running Expensive SQL Statement; Current Lock-wait Chains in the Database; Understanding Your Table Spaces; Getting to Know Your Database Server

Event MonitorsEvent Types and Examples; Reading Unformatted Event Data; Unformatted Event Data Format Table Functions; Analyzing SQL with the Explain Facility; The Explain Tables; Collecting Explain Data; Evaluating Explain Data; DB2 Troubleshooting Tools; Obtaining Information About an Error Code; Reason Codes; The db2diag Utility; First Occurrence Data Capture (FODC); The DB2 Diagnostic Log File; The Administration Notification Log; Controlling How Much Information Is Collected; Interpreting the Notification and Diagnostic Log Entries; The db2pdcfg Command; The db2bfd Command

The db2val Command

Notes:

Description based upon print version of record.

Description based on online resource; title from PDF title page (ebrary, viewed January 13, 2016).

ISBN:

1-58347-672-5

1-58347-716-0

OCLC:

934197927