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:[EMAIL PROTECTED] Gesendet: Montag, 10. M�rz 2003 15:15 An: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Gesendet: Montag, 10. M�rz 2003 14:16 An: [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED] "Herkenrath, Wolfgang" To: [EMAIL PROTECTED] <Wolfgang. cc: [EMAIL PROTECTED] Subject: AW: AW: Listing of all Backups and Archives DE> Sent by: "ADSM: Dist Stor Manager" <ADSM- [EMAIL PROTECTED]> 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:[EMAIL PROTECTED] Gesendet: Montag, 10. M�rz 2003 13:00 An: [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED] "Herkenrath, Wolfgang" To: [EMAIL PROTECTED] EDU <Wolfgang. cc: [EMAIL PROTECTED] Subject: AW: Listing of all Backups and Archives DE> Sent by: "ADSM: Dist Stor Manager" <ADSM- [EMAIL PROTECTED]> 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:[EMAIL PROTECTED] Gesendet: Montag, 10. M�rz 2003 11:23 An: [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED] "Herkenrath, Wolfgang" To: [EMAIL PROTECTED] EDU <Wolfgang. cc: [EMAIL PROTECTED] Subject: Listing of all Backups and Archives DE> Sent by: "ADSM: Dist Stor Manager" <ADSM- [EMAIL PROTECTED]> 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
