Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)
From: wu@paris.dvs1.informatik.tu-darmstadt.de (Ming-Chuan Wu)
>
>I include the outputs of the onstat's cammands as follows.
>The onstat's commands are given, while the IUS is running my test queries.
>
>---include begin
>=======================================================================
>OUTPUT OF onstat -c
>=======================================================================
>
>
>Informix Dynamic Server 2000 Version 9.20.UC2 -- On-Line -- Up 6 days
>09:32:19 -- 10240 Kbytes
ROTFLMAO. I have just the *faintest* idea of what the problem might be....
>Configuration File: /tools/com/informix/etc/onconfig.dw1
>#**************************************************************************
>#
># INFORMIX SOFTWARE, INC.
>#
># Title: onconfig.std
># Description: INFORMIX-Universal Server Configuration Parameters
>#
>#**************************************************************************
>
># Root Dbspace Configuration
>
>ROOTNAME dw1 # Root dbspace name
>ROOTPATH /tools/com/informix/dbspaces/dw1> # Path for device containing root dbspace
>ROOTOFFSET 512 # Offset of root dbspace into device
>(Kbytes)>#ROOTSIZE 8387584 # 8GB=Size of root dbspace (Kbytes)
>ROOTSIZE 2096639 # maximal root dbspace 2GB=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 dw1 # Location (dbspace) of physical log
>PHYSFILE 102400 # 100MB=Physical log file size (Kbytes)
Move this onto its own spindle.
># Logical Log Configuration
># 32 * 1000 = 32000 kBytes logical log
>
>LOGFILES 32 # Number of logical log files
>LOGSIZE 1000 # Logical log size (Kbytes)
These should also be on their own spindle.
># alter DVS1-Wert: 1000 alter-Default-Wert: 500
>
># Diagnostics
>
And now? Was ist los?
Bottom line, I'm guessing you have *way* too few BUFFERS (start at 768000)
and your SHMVIRTSIZE and SHMADD can both be around 128000. Also, switch on
PDQPRIORITY for the query.
But the other output and the rest of your onconfig will help.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.