https://www.cndba.cn/hbhe0316/article/4786https://www.cndba.cn/hbhe0316/article/4786https://www.cndba.cn/hbhe0316/article/4786

https://www.cndba.cn/hbhe0316/article/4786

原因为系统临时表空间不足，详见信息中心描述：https://www.ibm.com/support/pages/node/439759
Troubleshooting

https://www.cndba.cn/hbhe0316/article/4786

Problem
This DB2 SQL error occurs with Sterling B2B Integrator: SQLCODE: -1585, SQLSTATE: 54048
Symptom
com.sterlingcommerce.woodstock.profile.ProfileFinderException: listAllByEntityName: Finder Exception occurred:
SQLState: 54048
Message: DB2 SQL error: SQLCODE: -1585, SQLSTATE: 54048, SQLERRMC: null
Vendor: -1585
Cause
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.
Historical Number
PRI26178
SCI94737

解决方案：

db2 create bufferpool bp32k  size 1000 automatic pagesize 32k
db2 "create system temporary tablespace TEMPSPACE3 pagesize 32k  bufferpool bp32k"

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle,linux