Failed to execute DB2 Top SQL collection due to error occurred with SQL Code -83 (4277634)

サポートと今すぐチャット

戻る

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

タイトル

Failed to execute DB2 Top SQL collection due to error occurred with SQL Code -83
説明

Failed to execute DB2 Top SQL collection due to error occurred with SQL Code -83 on the Db2 db agent log. There is no data appearing on the Db2 dashboard for Top SQLs.
原因

SQL0083C A memory allocation error has occurred. This is Db2 error message.
対策

Resolution:
SQL0083C A memory allocation error has occurred.
Explanation: During processing, there was not enough memory to continue processing.
Possible solutions include:
-Ensure that your system has sufficient real and virtual memory.
-Remove background processes.
If you continue to receive this message after attempting the suggested solutions, contact IBM Customer Support.
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00083c.html
In addition to "SQL0083C DURING SORT MEMORY ALLOCATION" which is SQL Code -83 error message, here are additional links from IBM website:
http://www-01.ibm.com/support/docview.wss?uid=swg1IZ08387
or
http://www-01.ibm.com/support/docview.wss?uid=swg1IZ08403
追加情報

Maybe updating of SHEAPTHRES_SHR and SORTHEAP parameters at the database can resolve this error as well.

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

推奨コンテンツ

製品：: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5, 5.7.1, 5.6.11; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

タイトル