Solution : https://service.sap.com/sap/support/notes/831678 (SAP Service marketplace login required)
Summary :
In SAP environments on IBM i, database object damage can manifest in various errors, notably during backup operations or when executing SAP transactions, leading to specific error messages such as MCH0601, MCH1604, MCH1668, CPF3285, CPF3819, and CPF8111, usually accompanied by SQL code -901. The causes include hardware malfunctions, abrupt system terminations, or database software issues. Key troubleshooting data includes LIC logs, DSPLOG, job logs, journal receivers for the period of damage, and the faulty object, if relocated. For resolution, strategies vary based on the extent of damage—from full system recovery to individual object restoration—supplemented with detailed instructions for locating objects using SQL and handling delicate scenarios such as damaged primary keys or SQL packages.
Key words :
r3<sid>data/systables, r3<sid>data/sysindexes, start system service tools, r3<sid>data/qsqjrn, single-level storage concept, r3<sid>data/<table>, library r3<sid>data, library r3<sid>jrn, utilities -> database object -> display, symptom damaged database objects
Related Notes :
| 825473 | IBM i: Online backup as of V5R3M0 |
| 116192 | IBM i: SQL error -7008 |
| 63037 | AS/400: Deleting SQL Packages |