ADSM-L

Select Query Question

2003-03-03 05:46:35
Subject: Select Query Question
From: Farren Minns <fminns AT WILEY.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 3 Mar 2003 10:44:39 +0000
Hi TSMers

I'm trying to devise a select query that will show me the client backups
for the prev night with the following info:-

files checked
backed up
N transfer rate
A transfer rate
elapsed time etc.

Other than going throught the q actlog route, is there a way to get this
info using a select query of some sort?

Thanks

Farren



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

<Prev in Thread] Current Thread [Next in Thread>