Talk to IBM if you are interested. They helped us with our 30TB system.

Considering its a 40TB data - you need to purchase hardware for 2.5 times the data, so that is 40TB * 2.5 = 100 TB. This is considering future data...

Since you have 400K lines inserted everyday. I would consider doing WEEKLY logical PARTIONS. that way, each partition would have only 2.4Million Lines on a average. Follow these guide lines:

CREATE...

Since you have 400K lines inserted everyday. I would consider doing WEEKLY logical PARTIONS. that way, each partition would have only 2.4Million Lines on a average. Follow these guide lines:

CREATE...