I agree that Deiter did a good job of answering the question. There is however much more that should be discussed about dealing with "big data". Your reference to DB2 Multi-System is a good example.
To respond to your question, my RPG program writes records within a DOW loop where an "order number" column is incremented on each iteration of the loop. The only other columns in the table are "ship to" and "ship date".
Is there anyone out there who would like to test the performance of row inserts using a .Net, Java, or PHP program for comparison purposes (again another teaser)?
I would have responded sooner, but Yahoo Mail was on the blink this morning; must not be IBM i based ;-)
----- Original Message -----
From: "rob@xxxxxxxxx" <rob@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, September 5, 2013 5:50 AM
Subject: Re: How to handle Big Data under IBM i?
Was your RPG program reading from one or more other tables when it was
populating this new table or was it doing something like
for x = 1 to 1000000;
But that is just picking nits. I am sure that DB2 on IBM i on modern
Power equipment, appropriately sized and configured, can handle this. I
think Deiter did a better job of answering your question.