Database error messages
The server.log file can contain error messages that relate to databases, such as DB2®, Oracle, and SQL Server.
DB2 SQL error example
- Log Type: Exception Header
WARN/ERROR DB2 SQL Error: SQLCODE=### SQLSTATE=#####
- Resolution area
- DB2database
- Issue
- An SQL exception was encountered. The value of SQLCODE is based on the cause of the exception.
- Suggested action
- Examine the message in the server.log and
find the line that starts with
SQLCODE
. To determine the cause, look up the SQLCODE in the online documentation for your DB2 version. The issues can be varied, from being out of space to invalid SQL. - Example 1
- This code indicates that the database has run out of space in the file system:
- Example 2
- In this example, the S_POLINE business object and its staging table do not exist.