IDS 9.49 UC2 -> UC7 PDQ changes?
Posted in 2007
Topics: Logging & Checkpoints, Platform-Specific Issues, Versions, Editions & End-of-Life
Hi,
We changed from UC2 to UC7 on a Linux box with 2.4 kernel.
With the same configuration, UC7 runs out of memory, but I don't know why.
PDQ is enabled. When I disable PDQ everything works fine.
One thing, the working sessions nearly all have threads up to 300 opened.
Thanks
Sven
LOCKS 200000 # Maximum number of locks
BUFFERS 800000 # Maximum number of shared buffers
NUMAIOVPS 5 # Number of IO vps
PHYSBUFF 512 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
CLEANERS 4 # Number of buffer cleaner processes#SHMBASE 0x41000000L # Shared memory base address
SHMBASE 0x12000000L
SHMVIRTSIZE 400000 # initial virtual shared memory segment size
SHMADD 32000 # Size of new shared memory segments (Kbytes)
SHMTOTAL 3000000 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)NOFUZZYCKPT 1 # NO FUZZY Checkpoints
LRUS 4 # Number of LRU queues
LRU_MAX_DIRTY 4.000000 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 2.000000 # LRU percent dirty end cleaning limit
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES 60 # Maximum number of decision support queries
DS_TOTAL_MEMORY 600000 # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP off
Schuran, Sven said:
> Hi,
>
> We changed from UC2 to UC7 on a Linux box with 2.4 kernel.
>
> With the same configuration, UC7 runs out of memory, but I don't know why.
>
> PDQ is enabled. When I disable PDQ everything works fine.
> One thing, the working sessions nearly all have threads up to 300 opened.
>
> Thanks
> Sven
>
> LOCKS 200000 # Maximum number of locks
> BUFFERS 800000 # Maximum number of shared buffers
> NUMAIOVPS 5 # Number of IO vps
> PHYSBUFF 512 # Physical log buffer size (Kbytes)
> LOGBUFF 64 # Logical log buffer size (Kbytes)
> CLEANERS 4 # Number of buffer cleaner processes> #SHMBASE 0x41000000L # Shared memory base address
> SHMBASE 0x12000000L
> SHMVIRTSIZE 400000 # initial virtual shared memory segment size
> SHMADD 32000 # Size of new shared memory segments (Kbytes)
> SHMTOTAL 3000000 # Total shared memory (Kbytes). 0=>unlimited
> CKPTINTVL 300 # Check point interval (in sec)> NOFUZZYCKPT 1 # NO FUZZY Checkpoints
> LRUS 4 # Number of LRU queues
> LRU_MAX_DIRTY 4.000000 # LRU percent dirty begin cleaning limit
> LRU_MIN_DIRTY 2.000000 # LRU percent dirty end cleaning limit
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> STACKSIZE 32 # Stack size (Kbytes)
I don't know about the rest, but 32K is far too small a stack size.
> # Parallel Database Queries (pdq)
> MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
> DS_MAX_QUERIES 60 # Maximum number of decision support queries
> DS_TOTAL_MEMORY 600000 # Decision support memory (Kbytes)
> DS_MAX_SCANS 1048576 # Maximum number of decision support scans
> DATASKIP off>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>
--
Bye now,
Obnoxio
"I'm astonished anyone pays real money for this crap."
-- Cosmo
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
Sven,
Please try this by changing :
SHMVIRTSIZE 1200000
And let me know .......
Also please provide me the onstat -m output also ...
Thanks,
Amitava
"Schuran, Sven"
<sschuran@maske.d
e> To
Sent by: ids@iiug.org
ids-bounces@iiug. cc
org
Subject
IDS 9.49 UC2 -> UC7 PDQ changes?
26/02/2007 19:16 [8505]
Please respond to
ids@iiug.org
Hi,
We changed from UC2 to UC7 on a Linux box with 2.4 kernel.
With the same configuration, UC7 runs out of memory, but I don't know why.
PDQ is enabled. When I disable PDQ everything works fine.
One thing, the working sessions nearly all have threads up to 300 opened.
Thanks
Sven
LOCKS 200000 # Maximum number of locks
BUFFERS 800000 # Maximum number of shared buffers
NUMAIOVPS 5 # Number of IO vps
PHYSBUFF 512 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
CLEANERS 4 # Number of buffer cleaner processes#SHMBASE 0x41000000L # Shared memory base address
SHMBASE 0x12000000L
SHMVIRTSIZE 400000 # initial virtual shared memory segment size
SHMADD 32000 # Size of new shared memory segments (Kbytes)
SHMTOTAL 3000000 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)NOFUZZYCKPT 1 # NO FUZZY Checkpoints
LRUS 4 # Number of LRU queues
LRU_MAX_DIRTY 4.000000 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 2.000000 # LRU percent dirty end cleaning limit
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES 60 # Maximum number of decision support queries
DS_TOTAL_MEMORY 600000 # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP off
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.