You received warning from TSM about large results etc., did not you?
Large selects require appropriate large amount of free space in database to
save temporary results.
As I tried this script, my %util went from 27% to 32% and back.
Did you check free space in your database?
regards
Juraj
-----Ursprüngliche Nachricht-----
Von: Herkenrath, Wolfgang [mailto:Wolfgang.Herkenrath AT LVR DOT DE]
Gesendet: Montag, 10. März 2003 15:15
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: AW: AW: AW: Listing of all Backups and Archives
Wow, great select. I tried the first one. After some minutes my tsm-server
quit his job and break down. Think it was to much for him. ;-)
Wolfgang
-----Ursprüngliche Nachricht-----
Von: Christian Svensson [mailto:Christian.Svensson AT CRISTIE DOT SE]
Gesendet: Montag, 10. März 2003 14:16
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: AW: AW: Listing of all Backups and Archives
Hi!
That is one way to do it.
But you are lucky. Becuse for a few days i go i create a select command for
one of our larges customers here in Sweden. And they want to know how many
files our Bare Metal Restore software creating. And the select command to
see all backup files is.
tsm: TESTDOM>select NODE_NAME as "Node name", LL_NAME as "Filename", HL_Name
as "Path", Archive_date as "Backup Date" from archives group by node_name,
HL_Name, LL_Name, Archive_date
tsm: TESTDOM>select NODE_NAME as "Node name", LL_NAME as "Filename", HL_NAME
as "Path", Backup_date as "Backup Date" from backups group by node_name,
HL_Name, LL_Name, Backup_date
Try this command. Maybe this help you.
If not. Send me a email and tell me more what you searching for.
This script you got right now is a request after Node name, Filename, Path
and Backup date. And it´s sorted by 1)Node name 2)Path 3)Filename 4)Date.
Med Vänliga Hälsningar/Best Regards
Christian Svensson
----------------------------------------------------------------------------
---
Cristie Nordic AB
Box 2
SE-131 06 Nacka
Sweden
Phone : +46-(0)8-718 43 30
Mobil : +46-(0)70-325 15 77
eMail : christian.svensson AT cristie DOT se
MSN : issen007 AT hotmail DOT com
"Herkenrath,
Wolfgang" To:
ADSM-L AT VM.MARIST DOT EDU
<Wolfgang. cc:
Herkenrath@LVR. Subject: AW: AW: Listing of
all Backups and Archives
DE>
Sent by: "ADSM:
Dist Stor
Manager" <ADSM-
L AT VM.MARIST DOT EDU>
2003-03-10 13:21
Please respond to
"ADSM: Dist Stor
Manager"
Hi,
well, it's not my decision ;-)
I need all files from all clients. At the meantime I think I have to do it
with a select for the occupancy. Correct me if I'm wrong.
Wolfgang
-----Ursprüngliche Nachricht-----
Von: Christian Svensson [mailto:Christian.Svensson AT CRISTIE DOT SE]
Gesendet: Montag, 10. März 2003 13:00
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: AW: Listing of all Backups and Archives
Hi!
I can not help you if you going to move from TSM to NetBackup. I´m just
jokeing! ;-)
Do you only want to see the files who going to expire or all files?
Med Vänliga Hälsningar/Best Regards
Christian Svensson
----------------------------------------------------------------------------
---
Cristie Nordic AB
Box 2
SE-131 06 Nacka
Sweden
Phone : +46-(0)8-718 43 30
Mobil : +46-(0)70-325 15 77
eMail : christian.svensson AT cristie DOT se
MSN : issen007 AT hotmail DOT com
"Herkenrath,
Wolfgang" To: [email protected].
EDU
<Wolfgang. cc:
Herkenrath@LVR. Subject: AW: Listing of all
Backups and Archives
DE>
Sent by: "ADSM:
Dist Stor
Manager" <ADSM-
L AT VM.MARIST DOT EDU>
2003-03-10 12:08
Please respond to
"ADSM: Dist Stor
Manager"
Hi Cristie,
thanks for answer.
I need information for all files and when they will expire. For sure, it
will be a large list. My company will replace TSM with NetBackup :-((((( So
I need the information, wich data are at my TSM.
Wolfgang
-----Ursprüngliche Nachricht-----
Von: Christian Svensson [mailto:Christian.Svensson AT CRISTIE DOT SE]
Gesendet: Montag, 10. März 2003 11:23
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: Listing of all Backups and Archives
Hi Wolfgang!
Everything is possible to do. Becuse you have all the information in the
databas. So if you just use a select command you can get any information you
want. But do you want information for each file or do you want information
how much who going to expire in the closest 24 hours on each filespace or on
each node?
Med Vänliga Hälsningar/Best Regards
Christian Svensson
----------------------------------------------------------------------------
---
Cristie Nordic AB
Box 2
SE-131 06 Nacka
Sweden
Phone : +46-(0)8-718 43 30
Mobil : +46-(0)70-325 15 77
eMail : christian.svensson AT cristie DOT se
MSN : issen007 AT hotmail DOT com
"Herkenrath,
Wolfgang" To: [email protected].
EDU
<Wolfgang. cc:
Herkenrath@LVR. Subject: Listing of all
Backups and Archives
DE>
Sent by: "ADSM:
Dist Stor
Manager" <ADSM-
L AT VM.MARIST DOT EDU>
2003-03-10 11:17
Please respond to
"ADSM: Dist Stor
Manager"
Hi all,
is there a way to create a list of all backups and archives and there
expiration date? I mean all backups and archives for all clients. I think it
could be possible to do this with an SQL-script, but I'm not sure. And if it
is possible, does anyone has such a script. I don't want to invent the wheel
again.
THX
Wolfgang
|
