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

ISBN-10: 013185514X

ISBN-13: 9780131855144

Edition: 6th 2008 (Revised)

List price: $69.99
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

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, Internet-centered, and SOA-based applications; migration; and much more. Youll also find an unparalleled collection of expert tips for optimizing performance, availability, and value. Coverage includes: Important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator role Breakthrough pureXML ™ features that make it easier to succeed with service-oriented architecture Operational improvements that enhance DBA efficiency--including self-tuning memory allocation, automated storage management, and storage optimization Table-partitioning features that improve scalability and manageability Powerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all data Whatever your role in working with DB2 or preparing for certification,DB2 9 for Linux, UNIX, and Windows, Sixth Editionis the one book you cant afford to be without. Download Complete DB2 V9 Trial Version Visit ibm.com/db2/9/download.html to download a complete trial version of DB2, which enables you to try out dozens of the most powerful features of DB2 for yourself: everything from pureXML support to automated administration and optimization. Straight from IBM, the ultimate guide to running DB2 9 and preparing for the latest IBM DB2 certification exam! Covers powerful DB2 9 enhancements ranging from automated management to improved compression Covers the full spectrum of DBA responsibilities, including server management, data placement, XML concepts, activity analysis, high availability, and security Presents expert tips and best practices from the DB2 customer support organization

eBooks Starting from $55.99
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

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.25" wide x 9.50" long x 2.50" 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 Distinguished Engineer, and a senior architect for the DB2 on the Linux, UNIX, and Windows platform. He focuses on database kernel, which includes the data management, index management, locking, concurrency, and other protocols. Matt's most recent project role was the lead architect of DB2 pureScale--a new feature focusing on delivering new levels of scalability and availability.Paul Awad, B.Sc., is an IBM Project Manager whose main focus is DB2 pureScale. Paul has held several leadership positions at IBM, including roles in support, the Project Office, and the Collaboration Center. Paul is currently the DB2 pureScale Product Manager, and in this role he has influence over the DB2 pureScale product, customer, and market feedback channels for the offering as well as enabling the product to market.Aamer Sachedina, B.Eng., P.Eng., is a Senior Technical Staff Member and IBM Master Inventer at the IBM Toronto Lab. Over the years, he contributed to the design of the DB2 kernel, was the architect of DB2's Automatic Storage, and most recently headed the active-active availability effort as HA architect on the DB2 pureScale project.

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
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×