Db2 and database troubleshooting

Use this section to troubleshoot and resolve problems with IBM® Db2® and the database.

Db2 crashes on RHEL 7.2
IBM Db2 servers might crash when the RemoveIPC option for Red Hat® Enterprise Linux® 7.2 is set to yes.
Db2 log messages ADM5530W can be ignored
ADM5530W messages in the Db2 Event Log and db2diag.log indicate that the materialized query table (MQT) is using the 'NOT LOGGED INITIALLY' option to improve database performance and create fewer transaction log entries. These messages do not require any user action and can be ignored.
Db2 log files fill the C drive on the Windows DB2 system
On Db2 servers that run for extended periods of time, the Db2 logs can grow large enough to fill the C: drive if the default Db2 log location is used.
Cannot read Korean language logs from GUI
This problem occurs in Korean language environments.
Installation fails with "No valid local database found" error
During the IBM Spectrum Control installation, an error occurs stating that no valid databases were found.
Error message: GUI0023M
This error occurs when performing a system reboot.
Error message: SRV0024E
This error occurs when Db2 is down or not running.
Error message: SRV0044E
This error occurs when the password for the Db2 user ID account for which IBM Spectrum Control is installed under is changed.
Db2 instance crashes
This problem occurs when running an agent probe.
Db2 connection errors
These errors occur when rebooting remote Db2 servers.
Error message: SQL0968C
This error occurs when the file system storing the database table runs out of space.
Error message when installing Db2 on Windows
You get an error message when installing Db2 on a Windows system.
Error message: HWNOP0033 Database operation failed
You receive this error message after running several storage optimizer jobs.
Error message: DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011
You receive this SQL exception when you migrate IBM Spectrum Control data.
Error message: DB2 SQL error: SQLCODE: -973,STATE:57011, SQLERRMC:PCKCACHESZ
You receive this error when opening a panel in the IBM Spectrum Control user interface that requires information from the database repository. For example, when you generate a report or view a list of devices managed by CIMOMs.
Error message: DEBUG: Error 2836
After you install Db2, you might see this error message in the Db2 installation log file.
Error message: SRV0046E, Db2 stops running
You receive this error message when Db2 stops running.
Error message: The statement is too long or too complex (SQL0101N)
This error occurs when there is not enough storage available in the database heap to process a statement.
Db2 expired license error
IBM Spectrum® Control installation and operation requires that Db2 is running. After the Db2 trial license period expires, Db2 does not start without a valid license.
Context root not found on IBM Spectrum Control 5.3.5 or later on Red Hat Enterprise Linux 7
On the Red Hat Enterprise Linux 7 operating system, the Db2 and IBM Spectrum Control web server are configured to start at the same time upon start up.

Parent topic: Introduction to troubleshooting