Error message: DB2® SQL error: SQLCODE: -964, SQLSTATE: 57011

You receive this SQL exception when you migrate IBM Spectrum Control data.

Problem

When migrating IBM Spectrum Control data, you get this 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

This message indicates that there is not enough storage available in the database heap to process the statement. This error message is 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 100

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

Action

Increase the transaction log files. See the Db2® documentation for information about increasing the transaction log files. Go to IBM®® Db2 Version 11.5 Knowledge documentation. Search for logprimary and logsecond.