Hello gurus.
I have a 94+ GB database that I am dump and loading onto a new server. I can d&l the vast majority of tables within an 18 hour time frame and am proposing to d&l the two or three largest history tables off-line, using some 4GL to load the last week or so just prior to go-live.
One such history table crashed on loading, the error indicating that I'd exceeded a 2GB limit. I resolved this by adding another 10 volumes in the multi-volume sort file. However, the load now seems to be taking a significantly longer time.
I may be imagining things, but does anybody else have experience of this? I will try the load and idxbuild separately - but don't hold your breath, this could take a few more days.
TIA
Mike
I have a 94+ GB database that I am dump and loading onto a new server. I can d&l the vast majority of tables within an 18 hour time frame and am proposing to d&l the two or three largest history tables off-line, using some 4GL to load the last week or so just prior to go-live.
One such history table crashed on loading, the error indicating that I'd exceeded a 2GB limit. I resolved this by adding another 10 volumes in the multi-volume sort file. However, the load now seems to be taking a significantly longer time.
I may be imagining things, but does anybody else have experience of this? I will try the load and idxbuild separately - but don't hold your breath, this could take a few more days.
TIA
Mike