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.cndba.cn/hbhe0316/article/4786

原因為系統臨時表空間不足，詳見信息中心描述：https://www.ibm.com/support/pages/node/439759
Troubleshooting

https://www.cndba.cn/hbhe0316/article/4786 https://www.cndba.cn/hbhe0316/article/4786 https://www.cndba.cn/hbhe0316/article/4786 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

解決方案：

https://www.cndba.cn/hbhe0316/article/4786 db2 create bufferpool bp32k size 1000 automatic pagesize 32k db2 "create system temporary tablespace TEMPSPACE3 pagesize 32k bufferpool bp32k"

版權聲明：本文為博主原創文章，未經博主允許不得轉載。

oracle,linux

總結

以上是生活随笔為你收集整理的SQLCODE=-1585的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。