Troubleshooting
Problem
After upgrading IBM i2 Analyze to a later version, an error is thrown in the messages.log referring to issues with temp system tables, and though you are able to read from the database in the product, you are unable to make changes/upload new records.
Symptom
[DATABASE]: Unable to perform an operation against the data sources for the RecordsResource Delegate
com.ibm.db2.jcc.am.SqlException: A temporary table could not be created because there is no table space available for temporary system tables that has a compatible page size. SQLCODE=-1585, SQLSTATE=54048
Cause
This is a common error in DB2 which occurs when a database isn't able to find temporary system table space with sufficient page size.
You may also find that your upgrade was still using DB2 11.1, whereas IBM i2 Analyze 4.3.4 requires DB2 11.5 as a minimum.
Resolving The Problem
Either run the upgrade again (if possible after restoring backups) but also update DB2 to version 11.5, or run the following commands against the affected DB2 database hosting your i2 Analyze system.
CREATE BUFFERPOOL BP8K pagesize 8K CREATE SYSTEM TEMPORARY TABLESPACE STB_8 PAGESIZE 8K BUFFERPOOL BP8K CREATE BUFFERPOOL BP16K pagesize 16K CREATE SYSTEM TEMPORARY TABLESPACE STB_16 PAGESIZE 16K BUFFERPOOL BP16K CREATE BUFFERPOOL BP32K pagesize 32K CREATE SYSTEM TEMPORARY TABLESPACE STB_32 PAGESIZE 32K BUFFERPOOL BP32K
Then upgrade DB2 to 11.5
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXVXZ","label":"IBM i2 Enterprise Insight Analysis"},"ARM Category":[{"code":"a8m0z000000cwj3AAA","label":"i2 Enterprise Insight Analysis->Database"}],"ARM Case Number":"TS007179640","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Historical Number
TS007179640
Was this topic helpful?
Document Information
Modified date:
14 October 2021
UID
ibm16498471