DB2 11 for z/OS Database Administration: Certification Study Guide

by Susan Lawson

Overview

Written primarily for database administrators who work on z/OS and who are taking the IBM DB2 11 for z/OS Database Administration certification exam (Exam 312), this resource also appeals to those who simply want to master the skills needed to be an effective database administrator of z/OS mainframes. This study guide is designed to provide those seeking certification with an intense overview of DB2 11 for z/OS and all topics covered on the exam. Sample questions are provided at the end of each chapter, along with answers and explanations.

Product Details

ISBN-13:	9781583473979
Publisher:	MC Press, LLC
Publication date:	07/15/2016
Series:	DB2 DBA Certification
Edition description:	Study Guide
Pages:	600
Product dimensions:	7.00(w) x 9.00(h) x 1.20(d)

About the Author

Susan Lawson is an internationally recognized consultant, author, and lecturer with a background in system and database administration. She is an IBM GOLD Consultant for DB2 and z, an IBM Champion, and a Subject Matter Expert for several IBM DB2 for z/OS Certification exams.
 

Table of Contents

Introduction: IBM DB2 11 DBA for z/OS Certification Review Guide-Exam 312 1

IBM Certified Database Administrator-DB2 11 for z/OS 2

312 Exam-IBM DB2 11 DBA for z/OS 2

320 Exam-IBM DB2 11 Fundamentals for z/OS 4

610 Exam-DB2 10.1 Fundamentals 5

1 DB2 for z/OS Introduction 7

z/Architecture and the z/OS Operating System 7

DB2 for z/OS 11

DB2 z/OS Environment 11

Summary 34

Questions 35

Answers 37

2 Database Design and Implementation 41

Database Design 41

Creating DB2 Structures 45

Data Structures 67

Data Types 85

Data Integrity Support 94

Indexes 99

Views 110

Schemas 111

Large Object Support 112

XML Support 114

Altering Structures 115

Summary 129

Questions 130

Answers 134

3 Applications and Database Functionality 139

Application Programming 139

Application Process 141

Structured Query Language (SQL) 143

Processing XML Data with DB2 pureXML 187

Procedure and Functions Performance Considerations 199

Utilizing Additional DB2 Constructs 201

Application Program Preparation 222

Locking and Concurrency 230

Summary 247

Questions 248

Answers 251

4 Environment Management 255

Installation and Migration 255

Interacting with DB2 259

Subsystem Parameters 261

Commands 262

DB2 Utilities 274

Starting and Stopping DB2 281

Managing Threads and Connections 287

Distributed Data 294

Data Sharing Operations 297

Authorization and Security 303

Backup, Recovery, and Restart 329

Backup and Recovery 347

Summary 381

Questions 382

Answers 386

5 Data Management 391

Moving DB2 Data 391

Data Organization 417

Data Statistics 445

STOSPACE Utility 456

Data and Index Copies 456

Statistics for Maintenance 461

Summary 466

Questions 468

Answers 472

6 Performance and Tuning 477

z/OS Performance and DB2 478

Storage and Performance 480

Open Data Sets 490

Managing I/O 491

DB2 Monitoring 498

Tracing Problems in DB2 500

Lock Monitoring 511

Data Organization and Statistics 513

Access Path Tuning 525

Dynamic Statement Cache Information 547

Summary 550

Questions 551

Answers 554

Index 559