RE: Shared memory creation during oninit process
Posted in 2000
Topics: Performance & Tuning, Storage & Space Management, Server Administration, Transactions, Locking & Isolation, Logging & Checkpoints, Networking & sqlhosts Configuration
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BF636D.CCA2C94E
Content-Type: text/plain;
charset="iso-8859-1"
Look in the release notes. There are some kernel parameters that we had to
change to make ours come up. Just happened this past week as we were
building a new server. Look in the INFORMIXDIR/release/en_us/0333
directory.
-----Original Message-----
From: mcapp [mailto:mcappNOmcSPAM@gsite.com.invalid]
Sent: Thursday, January 20, 2000 5:44 AM
To: informix-list@iiug.org
Subject: Re: Shared memory creation during oninit process
I am posting my online.log, onconfig, and sqlhosts files. Hopefully
this will help in determining what's wrong. Thanks again in advance!
"ONLINE.LOG"
------------------------------------------------------------------------
17:51:48 shmget: [EEXIST][17]: key 52574801: shared memory alreadyexists
17:51:48 mt_shm_init: can't create resident segment
17:52:37 shmget: [EEXIST][17]: key 52574801: shared memory alreadyexists
17:52:37 mt_shm_init: can't create resident segment
09:48:32 shmget: [EEXIST][17]: key 52574801: shared memory alreadyexists
09:48:32 mt_shm_init: can't create resident segment
------------------------------------------------------------------------
.. It keeps repeating this over and over for each time it gets
executed.
"ONCONFIG"
------------------------------------------------------------------------
ROOTNAME rootdbs # Root dbspace nameROOTPATH /dev/online_root # Path for device containing root
dbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 20000 # Size of root dbspace (Kbytes)
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 1000 # Physical log file size (Kbytes)
LOGFILES 6 # Number of logical log files
LOGSIZE 500 # Logical log size (Kbytes)
MSGPATH /opt/informix/online.log
CONSOLE /dev/console ALARMPROGRAM
/opt/informix/etc/log_full.sh SYSALARMPROGRAM
/opt/informix/etc/evidence.sh
TBLSPACE_STATS 1
TAPEDEV /dev/null # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on tape
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
STAGEBLOB # Informix Dynamic Server/Optical
SERVERNUM 1 # Unique id corresponding to a DynamicDBSERVERNAME clouds_rest_shm # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in RESIDENT1 # Forced residency flag (Yes = 1, No =
MULTIPROCESSOR 0 # 0 for single-processor, 1 formulti-NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
LOCKS 2000 # Maximum number of locks
BUFFERS 200 # 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 0x10000000 # Shared memory base address
SHMVIRTSIZE 2000 # initial virtual shared memory segment
SHMADD 8192 # Size of new shared memory segments
SHMTOTAL 0 # Total shared memory (Kbytes).
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
LTXEHWM 60 # Long transaction high water mark
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
OFF_RECVRY_THREADS 10 # Default number of offline worker
ON_RECVRY_THREADS 1 # Default number of online worker
DRAUTO 0 # DR automatic switchover
DRINTERVAL 30 # DR max time between DR buffer flushes
DRTIMEOUT 30 # DR network timeout (in sec)DRLOSTFOUND /opt/informix/etc/dr.lostfound # DR lost+found file path
CDR_LOGBUFFERS 2048 # size of log reading buffer pool
CDR_EVALTHREADS 1,2 # evaluator threads(per-cpu-CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR
BAR_ACT_LOG /tmp/bar_act.log
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
ISM_DATA_POOL ISMData # If the data pool name is changed, be
ISM_LOG_POOL ISMLogs
RA_PAGES # Number of pages to attempt to read
RA_THRESHOLD # Number of pages left before next group
DBSPACETEMP # Default temp dbspaces
DUMPDIR /tmp # Preserve diagnostics in this
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this
DUMPCNT 1 # Number of shared memory or gcore
FILLFACTOR 90 # Fill factor for building indexes
USEOSTIME 0 # 0: use internal time(fast), 1: get
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES # Maximum number of decision support
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support
DATASKIP off # List of dbspaces to skip
OPTCOMPIND 2 # To hint the optimizer
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1LBU_PRESERVE 0 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size
(Kbytes)HETERO_COMMIT 0
OPT_GOAL -1
DIRECTIVES 1
RESTARTABLE_RESTORE off
NETTYPE ipcshm,1,999,CPU # Configure poll th
Related threads
- Conversion to differeent characters sets
- Control of CLIENT_LOCALE and DB_LOCALE at connection (doc issue?)
- Problem in changing locale via dbexport/dbimport
- Re: Matches not Work in 7.30
- DATABASE vs CONNECT TO: Invalid characters error?