SAP Note 9233 - INF131, INF179, INF567, INF564: Cannot write/sort..

Component : Informix -

Solution : https://service.sap.com/sap/support/notes/9233 (SAP Service marketplace login required)

Summary :
During R/3 operations, SQL errors -567 / -564 with ISAM code -131 might occur, leading to ABAP report termination. Error -567 indicates an inability to write sorted rows, -564 signifies sorting issues, -131 points to a lack of free disk space, and -179 indicates no disk space for sorting. The cause is insufficient temporary disk space for 'ORDER BY' SQL statements. Possible reasons include inactive or incorrect temporary DBSPACES settings in the $ONCONFIG file, insufficient disk space, or the use of multiple temporary DBspaces within one action. Solutions involve checking and activating appropriate DBSpaces using the onstat -d command, correcting $ONCONFIG settings, and potentially extending temporary DBSPACES. Restart the system after configuration changes.

Key words :
sort additional key words inf131, symptom sql error -567 / -564 occurs, write sorted rows, free disk space, incorrect entry exists, disk space defined, command 'onstat -d', chunk list shows, additional temporary dbspace, temporary disk space

Related Notes :

13142Defining additional storage areas under INFORMIX