Home
User Guide
The information contained in this section applies to IBM WebSphere Commerce Version 7.0.0.9 and Feautre Pack 8. The documentation also applies to all subsequent releases and modifications until otherwise indicated in new editions.
Troubleshooting
WebSphere Commerce search
If you encounter problems while using WebSphere Commerce search, refer to the troubleshooting information to help determine the problem and find possible solutions.
SQL errors during indexing
You might encounter SQL errors when you build the WebSphere Commerce search index.

Troubleshooting: SQL errors during indexing

You might encounter SQL errors when you build the WebSphere Commerce search index.

Problem

When you build the WebSphere Commerce search index, you encounter SQL errors similar to the following snippet:


DB2 SQL Error: SQLCODE=-955 
, SQLSTATE=57011, SQLERRMC=2, DRIVER=4.14.103

Solution

This issue occurs when the DB2 heap size is set too low.

To resolve this issue, increase the heap size for the WebSphere Commerce search server.

For example:


db2 update db cfg for mall using SHEAPTHRES_SHR 4096

Important: Using large heap sizes in WebSphere Commerce search, for example, more than 4 GB, require a 64-bit installation of Apache Solr. That is, for example, if you intend to increase the heap size to values greater than 1280.

For more information, see WebSphere Commerce search performance tuning.