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" <[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
