Does anyone how long it would take to import a 1TB database containing 312000 tables, with 570000 indexes containing 710000000 rows using an 8 way pSeries 570 with AIX 5.2?, or are there any benchmark sites that give this info?
Sorry but it is difficult (if not impossible) to give estimates on this kind of questions. But is is well-known that the dbimport tool is not the best scalable tool there is. Normally I would remove the indexes etc. from the import file and run them seperately afterwards using PDQ.
I think it is wise to tune your onconfig for this specific task. I can tell you it will take quite some time.