Archives of the TeradataForum
Message Posted: Mon, 01 Oct 2001 @ 20:03:30 GMT
| Subj: || || Re: Multiload status |
| From: || || Ruth Fenwick |
Just as an FYI dropping the 3 NUSI's on the table changed the load time from 24+ hours to 1 hour for 112 million rows. Rowlength is 32
bytes with a UPI. This may be a dumb question, but do standard MVS tuning techniques help - like putting some buffering on the input file?
I think it's spending most of the hour in the acquisition phase.
IA&DSS Team Leader
Information Resource Management
Hudson's Bay Company