This DB2 SQL error occurs with Sterling B2B Integrator: SQLCODE: -1585, SQLSTATE: 54048
com.sterlingcommerce.woodstock.profile.ProfileFinderException: listAllByEntityName: Finder Exception occurred:
Message: DB2 SQL error: SQLCODE: -1585, SQLSTATE: 54048, SQLERRMC: null
The DB2 instance did not have all 4 sizes of Temp tablespace defined.
DBA had manually created the Temp tablespaces but only the 8k and 32k size.
Resolving The Problem
The DB2 instance must have all 4 sizes of Temp tablespace created: 4k, 8k, 16k, and 32k.
In addition, these must be set as System Temp tablespaces, and not as User Temp tablespaces.
11 February 2020