Chinaunix

标题: 求救！在AIX上安装informix dynamic server7.31 失败！ [打印本页]

---

作者: chr911    时间: 2004-10-19 16:59
标题: 求救！在AIX上安装informix dynamic server7.31 失败！
初始化中断，online。log 上提示如下：
Tue Oct 19 16:42:25 2004

16:42:25  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/log_full.sh'
16:42:30  DR: DRAUTO is 0 (Off)
16:42:30  AIX MP latch code enabled
16:42:30  Informix Dynamic Server Version 7.31.UC5    Software Serial Number ＃＃＃
16:42:30  listener-thread: err = -25572: oserr = 68: errstr = : Network driver c
annot bind a name to the port.
System error = 68.
16:42:30  Attempting to bring listener thread down.

16:42:30  Server stopped.

16:42:30  Informix Dynamic Server Stopped.
16:42:31  mt_shm_remove: WARNING: may not have removed all/correct segments

---

作者: chr911    时间: 2004-10-19 17:08
标题: 求救！在AIX上安装informix dynamic server7.31 失败！
我的onconfig文件配置如下：
# Root Dbspace Configuration

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /dev/rrootdbs   # Path for device containing root dbspace
ROOTOFFSET      0               # Offset of root dbspace into device (Kbytes)
ROOTSIZE        320000          # 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        64000           # Physical log file size (Kbytes)



# Logical Log Configuration



LOGFILES        6               # Number of logical log files

LOGSIZE         5000            # Logical log size (Kbytes)



# Diagnostics

MSGPATH         /usr/informix/online.log # System message log file path

CONSOLE         /dev/console    # System console message path

ALARMPROGRAM    /usr/informix/etc/log_full.sh # Alarm program path

SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path

TBLSPACE_STATS  1



# 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)
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)
LTAPESIZE       10240           # Max amount of data to put on log tape (Kbytes)



# Optical



STAGEBLOB                       # Informix Dynamic Server/Optical staging area



# System Configuration
SERVERNUM       1               # Unique id corresponding to a Dynamic Server in

SERVERNUM       1               # Unique id corresponding to a Dynamic Server in
stance

DBSERVERNAME    sz38            # Name of default database server

DBSERVERALIASES                 # List of alternate dbservernames

NETTYPE         soctcp,1,10,CPU # 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           20000           # Maximum number of locks

BUFFERS         2000            # Maximum number of shared buffers

NUMAIOVPS       8               # Number of IO vps

PHYSBUFF        32              # Physical log buffer size (Kbytes)

LOGBUFF         32              # Logical log buffer size (Kbytes)

LOGSMAX         32              # Maximum number of logical log files
CLEANERS        1               # Number of buffer cleaner processes

SHMBASE         0x30000000        # 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)



# System Page Size

# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.

#            To determine the page size used by Dynamic Server 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:
OFF_RECVRY_THREADS 10              # Default number of offline worker threads

ON_RECVRY_THREADS 1               # Default number of online worker threads



# Data Replication Variables

# DRAUTO: 0 manual, 1 retain type, 2 reverse type

DRAUTO          0               # DR automatic switchover

DRINTERVAL      30              # DR max time between DR buffer flushes (in sec)
DRINTERVAL      30              # DR max time between DR buffer flushes (in sec)

DRTIMEOUT       30              # DR network timeout (in sec)

DRLOSTFOUND     /usr/informix/etc/dr.lostfound # DR lost+found file path
# CDR Variables

CDR_LOGBUFFERS  2048            # size of log reading buffer pool (Kbytes)

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 (Kb

CDR_QUEUEMEM    4096            # Maximum amount of memory for any CDR queue (Kb
ytes)

CDR_LOGDELTA    30              # % of log space allowed in queue memory

CDR_NUMCONNECT  16              # Expected connections per server

CDR_NIFRETRY    300             # Connection retry (seconds)

CDR_NIFCOMPRESS 0               # Link level compression (-1 never, 0 none, 9 ma

CDR_NIFCOMPRESS 0               # Link level compression (-1 never, 0 none, 9 ma
x)
# Backup/Restore variables

BAR_ACT_LOG     /tmp/bar_act.log

BAR_MAX_BACKUP  0

BAR_RETRY       1

BAR_NB_XPORT_COUNT 10

BAR_XFER_BUF_SIZE 31



# Informix Storage Manager variables

ISM_DATA_POOL   ISMData         # If the data pool name is changed, be sure to

                                # update $INFORMIXDIR/bin/onbar.  Change to

                                # ism_catalog -create_bootstrap -pool <new name>;
                                # ism_catalog -create_bootstrap -pool <new name>;

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:

# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces

# that the Dynamic Server SQL Engine will use to create temp tables etc.

# If specified it must be a colon separated list of dbspaces that exist

# when the Dynamic Server 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     tmpdbs          # 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 Dynamic Server operations.

# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.



DUMPDIR         /tmp            # Preserve diagnostics in this directory

DUMPSHMEM       1               # Dump a copy of shared memory

DUMPGCORE       0               # Dump a core image using 'gcore'

DUMPCORE        0               # Dump a core image (Warning:this aborts Dynamic
DUMPCORE        0               # Dump a core image (Warning:this aborts Dynamic
Server)

DUMPCNT         1               # Number of shared memory or gcore dumps for

                                # a single user's session



FILLFACTOR      90              # Fill factor for building indexes



# method for Dynamic Server to use when determining current time

USEOSTIME       0               # 0: use internal time(fast), 1: get time from O

USEOSTIME       0               # 0: use internal time(fast), 1: get time from O
S(slow)



# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100             # Maximum allowed pdqpriority

DS_MAX_QUERIES                  # Maximum number of decision support queries

DS_TOTAL_MEMORY                 # Decision support memory (Kbytes)

DS_MAX_SCANS    1048576         # Maximum number of decision support scans

DATASKIP        off             # List of dbspaces to skip



# OPTCOMPIND

# 0 =>; Nested loop joins will be preferred (where

#      possible) over sortmerge joins and hash joins.

# 1 =>; If the transaction isolation mode is not

#      "repeatable read", optimizer behaves as in (2)

#      below.  Otherwise it behaves as in (0) above.
# 2 =>; Use costs regardless of the transaction isolation

#      mode.  Nested loop joins are not necessarily

#      preferred.  Optimizer bases its decision purely

#      on costs.

OPTCOMPIND      2               # To hint the optimizer



ONDBSPACEDOWN   2               # Dbspace down option: 0 = CONTINUE, 1 = ABORT,

ONDBSPACEDOWN   2               # Dbspace down option: 0 = CONTINUE, 1 = ABORT,
2 = WAIT

LBU_PRESERVE    0               # Preserve last log for log backup

OPCACHEMAX      0               # Maximum optical cache size (Kbytes)



# HETERO_COMMIT (Gateway participation in distributed transactions)
OPTCOMPIND      2               # To hint the optimizer

ONDBSPACEDOWN   2               # Dbspace down option: 0 = CONTINUE, 1 = ABORT,
2 = WAIT
LBU_PRESERVE    0               # Preserve last log for log backup
OPCACHEMAX      0               # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 =>; Heterogeneous Commit is enabled
# 0 (or any other value) =>; Heterogeneous Commit is disabled
HETERO_COMMIT   0

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL        -1

# Optimizer DIRECTIVES ON (1/Default) or OFF (0)
DIRECTIVES      1

# Status of restartable restore
RESTARTABLE_RESTORE off

---

作者: lobo    时间: 2004-10-20 08:39
标题: 求救！在AIX上安装informix dynamic server7.31 失败！
检查 /etc/services
       /$INFORMIX/etc/sqlhosts
文件；

---

作者: 自由飞翔    时间: 2004-10-20 13:52
标题: 求救！在AIX上安装informix dynamic server7.31 失败！
～informix/etc/sqlhost文件多余的要删除了！

---

作者: chr911    时间: 2004-10-20 16:43
标题: 求救！在AIX上安装informix dynamic server7.31 失败！
谢谢，昨天已经解决了，确实是sqlhosts文件的问题1

---

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

Powered by Discuz! X3.2