informix又当机.online.log贴于内,请各路大侠诊治??

muzx

kaio是指核心异步IO！
如果你没有设置特意设置，那么你的系统就不会使用它！
如果你的dbs建立在熟文件上，就不要企图使用kaio。

zzher

那我应该没有用到.我没特意设过,用的是裸设备.

muzx

有没有用kaio可以用命令确认的
onstat -g glo
如果其中没有kaio，那肯定没有用到kaio。

rock1001

muzx  ：

ROOTOFFSET 100 # Offset of root dbspace into device (Kbytes)
这样子设有什么影响呢？

这样作很好，这是一个好习惯！

－－－－－为什么说是一个好习惯呢？设置偏移量有什么好处？？？？   

muzx

informix建议用户使用裸设备作为数据库空间，由于使用裸设备的缘故，informix建议用户在初始化数据库空间时最好给一个偏移量，避开设备的初始段，主要是为了避免覆盖os的设备管理信息或部分硬件的兼容性（这种情况虽然不多见，但确实存在，出于安全考虑）。
如果你使用的是熟设备，可以不必考虑这些因素，os已经替你考虑了。

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的结果.

muzx

原帖由 "zzher" 发表：

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

复制代码

从以上参数看，暂时没有必要增加locks,buffers,因为系统并没有这样的需求,也（你的系统已经运行了一天半来）没有出现这两个参数溢出的记录。

zzher

问题还是没有解决，一些信息继续贴如下！

$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.