Skip to content

DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep

Best in textbook rentals since 2012!

ISBN-10: 013185514X

ISBN-13: 9780131855144

Edition: 6th 2008 (Revised)

Authors: George Baklarz, Paul C. Zikopoulos, Michael Agostino

List price: $69.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

DB2 ® 9 builds on the worlds number one enterprise database to simplify the delivery of information as a service, accelerate development, and dramatically improve operational efficiency, security, and resiliency. Now, this new edition offers complete, start-to-finish coverage of DB2 9 administration and development for Linux ® , UNIX ® , and Windows ® platforms, as well as authoritative preparation for the latest IBM DB2 certification exam. Written for both DBAs and developers, this definitive reference and self-study guide covers all aspects of deploying and managing DB2 9, including DB2 database design and development; day-to-day administration and backup; deployment of networked,…    
Customers also bought

Book details

List price: $69.99
Edition: 6th
Copyright year: 2008
Publisher: Pearson Education
Publication date: 11/19/2007
Binding: Hardcover
Pages: 1136
Size: 7.28" wide x 9.33" long x 2.32" tall
Weight: 3.982
Language: English

Paul C. Zikopoulos, B.A., M.B.A., is the Director of Technical Professionals for IBM Software Group's Information Management division. In this role, he has executive responsibilities for the vitality of its client-facing technical professional community and ensuring they're among the most technically skilled personnel in the marketplace. Paul has written more than 300 magazine articles and 14 books on DB2, including Break Free with DB2: A Tour of Cost Saving Features; Information on Demand: Introduction to DB2 9.5 New Features; DB2 Fundamentals Certification for Dummies; DB2 for Dummies and more. Paul is a DB2 Certified Solutions Expert (BI and DBA).Matt Huras, B.ASc., M.Eng., is an IBM…    

Foreword
Preface
Introduction to DB2
Product Overview
Information as a Service
The DB2 for Linux, UNIX, and Windows Data Server
DB2 Connectivity
DB2 Administration
Summary
Getting Started
Product Installation
The DB2 Environment
Summary
Getting Connected
DB2 Client Overview
Roadmap to Distributed Communications
Summary
Controlling Data Access
Overview of Security
Auditing
Summary
Using SQL
Database Objects
Understanding Database Objects
Managing Database Objects
Tables
Database Design and Implementation
Summary
Manipulating Database Objects
Data Retrieval
Data Modification
View Classification
Summary
Advanced SQL 397
Triggers
Recursive SQL
Outer Join
OLAP Features
Advanced Case Expressions
Structured Types and Typed Tables
Summary Tables
Sequences
Advanced Functions
Summary
pureXML Storage Engine
pureXML Feature Pack
The Difference: pureXML
Creating an XML-enabled Database
Creating Tables with pureXML
Inserting Data into pureXML Columns
Selecting Data from pureXML Columns
Updating and Deleting pureXML Columns
Indexing pureXML Columns
XML Schema Repository (XSR)
Summary
Development SQL
User-Defined Functions
Structured Data Types
Schemas and Aliases
Commit and Rollback
SQL Procedural Language
Stored rocedures
Summary
Concurrency
Concurrency
Isolation Levels
Lockingv
Summary
DB2 Administration
Data Storage Management
Processor, Memory, and Disk Resources
DB2 Storage Model
Table Space Design
Implementation Examples
Automatic Storage
Table Space Maintenance
Table (Range) Partitioning
Summary
Maintaining Data
Moving Data
Data Movement Utilities
Data Maintenance
Data Maintenance Process
Summary
Database Recovery
Database Recovery Concepts
Types of Recovery
Recovery Strategies
Use of Log Files
Version Recovery Using Backup and Restore
Roll-Forward Recovery
Managing Log Files
Other Recovery Considerations
High Availability
High-Availability Disaster Recovery
Summary
Monitoring and Tuning
Elements of Performance
DB2 Architecture Overview
DB2 Sorting Methods
Monitoring the DB2 System
Database Monitoring
SQL Monitoring
Diagnostics and Problem Determination
Self-Tuning Memory Manager
Summary
Developing Applications
Application Development Overview
DB2 Application Development Environment
DB2 Programming Interfaces
Summary
Development Considerations
Embedded SQL Overview
Support for CLI and ODBC Programming
Support for Java Programming
DB2 Developer Workbench
Summary
Appendices
DB2 9 Certification Test Objectives
DB2 Certification Levels
DB2 9 Fundamentals (730)
DB2 for LUW Database Administration (731)
DB2 for LUW Advanced DBA (734)
IBM Certified DBA for DB2 9 for LUW, Upgrade (736)
DB2DEMO Installation
Installation Requirements
Using the DB2DEMO Program
Advanced Programming Information
Support
Index