Here is how you tell if you need to defrag your TSM 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
--------- -------- --------- --------- ------- --------- --------- -----
-----
20,416 15,384 5,032 0 4,096 3,938,304 17,791 0.5
0.5
Note that out of 15 GB used in a 20 GB db only 0.5% is used yet I can't
reduce the db ANY !
time to unload / load :-(
Dwight
-----Original Message-----
From: M Jenkins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 10:11 PM
To: [EMAIL PROTECTED]
Subject: Database defragmentation (was Expiration)
OK, I'm curious.
How do you define 'old' ?
How often do you need to defrag the ADSM database (or is this like 'how
long is a piece of string'). How can you tell it needs defragging ? I
know where to get this information from ADABAS but not ADSM
Mavis
IP Australia
------------------------------
>Date: Tue, 17 Apr 2001 15:51:03 +0200
>From: "Chibois, Herve" <[EMAIL PROTECTED]>
>Subject: Re: Expiration
>
>Hi Bert,
>
>Your TSM server creeps !
>
>what is your BUFPOOLSIZE (dsmserv.opt)
>
>you should not go below 99.5 % for PCT CACHE
>
>change BUFPOOLSIZE to 256 Mo at least and restart your tsm server,
>the expiration process should fill the DB cache and it should speed up
>your process.
>
>What kind of disks are you using ? SSA or SCSI ? are the DBVOL files
>on the same disks as AIX ?
>
>If your DB is "old" you should do an unload/load db operation to
>defrag. your DB pages.
>
>rv
