HPL unloading error

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 memorysegment (size 4194304) 09:16:02 dynamically allocated new shared memorysegment (size 4194304) 09:16:02 out of virtual shared memory 09:16:02 dynamically allocated new shared memorysegment (size 4194304) 09:16:02 dynamically allocated new shared memorysegment (size 4194304) 09:16:02 dynamically allocated new shared memorysegment (size 4194304) 09:16:02 dynamically allocated new shared memorysegment (size 4194304) and the log file on that particular table shown as below: Fri Jun 27 09:16:00 2003 SHMBASE 0x50000000CLIENTNUM 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