Solution : https://service.sap.com/sap/support/notes/16038 (SAP Service marketplace login required)
Summary :
SAP Note highlights issues with Informix server crashes due to internal errors, primarily segmentation violations. The issue typically manifests with entries in the database log indicating critical crashes and necessary abort steps. A common indicator of memory issues is found using the 'lockhash' symbol in memory dumps. Crashes occur due to complex SQL statements overloading thread stacks and premature dictionary copying caused by large table numbers in databases such as SAP R/3. Solutions include adjusting STACKSIZE, DD_HASHSIZE, and DD_HASHMAX configuration parameters to enhance memory allocation and error handling. Updated database software after version 7.23 UC4 contains fixes.
Key words :
additional key words assert failed, informix online server terminates, internal error - segmentation violationhh, informix configuration file $informixdir/, ss assert failed, reinitialize shared memoryhh, strings <dump-file>, complex sql statements, dd hashdd_hashmax 20 # width, shared memory dump
Related Notes :
| 38307 | Reducing shared memory consumption |