Chinaunix

标题: INFORMIX 侦听怪问题,请各路高手会诊!!!!!!!!! [打印本页]

作者: bluely 时间: 2004-09-08 16:27
标题: INFORMIX 侦听怪问题,请各路高手会诊!!!!!!!!!
最近发生一个奇怪问题,问题是这样,INFORMIX 版本是9.21 CU2 FOR AIX 5L 补丁为6ML,INFORMIX启动正常,信息如下1,:但用ODBC,或客户端无法联接数据,报错误信息如2:sqlhosts配置信息如下3;ONCONFIG信息如4;/ETC/SERVICES有相关的端口:但将ONCONFIG.ABC的NET 改为CPU时,可以联接上,信息如下5:现在不知为什么会这样,原来5L 5ML时用NET的配置正常的可用,但现在不知为什么会这样,请各路高手会诊,先谢了!!!
信息1:
11:32:52  Loading Module <CNULL>;
11:32:52  Booting Language <builtin>; from module <>;
11:32:52  Loading Module <BUILTINNULL>;
11:32:57  AIX MP latch code enabled
11:32:57  Requested shared memory segment size rounded from 648KB to 656KB
11:32:57  Informix Dynamic Server 2000 Version 9.21.UC2    Software Serial Numb
er AAC#J927554
11:32:58  Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized.

11:32:58  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tmpdbs'
11:32:58  Physical Recovery Started.
11:32:58  Physical Recovery Complete: 0 Pages Restored.

11:32:58  Logical Recovery Started.
11:32:58  10 recovery worker threads will be started.
11:33:02  Logical Recovery Complete.
      0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

11:33:03  Dataskip is now OFF for all dbspaces
11:33:03  On-Line Mode
11:33:03  Checkpoint Completed:  duration was 0 seconds.
11:33:03  Checkpoint loguniq 2, logpos 0x1f8018

信息如下2
27001: Read error occurred during connection attempt.

sqlhosts配置信息如下3
online       onipcshm       devf85       sql36
on_tcp       onsoctcp       devf85       sql36

信息如下4

SERVERNUM2# Unique id corresponding to a OnLine instance
DBSERVERNAME online# Name of default database server
DBSERVERALIASES on_tcp# List of alternate dbservernames
NETTYPEsoctcp,1,100,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60# Max time to wait of lock in distributed env.
RESIDENT0# Forced residency flag (Yes = 1, No = 0)

信息如下5

作者: bluely 时间: 2004-09-09 10:55
标题: INFORMIX 侦听怪问题,请各路高手会诊!!!!!!!!!
有谁能说说NET与CPU 的在底层操作有什么不同??

作者: zzjijun 时间: 2004-09-09 14:02
标题: INFORMIX 侦听怪问题,请各路高手会诊!!!!!!!!!
知道两点：
1、poll thread跑在CPU vp上比跑在NET vp上的优先级高
2、poll thread如果跑在CPU vp上建议poll thread的个数不要超过CPU vp的个数

作者: songdu 时间: 2004-09-09 16:38
标题: INFORMIX 侦听怪问题,请各路高手会诊!!!!!!!!!
好象只是一个警告而已

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)