Flylib.com
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
ISBN: 0130463884
EAN: 2147483647
Year: 2003
Pages: 121
Authors:
Dwaine Snow
,
Thomas Xuan Phan
BUY ON AMAZON
Main Page
Table of content
Copyright
IBM Press SeriesInformation Management
About Prentice Hall Professional Technical Reference
Foreword
Preface
DB2: Any Workload, Any Data, All the Time
Conventions Used Throughout the Book
Acknowledgments
Trademarks
Chapter 1. Data Storage
Some Terminology Used in DB2
The Default Database
Table Spaces
Additional Table Space OptionsParameters
Summary
Chapter 2. Data Manipulation
The Buffer Pools
Parallelism
Types of Database Objects
Summary
Chapter 3. Database Availability
Ability to Manage Logs
Developing a Backup and Recovery Strategy
Backup Overview
Restore Overview
Rollforward Overview
High Availability Clustering
Availability Enhancements
Ability to Use db2dart
Summary
Chapter 4. Database Security
Selecting User Names and Group Names for DB2 Installation
Authentication Methods
Privileges, Authorities, and Authorizations
Firewall Support
What Is LDAP?
Security Implementation and Usage
How DB2 for Windows NT2000 Works with Windows NT2000 Security
User Authentication with DB2 for Windows NT
Summary
Chapter 5. Multi-Dimensional Clustering
MDC Terminology
Design Guidelines for MDC Tables
MDC Performance Guidelines
Space Usage with MDC Tables
MDC Indexes
Summary
Chapter 6. The DB2 Optimizer
Joining in DB2 UDB
Materialized Query Tables
Understanding DB2 Query Access Plans
Summary
Chapter 7. Federated Database Access
What Is a Federated System?
Overview of the Tasks to Set Up a Federated System
How Do You Interact with a Federated System?
Setting Up the Federated Server and Database
Working with the Federated Data
Sample Configuration Federated between DB2 on OS390 and DB2 on Sun Solaris
Configuration of a Federated Database System
Nickname Characteristics Affecting Global Optimization
Summary
Chapter 8. Performance Tuning
Performance Fundamentals
Configuration Parameter Tuning
Database Configuration Parameter Tuning and Monitoring
Registry Variable Tuning
Other Important Configuration Parameters
Summary
Chapter 9. Database Communications
Database Partition Configuration File (db2nodes.cfg)
Default Port Range
Non-Partitioned Database Environment
Installing the DB2 Server
Partitioned Database Environment
Post-Installation Setup
Installing and Configuring DB2 Client to DB2 Server Communications
Installing and Configuring DB2 Client to DB2 Host Communications
Installing DB2 Connect Personal Edition
Configuring DB2 Clients in a Two-Tier Environment
Configuring DB2 Clients in a Three-Tier Environment
FCM Communication Buffers Considerations
Summary
Chapter 10. Performance Tuning Examples
Example 1: Create Index Taking Too Long
Example 2: Unable to Get Desired Throughput
Example 3: Query1 Taking Too Long to Run
Example 4: Query2 Taking Too Long to Run
Example 5: Periodic Noticeable Slowdown of Database Response Time
Appendix A. Useful DB2 Commands
System Commands
CLP Commands
ONLINE Utility
Appendix B. parseSQL.pl
Appendix C. exfmtDIF.pl
Appendix D. Comparing Index Advisor Recommended Indexes with Existing Indexes
Appendix E. Configuration Parameters That Can Be Changed Online
Appendix F. Explain Tools
EXPLAIN Tables
EXPLAIN Commands
EXPLAIN Output
Appendix G. Starting and Stopping a DB2 Instance
Appendix H. LDAP Integration in DB2 UDB Using Microsoft Active Directory
Implementation Guidelines
Appendix I. Tuning DB2 UDB in the IBM LDAP Environment
Appendix J. DB2 Support Information
DB2 Support Resources
Opening a PMR
Collecting Diagnostic Information
Sending Diagnostic Information
Appendix K. DB2 Connect Implementation
Installing DB2 Connect Enterprise Edition
Appendix L. Sample Questions
Appendix M. Answers to Sample Questions
About the CD-ROM
License Agreement
Technical Support
Article
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
ISBN: 0130463884
EAN: 2147483647
Year: 2003
Pages: 121
Authors:
Dwaine Snow
,
Thomas Xuan Phan
BUY ON AMAZON
Documenting Software Architectures: Views and Beyond
Summary Checklist
What the C&C Viewtype Is For and What Its Not For
Discussion Questions
For Further Reading
For Further Reading
Developing Tablet PC Applications (Charles River Media Programming)
The Tablet PC
Object-Oriented Programming with VB .NET
Form Effects
Getting Started with Microsoft Agent
Pong Game
Mastering Delphi 7
Multitier DataSnap Applications
Reporting with Rave
Internet Programming: Sockets and Indy
Web Programming with IntraWeb
The Microsoft .NET Architecture from the Delphi Perspective
An Introduction to Design Patterns in C++ with Qt 4
QActions, QToolbars, and QActionGroups
More Design Patterns
Part III: C++ Language Reference
Identifier Scope
Exceptions
.NET-A Complete Development Cycle
Commonly Used Software Development Models
Conclusion
Implementation of the Photo Editor Application
Dynamic Loading of Components
Integration Test
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Arrays and Collections
Objects, Interfaces, and Patterns
Windows Programming
Printing and Drawing with GDI+
ASP.NET Web Applications
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies