Hej
Med den storleken p� databas, kan Du r�kna med att det tar ungef�r en timme
f�r 3GB av databas. Databasen �r ca 37GB, vilket borde ta i
storleksordningen 12-13 timmar i b�sta fall. Sedan har ju detta ocks� med
att g�ra vilken I/O du har. S�mre I/O = l�ngre tid, b�ttre I/O = snabbare
tid.
S�, man kan v�l konstatera att 6 timmar �r f�r kort tid, s� det var nog
inget problem Du hade.
Mvh // Daniel Sparrman
-----------------------------------
Daniel Sparrman
Exist i Stockholm AB
Bergk�llav�gen 31D
192 79 SOLLENTUNA
V�xel: 08 - 754 98 00
Mobil: 070 - 399 27 51
Niklas Lundstrom
<niklas.lundstrom@FORENINGSSPAR To:
[EMAIL PROTECTED]
BANKEN.SE> cc:
Sent by: "ADSM: Dist Stor Subject: How long does
a UNLOADDB take???
Manager" <[EMAIL PROTECTED]>
2002-01-21 09:35
Please respond to "ADSM: Dist
Stor Manager"
Hello
We tried to do a unloaddb this weekend to reorganise our database. It ran
fine for 2 hours but then it seemed to stop after 157 million entries.
ANR4013I UNLOADDB: Dumped 157654872 database entries (cumulative).
But after this nothing happens, we could see I/O activity in MVS for the
task. After 6 hours we cancelled the job.
I've read on the ADSM list about unload times over 20 hours, is this a
normal time?
q db
Available Assigned Maximum Maximum Page Total Used
Pct Max.
Space Capacity Extension Reduction Size Usable
Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages
Util
-----------------------------------------------------------------------------------------------------------------------------------
44,868 44,868 0 6,216 4,096
11,486,208 9,737,492 84.8 84.8
TSM 4.2.0 running on OS/390
MVH
Niklas Lundstr�m
F�reningssparbanken IT
08-5859 5164
