Re: SIEMENS experiences with 7.X Dynamic or Work Group
In article <6eior8$5bo$1@news.xmission.com>, Hamzova Katarina
<Katarina.Hamzova@swh.sk> writes
>
>
>
>> -----Original Message-----
>> From: Alexander Selg [SMTP:alexander.selg@siemens.at]
>> Sent: Wednesday, March 11, 1998 10:50 AM
>> To: informix-list@iiug.org
>> Subject: Re: SIEMENS experiences with 7.X Dynamic or Work Group
>>
>> MARTIN wrote:
>> >
>> > Please tell me what kind of config you use with Siemens/Nixdorf
>> Unix
>> > boxes and On-Line engines 7.x.
>> >
>> > -What config.
>> > -What box , RM-300, RM-400, RM-600, ...
>> > -How big is your data base , ...
>> >
>> > Thanks in advance
>>
>> Box: RM400
> On line : DSA 7.20 UC2
> Database : 600 MB
>
How many CPUs + disks + how many memory?
I'll assume one CPU:-
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH /dev/ios0/inf7_0 # Path for device containing>root dbspace
> ROOTOFFSET 0 # Offset of root dbspace into
>device (Kbytes)
> ROOTSIZE 120000 # 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 6000 # Physical log file size
>(Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 40 # Number of logical log files
> LOGSIZE 2000 # Logical log size (Kbytes)>
> # Diagnostics
>
> MSGPATH /home/informix/online.uni # System message log
>file path
> CONSOLE /home/informix/sysmsg.uni # System console
>message path
> ALARMPROGRAM /opt/inf7/etc/log_full.sh # Alarm program path
>
> # System Archive Tape Device
>
> TAPEDEV /dev/null # Tape device path
> TAPEBLK 16 # Tape block size (Kbytes)
> TAPESIZE 10484000 # Maximum amount of data to put
>on tape (Kbytes)>
> # Log Archive Tape Device
>
> # LTAPEDEV /dev/null # Log tape device path
> LTAPEDEV /dev/null # Log tape device path
> LTAPEBLK 16 # Log tape block size (Kbytes)
> LTAPESIZE 100000 # Max amount of data to put on
>log tape (Kbytes)>
> # Optical
>
> STAGEBLOB # INFORMIX-OnLine/Optical
>staging area
>
> # System Configuration
>
> SERVERNUM 1 # Unique id corresponding to a>OnLine instance
> DBSERVERNAME infuni # Name of default database>server
> DBSERVERALIASES inf_ipc,inf_aur # 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) change to 1 , we don't want online getting swapped.
>
> 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 Set to1, we don't want Online getting aged.
> AFF_SPROC 0 # Affinity start processor
> AFF_NPROCS 0 # Affinity number of processors>
Set AFF_SPROC=1 AFF_NPROC=1, we want to pin the CPU VPs
> # Shared Memory Parameters
>
> LOCKS 25000 # Maximum number of locks
> BUFFERS 8000 # Maximum number of shared>buffers
> NUMAIOVPS 2 # Number of IO vps
Make sure kaio is being used. Use raw chunks and check
$INFORMIXDIR/release/...ONLINE_7.2
in case you need to setup certain things to enable it.
> PHYSBUFF 32 # Physical log buffer size
>(Kbytes)
> LOGBUFF 32 # Logical log buffer size
>(Kbytes)> LOGSMAX 50 # Maximum number of logical log
>files
> CLEANERS 8 # Number of buffer cleaner>processes
Set = number of disks and make sure that your chunks are created
round robin across the disks.
> SHMBASE 0x20000000 # Shared memory base address
> SHMVIRTSIZE 24000 # initial virtual shared memory>segment size
Run onstat -g seg and set SHMVIRTSIZE such that you only get one
shared memory segment of class V.
> SHMADD 8192 # Size of new shared memory
>segments (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes).
>0=>unlimited
> CKPTINTVL 420 # Check point interval (in sec)
> LRUS 8 # Number of LRU queues
Set LRU = cleaners
> LRU_MAX_DIRTY 20 # LRU percent dirty begin>cleaning limit
> LRU_MIN_DIRTY 10 # LRU percent dirty end cleaning>limit
> LTXHWM 60 # Long transaction high water>mark percentage
> LTXEHWM 70 # Long transaction high water
>mark (exclusi60)
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> STACKSIZE 32 # Stack size (Kbytes)>
> # 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 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 /home/informix/dr.lostfound # DR lost+found file>path
>
> # Read Ahead Variables
> RA_PAGES 20 # Number of pages to attempt to>read ahead
> RA_THRESHOLD 10 # Number