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
