Solution : https://service.sap.com/sap/support/notes/17267 (SAP Service marketplace login required)
Summary :
The SAP Note addresses errors in Informix during specific database operations (e.g., batch input sessions, client modifications, and language import/completion). Errors include ISAM lock shortages and several SQL errors like INF240 and INF605 indicating inability to manipulate rows or blobs. The problem is rooted in exceeding the maximum simultaneous database locks, leading to transaction termination and extensive rollback. Solutions involve increasing the maximum lock limit, changing lock granularity, or splitting the DB transaction to release locks promptly. Implementing these solutions requires changes in DB server settings and possibly, operational procedures.
Key words :
additional key words inf240 inf246 inf271 inf418 inf603 inf605 inf134 isam134rsclicop rscliexp rslangim rslangcp r3trlanz, $ dbaccess <sid> - > alter table <table> lock mode, create/process batch input sessions, 'page lock' takes place implicitly, $ dbaccess <sid> - > begin work, host variable list encountered, dml instruction 'lock table, informix profile parameter 'locks', db transaction responsible generally, batch input sessions
Related Notes :
| 436980 | Database error with client copy |
| 358613 | SAP BW: SQL error "ISAM-134: no more locks" |
| 142645 | VBSK deadlock |
| 108330 | InfoDB update number 5 |
| 69240 | Archiving: maximum number of database blocking achieved |
| 18993 | Influence of LOCK Parameter on Shared Memory Size |