Hi,
looks like your DB is good optimised for read operations,
less for write/change operations.
Load takes long, but not necessarily that long.
My DB of some 6 GB used space took more than an hour to be dumped,
but was loaded in something more than a day.
NT4, 2 333 Pentii CPU´s.
I believe that adsm-DB spread in mure (16) db volumes
over 2 raid 1 arrays implemented on
an 80MB/s SCSI controller with fair amount
of well-managed on-board RAM-cache
and usage of at least 2 independent scsi channels
speeds up writing in adsm´s database significantly.
(please note, same amount of dbvols could
be fatal in another HW environmenmt)
More usefull in your current situation:
if you are using the adsm´s software raid 1,
switch it off during either load or restore operations.
This will speed things up, you can add this
redundancy any time later.
regards
Juraj Salak
-----Ursprüngliche Nachricht-----
Von: William Boyer [mailto:[EMAIL PROTECTED]]
Gesendet am: Sonntag, 15. April 2001 23:50
An: [EMAIL PROTECTED]
Betreff: Should LOADDB take this long?
TSM 3.7.3.0 running on OS/390 2.9
Last night our automated processes to shut the system down didn't take into
account that TSM would take a few extra minutes to halt due to reclamation
running. The automation script ended up taking TCPIP and CA-TLMS and
DFSMSRmm (in warn mode) down while TSM was still up and trying to close out
his tape processing. TSM ended up abending with a EC6. After our downtime,
TSM wouldn't come back up. It would sit there in a CPU loop with no I/O. The
last message in the joblog was "ANR0306I Recovery log volume mount in
progress." WOuld come up any farther. I managed to get an DUMPDB to run and
it took only 1/2 hour and dumped over 78million database entries for a total
of 6.9MB. I then did a FORMAT for all the db/log volumes and started the
LOADDB last night at 20:15. It is still running and it is now 22 hours later
and has only processed 70million of those database entries.
I searched the archives, but there wasn't much on LOADDB. Should LOADDB take
this long when the DUMPDB only took 1/2hour? Good thing this is a holiday
weekend or the users and managers would be more upset than they
are. I tell them, Hey it wasn't my shutdown script that corrupted the
system!!!
Also, if anyone has any ideas on how I could have averted having to do the
DUMP/LOADDB processes I would be more than happy to hear them. I just
couldn't think of any way to bypass the recovery log processing during
startup, or to have the load cleared by itself.
TIA,
Bill Boyer
"Some days you are the bug, some days you are the windshield." - ??
