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" <ADSM-L AT VM.MARIST DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
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
|
