informix初始化新问题！急！

[zhukejun]

我执行oninit -i -v 后：
This action will initialize Informix Dynamic Server 2000;
any existing Informix Dynamic Server 2000 databases will NOT be accessible -
Do you wish to continue (y/n)? y
Checking group membership to determine server run modesucceeded
Reading configuration file '/var/informix/etc/onconfig.cc08md'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/var/informix/etc/.infos.online" ... "/var/informix/etc/.cd
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 618 kbytes...succeeded
Creating buffer pool 2002 kbytes...succeeded
Initializing rhead structure...succeeded
Initializing ASF ...
------------------然后就自动退出！
查看online.log，内容如下：

Mon May 20 22:55:16 2002

22:55:16 Event alarms enabled. ALARMPROG = '/var/informix/etc/log_full.sh'
22:55:17 Assert Failed: net_init.c, line 327, thread 1, errno=1, error in updating /INFORMIXTMP.
22:55:17 Informix Dynamic Server 2000 Version 9.21.HC5
22:55:17 Who: Session(0, @, 0, 0)
Thread(1, main_thread, 0, 1)
File: neterrb.c Line: 658
22:55:17 stack trace for pid 2045 written to /tmp/af.3e9ef54
22:55:17 See Also: /tmp/af.3e9ef54, shmem.3e9ef54.0
22:55:18 Unable to create output file '/tmp/shmem.3e9ef54.0' errno = 28
22:55:18 neterrb.c, line 658, thread 1, proc id 2045, net_init.c, line 327, thread 1, errno=1, error in updating /INFORMIXTMP..
22:55:18 PANIC: Attempting to bring system down
什么原因？

[freebird77]

你看一下是不是你的/tmp是不是沒有空間了?

[loanerw]

配置online做初始化的几个主要参数：
ROOTPATH 改为chunk的路径。
MSGPATH 和home director及informixdir统一
TAPEDEV /dev/null
LTAPEDEV /dev/null
DBSERVERNAME 同.profile中informixserver名字和sqlhosts中统一

[zhukejun]

loanerw(把你的钱给我我放高利贷给你),你也来了
我的问题比以前有进步了，是我把别人安装成功的目录下的bin&动态连接库
拷过来才好的，但是现在又有新问题了

[loanerw]

刚才我用你的设置测试了一下。
NETTYPE ipcstr,,, # Configure poll thread(s) for nettype

改为：

NETTYPE soctcp,1,150,NET # Configure poll thread(s) for nettype
测试一下，刚才我在这里过不去。

[zhukejun]

我用的是ipcshm方式，release 下将这个方式设为ipcstr

[zhukejun]

你看一下是不是你的/tmp是不是沒有空間了?

跟这个有关系吗？要多少呢？我的
$ bdf
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvol3 143360 25884 110435 19% /
/dev/vg00/lvol1 83733 23313 52046 31% /stand
/dev/vg00/lvol8 512000 263462 235877 53% /var
/dev/vg00/lvol7 454656 426444 26495 94% /usr
/dev/vg00/lvol4 65536 1503 60422 2% /tmp
/dev/vg00/lvol6 270336 243565 25554 91% /opt
/dev/vg00/lvol5 20480 1242 18096 6% /home
$
只有这么大，怎么解决呢

[loanerw]

那你就把
DUMPDIR
BAR_ACT_LOG
写入的位置换一下目录

[zhukejun]

我改了，没有用，错误依旧

[loanerw]

我已经弹尽粮绝了。看一下这里的文章了，不行，就再安装一变了。
http://www.texiao.net/asp/index.asp?pgtype=ifx

[twit_book]

LOOK /usr/informix/etc/sqlhosts for "ASF..."

[freebird77]

你再看一下你的sqlhosts,共有4列, 第一列是dbservername要和 onconfig中的
DBSERVERNAME一致,第二列是NETTYPE這個要和ONCONFIG中的NETTYPE一致,
第三列是HOSTNAME 要和hosts文件中的hostname一致,再試一下,看如何!

[zhukejun]

sqlhosts文件内容：
#demo_ononipcshmon_hostnameon_servername
#demo_seseipcpipse_hostnamesqlexec
onlineonipcshmcc08mdsqlexec
#onlineontlitcpcc08mdsqlexec_net

[zhukejun]

onconfig.cc08md内容：
# Root Dbspace Configuration

ROOTNAME rootdbs # Root dbspace name
ROOTPATH /var/informix/rootdbs # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 30000 # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 2000 # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES 6 # Number of logical log files
LOGSIZE 1500 # Logical log size (Kbytes)

# Diagnostics

MSGPATH /var/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /var/informix/etc/log_full.sh # Alarm program path
TBLSPACE_STATS 1 # Maintain tblspace statistics

# System Archive Tape Device

TAPEDEV /dev/null # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB # Informix Dynamic Server 2000 staging area

# System Configuration

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

MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors

# Shared Memory Parameters

LOCKS 2000 # Maximum number of locks
BUFFERS 1000 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
LOGSMAX 6 # Maximum number of logical log files
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 8000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
................

[dragon_lxl]

这个问题我也碰到过，这是因为你的sqlhosts文件里的nettype和onconfig里的配置不同，你仔细检查一下，在这个文件里应该有servername,ontlitcp,sqlexec.并且不能被注释掉。这个问题曾经困扰了我一段时间，我的QQ:115926406，可以在线讨论。如有msn,那就更好。

[zhukejun]

是一样的，我看了很多遍了都！

[zhukejun]

我已解决

[loanerw]

怎么搞定的？

[whoke]

保密？自私？