IBM Books

Troubleshooting Guide

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties and any statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in U.S. or 1-800-IBM-4YOU in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you.

© Copyright International Business Machines Corporation 1993, 1997. All rights reserved.
Note to U.S. government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.

Table of Contents

  • Welcome to DB2
  • Roadmap
  • Conventions

    • Part 1. Basic DB2 Troubleshooting

  • Chapter 1. Good Troubleshooting Practices
  • Maintaining a Problem History
  • Determining Origins and Symptoms of Problems
  • Determining the Location of a Problem
  • Responding to Unexpected Messages or SQL Codes
  • Responding to Abends
  • Responding to Suspensions and Loops
  • Using All Available Information
  • Updating DB2 Products
  • Using Logged Data and Taking Traces
  • Contacting IBM for Support

  • Chapter 2. Troubleshooting the DB2 Universal Database Server
  • DB2 Administrative Tools
  • Graphical Tools
  • Miscellaneous Troubleshooting Tools
  • The Database System Monitor
  • Troubleshooting Tips
  • Migrating to Version 5
  • Server Fails
  • Can't Administer Databases
  • Backing Up and Restoring Data
  • Loading Data
  • Importing Data
  • Can't Use Commands, Utilities, or the Command Line Processor
  • Tables or Rows Locked
  • User Authentication with DB2 for Windows NT
  • Improving Database Performance
  • Still Have Problems?

  • Chapter 3. Troubleshooting on the Client
  • Overview of Client Connectivity
  • Client Connectivity Tools
  • Troubleshooting Tips
  • Determining the Scope of a Client Problem
  • Cannot Make Initial Connection After Installation
  • Clients Suddenly Experiencing Problems
  • User Name Not Valid on Windows 95
  • Using the TCP/IP Protocol
  • Using the IPX/SPX Protocol
  • Using the NetBIOS Protocol
  • Using Named Pipes
  • Using the APPC Protocol
  • Still Have Problems?

  • Chapter 4. Troubleshooting Host Communications
  • Troubleshooting Host Connections
  • Troubleshooting Tips for DB2 Connect
  • Initial Questions
  • Cannot Make Initial Connection After Installation
  • Problems Encountered After Initial Connection
  • DB2 Connect Connection Using SNA Does Not Work
  • Changing Number of Connections
  • Authentication Problems
  • Windows Clients Won't Connect
  • Troubleshooting Tips for Host Connections to DB2 Universal Database
  • Still Have Problems?

  • Chapter 5. Troubleshooting Applications
  • Troubleshooting Tips
  • Developing Applications
  • Compiling and Linking Applications
  • Running Applications
  • Using CLI/ODBC Applications
  • Still Have Problems?

  • Chapter 6. Troubleshooting DB2 Universal Database Extended Enterprise Edition
  • Troubleshooting Tips
  • Extended Enterprise Edition Won't Install
  • Severe Error Occurs on System
  • Determining Failing Node
  • Database Manager Won't Start or Hangs
  • Cannot Create Database
  • Commands Cannot Be Issued
  • Problems with Splitting and Loading Data
  • Problems with Indexing Data
  • Problems During Recovery
  • Developing Applications in DB2 Extended Enterprise Edition
  • Still Have Problems?

    • Part 2. Advanced DB2 Troubleshooting

  • Chapter 7. Roadmap

  • Chapter 8. The DB2 Process Model
  • Description of the DB2 Process Model
  • Differences Between Intel and UNIX
  • Viewing System Threads and Processes

  • Chapter 9. Using Logged Information
  • Understanding First Failure Data Capture
  • Setting DIAGLEVEL and DIAGPATH
  • Interpreting the db2diag.log File
  • Interpreting db2diag.log Entry Headers
  • Interpreting an SQLCA Structure
  • Interpreting Hexadecimal Codes
  • Some Examples for Interpreting the db2diag.log File
  • Dump Files
  • Trap Files
  • Gathering Stack Traceback Information on UNIX-Based Systems
  • Using the Administrative Tools Log
  • Administrative Tools Log File Sample
  • Using Message Files
  • Alerts
  • SNMP Alerts

  • Chapter 10. Taking Traces
  • Using the DB2 Trace Facility (db2trc)
  • Starting a DB2 Trace
  • Verifying a DB2 Trace
  • Examples of Using db2trc
  • Taking Other Traces
  • Administration Tools Trace
  • Taking a Graphical Interface Trace
  • Taking a CLI/ODBC/JDBC Trace
  • Taking a DB2 Connect Trace (ddcstrc)
  • Taking a DRDA Trace (db2drdat)
  • Taking an SNA Trace

  • Chapter 11. Diagnostic Tools for UNIX-Based Systems
  • Using the System Error Log (syslog)
  • Setting Up the System Error Log
  • Understanding the System Error Log
  • Using the Core File
  • Accessing Core File Information
  • Viewing Process Status Using the ps Command
  • Other Commands
  • AIX Troubleshooting Commands
  • UNIX-Based Troubleshooting Commands
  • Performance Monitoring Tools
  • Commands for DB2 Extended Enterprise Edition

  • Chapter 12. Diagnostic Tools for OS/2
  • Using the OS/2 Logging Facility
  • Preliminary Considerations
  • Using OS/2 Logging Facility Commands
  • Using the FFST for OS/2 Utility
  • Adding the FFST for OS/2 Program Group to the Desktop Manager Window
  • Configuring and Enabling the FFST for OS/2 Utility
  • Accessing FFST for OS/2 Error Records
  • Routing Generic Alerts
  • Using the pstat Command

  • Chapter 13. Diagnostic Tools for Windows Operating Systems
  • Diagnostic Tools for Windows Version 3.1 and Windows 95
  • Diagnostic Tools for Windows NT
  • Using Administrative Tools Provided by Windows NT
  • Taking Screen Captures
  • Using DB2-Supplied Tools

  • Chapter 14. Diagnostic Tools for Macintosh

    • Part 3. Appendixes

  • Appendix A. Using the Problem Determination Tools Folder
  • Accessing Internet Information for DB2 for OS/2
  • Accessing Internet Information for DB2 for Windows NT
  • Updating DB2 Products
  • Setting Diagnostic Levels
  • Collecting Diagnostic Information
  • Sending or Receiving Information
  • Tracing

  • Appendix B. SQL Communication Area (SQLCA)
  • Viewing the SQLCA Interactively
  • SQLCA Field Descriptions
  • Order of Error Reporting
  • DB2 Extended Enterprise Edition Usage of the SQLCA

  • Appendix C. DB2 Internal Return Codes

  • Appendix D. How the DB2 Library Is Structured
  • SmartGuides
  • Online Help
  • DB2 Books
  • About the Information Center

  • Appendix E. How to Read Syntax Diagrams

  • Appendix F. Notices
  • Trademarks
  • Trademarks of Other Companies

  • Appendix G. Contacting IBM

  • Index

    • [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]