Re: INFORMIX and utilization of system resources on HP-UX 10.20
Ho Andrzej,
on HP-UX systems, be sure also to have PHKL_16751
(in fact it is PHKL_13261 included on it)
It is really important for performance improvment when
using raw devices through LVM.
David...
Andrzej Piotrowski a =E9crit :
> This is a multi-part message in MIME format.
> --------------1BDF045F91B4032E8276E3E0
> Content-Type: text/plain; charset=3Dus-ascii
> Content-Transfer-Encoding: 7bit
>
> I have a new double HP9000 system with MC/ServiceGuard, and I,ve
> installed IDS 7.3 UC7 on this cluster. At the beginning I've nottic=
ed,
> that database is running rather slowly (thats mean it is unacceptab=
le
> slow ;-). I've carefully read release notes for IDS 7.3 and I had t=
uned
> kernel as it was described in this document, but the situation was =
the
> same. For instance I am doing dbexport & dbimport and there is onp=
erf
> runnig at background, which monitors cpu utilisation (machine has 2
> CPU). The diagram is awfully shaterred. In 2-3 sec. periods CPU
> utilization can change from 0% to 80% and back to 0% and it is regu=
lar.
> On the other way average utilization measured in longer periods isn=
't
> constant, but becomes smaller and smaller. I have already set NOAGE
> parameter to 1 in $ONCONFIG.
>
> Anybody knows what is going on? I'm not sure, if I should search th=
e
> solution at the HP-UX kernel or IDS 7.3 tuning.
>
> I'm attching my onconfig file.
> Thanks for any advice.
> --------------1BDF045F91B4032E8276E3E0
> Content-Type: text/plain; charset=3Dus-ascii;
> name=3D"onconfig"
> Content-Transfer-Encoding: 7bit
> Content-Disposition: inline;
> filename=3D"onconfig"
>
> #******************************************************************=
********
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.std
> # Description: INFORMIX-OnLine Configuration Parameters
> #
> #******************************************************************=
********
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH /dev/vg01/rrootdbs # Path for device containing roo=t dbspace
> ROOTOFFSET 0 # Offset of root dbspace into devic=
e (Kbytes)
> ROOTSIZE 50000 # Size of root dbspace (Kbytes)>
> # Disk Mirroring Configuration Parameters
>
> MIRROR 0 # Mirroring flag (Yes =3D 1, No =
=3D 0)
> MIRRORPATH # Path for device containing mirror=ed root
> MIRROROFFSET 0 # Offset into mirrored device (Kbyt=
es)>
> # Physical Log Configuration
>
> PHYSDBS plogdbs # Location (dbspace) of physical lo=
g
> PHYSFILE 1024000 # Physical log file size (Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 5 # Number of logical log files
> LOGSIZE 60000 # Logical log size (Kbytes)>
> # Diagnostics
>
> MSGPATH /usr/informix/online.log # System message log file =
path
> CONSOLE /usr/informix/console # System console message path
> ALARMPROGRAM /usr/informix/log_full.sh # Alarm program path
>
> # System Archive Tape Device
>
> TAPEDEV /baan/worek/tapedev # Tape device path
> TAPEBLK 512 # Tape block size (Kbytes)
> TAPESIZE 25165824 # Maximum amount of data to put on =
tape (Kbytes)>
> # Log Archive Tape Device
>
> LTAPEDEV /baan/worek/ltapedev # Log tape device path
> LTAPEBLK 512 # Log tape block size (Kbytes)
> LTAPESIZE 25165824 # Max amount of data to put on log =
tape (Kbytes)>
> # Optical
>
> STAGEBLOB # INFORMIX-OnLine/Optical staging a=
rea
>
> # System Configuration
>
> SERVERNUM 0 # Unique id corresponding to a OnLi=ne instance
> DBSERVERNAME baan # Name of default database server
> DBSERVERALIASES # List of alternate dbservernames
> NETTYPE ipcshm,1,300,CPU # Configure poll thread(s) for net=type
> NETTYPE soctcp,1,300,NET # Configure poll thread(s) for net=type
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in dist=ributed env.
> RESIDENT 0 # Forced residency flag (Yes =3D 1,=
No =3D 0)
>
> MULTIPROCESSOR 1 # 0 for single-processor, 1 for mul=ti-processor
> NUMCPUVPS 1 # Number of user (cpu) vps
> SINGLE_CPU_VP 1 # If non-zero, limit number of cpu =vps to one
>
> NOAGE 1 # Process aging
> AFF_SPROC 2 # Affinity start processor
> AFF_NPROCS 2 # Affinity number of processors>
> # Shared Memory Parameters
>
> LOCKS 1000000 # Maximum number of locks
> BUFFERS 40000 # Maximum number of shared buffers
> NUMAIOVPS 1 # 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 fil=
es
> CLEANERS 8 # Number of buffer cleaner processe=s
> SHMBASE 0x0 # Shared memory base address
> SHMVIRTSIZE 16384 # initial virtual shared memory seg=ment size
> SHMADD 16384 # Size of new shared memory segment=
s (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes). 0=
=3D>unlimited
> CKPTINTVL 300 # Check point interval (in sec)
> LRUS 4 # Number of LRU queues
> LRU_MAX_DIRTY 25 # LRU percent dirty begin cleaning =limit
> LRU_MIN_DIRTY 15 # LRU percent dirty end cleaning li=mit
> 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 - OnLine no longer supports this configuration parameter=
.
> # To determine the page size used by OnLine on your plat=
form
> # 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 offl=
ine restore.
> # ON_RECVRY_THREADS:
> # Number of parallel worker threads during an online restore.
>
> OFF_RECVRY_THREADS 10 # Default number of offline work=er 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 flu=
shes (in sec)
> DRTIMEOUT