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
Agile Project Management: Creating Innovative Products (2nd Edition)
Reliable Innovation
Core Agile Values
Our Journey
Practice: Participant Identification
Practice: Customer Team-Developer Team Interface
Image Processing with LabVIEW and IMAQ Vision
Introduction to IMAQ Vision Builder
Video Standards
Pixel Value Analysis
Character Recognition
Image Focus Quality
Snort Cookbook
Upgrading Snort on Linux
Invisibly Sniffing Between Two Network Points
Dynamic Rules
Installing and Configuring Barnyard
Generating Statistical Output from Snort Databases
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Converting a String to Lower- or Uppercase
Making a Class Readable from a Stream
Computing the Norm of a Vector
Creating a Thread
Writing an Operator That Isnt a Member Function
Introduction to 80x86 Assembly Language and Computer Architecture
Elements of Assembly Language
Branching and Looping
Procedures
Floating-Point Arithmetic
Appendix C MASM 6.11 Reserved Words
Microsoft WSH and VBScript Programming for the Absolute Beginner
VBScript Basics
Processing Collections of Data
Combining Different Scripting Languages
Appendix A WSH Administrative Scripting
Appendix B Built-In VBScript Functions
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