Shop now Shop now Shop now See more Shop all Amazon Fashion Cloud Drive Photos Shop now Learn More Shop now DIYED Shop now Shop Fire Shop Kindle Shop now Shop now
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference,... and over 2 million other books are available for Amazon Kindle . Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
Buy Used
Used - Very Good See details
Price: £5.43

or
 
   
More Buying Choices
Have one to sell? Sell yours here
Start reading DB2 9 for Linux, UNIX, and Windows on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

DB2 9 for Linux, Unix, and Windows: DBA Guide, Referenceand Exam Prep [Hardcover]

George Baklarz , Paul C. Zikopoulos

Price: £43.99 Eligible for FREE UK Delivery Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Saturday, 27 Aug.? Choose Express delivery at checkout. Details
‹  Return to Product Overview

Table of Contents

Foreword        xxi
Preface        xxiii
Part ONE: Introduction to DB2        1Chapter 1: Product Overview        3Information as a Service        4
The DB2 for Linux, UNIX, and Windows Data Server        9
DB2 Connectivity        28
DB2 Administration        45
Summary        60Chapter 2: Getting Started        63Product Installation        64
The DB2 Environment        98
Summary        115Chapter 3: Getting Connected        117DB2 Client Overview        118
Roadmap to Distributed Communications        124
Summary        164Chapter 4: Controlling Data Access        167Overview of Security        168
Auditing        216
Summary        221Part TWO: Using SQL        223Chapter 5: Database Objects        225Understanding Database Objects        227
Managing Database Objects        235
Tables        263
Database Design and Implementation        316
Summary        325Chapter 6: Manipulating Database Objects        327Data Retrieval        328
Data Modification        365
View Classification        383
Summary        395Chapter 7: Advanced SQL        397Triggers        398
Recursive SQL        405
Outer Join        409
OLAP Features        414
Advanced CASE Expressions        432
Structured Types and Typed Tables        434
Summary Tables        456
Sequences        469
Advanced Functions        472
Summary        487Chapter 8: pureXML Storage Engine        489pureXML Feature Pack        490
The Difference: pureXML        495
Creating an XML-enabled Database        500
Creating Tables with pureXML        502
Inserting Data into pureXML Columns        504
Selecting Data from pureXML Columns        513
Updating and Deleting pureXML Columns        520
Indexing pureXML Columns        521
XML Schema Repository (XSR)        533
Summary        537Chapter 9: Development SQL        539User-Defined Functions        540
Structured Data Types        549
Schemas and Aliases        555
COMMIT and ROLLBACK        558
SQL Procedural Language        559
Stored Procedures        578
Summary        597Chapter 10: Concurrency        599Concurrency        600
Isolation Levels        607
Lockingv610
Summary        621Part THREE: DB2 Administration        623Chapter 11: Data Storage Management        625Processor, Memory, and Disk Resources        626
DB2 Storage Model        628
Table Space Design        640
Implementation Examples        652
Automatic Storage        664
Table Space Maintenance        666
Table (Range) Partitioning        674
Summary        699Chapter 12: Maintaining Data        701Moving Data        702
Data Movement Utilities        705
Data Maintenance        766
Data Maintenance Process        786
Summary        791Chapter 13: Database Recovery        793Database Recovery Concepts        794
Types of Recovery        795
Recovery Strategies        796
Use of Log Files        797
Version Recovery Using Backup and Restore        805
Roll-Forward Recovery        827
Managing Log Files        837
Other Recovery Considerations        838
High Availability        845
High-Availability Disaster Recovery        850
Summary        869Chapter 14: Monitoring and Tuning        871Elements of Performance        872
DB2 Architecture Overview        876
DB2 Sorting Methods        887
Monitoring the DB2 System        887
Database Monitoring        890
SQL Monitoring        921
Diagnostics and Problem Determination        947
Self-Tuning Memory Manager        960
Summary        973Part FOUR: Developing Applications        975Chapter 15: Application Development Overview        977DB2 Application Development Environment        978
DB2 Programming Interfaces        982
Summary        995Chapter 16: Development Considerations        997Embedded SQL Overview        998
Support for CLI and        ODBC Programming        1009
Support for Java Programming        1018
DB2 Developer Workbench        1021
Summary        1022Part FIVE: Appendices        1023Appendix A: DB2 9 Certification Test Objectives        1025DB2 Certification Levels        1026
DB2 9 Fundamentals (730)        1027
DB2 for LUW Database Administration (731)        1029
DB2 for LUW Advanced DBA (734)        1032
IBM Certified DBA for DB2 9 for LUW, Upgrade (736)        1034Appendix B: DB2DEMO Installation        1037Installation Requirements        1038
Using the DB2DEMO Program        1045
Advanced Programming Information        1066
Support        1095Index        1097

‹  Return to Product Overview