Re: UNLOAD/RELOAD DB
2003-04-09 13:06:00
Will skipdirs=yes cause more overhead and performance problems? Right now
I only have a 5 GB recovery log (which I have also been having issues with)
and I don't want to crash the TSM server. Thanks!
Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338
"Rushforth, Tim"
<TRushforth@WINNI To: ADSM-L AT VM.MARIST
DOT EDU
PEG.CA> cc:
Sent by: "ADSM: Subject: Re: UNLOAD/RELOAD DB
Dist Stor
Manager"
<[email protected]
.EDU>
04/09/2003 11:15
AM
Please respond to
"ADSM: Dist Stor
Manager"
Have you tried running expiration with skipdirs=yes? This may run quicker
and expire most of the data.
When we had long runing expirations we did this (also running regular
expiration).
-----Original Message-----
From: Joni Moyer [mailto:joni.moyer AT HIGHMARK DOT COM]
Sent: Wednesday, April 09, 2003 10:10 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: UNLOAD/RELOAD DB
Another of my problems is that expiration hasn't been able to run from
beginning to end, I set a duration of approximately 7 hours. Could this
also be causing performance/DB growth? Thanks!
Available Space (MB): 60,456
Assigned Capacity (MB): 60,456
Maximum Extension (MB): 0
Maximum Reduction (MB): 8,044
Page Size (bytes): 4,096
Total Usable Pages: 15,476,736
Used Pages: 12,913,875
Pct Util: 83.4
Max. Pct Util: 83.5
Physical Volumes: 26
Buffer Pool Pages: 24,576
Total Buffer Requests: 4,229,185
Cache Hit Pct.: 98.30
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 9
Changed Since Last Backup (MB): 149.34
Percentage Changed: 0.30
Last Complete Backup Date/Time: 04/09/2003 09:32:43
Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: UNLOAD/RELOAD DB, (continued)
- Re: UNLOAD/RELOAD DB, David Longo
- Re: UNLOAD/RELOAD DB, Joni Moyer
- Re: UNLOAD/RELOAD DB, Rushforth, Tim
- Re: UNLOAD/RELOAD DB, bbullock
- Re: UNLOAD/RELOAD DB, Hart, Charles
- Re: UNLOAD/RELOAD DB, Rushforth, Tim
- Re: UNLOAD/RELOAD DB, Loon, E.J. van - SPLXM
- Re: UNLOAD/RELOAD DB, bbullock
- Re: UNLOAD/RELOAD DB,
Joni Moyer <=
- Re: UNLOAD/RELOAD DB, Cinda Mullen
|
|
|