Server won't initialize
Posted in 2005
Topics: High Availability & Replication, Backup & Restore, Storage & Space Management, Server Administration, Transactions, Locking & Isolation, Logging & Checkpoints, Networking & sqlhosts Configuration, Versions, Editions & End-of-Life
Hi,
We seem to have a problem getting the server to initialize. We get an error
shmat: [ENOMEM][12]: out of available data space, check system MAXMEM if we
increase the amount of BUFFERS. I seem to get up to a limit of +- 120 MB
shared memory although the machine has memory of 512 MB. I have set the
kernel parameters as recommended by the machine notes as well as increasing
the SHMMAX parameter (as recommended in a previous thread) to something
really high with no joy. Anyone have any ideas?
Platform: Unixware 7.1.1 / IDS 7.31.UD1
Memory : 512 MB
Files - online.log, onconfig, stune, mtune
-----
online.log
--------------
18:26:16 Informix Dynamic Server Stopped.
18:26:22 shmat: [ENOMEM][12]: out of available data space, check system
MAXMEM
18:26:22 mt_shm_init: can't create resident segment
18:26:57 shmat: [ENOMEM][12]: out of available data space, check system
MAXMEM
18:26:57 mt_shm_init: can't create resident segment
onconfig
------------
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /u/informix731/my_chunk/rootdbs #Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 50000 # 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 10000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 10 # Number of logical log files
LOGSIZE 500 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /u/informix731/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /usr/local/informix/etc/log_full.sh # Alarm program pathSYSALARMPROGRAM /usr/local/informix/etc/evidence.sh # System Alarm program
path
TBLSPACE_STATS 1
# System Archive Tape Device
TAPEDEV /dev/rmt/ctape1 # Tape device path
TAPEBLK 512 # Tape block size (Kbytes)
TAPESIZE 1024000 # Maximum amount of data to put on tape
(Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 512 # Log tape block size (Kbytes)
LTAPESIZE 1024000 # Max amount of data to put on log tape
(Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server/Optical staging
area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a DynamicServer instance
DBSERVERNAME nphwtest_tcp # Name of default database serverDBSERVERALIASES nphwtest,nphwtest_tcp # List of alternate dbservernames
NETTYPE ipcshm,1,300,CPU # Configure poll thread(s) for nettype
NETTYPE tlitcp,1,50,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 formulti-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps toone
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 10000 # Maximum number of locks
BUFFERS 45000 # 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 10 # Maximum number of logical log files
CLEANERS 2 # Number of buffer cleaner processes#SHMBASE 0xA000000L # Shared memory base address
SHMBASE 0X0A000000
SHMVIRTSIZE 15000 # initial virtual shared memory segment size
SHMADD 15000 # 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 markpercentage
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:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 10 # Default number of offline workerthreads
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)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /u/informix731/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
(Kbytes)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 max)
# 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_
What is SHMBASE set to? Try setting it to "0"
"Steven Weiss" <sweiss@iafrica.com> wrote in message
news:d4ae07$b0l$1@ctb-nnrp2.saix.net...
>
> Hi,
>
> We seem to have a problem getting the server to initialize. We get an
> error
> shmat: [ENOMEM][12]: out of available data space, check system MAXMEM if
> we
> increase the amount of BUFFERS. I seem to get up to a limit of +- 120 MB
> shared memory although the machine has memory of 512 MB. I have set the
> kernel parameters as recommended by the machine notes as well as
> increasing
> the SHMMAX parameter (as recommended in a previous thread) to something
> really high with no joy. Anyone have any ideas?
>
> Platform: Unixware 7.1.1 / IDS 7.31.UD1
> Memory : 512 MB
>
>
> Files - online.log, onconfig, stune, mtune
> -----
> online.log
> --------------
> 18:26:16 Informix Dynamic Server Stopped.
> 18:26:22 shmat: [ENOMEM][12]: out of available data space, check system
> MAXMEM
> 18:26:22 mt_shm_init: can't create resident segment
> 18:26:57 shmat: [ENOMEM][12]: out of available data space, check system
> MAXMEM
> 18:26:57 mt_shm_init: can't create resident segment
>
> onconfig
> ------------
> #**************************************************************************
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.std
> # Description: Informix Dynamic Server Configuration Parameters
> #
> #**************************************************************************
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH /u/informix731/my_chunk/rootdbs> #Path for device containing root dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 50000 # 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 10000 # Physical log file size (Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 10 # Number of logical log files
> LOGSIZE 500 # Logical log size (Kbytes)>
> # Diagnostics
>
> MSGPATH /u/informix731/online.log # System message log file path
> CONSOLE /dev/console # System console message path
> ALARMPROGRAM /usr/local/informix/etc/log_full.sh # Alarm program path> SYSALARMPROGRAM /usr/local/informix/etc/evidence.sh # System Alarm program
> path
> TBLSPACE_STATS 1>
> # System Archive Tape Device
>
> TAPEDEV /dev/rmt/ctape1 # Tape device path
> TAPEBLK 512 # Tape block size (Kbytes)
> TAPESIZE 1024000 # Maximum amount of data to put on tape
> (Kbytes)>
> # Log Archive Tape Device
>
> LTAPEDEV /dev/null # Log tape device path
> LTAPEBLK 512 # Log tape block size (Kbytes)
> LTAPESIZE 1024000 # Max amount of data to put on log tape
> (Kbytes)>
> # Optical
>
> STAGEBLOB # Informix Dynamic Server/Optical staging
> area
>
> # System Configuration
>
> SERVERNUM 0 # Unique id corresponding to a Dynamic> Server instance
> DBSERVERNAME nphwtest_tcp # Name of default database server> DBSERVERALIASES nphwtest,nphwtest_tcp # List of alternate dbservernames
> NETTYPE ipcshm,1,300,CPU # Configure poll thread(s) for nettype
> NETTYPE tlitcp,1,50,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 1 # If non-zero, limit number of cpu vps to> one
>
> AFF_SPROC 0 # Affinity start processor
> AFF_NPROCS 0 # Affinity number of processors>
> # Shared Memory Parameters
>
> LOCKS 10000 # Maximum number of locks
> BUFFERS 45000 # 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 10 # Maximum number of logical log files
> CLEANERS 2 # Number of buffer cleaner processes> #SHMBASE 0xA000000L # Shared memory base address
> SHMBASE 0X0A000000
> SHMVIRTSIZE 15000 # initial virtual shared memory segment> size
> SHMADD 15000 # 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:
> # Number of parallel worker threads during an online restore.
>
> 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)
> DRTIMEOUT 30 # DR network timeout (in sec)
> DRLOSTFOUND /u/informix731/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@
Related threads
- onbar -c -F in Windows Informix instance
- Anyone... SQLCODE=-668, ISAM error=-1
- Not using the 100% logical log page size alloacted to informix