Hi Geoff, In addition to Ren�'s queries, you could give "show version" command a try ! It will show you all files backed up inside a filespace, when they whent backuped, with which management class, if they're active etc .... Syntax is like this "show version NODE_NAME FILESPACE_NAME" (for old TSM server version) or "show version NODE_NAME XX nametype=fsid" XX beeing the filespace number found when issuing "q fi" (for TSM version >5). Concerning the growth of your SAP data, keep an eye on DB logs : maybe they where'nt deleted since a while ... (not sure if what I say makes sense when using TDP for SAP, but we had the problem while backuping our Informix DB's : the logs where not expired automatically ...) Good fishing !
Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lambelet,Rene,VEVEY,GL-CSC Sent: Monday, 03 November, 2003 16:33 To: [EMAIL PROTECTED] Subject: Re: SAP data select * from backups where node_name='XXXXXXXX' select * from archive where node_name='XXXXXXXX' or select * from backups where node_name='XXXXXXXX' and class_name='YYYYY' select * from archives where node_name='XXXXXXXX' and class_name='YYYYY' good luck Ren� LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center SD/ESN Av. Nestl� 55 CH-1800 Vevey (Switzerland) t�l +41 (0)21 924 35 43 fax +41 (0)21 924 13 69 local K4-104 mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential. -----Original Message----- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED] Sent: Monday,3. November 2003 16:23 To: [EMAIL PROTECTED] Subject: SAP data TSM Server AIX 4.3.3 TSM 5.1.6.3 Since we started running SAP R/3 backups the amount of data has continued to grow enormously. Being that those folks have asked me to set up a number of management classes for them it could be each of these are bound to different classes, or God forbid the same one. Is there a SQL query that will tell me what management classes this data is bound to? I'm a little concerned, with one node at 30TB and climbing and the other at 8TB, they could all be going to the wrong management class. Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
