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
SQL Tips & Techniques (Miscellaneous)
Understanding SQL Basics and Creating Database Files
Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
Working with Queries, Expressions, and Aggregate Functions
Using Data Control Language (DCL) to Setup Database Security
Working with Functions, Parameters, and Data Types
Competency-Based Human Resource Management
An Overview of Competency-Based HR Management Practices
Competency-Based HR Planning
Competency-Based Employee Rewards
Appendix A Frequently Asked Questions About Competency-Based HR Management
Appendix D Employee Development and Succession Management
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 29. Detect Networks with Kismet
Hack 53. Do-It-Yourself Access Point Hardware
Hack 99. Slow Down to Speed Up
Section A.8. CDPD, 1xRTT, and GPRS: Cellular Data Networks
Section B.5. 802.11 Hardware Suppliers
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Basic ImageReady Animation, Tweening, and Layer Styles
Rotoscoping Techniques with Photoshop
Matte and Keying Plug-ins
Motion Titling Effects
Custom Scene Transitions
Sap Bw: a Step By Step Guide for Bw 2.0
Creating an InfoCube
Summary
Creating a Characteristic in BW
Maintaining Characteristic Data
Summary
Understanding Digital Signal Processing (2nd Edition)
DFT SHIFTING THEOREM
REFERENCES
COMPARING ANALYTIC SIGNAL GENERATION METHODS
FLOATING-POINT BINARY FORMATS
Appendix F. Digital Filter Terminology
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