|
안녕하세요..
인포믹스 디비가.. 접속및.. 서버가 죽지도
않아.. 이렇게 질문을 드립니다.
1)
dbacces 를 실행후
SELECT DATABASE >>
Select a database with the Arrow Keys, or enter a name, then
press Return.
------------------------------------------------ Press CTRL-W
for Help --------
Running . . .
db 에 접근을 할수 없고 계속
running... 만뜨는현상
2)
[nms:/opt/informix/bin]# onmode -ky
실행후.. 뒤로 넘어가지 않습니다.
.. 서버가 죽지 않는 현상
3)onstat -d
[nms:/opt/informix/bin]# onstat
-d
IBM Informix Dynamic Server
Version 9.40.UC3 -- On-Line (CKPT REQ) -- Up 52 days 08:54:25
-- 196128 Kbytes
Blocked:CKPT <== 블럭걸려있습니다.
Dbspaces
address number flags fchunk nchunks flags owner
name
1727d7d8 1 0x20001 1 1 N informix
rootdbs
1727daf0 2 0x20001 2 1 N informix
isol_db
2 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages
flags pathname
1727d928 1 1 0 1024000 821334
PO-- /data/DBS/root.chk
17396d70 2 2 0 1024000 80257
PO-- /data/DBS/isol_db.chk
2 active, 2047 maximum
Expanded chunk capacity mode:
disabled
4)
[isl@nms:/home/isl/tomcat/bin]# !!
ps -ef | grep oninit
informix 839 1 33 2004 ? 17-19:09:32 ./bin/oninit
-v
root 840 839 0 2004 ? 00:03:38 ./bin/oninit
-v
root 841 840 0 2004 ? 00:07:14 ./bin/oninit
-v
root 842 840 0 2004 ? 00:03:12 ./bin/oninit
-v
root 843 840 0 2004 ? 02:19:08 ./bin/oninit
-v
root 844 840 0 2004 ? 00:00:04 ./bin/oninit
-v
root 845 840 0 2004 ? 01:35:00 ./bin/oninit
-v
root 846 840 0 2004 ? 00:13:03 ./bin/oninit
-v
root 847 840 0 2004 ? 00:06:13 ./bin/oninit
-v
root 848 840 10 2004 ? 5-19:00:59 ./bin/oninit
-v
isl 1384 31180 0 20:06 pts/2 00:00:00 grep
oninit
5) 로그내용
10:39:26 listener-thread: err = -25580: oserr = 104: errstr = :
System error occurred in network function.
System error = 104.
10:39:31 listener-thread: err = -408: oserr = 0: errstr = :
Invalid message type received from the sqlexec process.
6)
[nms:/opt/informix]# onstat -g ses
IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line (CKPT
REQ) -- Up 52 days 23:48:21 -- 196128 Kbytes
Blocked:CKPT
session #RSAM total
used dynamic
id user tty pid hostname threads memory
memory explain
5240 informix - 0 - 0 12288
7888 off
5239 isl - -1 nms 1 61440
56368 off
5238 isl - -1 nms 1 45056
33024 off
5237 isl - -1 nms 1 69632
66048 off
5236 isl - -1 nms 1 57344
42256 off
onmode -z 5239 시 ... 세션종료가 되지 않습니다.
어떻게 해야할지.... 아시는분은
답변주시면..감사합니다...
|
