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

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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.
Ursache

SQL0083C A memory allocation error has occurred. This is Db2 error message.
Lösung

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
Weitere Informationen

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

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: 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

Titel