Serious problem with dbimport
Posted in 1997
I am having a serious problem with a dbimport on one and only one of
our systems. A dbexport of a 5 gig database runs fine. However, when
I try to dbimport back on the system, the import runs, but all
estimates point to the import taking in excess of 72 hours to
complete. I don't know the exact time because we can't afford to wait
that long. I resolved the problem by loading the tables manually from
the exported files. I would like to know what the problem is.
I actually had this problem approximately 8 mos. ago, but I thought it
was related the version of the engine. At that time it is was 6.0.
The current version of the engine is 7.14ud5. This obviously throws
the previous theory out the window.
Here are more specifics. The database supports a PeopleSoft
Financials application. The hardware is an HP9000 h70 with 256meg of
memory and 2 cpus. The OS is HPUX 9.04. The disks are the HP versions
of the 2 gig DG Clarions, and they are configred as 2 RAID 5
devices.(Don't ask, it wasn't my doing. It will be changed later this
month).
When the problem showed up again, I immediately tried the same
dbimport to a second similar, but not identical, system. The second
system was an HP k100 with 1 cpu, a disk farm with standard disks, no
RAID or mirroring, HPUX 10.2 and and 288meg memory. This import ran
in approximately 10 hrs.
I have pretty much ruled out the RAID 5 as the problem because the
straight load statements ran against the exported files loaded all the
data in a reasonable amount of time(apprx 10 hrs).
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