当INFORMIX数据库服务器出现异常情况,我们需要立即重新启动数据库的情况下,我们可以按照下面的方法进行数据库的关闭操作:
做下面的操作之前,请做好必要的信息的收集工作。比如:
/opt/informix>onstat -a > onstata.sql
/opt/informix>onstat -g stk all > onstatgstkall.log
然后执行如下操作杀掉informix数据库的核心进程即可:
1、/opt/informix>onstat -g glo
IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line (CKPT REQ) -- Up 77 days 23:59:54 -- 6472900 Kbytes
Blocked:CKPT
MT global info:
sessions threads vps lngspins
254 312 22 1621
sched calls thread switches yield 0 yield n yield forever
total: 2682208374 1934476358 898248812 104434024 729883846
per sec: 15 15 0 12 0
Virtual processor summary:
class vps usercpu syscpu total
cpu 7 1040863.35 89660.27 1130523.62
aio 10 39.39 146.00 185.39
lio 1 3.82 14.77 18.59
pio 1 4.08 14.68 18.76
adm 1 148.71 401.81 550.52
soc 1 1041.96 5600.11 6642.07
msc 1 225.89 907.70 1133.59
total 22 1042327.20 96745.34 1139072.54
Individual virtual processors:
vp pid class usercpu syscpu total
1 3551 cpu 216353.61 17415.49 233769.10
2 3552 adm 148.71 401.81 550.52
3 3553 cpu 261464.80 20754.77 282219.57
4 3554 cpu 211624.19 15666.87 227291.06
5 3555 cpu 136530.03 11733.39 148263.42
6 3556 cpu 91945.35 9022.65 100968.00
7 3557 cpu 67177.03 7790.28 74967.31
8 3558 cpu 55768.34 7276.82 63045.16
9 3559 lio 3.82 14.77 18.59
10 3560 pio 4.08 14.68 18.76
11 3561 aio 5.27 16.52 21.79
12 3562 msc 225.89 907.70 1133.59
13 3563 aio 3.84 14.91 18.75
14 3564 aio 4.10 14.62 18.72
15 3565 aio 3.70 14.23 17.93
16 3566 aio 3.75 14.27 18.02
17 3567 aio 3.56 14.46 18.02
18 3568 aio 3.98 14.48 18.46
19 3569 aio 3.84 14.19 18.03
20 3570 aio 3.70 14.20 17.90
21 3571 aio 3.65 14.12 17.77
22 3572 soc 1041.96 5600.11 6642.07
tot 1042327.20 96745.34 1139072.54
2、/opt/informix>kill -9 3551
然后重启数据库【oninit -vy】就可以(这种情况下数据库会进行恢复,启动过程比较慢)