Re: SAP data
2003-11-03 10:34:01
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:rene.lambelet AT nestle DOT com
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:GEOFFREY.L.GILL AT SAIC DOT COM]
Sent: Monday,3. November 2003 16:23
To: ADSM-L AT VM.MARIST DOT EDU
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: gillg AT saic DOT com
Phone: (858) 826-4062
Pager: (877) 905-7154
|
|
|