Diagnosing Problems
by Dwaine R. Snow, Sylvia F. Qi, Clara Liu, Raul F. Chong
Understanding DB2®: Learning Visually with Examples
- Copyright
- IBM Press
- Foreword
- Preface
- Acknowledgments
- About the Authors
- Introduction to DB2 UDB
- A Brief History of DB2
- DB2 software and the IBM E-Business On-Demand Model
- DB2 UDB Editions
- DB2 UDB Clients
- “Try and Buy” Versions
- Host Connectivity
- Federated Support
- Replication Support
- IBM DB2 Information Integrator
- Special Package Offerings for Developers
- DB2 Syntax Diagram Conventions
- Case Study
- Summary
- Review Questions
- DB2 at a Glance: The Big Picture
- Installing DB2
- DB2 Installation: The Big Picture
- Required User IDs and Groups
- Installing DB2 Using the DB2 Setup Wizard
- Silent Install Using a Response File
- Installing DB2 Manually (Linux/UNIX Only)
- Installing a DB2 License
- Installing DB2 in a DPF Environment
- Installing DB2 FixPaks
- Case Study
- Summary
- Review Questions
- Using the DB2 Tools
- Understanding the DB2 Environment, DB2 Instances, and Databases
- Configuring Client and Server Connectivity
- Working with Database Objects
- The DB2 Storage Model
- Leveraging the Power of SQL
- Implementing Security
- Understanding Concurrency and Locking
- Maintaining Data
- Developing Database Backup and Recovery Solutions
- Database Recovery Concepts
- DB2 Transaction Logs
- Recovery Terminology
- Performing Database and Table Space Backups
- Database and Table Space Recovery Using the RESTORE DATABASE Command
- Database and Table Space Roll Forward
- Recovering a Dropped Table
- The Recovery History File
- Database Recovery Using the RECOVER DATABASE Command
- High Availability Through Online Split Mirroring and Suspended I/O Support
- High Availability Disaster Recovery
- Using DB2 Tools to Inspect the Health of Your Database
- Case Study
- Summary
- Review Questions
- The DB2 Process Model
- The DB2 Memory Model
- DB2 Memory Allocation: The Big Picture
- Instance-Level Shared Memory
- Database-Level Shared Memory
- Application-Level Shared Memory
- Agent-Level Private Memory
- The Memory Model
- 32-Bit Memory Model Considerations
- 64-Bit Memory Model Considerations
- AWE Support with Windows
- Case Study
- Summary
- Review Questions
- Database Performance Considerations
- Performance Fundamentals
- System/Server Configuration
- The DB2 Configuration Advisor
- Configuring the DB2 Instance
- Configuring Your Databases
- Lack of Proper Maintenance
- The Snapshot Monitor
- Event Monitors
- The DB2 Optimizer
- The Explain Tool and Explain Tables
- Using Visual Explain to Examine Access Plans
- Case Study
- Summary
- Review Questions
- Diagnosing Problems
- Solutions to the Review Questions
- Use of Uppercase Versus Lowercase in DB2
- IBM Servers
- Using the DB2 System Catalog Tables
- Setting Up Database Connectivity for DB2 UDB for z/OS and DB2 UDB for iSeries
- Diagnosing DB2 Connectivity Problems
- Resources
- Glossary
- About the CD-ROM
- CD-ROM Warranty
- Index
Chapter 17. Diagnosing Problems
This chapter describes how to investigate problems you may encounter while working with DB2 and how to isolate them using diagnostic information. Once you isolate a problem, you can search for previously reported problems and identify workarounds.
In this chapter you will learn about:
The big picture of DB2 problem diagnosis
Obtaining more information about an error message
Collecting diagnostic information: First Failure Data Capture (FFDC)
The trace facility
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.