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.