Re: How to handle Big Data under IBM i?

Dieter

Did you have Symmetric Multiprocessing installed? That would give you parallel processing and might give the results you were looking for.

As I'm sure you know, that is NOT Multisystem.

With multiple cores, there is a lot of opportunity for database to use them in parallel.

Vern

----- Original Message -----
@DB2 Multisystems: we evaluated DB2 Multisystems at the moment we recognized that some tables grew into a range where db2/400 didn't scale linear anymore (at that time about 600 million of records, especeally deleting 30 million records, wich was needed monthly, slept away from minutes to hours. The manuals for multisystems are saying that DB2 multisystems allows to go beyond 4.300 million records, but accessing one partition of a partitioned table would be slower than accessing a non partitioned table and they recommend to create an alias to the partition to get maximal throughput. So it will all depend on partitioning and we would have had to rebalance the data every month, throwing in more time, than we would win.
So we where looking for alternative solutions and we solved our problems by adjusting parallelism and working with extracts and changing maint to delay for bulk operations and changing back in parallel. With these technics we brought back scalability up to more than 1000 million of records. reaching the maximum size of a table (more exact: member), partitioning might help, but I suspect that it is working - I never heard of anyone using this.

D*B