informix又當(dāng)機(jī).online.log貼于內(nèi),請(qǐng)各路大俠診治??

muzx

kaio是指核心異步IO！
如果你沒(méi)有設(shè)置特意設(shè)置，那么你的系統(tǒng)就不會(huì)使用它！
如果你的dbs建立在熟文件上，就不要企圖使用kaio。

zzher

那我應(yīng)該沒(méi)有用到.我沒(méi)特意設(shè)過(guò),用的是裸設(shè)備.

muzx

有沒(méi)有用kaio可以用命令確認(rèn)的
onstat -g glo
如果其中沒(méi)有kaio，那肯定沒(méi)有用到kaio。

rock1001

muzx  ：

ROOTOFFSET 100 # Offset of root dbspace into device (Kbytes)
這樣子設(shè)有什么影響呢？

這樣作很好，這是一個(gè)好習(xí)慣！

－－－－－為什么說(shuō)是一個(gè)好習(xí)慣呢？設(shè)置偏移量有什么好處？？？？   

muzx

informix建議用戶使用裸設(shè)備作為數(shù)據(jù)庫(kù)空間，由于使用裸設(shè)備的緣故，informix建議用戶在初始化數(shù)據(jù)庫(kù)空間時(shí)最好給一個(gè)偏移量，避開(kāi)設(shè)備的初始段，主要是為了避免覆蓋os的設(shè)備管理信息或部分硬件的兼容性（這種情況雖然不多見(jiàn)，但確實(shí)存在，出于安全考慮）。
如果你使用的是熟設(shè)備，可以不必考慮這些因素，os已經(jīng)替你考慮了。

semicolon

看看
受益匪淺

bysysnet

Read error occurred during connection attempt.

This error can occur on either the client or database server side.

When you encounter this error on the client side, it indicates that a network I/O error occurred when the client tried to connect to a database server.  Probably the connection attempt timed out because the database server or the network was very busy, too many clients were attempting to connect to the database server simultaneously, or the database server was taken off-line during the connection attempt.

If you are using INFORMIX-OnLine Dynamic Server, verify that the database server is still on-line. If you are using the INFORMIX-SE database server, verify that the sqlexecd daemon for the database server is still running. Use the environment variables INFORMIXCONTIME and/or INFORMIXCONRETRY on the client side to increase the connection time and number of retry attempts.

When you encounter this error on the database server side, it is a warning that a network I/O error is detected while the database server is accepting a connection request from a client. This error usually occurs when the database server or the network is very busy or when too many clients are trying to connect to the database server at once. The database server might be taking so long to respond to a client that the client's connection request timed out before the connection is complete. Or possibly a client terminated its connection attempt before the connection is completely established.

If this error is seen only occasionally in the server message log, it is just a warning. No corrective action is required on the server side.

If this error occurs frequently on an INFORMIX-OnLine server that runs on a host with multiple processors, you might want to tune the database server by increasing the number of poll threads and/or listener threads.

bysysnet

增加你的locks values,buffers values,你給出onstat -R,onstat -g seg
,onstat -l,onstat -m的結(jié)果.

muzx

原帖由 "zzher" 發(fā)表：

1. ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
   
2. 0         0                    0        2315.67 872.96   479      1696
   

復(fù)制代碼

從以上參數(shù)看，暫時(shí)沒(méi)有必要增加locks,buffers,因?yàn)橄到y(tǒng)并沒(méi)有這樣的需求,也（你的系統(tǒng)已經(jīng)運(yùn)行了一天半來(lái)）沒(méi)有出現(xiàn)這兩個(gè)參數(shù)溢出的記錄。

zzher

問(wèn)題還是沒(méi)有解決，一些信息繼續(xù)貼如下！

$onstat -R
Informix Dynamic Server Version 7.30.UC2   -- On-Line -- Up 00:39:13 -- 458752 K
bytes

8 buffer LRU queue pairs                     priority levels
# f/m  pair total  % of    length     LOW   MED_LOW  MED_HIGH   HIGH
0 f     16510    99.8%    16474        2    16390       72       10
1 m               0.2%       36        0       36        0        0
2 f     16511    99.8%    16482        5    16413       54       10
3 m               0.2%       29        0       29        0        0
4 F     16507    99.8%    16478        6    16385       68       19
5 m               0.2%       29        0       29        0        0
6 f     16509    99.8%    16484        0    16388       83       13
7 m               0.2%       25        0       25        0        0
8 f     16509    99.8%    16480        0    16405       66        9
9 m               0.2%       29        0       29        0        0
10 f     16507    99.8%    16479        4    16405       63        7
11 m               0.2%       28        0       28        0        0
12 f     16509    99.9%    16489       13    16409       58        9
13 m               0.1%       20        0       20        0        0
14 f     16509    99.8%    16482        0    16397       76        9
15 m               0.2%       27        0       27        0        0
223 dirty, 132071 queued, 132100 total, 262144 hash buckets, 2048 buffer size
start clean at 60% (of pair total) dirty, or 9908 buffs dirty, stop at 50%



$onstat -g seg

Informix Dynamic Server Version 7.30.UC2   -- On-Line -- Up 00:40:25 -- 458752 K
bytes

Segment Summary:
id       key        addr     size       ovhd     class blkused  blkfree
1        1381451777 82000000 402653184  6996     R     48724    428
2        1381451778 9a000000 8388608    720      V     1017     7
3        1381451779 9a800000 20971520   912      V     2558     2
4        1381451780 9bc00000 4194304    656      M     260      252
5        1381451781 9c000000 20971520   912      V     1151     1409
6        1381451782 9d400000 8388608    720      V     1        1023
7        1381451783 9dc00000 8388608    720      V     66       958
Total:   -          -        473956352  -        -     53777    4079

   (* segment locked in memory)

$onstat -l

Informix Dynamic Server Version 7.30.UC2   -- On-Line -- Up 00:41:49 -- 458752 K
bytes

Physical Logging
Buffer bufused  bufsize  numpages numwrits pages/io
  P-1  13       10000    2522     8        315.25%
      phybegin physize  phypos   phyused  %used
      10003f   25000    6554     13       0.05

Logical Logging
Buffer bufused  bufsize  numrecs  numpages numwrits recs/pages pages/io
  L-3  0        10000    2394     74       17       32.4       4.4
        Subsystem    numrecs  Log Space used
        OLDRSAM      2394     120636

address  number   flags    uniqid   begin        size     used    %used
82ae5d20 1        U-B----  1        1061e7       5000     5000   100.00%
82ae5d3c 2        U-B----  2        10756f       5000     5000   100.00%
82ae5d58 3        U-B----  3        1088f7       5000     5000   100.00%
82ae5d74 4        U-B----  4        109c7f       5000     5000   100.00%
82ae5d90 5        U-B----  5        10b007       5000     5000   100.00%
82ae5dac 6        U---C-L  6        300035      25000     2782    11.13%
82ae5dc8 7        F------  0        3061dd      24945        0     0.00%



$ onstat -m

Informix Dynamic Server Version 7.30.UC2   -- On-Line -- Up 00:42:56 -- 458752 K
bytes

Message Log File: /usr/informix/online.log
16:44:40  dynamically allocated new shared memory segment (size 2055372

16:44:41  dynamically allocated new shared memory segment (size 838860

16:44:41  dynamically allocated new shared memory segment (size 838860

16:44:45  Logical Recovery Complete.
        0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

16:44:45  Dataskip is now OFF for all dbspaces
16:44:45  On-Line Mode
16:44:45  Checkpoint Completed:  duration was 0 seconds.
16:49:47  Checkpoint Completed:  duration was 0 seconds.
16:54:51  Checkpoint Completed:  duration was 1 seconds.
16:59:56  Checkpoint Completed:  duration was 0 seconds.
17:05:01  Checkpoint Completed:  duration was 2 seconds.
17:10:12  Checkpoint Completed:  duration was 8 seconds.
17:15:15  Checkpoint Completed:  duration was 0 seconds.
17:20:18  Checkpoint Completed:  duration was 0 seconds.
17:25:21  Checkpoint Completed:  duration was 0 seconds.