Username: Password:
 Home |  | Exam Engines | Study Packs | Labs |  | Sample | FAQ | Guarantee | Support | Order
Go
  Total (3799)
  3Com (14)
  AccessData (2)
  ACE (1)
  ACI (9)
  Acme Packet (1)
  ACSM (8)
  Adobe (129)
  AIIM (2)
  Alcatel Lucent (17)
  Altiris Exams (4)
  American College (1)
  APC (4)
  Apple (63)
  Arm (4)
  Aruba (2)
  ASQ (4)
  ASTQB (2)
  AUTODESK (2)
  Automotive (0)
  Avaya (58)
  Axis (2)
  Banking (2)
  BICSI (2)
  BlackBerry (17)
  Blue Coat (2)
  BMC (2)
  Business Objects (16)
  CA (31)
  Certiport (6)
  CheckPoint (44)
  CIPS (5)
  Cisco (736)
  Citrix (135)
  CIW (47)
  Cloudera (4)
  CLP (2)
  CompTIA (147)
  CWNA (16)
  Dassault (2)
  Dell (5)
  ECCouncil (19)
  EMC (136)
  ENTERASYS (16)
  Ericsson (4)
  Esri (4)
  Exam Express (18)
  EXIN (41)
  Extreme Networks (4)
  F5 Networks (21)
  FileMaker (11)
  Financial (56)
  Fitness (6)
  FORTINET (5)
  Fujitsu (4)
  GAQM (1)
  Genesys (2)
  GIAC (17)
  GRE (2)
  GuidanceSoftware (5)
  H3C (2)
  HDI (10)
  Healthcare (4)
  HIPAA (2)
  Hitachi (17)
  Hospitality (3)
  HP (751)
  HRCI (6)
  Huawei (13)
  Hyperion (15)
  IASSC (1)
  IBM (963)
  ICDL (8)
  IELTS (3)
  IFPUG (2)
  IIA (1)
  IIBA (4)
  IISFA (1)
  Intel (2)
  IRS (4)
  Isaca (5)
  ISC (15)
  ISEB-ITIL (37)
  Isilion (4)
  ISM (0)
  ISM (8)
  iSQI (12)
  Juniper (53)
  Legato (5)
  Lotus (135)
  LPI (18)
  LSI (6)
  Magento (4)
  Maintenance (4)
  Marketing (2)
  McAfee (7)
  McData (5)
  Microsoft (912)
  Mile2 (5)
  Motorola (6)
  MySQL (5)
  Network Appliance (31)
  Nework-GENERAL (16)
  NI-LabVIEW (1)
  NOKIA (3)
  Nortel (176)
  Novell (77)
  OMG (12)
  Open Group (4)
  Oracle (297)
  Pegasystems (4)
  PEOPLECERT (2)
  PMI (7)
  Polycom (3)
  PostgreSQL CE (1)
  Prince2 (1)
  PRMIA (2)
  Quality Assurance (6)
  Real Estate (2)
  RedHat (4)
  RES Software (8)
  Research (2)
  Riverbed (3)
  RSA (19)
  SAIR (16)
  SAP (45)
  SAS Institute (19)
  SCO (11)
  SCP (9)
  SDI (4)
  SeeBeyond (2)
  SNIA (9)
  SOA (15)
  SolarWinds (1)
  SpringSource (1)
  SPSS (8)
  Sybase (20)
  Symantec (158)
  The Open Group (4)
  Tibco (28)
  TruSecure (2)
  TSEP (2)
  Veritas (12)
  VMWare (16)
  XML Master (6)
 
New  Releases More...
 
   Study Pack
 
     A DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows   
     
Lifetime member (All Exams and Study Packs Only $ 79.99)   
 
  Introduction




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 Options/Parameters
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 NT/2000 Works with Windows NT/2000 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 OS/390 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

  Index
 
 
Home | Training List | Study Pack | Free Demo | F A Q | Guarantee | Support | Order | Privacy Policy| Website Index
Copyright 2000 - 2018 ITExamWorld.net , All rights reserved.