SAP Note 13957 - Index is now unusable

Component : Informix -

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

Summary :
Certain SAP transactions experience sudden performance slowdowns or ABAP/4 runtime errors such as DBIF_RSQL_SQL_ERROR or DBIF_RTAB_SQL_ERROR. SYSLOG entries include "SQL error -243" and "ISAM-101: file is not open." Earlier database log files (online.log) might show messages like "Index is now unusable" suggesting a dbspace overflow during index modification rollback. SYSLOG may also show "ISAM-131: no free disk space." To resolve, use 'oncheck -cI' for specified index and recreate it with SAPDBA, following steps to stop and start the R/3 System as detailed.

Key words :
additional key words inf243, abap/4 runtime error dbif_rsql_sql_error, sql error <error> occurs, abap/4 runtime error, sql error -243 occured, sudden extremely slow, database log file, syslog previous entries, free disk space, user <sid>adm

Related Notes :

510019
38401Download the latest SAPDBA version