SEO

Dear all,

OS: Solaris 2.7
Memory : 2048MB
CPU : 4
Engine Version : IDS 7.31.UC2

I'm using HPL to unload my database into the flat
files format. I encountered the problem when the HPL
unloading a table that having ~33 mil rows into
multiple files. However, this problem only happen
intermittently. The error that I got shown as below:

Fri Jun 27 09:16:02 2003

09:16:02 dynamically allocated new shared memory
segment (size 4194304)

09:16:02 dynamically allocated new shared memory
segment (size 4194304)

09:16:02 out of virtual shared memory

09:16:02 dynamically allocated new shared memory
segment (size 4194304)

09:16:02 dynamically allocated new shared memory
segment (size 4194304)

09:16:02 dynamically allocated new shared memory
segment (size 4194304)

09:16:02 dynamically allocated new shared memory
segment (size 4194304)

and the log file on that particular table shown as
below:

Fri Jun 27 09:16:00 2003

SHMBASE 0x50000000
CLIENTNUM 0x49010000
Session ID 2

Unload Database -> prodmac
Query Name -> AUTO.2
Device Array -> c_obs
Query Mapping -> AUTO.2
Query -> select * from c_obs where obsdate >
today - 365 for read only
Convert Reject -> /tmp/c_obs.rej
Cannot allocate shared memory

Database Unload Completed -- Unloaded 0 Records
Detected 0 Errors
Fri Jun 27 09:16:02 2003


The above error log was telling me that the shared
memory was not enough. But, the system still have
plenty of memory while the HPL is running. I even
tried to increase the shminfo_shmmax from 256MB to
512MB, but it doesn't help at all. Does anyone out
there know how to resolve this problem?

Here's my current plconfig and /etc/system files

# System Configuration

CONVERTTHREADS 1 # Number of conversion threads
per device
CONVERTVPS 4 # Max number of vps for
converters (total)

# Buffer Configuration

STRMBUFFSIZE 1024 # Buffer size for server
stream buffer (kbytes)
STRMBUFFERS 5 # Number of server stream
buffers per device
AIOBUFSIZE 256 # Buffer size for tape/file
I/O (kbytes)
AIOBUFFERS 5 # Number of buffers for I/O
per device

/etc/system file:
=================
set shmsys:shminfo_shmmax=536870912
set semsys:seminfo_semmap=256
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semume=64
set semsys:seminfo_semmsl=100
set shmsys:shminfo_shmmin=100
set shmsys:shminfo_shmmni=500
set shmsys:shminfo_shmseg=100


Thanks & regards,
Miyaki


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
sending to informix-list