Error Messages: Get SQLCODE: -964, SQLSTATE: 57011, Unexpected error occurred while performing [a function]

You might receive these error messages when performing tasks within IBM Spectrum Control.

Problem

When performing tasks within IBM Spectrum Control that require accessing and storing data in the database repository, you might receive error messages similar to the following:

[message #]: Unexpected error occurred while performing the following [functions]

where

[message
#]

represents the number of the error message and [functions] represents a task that you were performing.

You might also see the following error message in the database installation log:

Instruction SQL : insert into t_stat_file_temp
SQLSTATE: 57011, Vendor error code: -964
DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011, 
SQLERRMC: null

These error messages are a result of running out of space in the transaction log. The transaction log configuration is set as:

db2 update db cfg for $DBNAME using logprimary 8
db2 update db cfg for $DBNAME using logsecond 16

Each transaction log file is 10 MB ( logFileSize=2500 pages of 4 KB each). Eight (8) primary log files are allocated all the time; secondary log files are allocated as needed, and deleted when not needed, to the maximum of 16.

Action

Increase the transaction log files. See the DB2 documentation for information about increasing the transaction log files.