SQL2310N with error "-964" when executing the

runstats, reorg, and reorgchk commands on a WebSphere Commerce DB2 database
 Technote (troubleshooting)
Problem(Abstract)
When executing the runstats, reorg, and reorgchk commands on a WebSphere Commerce DB2 database, the following error statement results:

SQL2310N The utility could not generate statistics. Error "-964" was returned.
Cause
There is insufficient database log space available.
Resolving the problem
The following three configuration values need to be tuned in order to create sufficient log space:

  • LOGFILSIZ

  • LOGPRIMARY

  • LOGSECOND


The following SQL statements should be executed to set the configuration parameters. Each specific WebSphere Commerce site needs to be tuned individually according to transaction volumes and specific needs. Example configuration values are provided in the SQL statements, but note that the given values are starting points and may need to be customized.

  • db2 update db cfg for <db_name> using LOGFILSIZ 10000

  • db2 update db cfg for <db_name> using LOGPRIMARY 6

  • db2 update db cfg for <db_name> using LOGSECOND 2


After making the above changes, stop and start the DB2 instance in order for the changes to take effect.

  • db2stop

  • db2start


After making the changes, attempt the runstats, reorg, and reorgchk commands again. If the error persists, increase the configuration values incrementally until the problem is resolved.

Cross Reference information
Segment Product Component Platform Version Edition
Commerce WebSphere Commerce Professional Edition Performance AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, Solaris, Windows 5.6, 5.6.1, 6.0 Professional Edition
Commerce WebSphere Commerce - Express Performance AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, Solaris, Windows 5.6, 5.6.1, 6.0 Express
Commerce WebSphere Commerce Business Edition Performance AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, Solaris, Windows 5.6, 5.6.1 Business Edition
   

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21224027