I’m trying to load on my database 900,000 records of approximately 10K each one, with the command inoload. I have divided the 900,000 files in 1000 folders in 900 files each one, and 900 sequentially execute commands inoload, one for each folder (one behind the other)
I have not yet to have a full load of 900,000 records and I always get the error MEMORY ALLOCATION FAILED (in uncertain times and for different load tests)
As a result, also the error:
The machine for this purpose has 16 GB of memory.
The parameters of my database are:
BUFFER POOL SIZE: 1,000
DYNAMIC POOL SIZE: 20,000
Maximun TRANSACTION DURATION: 36,000
NON_ACTIVITY TIMEOUT: 3,600
REPLICATION DELAY: 20,000
FLUSH GROUP SIZE: 2,000
FLUSH LIMIT: 700
WORK XML Threads: 200
XML Maximun SESSIONS: 2,000
I looked in the Tamino log (AABinosrv.09-01-10.txt) and the load fails just at:
10-JUN-2009 12:52:51 INODCI6565: Data loading completed, number of documents processed 1000, loaded 1000, rejected 0
10-JUN-2009 12:52:53 INOLDI3002: Preparing documents for load
[XTS] 12:56:04.990 390be20 Trace: (Module: xtsthr Line: 605) Create Thread = DrvReceive755 failed rc = 12
[XTS] 12:56:04.990 390be20 Trace: (Module: Threads Line: 742) ReadThread creation failure Rc returning =- 61 …
Please I need help if someone finds the problem.
Thank you very much in advance.