建立表空间时出现 shared memory not initialized for INFORMIXSERVER

如题出现错误,建立表空间失败,具体情况如下:
输入:onspaces -c -d plogdbs -p /opt/informix/chunks/plogchk -o 0 -s 2000000
输出:shared memory not initialized for INFORMIXSERVER 'testserver'

查看onstat -m:
IBM Informix Dynamic Server Version 11.50.FC9DE -- On-Line -- Up 01:19:12 -- 149196 Kbytes

Message Log File: /opt/informix/tmp/online.log
20:14:43  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

20:29:44  Checkpoint Completed:  duration was 0 seconds.
20:29:44  Thu Nov  6 - loguniq 1, logpos 0x6018, timestamp: 0xe1 Interval: 5

20:29:44  Maximum server connections 0
20:29:44  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

20:44:44  Checkpoint Completed:  duration was 0 seconds.
20:44:44  Thu Nov  6 - loguniq 1, logpos 0x8018, timestamp: 0xeb Interval: 6

20:44:44  Maximum server connections 0
20:44:44  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

20:59:45  Checkpoint Completed:  duration was 0 seconds.
20:59:45  Thu Nov  6 - loguniq 1, logpos 0xa018, timestamp: 0xf5 Interval: 7

20:59:45  Maximum server connections 0
20:59:45  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

查看ipcs:
------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x52564801 655364     informix   660        119336960  9                       
0x52564802 688133     informix   660        33439744   9                       

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     
0x00000000 163844     root       660        9         
0x00000000 196613     root       660        9         
0x00000000 327686     informix   660        9         

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages   

小弟初学,感谢各位大神的帮助!!

补充一下,初步认为是Maximum server connections 数量的问题...不明白为什么是0,能不能改?
参与19

18同行回答

liaosnetliaosnet信息分析/架构师gbasedbt.com
回复 8# PumChi     ssh 到122 这台机器上,使用informix用户执行onspaces命令。显示全部
回复 8# PumChi


    ssh 到122 这台机器上,使用informix用户执行onspaces命令。收起
IT咨询服务 · 2014-11-10
浏览1234
PumChiPumChi其它UCSD
回复 7# liaosnet     这么说吧,我的任务是在名为122的服务器上装上informix,数据库是给这个服务器用的,这算不算本机?如果不算,应该怎么解决目前的问题?谢谢大神显示全部
回复 7# liaosnet


    这么说吧,我的任务是在名为122的服务器上装上informix,数据库是给这个服务器用的,这算不算本机?如果不算,应该怎么解决目前的问题?谢谢大神收起
IT其它 · 2014-11-10
浏览1228
liaosnetliaosnet信息分析/架构师gbasedbt.com
回复 6# PumChi     onspaces命令只能在本机上执行。。。即数据库IP和本机IP相同时才可执行。显示全部
回复 6# PumChi


    onspaces命令只能在本机上执行。。。即数据库IP和本机IP相同时才可执行。收起
IT咨询服务 · 2014-11-10
浏览1198
PumChiPumChi其它UCSD
回复 5# liaosnet 是主机名,我是ssh连上另一台服务器上装的显示全部
回复 5# liaosnet

是主机名,我是ssh连上另一台服务器上装的收起
IT其它 · 2014-11-09
浏览1225
liaosnetliaosnet信息分析/架构师gbasedbt.com
sqlhost:         demo_on        onipcshm          on_hostname           on_servername        &nb...显示全部
sqlhost:
         demo_on        onipcshm          on_hostname           on_servername
         testserver        onsoctcp                122                           9088

这个122是真实的主机名?? 还只是IP? 指向的主机是本机呢?还是远程?收起
IT咨询服务 · 2014-11-08
浏览1141
PumChiPumChi其它UCSD
回复 3# liaosnet     sqlhost:         demo_on        onipcshm          on_hostname           on_servername      ...显示全部
回复 3# liaosnet


    sqlhost:
         demo_on        onipcshm          on_hostname           on_servername
         testserver        onsoctcp                122                           9088
    onconfig:
# Root Dbspace Configuration Parameters


ROOTNAME rootdbs
ROOTPATH /opt/informix/chunks/rootchk
ROOTOFFSET 5000
ROOTSIZE 1500000
MIRROR 0
MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
MIRROROFFSET 0

# Physical Log Configuration Parameters

PHYSFILE 50000
PLOG_OVERFLOW_PATH  $INFORMIXDIR/tmp
PHYSBUFF 128

# Logical Log Configuration Parameters

LOGFILES 6
LOGSIZE 10000
DYNAMIC_LOGS 2
LOGBUFF 64

# Long Transaction Configuration Parameters

LTXHWM 70
LTXEHWM 80

# Server Message File Configuration Parameters

MSGPATH $INFORMIXDIR/tmp/online.log
CONSOLE $INFORMIXDIR/tmp/online.con

# Tblspace Configuration Parameters

TBLTBLFIRST 0
TBLTBLNEXT 0
TBLSPACE_STATS 1

# Temporary dbspace and sbspace Configuration Parameters

DBSPACETEMP
SBSPACETEMP

# Dbspace and sbspace Configuration Parameters

SBSPACENAME
SYSSBSPACENAME
ONDBSPACEDOWN 2

# System Configuration Parameters

SERVERNUM 0
DBSERVERNAME    testserver
DBSERVERALIASES testserver

# Network Configuration Parameters

NETTYPE ipcshm,1,50,CPU
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1

# CPU-Related Configuration Parameters

MULTIPROCESSOR 0
VPCLASS cpu,num=1,noage
VP_MEMORY_CACHE_KB 0
SINGLE_CPU_VP 0

# AIO and Cleaner-Related Configuration Parameters

#VPCLASS aio,num=1
CLEANERS 8
AUTO_AIOVPS 1
DIRECT_IO 0

# Lock-Related Configuration Parameters

LOCKS 20000
DEF_TABLE_LOCKMODE page

# Shared Memory Configuration Parameters

RESIDENT 0
SHMBASE 0x44000000L
SHMVIRTSIZE 32656
SHMADD 8192
EXTSHMADD 8192
SHMTOTAL 65312
SHMVIRT_ALLOCSEG 0,3
SHMNOACCESS

# Checkpoint and System Block Configuration Parameters

CKPTINTVL 300
AUTO_CKPTS 1
RTO_SERVER_RESTART 0
BLOCKTIMEOUT 3600

# Conversion Guard Related Configuration Parameters

CONVERSION_GUARD 2
RESTORE_POINT_DIR $INFORMIXDIR/tmp


# Transaction-Related Configuration Parameters

TXTIMEOUT 300
DEADLOCK_TIMEOUT 60
HETERO_COMMIT 0

# ontape Tape Device Configuration Parameters

TAPEDEV /dev/null
TAPEBLK 32
TAPESIZE 0

# ontape Logial Log Tape Device Configuration Parameters

LTAPEDEV /dev/null
LTAPEBLK 32
LTAPESIZE 0

# Backup and Restore Configuration Parameters

BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log
BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log
BAR_DEBUG 0
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE ON
BAR_PROGRESS_FREQ 0
BAR_BSALIB_PATH
BACKUP_FILTER
RESTORE_FILTER
BAR_PERFORMANCE 0

# Informix Storage Manager (ISM) Configuration Parameters

ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs

# Data Dictionary Cache Configuration Parameters

DD_HASHSIZE 31
DD_HASHMAX  10

# Data Distribution Configuration Parameters

DS_HASHSIZE 31
DS_POOLSIZE 127

# User Defined Routine (UDR) Cache Configuration Parameters

PC_HASHSIZE 31
PC_POOLSIZE 127

# SQL Statement Cache Configuration Parameters

STMT_CACHE 0
STMT_CACHE_HITS 0
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1

# Operating System Session-Related Configuration Parameters

USEOSTIME 0
STACKSIZE 64
ALLOW_NEWLINE 0
USELASTCOMMITTED NONE

# Index Related Configuration Parameters

FILLFACTOR 90
MAX_FILL_DATA_PAGES 0
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default
ONLIDX_MAXMEM 5120

# Parallel Database Query (PDQ) Configuration Parameters

MAX_PDQPRIORITY 100
DS_MAX_QUERIES
DS_TOTAL_MEMORY
DS_MAX_SCANS 1048576
DS_NONPDQ_QUERY_MEM 128
DATASKIP

# Optimizer Configuration Parameters

OPTCOMPIND 2
DIRECTIVES 1
EXT_DIRECTIVES 0
OPT_GOAL -1
IFX_FOLDVIEW 0
AUTO_REPREPARE 1

# Scan Configuration Parameters

RA_PAGES     64
RA_THRESHOLD 16
BATCHEDREAD_TABLE 0

# SQL Tracing and EXPLAIN Plan Configuration Parameters

EXPLAIN_STAT 1
#SQLTRACE level=low,ntraces=1000,size=2,mode=global

# Security Configuration Parameters

#DBCREATE_PERMISSION informix
#DB_LIBRARY_PATH
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION
UNSECURE_ONSTAT
ADMIN_USER_MODE_WITH_DBSA
ADMIN_MODE_USERS
SSL_KEYSTORE_LABEL

# LBAC Configuration Parameters

PLCY_POOLSIZE 127
PLCY_HASHSIZE 31
USRC_POOLSIZE 127
USRC_HASHSIZE 31

# Optical Configuration Parameters

STAGEBLOB
OPCACHEMAX 0

# Built-in Character Data Types Parameters

SQL_LOGICAL_CHAR OFF

# Sequence Cache Parameters

SEQ_CACHE_SIZE 10

# High Availability and Enterprise Replication Security
# Configuration Parameters

ENCRYPT_HDR
ENCRYPT_SMX
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC
ENCRYPT_MACFILE
ENCRYPT_SWITCH


# Enterprise Replication (ER) Configuration Parameters

CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_NIFCOMPRESS 0
CDR_SERIAL 0
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE
CDR_MAX_DYNAMIC_LOGS 0
CDR_SUPPRESS_ATSRISWARN


# High Availability Cluster (HDR, SDS, and RSS)
# Configuration Parameters

DRAUTO                  0
DRINTERVAL              30
DRTIMEOUT               30
HA_ALIAS
DRLOSTFOUND             $INFORMIXDIR/etc/dr.lostfound
DRIDXAUTO               0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT             20
SDS_TEMPDBS
SDS_PAGING
SDS_LOGCHECK            0
UPDATABLE_SECONDARY     0
FAILOVER_CALLBACK
TEMPTAB_NOLOG           0
DELAY_APPLY             0
STOP_APPLY              0
LOG_STAGING_DIR         
RSS_FLOW_CONTROL        0

# Logical Recovery Parameters

ON_RECVRY_THREADS  1
OFF_RECVRY_THREADS 10

# Diagnostic Dump Configuration Parameters
DUMPDIR $INFORMIXDIR/tmp
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1

# Alarm Program Configuration Parameters

ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3
SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh

# RAS Configuration Parameters

RAS_PLOG_SPEED  25000           
RAS_LLOG_SPEED 0

# Character Processing Configuration Parameter

EILSEQ_COMPAT_MODE  0

# Statistic Configuration Parameters

QSTATS 0
WSTATS 0

# Low Memory Parameter

LOW_MEMORY_RESERVE 0
LOW_MEMORY_MGR 0

# GSKit Library Version

GSKIT_VERSION

# Java Configuration Parameters

#VPCLASS        jvp,num=1
JVPJAVAHOME     $INFORMIXDIR/extend/krakatoa/jre
JVPHOME         $INFORMIXDIR/extend/krakatoa
JVPPROPFILE     $INFORMIXDIR/extend/krakatoa/.jvpprops
JVPLOGFILE      $INFORMIXDIR/jvp.log
#JDKVERSION      1.5
JVPJAVALIB      /bin/j9vm
JVPJAVAVM       jvm
#JVPARGS        -verbose:jni
#JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g.jar
JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar

# Buffer pool and LRU Configuration Parameters

BUFFERPOOL        default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
BUFFERPOOL        size=2K,buffers=50000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
AUTO_LRU_TUNING 1

以上是两个文件的主要内容,我重新看了一次,不知是否onconfig里SERVERNUM 的值的问题?
谢谢大神的回复收起
IT其它 · 2014-11-08
浏览1399
liaosnetliaosnet信息分析/架构师gbasedbt.com
输出$INFORMIXDIR/etc/sqlhosts输出 grep DBSERVER $INFORMIXDIR/etc/$ONCONFIG显示全部
输出$INFORMIXDIR/etc/sqlhosts
输出 grep DBSERVER $INFORMIXDIR/etc/$ONCONFIG收起
IT咨询服务 · 2014-11-07
浏览1245
PumChiPumChi其它UCSD
补充一下,初步认为是Maximum server connections 数量的问题...不明白为什么是0,能不能改?显示全部
补充一下,初步认为是Maximum server connections 数量的问题...不明白为什么是0,能不能改?收起
IT其它 · 2014-11-06
浏览1228

提问者

PumChi
其它UCSD

问题状态

  • 发布时间:2014-11-06
  • 关注会员:1 人
  • 问题浏览:22838
  • 最近回答:2016-02-23
  • X社区推广