728x90
Question
From time to time, if an Informix Server crashes, the instance may be left in a state where the Server cannot start, and information about the recovery failure is needed. How can the dba collect information when the database has a failure and cannot recover?
Answer
1.Stop any Informix process that are still running.
2. Load the environment with the parameter: export STOP_RECOVERY=1 (using an appropriate shell command).
3. Attempt recovery, by starting the oninit process.
- The online log will show a message, similar to the following:
- 11:26:34 oninit hung at STOPPING_POINT 1, pid=19548
- onstat output, shared memory dump, OS commands etc.
http://www-01.ibm.com/support/docview.wss?uid=swg21644659
728x90
'Informix > informix troubleshooting' 카테고리의 다른 글
| 깨진 문자열 UNLOAD 하기위한 설정 (0) | 2018.08.01 |
|---|---|
| non-exclusive lock 확인, 해제 방법 (0) | 2017.07.19 |
| 인포믹스 12.10 설치시 오류 (Windows 2012 R2) (0) | 2015.08.05 |
| Errors 244 and 197 when running a write sql on a table (0) | 2015.07.16 |
| onbar restore중 out of virtual shared memory 오류 (0) | 2015.06.28 |