Who Should Read This Book?
Conventions
How to Read the Syntax Diagrams
Who Should Read This Book?
Conventions
How to Read the Syntax Diagrams
Part 1. Basic DB2 Troubleshooting
Maintaining a Problem History
Determining Origins and Symptoms of Problems
Determining the Location of a Problem
Responding to Unexpected Messages or SQLCODEs
Responding to Abends
Responding to Suspensions and Loops
Using All Available Information
Updating DB2 Products
Updating DB2 Products Using Fix Packs
Using Logged Data and Taking Traces
Contacting IBM for Support
DB2 Administrative Tools
Graphical Tools
Miscellaneous Troubleshooting Tools
The Database System Monitor
Troubleshooting Tips
Problems Migrating to Version 7
Problems When Applying Fix Packs
Server Failures
Starting DB2 on Windows 95 and Windows 98 When the User Is Not Logged On
Using a Windows 2000 Terminal Server environment
SQL1403N Received When Authenticating Usernames or Groups
Administration Difficulties
Backing Up and Restoring Data
Data Not Loading
Difficulties Importing Data
DB2 Support for Raw Devices when Using Windows 2000
Disk Alignment when Using Windows 2000
Problems Using Commands, Utilities, or the Command Line Processor
Locking and Deadlocks
Improving Database Performance
Still Have Problems?
Overview of Client Connectivity
Client Connectivity Tools
Troubleshooting Tips
Determining the Scope of a Client Problem
Initial Connection after Installation Fails
Clients Suddenly Experiencing Problems
User Name Not Valid on Windows 95 and Windows 98
TCP/IP Problems
IPX/SPX Problems
NetBIOS Problems
Problems When Using Named Pipes
APPC Problems
Still Have Problems?
Troubleshooting Host Connections
Direct Connection
Gateway Connection
Troubleshooting Tips for DB2 Connect
Problems Encountered after Initial Connection
Changing the Number of Connections
Authentication Problems
Windows Clients Do Not Connect
Troubleshooting Tips for Host Connections to DB2 Universal Database
Troubleshooting Installation Problems on Windows 2000
Still Have Problems?
Troubleshooting Tips
Developing Applications
Compiling and Linking Applications
Running Applications
Using CLI/ODBC/JDBC Applications
Using SQLJ Applications
Using the db2ocat Tool
Stored Procedures
Still Have Problems?
Still Have Problems?
Troubleshooting Tips
DB2 Universal Database Enterprise - Extended Edition Will Not Install
Determining a Failing Node
Database Manager Will Not Start
Cannot Create Database
Commands Cannot Be Issued
Problems Backing Up On Database Partitions
Lost Database Partitions on Windows 2000
Database Partition Size Rounding on Windows 2000
Problems with LOAD and with Splitting and Loading Data
Problems with Indexing Data
Problems during Recovery
Developing Applications in DB2 Enterprise - Extended Edition
Severe Error Occurs on System
Additional Enterprise - Extended Edition Considerations
First Failure Data Capture
DB2 Trace Facility
Other Methods
General Instructions When in a Bad State
Hierarchy of Shutdowns
Still Have Problems?
DB2 Data Links Manager Considerations
DB2 Data Links Manager
Data Access Token
Recovery Data Links Manager Environment
Backup Data Links Manager Environment
Export Operation
Import Operation
Load Considerations
DB2 Data Links Manager for Windows NT
Still Have Problems?
DB2 DataPropagator
Using the Log Header Control File with db2flsn
Example of Using the db2flsn Command and the db2diag.log File
DB2 DataPropagator Enhancements
Still Have Problems?
Prerequisite or related product issues
A DataJoiner Version 2 CREATE SERVER MAPPING statement for an Oracle data source fails
Unable to connect to a DB2 database from a Windows NT or Windows 2000 agent site
Cannot connect to an ODBC data source on UNIX
Unable to use TCP/IP to connect to AS/400 from Windows NT or Windows 2000
Connecting to a Sybase source fails
FTP log displays "NAMEFMT not a valid command"
The warehouse server or warehouse agent is unresponsive when using ODBC drivers that were purchased separately
Installation issues
Windows NT or Windows 2000 cannot install services for Data Warehouse Center components
Initialization fails at "Add install path to NT service path" message
Initialization fails with a "3043 Disk or Network Error" message
Data Warehouse Center files disappear after you install the product again
The Data Warehouse Center will not start
Initialization fails with an "Unable to connect" message
Initialization fails with a 9159: Win32 function RegOpenKeyEx failed message
Product function issues
A Data Warehouse Center component is unable to communicate with another component
The Data Warehouse Center and the AS/400 agent are unable to communicate
The warehouse logger stops while the Data Warehouse Center is running
A warehouse agent stops processing when promoting a step
Creation of an AIX or Solaris Operating Environment warehouse agent process fails
The Data Warehouse Center stops processing if you run several steps at the same time
Cannot import tables from AS/400
Columns defined as BINARY WITH PRECISION are interpreted as INTEGER
Prepare of SQL statement fails
The Data Warehouse Center displays return code 7356
Promoting a step that uses DB2 for MVS Version 4 Release 1 as the source and an AS/400 agent hangs
Promoting a step that uses DB2 for OS/390 as the warehouse target and the AS/400 agent fails
The Data Warehouse Center displays the "Could not retrieve the step RC- 3142" message when creating a step with a long name
The warehouse server cannot create a warehouse agent or it did not receive a valid reply back from the warehouse agent
The Start/End Date/Time is incorrect in the Work In Progress window
DB2 reports an SQL0973N error when you open and close steps
A step that uses Microsoft Access as a source fails
The Data Warehouse Center supplies incorrect table names or an ODBC OLE error occurs when using the Microsoft Excel 95/97 ODBC driver to access Excel spreadsheets
An file access error occurs when using the Data Warehouse Center ODBC text file driver or accessing files using warehouse programs
Column is no longer visible in the column grid
Supplied warehouse program issues
Step running VWPRCPY fails with RC2 = 12
On AS/400, the VWPFTP trace says that the job completed successfully, but data was not transferred and the FTP message log is missing
One of the OLAP Server warehouse programs cannot find the rules file or load file
User-defined programs are not found, or they run with errors
Still Have Problems?
Still Have Problems?
Still Have Problems?
Part 2. Advanced DB2 Troubleshooting
Description of the DB2 Process Model
Differences between Intel and UNIX
Viewing System Threads and Processes
First Failure Data Capture
Setting Configuration Parameters Affecting FFDC
Interpreting the db2diag.log
Interpreting db2diag.log Entry Headers
Interpreting an SQLCA Structure
Interpreting Hexadecimal Codes
Some Examples for Interpreting the db2diag.log
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
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 DB2 Connect Trace (ddcstrc)
Taking a DRDA Trace (db2drdat)
Taking an SNA Trace
Using the DB2 CLI/ODBC/JDBC Trace Facility
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 Enterprise - Extended Edition
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
Diagnostic Tools for Windows 95 and Windows 98
Diagnostic Tools for Windows NT
Using Administrative Tools Provided by Windows NT
Taking Screen Captures
Using DB2-Supplied Tools
Database System Monitor
Using the Snapshot Monitor
Using the Event Monitor
Control Center
Using Search Utility for DB2 Online Information
Troubleshooting Tips
Troubleshooting Page
Stored Procedure Builder
DB2 Index Advisor
Recovery Concepts
Recoverable and Non-Recoverable Databases
Database Logs
Point of Recovery
Dropped Table Point-in-Time Recovery
Table Space OFFLINE
Archive Logging
Table Space Usability
RESTART ... DROP PENDING TABLESPACE
RESTART ... DROP PENDING Table Space State
Table Space Usability
RESTART ... DROP PENDING
Database Directories
Database Files
Viewing the SQLCA Interactively
SQLCA Field Descriptions
Order of Error Reporting
DB2 Enterprise - Extended Edition Usage of the SQLCA
DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online