
DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep
by Baklarz, George; Zikopoulos, Paul C.-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
Rent Book
Rent Digital
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Author Biography
George Baklarz , B. Math, M.Sc., Ph.D., has spent 22 years at IBM working on various aspects of database technology. From 1987 to 1991 he worked on SQL/DS as part of the product planning department, system test team, performance team, and application development group. In 1991, Baklarz was part of the team that helped moved the OS/2 ES database to Toronto to become part of the DB2 family of products. Since that time he has worked on vendor enablement, competitive analysis, product marketing, product planning, and technical sales support. Today, Baklarz is the Program Director responsible for Dynamic Warehousing Pre-Sales Support, and he works with customers to help them understand DB2 technology directions and uses their feedback to improve the product. When not traveling the world, Baklarz lectures at the University of Guelph, teaching relational database concepts to students. You can reach him at gbaklarz@uoguelph.ca.
Paul C. Zikopoulos , B.A., M.B.A., is an award-winning writer and speaker with the IBM Database Competitive Technology team. He has more than thirteen years of experience with DB2 and has written more than 150 magazine articles and is currently working on book number twelve. Zikopoulos has authored the books Information on Demand: Introduction to DB2 9.5 New Features; DB2 9 Database Administration Certification Guide and Reference (6th Edition); DB2 9: New Features; Information on Demand: Introduction to DB2 9 New Features; Off to the Races with Apache Derby; DB2 Version 8: The Official Guide; DB2: The Complete Reference; DB2 Fundamentals Certification for Dummies; DB2 for Dummies; and A DBA's Guide to Databases on Linux. Zikopoulos is a DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration). In his spare time, he enjoys all sorts of sporting activities, including running with his dog Chachi, avoiding punches in his MMA class, and trying to figure out the world according to Chloë, his daughter. You can reach him at paulz_ibm@msn.com.
Table of Contents
Foreword | p. xxi |
Preface | p. xxiii |
Introduction to DB2 | p. 1 |
Product Overview | p. 3 |
Information as a Service | p. 4 |
The DB2 for Linux, UNIX, and Windows Data Server | p. 9 |
DB2 Connectivity | p. 28 |
DB2 Administration | p. 45 |
Summary | p. 60 |
Getting Started | p. 63 |
Product Installation | p. 64 |
The DB2 Environment | p. 98 |
Summary | p. 115 |
Getting Connected | p. 117 |
DB2 Client Overview | p. 118 |
Roadmap to Distributed Communications | |
Summary | p. 164 |
Controlling Data Access | p. 167 |
Overview of Security | p. 168 |
Auditing | p. 216 |
Summary | p. 221 |
Using SQL | p. 223 |
Database Objects | p. 225 |
Understanding Database Objects | p. 227 |
Managing Database Objects | p. 235 |
Tables | p. 263 |
Database Design and Implementation | p. 316 |
Summary | p. 325 |
Manipulating Database Objects | p. 327 |
Data Retrieval | p. 328 |
Data Modification | p. 365 |
View Classification | p. 383 |
Summary | p. 395 |
Advanced SQL 397 | |
Triggers | p. 398 |
Recursive SQL | p. 405 |
Outer Join | p. 409 |
OLAP Features | p. 414 |
Advanced Case Expressions | p. 432 |
Structured Types and Typed Tables | p. 434 |
Summary Tables | p. 456 |
Sequences | p. 469 |
Advanced Functions | p. 472 |
Summary | p. 487 |
pureXML Storage Engine | p. 489 |
pureXML Feature Pack | p. 490 |
The Difference: pureXML | p. 495 |
Creating an XML-enabled Database | p. 500 |
Creating Tables with pureXML | p. 502 |
Inserting Data into pureXML Columns | p. 504 |
Selecting Data from pureXML Columns | p. 513 |
Updating and Deleting pureXML Columns | p. 520 |
Indexing pureXML Columns | p. 521 |
XML Schema Repository (XSR) | p. 533 |
Summary | p. 537 |
Development SQL | p. 539 |
User-Defined Functions | p. 540 |
Structured Data Types | p. 549 |
Schemas and Aliases | p. 555 |
Commit and Rollback | p. 558 |
SQL Procedural Language | p. 559 |
Stored rocedures | p. 578 |
Summary | p. 597 |
Concurrency | p. 599 |
Concurrency | p. 600 |
Isolation Levels | p. 607 |
Lockingv | p. 610 |
Summary | p. 621 |
DB2 Administration | p. 623 |
Data Storage Management | p. 625 |
Processor, Memory, and Disk Resources | p. 626 |
DB2 Storage Model | p. 628 |
Table Space Design | p. 640 |
Implementation Examples | p. 652 |
Automatic Storage | p. 664 |
Table Space Maintenance | p. 666 |
Table (Range) Partitioning | p. 674 |
Summary | p. 699 |
Maintaining Data | p. 701 |
Moving Data | p. 702 |
Data Movement Utilities | p. 705 |
Data Maintenance | p. 766 |
Data Maintenance Process | p. 786 |
Summary | p. 791 |
Database Recovery | p. 793 |
Database Recovery Concepts | p. 794 |
Types of Recovery | p. 795 |
Recovery Strategies | p. 796 |
Use of Log Files | p. 797 |
Version Recovery Using Backup and Restore | p. 805 |
Roll-Forward Recovery | p. 827 |
Managing Log Files | p. 837 |
Other Recovery Considerations | p. 838 |
High Availability | p. 845 |
High-Availability Disaster Recovery | p. 850 |
Summary | p. 869 |
Monitoring and Tuning | p. 871 |
Elements of Performance | p. 872 |
DB2 Architecture Overview | p. 876 |
DB2 Sorting Methods | p. 887 |
Monitoring the DB2 System | p. 887 |
Database Monitoring | p. 890 |
SQL Monitoring | p. 921 |
Diagnostics and Problem Determination | p. 947 |
Self-Tuning Memory Manager | p. 960 |
Summary | p. 973 |
Developing Applications | p. 975 |
Application Development Overview | p. 977 |
DB2 Application Development Environment | p. 978 |
DB2 Programming Interfaces | p. 982 |
Summary | p. 995 |
Development Considerations | p. 997 |
Embedded SQL Overview | p. 998 |
Support for CLI and ODBC Programming | p. 1009 |
Support for Java Programming | p. 1018 |
DB2 Developer Workbench | p. 1021 |
Summary | p. 1022 |
Appendices | p. 1023 |
DB2 9 Certification Test Objectives | p. 1025 |
DB2 Certification Levels | p. 1026 |
DB2 9 Fundamentals (730) | p. 1027 |
DB2 for LUW Database Administration (731) | p. 1029 |
DB2 for LUW Advanced DBA (734) | p. 1032 |
IBM Certified DBA for DB2 9 for LUW, Upgrade (736) | p. 1034 |
DB2DEMO Installation | p. 1037 |
Installation Requirements | p. 1038 |
Using the DB2DEMO Program | p. 1045 |
Advanced Programming Information | p. 1066 |
Support | p. 1095 |
Index | p. 1097 |
Table of Contents provided by Publisher. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.