Re: Serious problem with dbimport

In article <661fea$c8q@camel15.mindspring.com>, Barry Leb <barryleb@atl.mindspring.com> writes > >I can provide the following additional information as I remember it. >I would run an onstat -ur on both systems. One significant difference >was the nwrites for the dbimport sessions. On the good performing >system, the nwrites would increment by anywhere from 200 to 1000 every >5 sec. On the poor performance system, it would increment by >approximately 20 to 25. Also when I switched to loading the data >manually through a load command, one table at a time, the nwrite >numbers on the poor system jumped those seen on the good performing >system during the dbimport. As a matter of fact, they looked almost >identical. > ith PDQPRIORITY = 100, the poor performing one was probably grabbing too much memory and paging/swapping. >> >>>It would seem that the problem is somewhere in the OS. However, I'm >>>not sure where to look. I'm looking for anyone who might point me in >>>the right direction. >>> > > >Barry Leb > >National Linen Service >1420 Peachtree Street >MS #314 >Atlanta, GA 30309 > >(404) 853-6119 >(404) 853-6485 fax >e-mail: barryleb@mindspring.com > -- David Williams