Hi Joni!
I used the following formula:
Total usable pages - Used pages = Empty pages
Empty pages * 4096 = Empty bytes
Maximum reduction * 1024 * 1024 = Maximum reduction in bytes
Maximum reduction in bytes / Empty bytes * 100 = Usable percentage
In your case:
15,476,736 - 12,913,875 = 2,562,861
2,562,861 * 4096 = 10,497,478,656
8,044 * 1,024 * 1,024 = 8,434,745,344
8,434,745,344 / 10,497,478,656 * 100 = 80.35
So your fragmentation is about 20%, which looks rather high to me.
Of course, a never finishing expiration will also cause database growth (and
a growing amount of storagepool tapes).
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-----Original Message-----
From: Joni Moyer [mailto:joni.moyer AT HIGHMARK DOT COM]
Sent: Wednesday, April 09, 2003 17:10
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
"Loon, E.J. van -
SPLXM" To:
ADSM-L AT VM.MARIST DOT EDU
<Eric-van.Loon@KL cc:
M.COM> Subject: Re: UNLOAD/RELOAD
DB
Sent by: "ADSM:
Dist Stor
Manager"
<[email protected]
.EDU>
04/09/2003 09:54
AM
Please respond to
"ADSM: Dist Stor
Manager"
Hi Joni!
Please send us the output form the command q db f=d so we can calculate if
your database indeed is heavily fragmented.
I haven't done a unload/load myself but I read some stories in this list:
it
can be a rather lengthy process
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-----Original Message-----
From: Joni Moyer [mailto:joni.moyer AT HIGHMARK DOT COM]
Sent: Wednesday, April 09, 2003 14:22
To: ADSM-L AT VM.MARIST DOT EDU
Subject: UNLOAD/RELOAD DB
Hello All!
I was talking to TSM support yesterday about several issues concerning
expiration and the tsm database in my environment. I am on 4.1.5 on os/390
2.10 and I have a db that is 60GB with 83% utilized. It was suggested to
try to unloaddb and reload it, but I have been receiving mixed
feelings/messages from many users and co-workers. If anyone has done this
process, what are the pros/cons? Does this help with DB growth and
performance? I would appreciate any opinions or suggestions you may have!
Thank you in advance!
Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338
**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment
may be disclosed, copied or distributed, and that any other action related
to this e-mail or attachment is strictly prohibited, and may be unlawful.
If you have received this e-mail by error, please notify the sender
immediately by return e-mail, and delete this message. Koninklijke
Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees
shall not be liable for the incorrect or incomplete transmission of this
e-mail or any attachments, nor responsible for any delay in receipt.
**********************************************************************
|