免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
楼主: topgtian
打印 上一主题 下一主题

informix初始化的系列问题? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2007-12-07 17:53 |显示全部楼层 |倒序浏览
oninit -ivy初始化失败,日志为:

16:55:57  IBM Informix Dynamic Server Started.

Fri Dec  7 16:55:59 2007

16:55:59  Warning: ONCONFIG dump directory (DUMPDIR) '/home/informix/ifxtmp' has insecure permissions
16:55:59  Error: Unable to reset open files limit, must run as super-user
16:55:59  Event alarms enabled.  ALARMPROG = '/home/informix/etc/no_log.sh'
16:55:59  Booting Language <c> from module <>
16:55:59  Loading Module <CNULL>
16:55:59  Booting Language <builtin> from module <>
16:55:59  Loading Module <BUILTINNULL>
16:56:04  IBM Informix Dynamic Server Version 9.40.UC8     Software Serial Number AFC#B000000
16:56:04  The chunk '/home/informix/dbspace/rootdbs' will not fit in the space specified.

16:56:04  IBM Informix Dynamic Server Stopped.

16:56:04  mt_shm_remove: WARNING: may not have removed all/correct segments
17:13:10  IBM Informix Dynamic Server Started.

Fri Dec  7 17:13:11 2007

请问什么原因了?

论坛徽章:
0
2 [报告]
发表于 2007-12-11 17:16 |显示全部楼层
我是以informix运行的。/dev/raw/raw*的权限是660(informix:informix) ,raw1的空间是2048M,onconfig的rootdbs是2000000

论坛徽章:
0
3 [报告]
发表于 2007-12-11 17:32 |显示全部楼层
Warning: ONCONFIG dump directory (DUMPDIR) '/home/informix/ifxtmp' has insecure permissions
这个问题已经解决。将ifxtmp权限改为660就可以了,但是chunk的大小始终不对。
我将rootdbs的size设置为2000000的时候,提示说
Not enough room in ROOT DBspace.
        Requested 2191038K, ONCONFIG value 'ROOTSIZE' 2000000K.
FAILED
按照提示将size更改。却是提示说The chunk '/dev/raw/raw1' will not fit in the space specified.
到底怎么回事啊。
我使用的是裸设备作为数据空间。raw1~raw6都是2048M的大小。
onconfig的配置如下
OOTNAME        rootdbs         # Root dbspace name
#ROOTPATH        /home/informix/DBSPACE/rawlv1
ROOTPATH        /dev/raw/raw1
                                # Path for device containing root dbspace
ROOTOFFSET      4               # Offset of root dbspace into device (Kbytes)
#ROOTSIZE        2191038         # Size of root dbspace (Kbytes)
ROOTSIZE        3000000
# 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        200000           # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES        199             # Number of logical log files
LOGSIZE         10000           # Logical log size (Kbytes)
LOG_BACKUP_MODE MANUAL          # Logical log backup mode (MANUAL, CONT)
MSGPATH         /home/informix/online.log # System message log file path
CONSOLE         /dev/null    # System console message path

# To automatically backup logical logs, edit alarmprogram.sh and set
# BACKUPLOGS=Y
ALARMPROGRAM    /home/informix/etc/no_log.sh # Alarm program path
TBLSPACE_STATS  1               # Maintain tblspace statistics

# System Archive Tape Device

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

# Log Archive Tape Device

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

# Optical

STAGEBLOB                       # Informix Dynamic Server staging area

# System Configuration

SERVERNUM       1               # Unique id corresponding to a OnLine instance
DBSERVERNAME    rawdbs          # Name of default database server
DBSERVERALIASES                 # List of alternate dbservernames
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   1               # 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           1000000         # Maximum number of locks
BUFFERS         200000          # Maximum number of shared buffers
NUMAIOVPS       5               # Number of IO vps
PHYSBUFF        64              # Physical log buffer size (Kbytes)
LOGBUFF         64              # Logical log buffer size (Kbytes)
CLEANERS        8               # Number of buffer cleaner processes
SHMBASE         0x44000000      # Shared memory base address
SHMVIRTSIZE     256000          # initial virtual shared memory segment size
SHMADD          256000          # Size of new shared memory segments (Kbytes)
EXTSHMADD       8192            # Size of new extension shared memory segments (Kbytes)
SHMTOTAL        0               # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL       300             # Check point interval (in sec)
LRUS            10              # Number of LRU queues
LRU_MAX_DIRTY   60.000000       # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY   50.000000       # LRU percent dirty end cleaning limit
TXTIMEOUT       0x12c             # Transaction timeout (in sec)
STACKSIZE       64              # Stack size (Kbytes)
DYNAMIC_LOGS    2
LTXHWM          70
LTXEHWM         80

# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
#            To determine the page size used by OnLine on your platform
#            see the last line of output from the command, 'onstat -b'.


# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10              # Default number of offline worker threads
ON_RECVRY_THREADS 2               # Default number of online worker threads

# Data Replication Variables
DRINTERVAL      30              # DR max time between DR buffer flushes (in sec)
DRTIMEOUT       30              # DR network timeout (in sec)
DRLOSTFOUND     /home/informix/etc/dr.lostfound # DR lost+found file path

# CDR Variables
CDR_EVALTHREADS 1,2             # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT  5               # DS lockwait timeout (seconds)
CDR_QUEUEMEM    4096            # Maximum amount of memory for any CDR queue (Kbytes)
CDR_NIFCOMPRESS 0               # Link level compression (-1 never, 0 none, 9 max)
CDR_SERIAL      0,0             # Serial Column Sequence
CDR_DBSPACE                     # dbspace for syscdr database
CDR_QHDR_DBSPACE                 # CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE                 # List of CDR queue smart blob spaces

# CDR_MAX_DYNAMIC_LOGS
# -1 => unlimited
#  0 => disable dynamic log addition
# >0 => limit the no. of dynamic log additions with the specified value.
BAR_ACT_LOG     /usr/informix/bar_act.log # ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG   /usr/informix/bar_dbug.log
                                # ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP  0
BAR_RETRY       1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE on
BAR_PROGRESS_FREQ 0

# Informix Storage Manager variables
ISM_DATA_POOL   ISMData
ISM_LOG_POOL    ISMLogs

# Read Ahead Variables
RA_PAGES                        # Number of pages to attempt to read ahead
RA_THRESHOLD                    # Number of pages left before next group

# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online.  If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.

DBSPACETEMP     tempdbs         # Default temp dbspaces

# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR         /home/informix/tmp # Preserve diagnostics in this directory
DUMPSHMEM       0               # Dump a copy of shared memory
DUMPGCORE       0               # Dump a core image using 'gcore'
DUMPCORE        0               # Dump a core image (Warning:this aborts OnLine)
DUMPCNT         1               # Number of shared memory or gcore dumps for

论坛徽章:
0
4 [报告]
发表于 2007-12-12 09:30 |显示全部楼层

回复 #7 liaosnet 的帖子

谢谢,我试试看。

论坛徽章:
0
5 [报告]
发表于 2007-12-12 09:40 |显示全部楼层

回复 #7 liaosnet 的帖子

试着 将LOGFILES        199    改为     logfile     20     
问题依旧
并且199*10000+200000=2190000<3000000啊

论坛徽章:
0
6 [报告]
发表于 2007-12-12 09:57 |显示全部楼层
另外我这个onconfig是从一个正常运行的机器上cp过来的。这个服务器的分区也是和那个正常机器的raw分区一样。区别就在我将这个raw分区放在了第2块硬盘上。

论坛徽章:
0
7 [报告]
发表于 2007-12-12 18:05 |显示全部楼层

回复 #11 liaosnet 的帖子

修改了rootsize的大小,为2G,PHYSIZE和logsize的和也小于了ROOTSIZE,大概有1个G左右。现在提示变了,提示为
Cannot Open Primary Chunk '/dev/raw/raw1', errno = 13

论坛徽章:
0
8 [报告]
发表于 2007-12-13 09:35 |显示全部楼层

回复 #11 liaosnet 的帖子

十分感谢,开始 是因为忘记把/dev/raw的属主修改成informix。有什么办法能给你分吗?
高手能不能建立一个qq群啊,专门研究数据库。

论坛徽章:
0
9 [报告]
发表于 2007-12-13 11:59 |显示全部楼层

回复 #14 liaosnet 的帖子

为什么不用裸设备了?我试了用文件系统,速度比裸设备慢好多哦

论坛徽章:
0
10 [报告]
发表于 2007-12-14 09:39 |显示全部楼层

回复 #16 liaosnet 的帖子

哦,我开始是链接了的,结果启动不起来,以为是链接的问题,就直接用了。群已经加入了。谢谢!
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP