Hello yet again to all. I'm still trying to figure out if my database is behaving in an odd manner. When expiration runs on the database, it gives the output at the end as follows:-
03/02/03 16:49:22 ANR0812I Inventory file expiration process 22 completed: examined 616719 objects, deleting 13750 backup objects, 0 archive objects, 0 DB backup volumes, and 0 recovery plan files. 0 errors were encountered. What is the 'object' that it's referring to? Is it files and dir's that we have got backed up? If so than it's very wrong as some of our machines have over 2,000,000 files on them. Can someone explain to me where it gets the figures from? Many thanks as always Farren Minns - John Wiley & Sons Ltd Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: Fragmented Database Question 2 On vrijdag, feb 28, 2003, at 17:14 Europe/Amsterdam, Farren Minns wrote: > Hi Again > > Regarding the TSM DB, wouldn't the 'Used' and 'Total Usable Pages' > figures > help to point to a fragmentation problem. > > The output fro our DB is as follows:- > > Available Space (MB): 10,000 > Assigned Capacity (MB): 8,500 > Maximum Extension (MB): 1,500 > Maximum Reduction (MB): 1,492 > Page Size (bytes): 4,096 > Total Usable Pages: 2,176,000 > Used Pages: 1,787,528 > Pct Util: 82.1 > Max. Pct Util: 82.5 > Physical Volumes: 2 > Buffer Pool Pages: 32,768 > Total Buffer Requests: 10,278,342 > Cache Hit Pct.: 98.88 > Cache Wait Pct.: 0.00 > > > > Our database is 8500Mb assigned, and 82.1% utilised. So how do the > figures > of '1,787,528 pages used' and '2,176,000 Usable Pages' work in this > case. > If we have used 81% percent of 8500, our usable pages should be much > lower > than used pages shouldn't it? Or am I missing something? > > Thanks again > > Farren Minns - John Wiley & Sons Ltd > 1.788 / 2.176 ~= 0.82, so that sort of works out. Each db page is 4k in size, so 2,176,000 * 4k = 8704000000 with will probably work out to about 8.5G, zo no problem ther either. Oh and uasble = free + used ;-) -- Met vriendelijke groeten, Remco Post SARA - Stichting Academisch Rekencentrum Amsterdam http://www.sara.nl High Performance Computing Tel. +31 20 592 8008 Fax. +31 20 668 3167 "I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end." -- Douglas Adams
