Re: Deleting a management class
Hi Andy, In my particular case the domain has a default management class of 14 days, but there is also a management class with a 10 years retention in this domain. Because directories are bound to the management class with the highest retention we normally use a cloptset for all nodes which sets the dirmc to the 14 days mgmtclass, but I noticed several nodes don't use this cloptset. I was thinking about removing the 10 years management class from the domain, since it's no longer used anymore. Afterwards the active directory backups will be rebound to the only remaining 14 days mgmtclass, but how about the inactive directory backups? Thanks again for your help! Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Andrew Raibeck Sent: vrijdag 24 augustus 2018 14:19 To: ADSM-L@VM.MARIST.EDU Subject: Re: Deleting a management class Hi Eric, The default management class is used if it has a backup copy group. If the default management class does not have a backup copy group, then the domain's backup retention (grace period) is used. Similar story for archive copies: If the default management class has an archive copy group, then the default management class is used. Otherwise the domain's archive retention (grace period) is used. Best regards, Andy Andrew Raibeck | IBM Spectrum Protect Level 3 | stor...@us.ibm.com "ADSM: Dist Stor Manager" wrote on 2018-08-24 07:42:47: > From: "Loon, Eric van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 2018-08-24 07:46 > Subject: Deleting a management class > Sent by: "ADSM: Dist Stor Manager" > > Hi guys, > What happens to inactive files when I remove a management class from a > domain? Active files will be rebound during the next backup, but how > about inactive files? I cannot find anything about this in the manuals. > Thanks for your help again. > Kind regards, > Eric van Loon > Air France/KLM Storage Engineering > > For information, services and offers, please visit our web site: > INVALID URI REMOVED > u=http-3A__www.klm.com&d=DwIFAg&c=jf_iaSHvJObTbx- > siA1ZOg&r=Ij6DLy1l7wDpCbTfcDkLC_KknvhyGdCy_RnAGnhV37I&m=aT1Z1ROlheBVJvXkAo5t3N9NOKCadcbwljNWDNF- > ydw&s=TLUpYDeGmNkJYKFLZhptXagzvfkDHF8W_ufRRQCXMI4&e=. This e-mail and > any attachment may contain confidential and privileged material > intended for the addressee only. If you are not the addressee, you are > notified that no part of the e-mail or any attachment may be > disclosed, copied or distributed, and that any other action related to > this e-mail or attachment is strictly prohibited, and may be unlawful. > If you have received this e-mail by error, please notify the sender > immediately by return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or > its employees shall not be liable for the incorrect or incomplete > transmission of this e-mail or any attachments, nor responsible for > any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal > Dutch Airlines) is registered in Amstelveen, The Netherlands, with > registered number 33014286 > > For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286
Re: Deleting a management class
Hi Eric, The default management class is used if it has a backup copy group. If the default management class does not have a backup copy group, then the domain's backup retention (grace period) is used. Similar story for archive copies: If the default management class has an archive copy group, then the default management class is used. Otherwise the domain's archive retention (grace period) is used. Best regards, Andy Andrew Raibeck | IBM Spectrum Protect Level 3 | stor...@us.ibm.com "ADSM: Dist Stor Manager" wrote on 2018-08-24 07:42:47: > From: "Loon, Eric van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 2018-08-24 07:46 > Subject: Deleting a management class > Sent by: "ADSM: Dist Stor Manager" > > Hi guys, > What happens to inactive files when I remove a management class from > a domain? Active files will be rebound during the next backup, but > how about inactive files? I cannot find anything about this in the manuals. > Thanks for your help again. > Kind regards, > Eric van Loon > Air France/KLM Storage Engineering > > For information, services and offers, please visit our web site: > INVALID URI REMOVED > u=http-3A__www.klm.com&d=DwIFAg&c=jf_iaSHvJObTbx- > siA1ZOg&r=Ij6DLy1l7wDpCbTfcDkLC_KknvhyGdCy_RnAGnhV37I&m=aT1Z1ROlheBVJvXkAo5t3N9NOKCadcbwljNWDNF- > ydw&s=TLUpYDeGmNkJYKFLZhptXagzvfkDHF8W_ufRRQCXMI4&e=. This e-mail > and any attachment may contain confidential and privileged material > intended for the addressee only. If you are not the addressee, you > are notified that no part of the e-mail or any attachment may be > disclosed, copied or distributed, and that any other action related > to this e-mail or attachment is strictly prohibited, and may be > unlawful. If you have received this e-mail by error, please notify > the sender immediately by return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ > or its employees shall not be liable for the incorrect or incomplete > transmission of this e-mail or any attachments, nor responsible for > any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal > Dutch Airlines) is registered in Amstelveen, The Netherlands, with > registered number 33014286 > >
Deleting a management class
Hi guys, What happens to inactive files when I remove a management class from a domain? Active files will be rebound during the next backup, but how about inactive files? I cannot find anything about this in the manuals. Thanks for your help again. Kind regards, Eric van Loon Air France/KLM Storage Engineering For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286
Re: Select statement for client occupancy by management class...???
select b.node_name,b.class_name,sum(c.file_size) from backups b,contents c
where b.object_id=c.object_id and b.node_name and b.node_name in
('','','') group by b.node_name,b.class_name
(don't expect it to run fast though...)
Dwight E. Cook
Technical Services Prof. Sr.
TSM Delivery Architect
IBM Cloud
(918) 493-4678
From: Efim
To: ADSM-L@VM.MARIST.EDU
Date: 04/11/2016 08:20 AM
Subject:Re: Select statement for client occupancy by management
class...???
Sent by:"ADSM: Dist Stor Manager"
Do you use different storage pools for each management class?
If no - it is very very difficult to calculate occupancy for each stored
object because you must select from backups table.
I don?t have select for do it.
Efim
> 11 апр. 2016 г., в 15:43, Dwight Cook написал(а):
>
> Does anyone have a select statement for client occupancy by management
> class (so I don't have to recreate the wheel)?
>
>
> Dwight E. Cook
> Technical Services Prof. Sr.
> TSM Delivery Architect
> IBM Cloud
> (918) 493-4678
Re: Select statement for client occupancy by management class...???
Do you use different storage pools for each management class? If no - it is very very difficult to calculate occupancy for each stored object because you must select from backups table. I don’t have select for do it. Efim > 11 апр. 2016 г., в 15:43, Dwight Cook написал(а): > > Does anyone have a select statement for client occupancy by management > class (so I don't have to recreate the wheel)? > > > Dwight E. Cook > Technical Services Prof. Sr. > TSM Delivery Architect > IBM Cloud > (918) 493-4678
Select statement for client occupancy by management class...???
Does anyone have a select statement for client occupancy by management class (so I don't have to recreate the wheel)? Dwight E. Cook Technical Services Prof. Sr. TSM Delivery Architect IBM Cloud (918) 493-4678
Re: Re: Different management class
On 08/18/2015 07:43 AM, Henrik Ahlgren wrote: > On Thu, Aug 13, 2015, at 10:42 AM, Robert Ouzen wrote: > >> I think I found the solution, to change on the backup copy group on the >> management class mgtest1 the copy mode to absolute. >> >> Run an incremental backup , the pst will be rebound and store to the >> correct storage pool and put back the copy mode to modified > > No need to do that. MOVE NODEDATA can be used to move the backups from > one storagepool to another. What that won't do, though, is move _only_ the .pst files. The smallest granularity for MOVE NODEDATA is an entire filespace. I don't think there is an actual full solution for this situation; you have to choose between leaving the already-backed-up .pst files where they are, moving them and any other data in those filespaces to the storage pool desired for the .pst files, or back up the .pst files again (either via the absolute setting described above or via a selective backup of just the .pst files) and lose a previous version in TSM. -- Hello World.David Bronder - Systems Architect Segmentation Fault ITS-EI, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. david-bron...@uiowa.edu
Re: Different management class
On Thu, Aug 13, 2015, at 10:42 AM, Robert Ouzen wrote: > I think I found the solution, to change on the backup copy group on the > management class mgtest1 the copy mode to absolute. > > Run an incremental backup , the pst will be rebound and store to the > correct storage pool and put back the copy mode to modified No need to do that. MOVE NODEDATA can be used to move the backups from one storagepool to another.
Re: Different management class
Hi Karel I think I found the solution, to change on the backup copy group on the management class mgtest1 the copy mode to absolute. Run an incremental backup , the pst will be rebound and store to the correct storage pool and put back the copy mode to modified Best Regards Robert -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Karel Bos Sent: Thursday, August 13, 2015 10:00 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Different management class New backup copies will go to new stg, existing backup copies gets rebound to new mgmt class but won't be automatically moved from 1 stg pool to another. Op 13 aug. 2015 08:05 schreef "Robert Ouzen" : > I to all > > I try to figure a scenario to change a backup for a client that only > pst files to go to another storage I created a new management class > and different copygroup destination for pst files call: mgtest1 > > > ? For all files management mgtest (default) go to TSMSTG1 storage > > ? For pst files management mgtest1 go to TSMSTG2 > storage > > ? > Here the copygroup output: > > tsm: TSMTEST>q co test active mgtest* f=d > > Policy Policy Mgmt Copy Copy > Versions Versions Retain Retain Copy Mode Copy > Serialization CopyCopy Destination Table of > DomainSet Name ClassGroupGroup Data > Data ExtraOnly > Frequency > Contents > Name Name Name Type > Exists DeletedVersions Version > >(TOC) Destination > > - > TEST ACTIVEMGTESTSTANDARDBackup 3 > 1No Limit 90 Modified >Shared Static 0 TSMSTG1 >TSMSTG1 > > TEST ACTIVEMGTEST1 STANDARDBackup 2 >130 60Modified > Shared Static 0 > TSMSTG2 TSMSTG2 > > In my dsm.opt I add another include statement: > > include "c:\...\*.*" mgtest > include "c:\...\*.pst" mgtest1 > > Run an incremental backup with the new include pst statement: > > Here the output: > > 08/13/2015 08:02:19 ANE4952I (Session: 1629, Node: TEST) Total > number of objects inspected: 44,375 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4954I (Session: 1629, Node: TEST) Total > number of objects backed up: 24 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4958I (Session: 1629, Node: TEST) Total > number of objects updated: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4960I (Session: 1629, Node: TEST) Total > number of objects rebound: 9 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4957I (Session: 1629, Node: TEST) Total > number of objects deleted: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4970I (Session: 1629, Node: TEST) Total > number of objects expired: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4959I (Session: 1629, Node: TEST) Total > number of objects failed: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4197I (Session: 1629, Node: TEST) Total > number of objects encrypted:0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4965I (Session: 1629, Node: TEST) Total > number of subfile objects: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4914I (Session: 1629, Node: TEST) Total > number of objects grew: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4916I (Session: 1629, Node: TEST) Total > number of retries: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4977I (Session: 1629, Node: TEST) Total > number of bytes inspected: 12.99 GB > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4961I (Session: 1629, Node: TEST) Total > number of
Re: Different management class
Hi Karel Did is a way to trigger the move ? I think a full backup maybe will do it . But I tried to figure another workaround , huge client. Best Regards Robert -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Karel Bos Sent: Thursday, August 13, 2015 10:00 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Different management class New backup copies will go to new stg, existing backup copies gets rebound to new mgmt class but won't be automatically moved from 1 stg pool to another. Op 13 aug. 2015 08:05 schreef "Robert Ouzen" : > I to all > > I try to figure a scenario to change a backup for a client that only > pst files to go to another storage I created a new management class > and different copygroup destination for pst files call: mgtest1 > > > ? For all files management mgtest (default) go to TSMSTG1 storage > > ? For pst files management mgtest1 go to TSMSTG2 > storage > > ? > Here the copygroup output: > > tsm: TSMTEST>q co test active mgtest* f=d > > Policy Policy Mgmt Copy Copy > Versions Versions Retain Retain Copy Mode Copy > Serialization CopyCopy Destination Table of > DomainSet Name ClassGroupGroup Data > Data ExtraOnly > Frequency > Contents > Name Name Name Type > Exists DeletedVersions Version > >(TOC) Destination > > - > TEST ACTIVEMGTESTSTANDARDBackup 3 > 1No Limit 90 Modified >Shared Static 0 TSMSTG1 >TSMSTG1 > > TEST ACTIVEMGTEST1 STANDARDBackup 2 >130 60Modified > Shared Static 0 > TSMSTG2 TSMSTG2 > > In my dsm.opt I add another include statement: > > include "c:\...\*.*" mgtest > include "c:\...\*.pst" mgtest1 > > Run an incremental backup with the new include pst statement: > > Here the output: > > 08/13/2015 08:02:19 ANE4952I (Session: 1629, Node: TEST) Total > number of objects inspected: 44,375 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4954I (Session: 1629, Node: TEST) Total > number of objects backed up: 24 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4958I (Session: 1629, Node: TEST) Total > number of objects updated: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4960I (Session: 1629, Node: TEST) Total > number of objects rebound: 9 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4957I (Session: 1629, Node: TEST) Total > number of objects deleted: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4970I (Session: 1629, Node: TEST) Total > number of objects expired: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4959I (Session: 1629, Node: TEST) Total > number of objects failed: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4197I (Session: 1629, Node: TEST) Total > number of objects encrypted:0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4965I (Session: 1629, Node: TEST) Total > number of subfile objects: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4914I (Session: 1629, Node: TEST) Total > number of objects grew: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4916I (Session: 1629, Node: TEST) Total > number of retries: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4977I (Session: 1629, Node: TEST) Total > number of bytes inspected: 12.99 GB > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4961I (Session: 1629, Node: TEST) Total > number of bytes transferred:25.16 MB > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4963I (Session: 1629
Re: Different management class
New backup copies will go to new stg, existing backup copies gets rebound to new mgmt class but won't be automatically moved from 1 stg pool to another. Op 13 aug. 2015 08:05 schreef "Robert Ouzen" : > I to all > > I try to figure a scenario to change a backup for a client that only pst > files to go to another storage > I created a new management class and different copygroup destination for > pst files call: mgtest1 > > > ? For all files management mgtest (default) go to TSMSTG1 storage > > ? For pst files management mgtest1 go to TSMSTG2 > storage > > ? > Here the copygroup output: > > tsm: TSMTEST>q co test active mgtest* f=d > > Policy Policy Mgmt Copy Copy > Versions Versions Retain Retain Copy Mode Copy > Serialization CopyCopy Destination Table of > DomainSet Name ClassGroupGroup Data > Data ExtraOnly > Frequency > Contents > Name Name Name Type > Exists DeletedVersions Version > >(TOC) Destination > > - > TEST ACTIVEMGTESTSTANDARDBackup 3 > 1No Limit 90 Modified >Shared Static 0 TSMSTG1 >TSMSTG1 > > TEST ACTIVEMGTEST1 STANDARDBackup 2 >130 60Modified > Shared Static 0 > TSMSTG2 TSMSTG2 > > In my dsm.opt I add another include statement: > > include "c:\...\*.*" mgtest > include "c:\...\*.pst" mgtest1 > > Run an incremental backup with the new include pst statement: > > Here the output: > > 08/13/2015 08:02:19 ANE4952I (Session: 1629, Node: TEST) Total > number of objects inspected: 44,375 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4954I (Session: 1629, Node: TEST) Total > number of objects backed up: 24 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4958I (Session: 1629, Node: TEST) Total > number of objects updated: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4960I (Session: 1629, Node: TEST) Total > number of objects rebound: 9 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4957I (Session: 1629, Node: TEST) Total > number of objects deleted: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4970I (Session: 1629, Node: TEST) Total > number of objects expired: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4959I (Session: 1629, Node: TEST) Total > number of objects failed: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4197I (Session: 1629, Node: TEST) Total > number of objects encrypted:0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4965I (Session: 1629, Node: TEST) Total > number of subfile objects: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4914I (Session: 1629, Node: TEST) Total > number of objects grew: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4916I (Session: 1629, Node: TEST) Total > number of retries: 0 > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4977I (Session: 1629, Node: TEST) Total > number of bytes inspected: 12.99 GB > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4961I (Session: 1629, Node: TEST) Total > number of bytes transferred:25.16 MB > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4963I (Session: 1629, Node: TEST) Data > transfer time:0.21 sec > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4966I (Session: 1629, Node: TEST) Network > data transfer rate: 117,985.53 KB/sec > (SESSION: 1629) > 08/13/2015 08:02:19 ANE4967I (Session: 1629, Node: TEST) Aggregate
Different management class
I to all I try to figure a scenario to change a backup for a client that only pst files to go to another storage I created a new management class and different copygroup destination for pst files call: mgtest1 ? For all files management mgtest (default) go to TSMSTG1 storage ? For pst files management mgtest1 go to TSMSTG2 storage ? Here the copygroup output: tsm: TSMTEST>q co test active mgtest* f=d Policy Policy Mgmt Copy Copy Versions Versions Retain Retain Copy Mode Copy Serialization CopyCopy Destination Table of DomainSet Name ClassGroupGroup Data Data ExtraOnly Frequency Contents Name Name Name Type Exists DeletedVersions Version (TOC) Destination - TEST ACTIVEMGTESTSTANDARDBackup 3 1No Limit 90 Modified Shared Static 0 TSMSTG1 TSMSTG1 TEST ACTIVEMGTEST1 STANDARDBackup 2 130 60Modified Shared Static 0 TSMSTG2 TSMSTG2 In my dsm.opt I add another include statement: include "c:\...\*.*" mgtest include "c:\...\*.pst" mgtest1 Run an incremental backup with the new include pst statement: Here the output: 08/13/2015 08:02:19 ANE4952I (Session: 1629, Node: TEST) Total number of objects inspected: 44,375 (SESSION: 1629) 08/13/2015 08:02:19 ANE4954I (Session: 1629, Node: TEST) Total number of objects backed up: 24 (SESSION: 1629) 08/13/2015 08:02:19 ANE4958I (Session: 1629, Node: TEST) Total number of objects updated: 0 (SESSION: 1629) 08/13/2015 08:02:19 ANE4960I (Session: 1629, Node: TEST) Total number of objects rebound: 9 (SESSION: 1629) 08/13/2015 08:02:19 ANE4957I (Session: 1629, Node: TEST) Total number of objects deleted: 0 (SESSION: 1629) 08/13/2015 08:02:19 ANE4970I (Session: 1629, Node: TEST) Total number of objects expired: 0 (SESSION: 1629) 08/13/2015 08:02:19 ANE4959I (Session: 1629, Node: TEST) Total number of objects failed: 0 (SESSION: 1629) 08/13/2015 08:02:19 ANE4197I (Session: 1629, Node: TEST) Total number of objects encrypted:0 (SESSION: 1629) 08/13/2015 08:02:19 ANE4965I (Session: 1629, Node: TEST) Total number of subfile objects: 0 (SESSION: 1629) 08/13/2015 08:02:19 ANE4914I (Session: 1629, Node: TEST) Total number of objects grew: 0 (SESSION: 1629) 08/13/2015 08:02:19 ANE4916I (Session: 1629, Node: TEST) Total number of retries: 0 (SESSION: 1629) 08/13/2015 08:02:19 ANE4977I (Session: 1629, Node: TEST) Total number of bytes inspected: 12.99 GB (SESSION: 1629) 08/13/2015 08:02:19 ANE4961I (Session: 1629, Node: TEST) Total number of bytes transferred:25.16 MB (SESSION: 1629) 08/13/2015 08:02:19 ANE4963I (Session: 1629, Node: TEST) Data transfer time:0.21 sec (SESSION: 1629) 08/13/2015 08:02:19 ANE4966I (Session: 1629, Node: TEST) Network data transfer rate: 117,985.53 KB/sec (SESSION: 1629) 08/13/2015 08:02:19 ANE4967I (Session: 1629, Node: TEST) Aggregate data transfer rate:445.70 KB/sec (SESSION: 1629) 08/13/2015 08:02:19 ANE4968I (Session: 1629, Node: TEST) Objects compressed by:0% (SESSION: 1629) 08/13/2015 08:02:19 ANE4976I (Session: 1629, Node: TEST) Total data reduction ratio: 99.82% (SESSION: 1629) 08/13/2015
Re: archive and directory management class
Eric If i remember correctly, dirmc is for backup only. How do you know that the archived directories are using the default 14 day MC? What does select * from archives where node_name =- 'n' and type = 'DIR' show? Also, unlike backups, i've always understood that archived directories are not bound to the MC with the longest retention (RETOnly) On 11 February 2015 at 10:16, Loon, EJ van (ITOPT3) - KLM < eric-van.l...@klm.com> wrote: > Hi guys! > I have hardly used the archive command myself but one of my customers now > tries to archive some data for 5 years. He specifies the -archmc= > commandline parameter and all files are correctly bound to the 5 years > management class. The directories however are bound to the default > management class (14 days). I know about the dirmc parameter, but this can > only be added to the option file, it's not a valid commandline parameter. > How does this work? I don't want to include the dirmc in the option file > because we only want the 5 year retention once for this specific archive... > Thanks for your help in advance! > Kind regards, > Eric van Loon > AF/KLM Storage Engineering > > > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain > confidential and privileged material intended for the addressee only. If > you are not the addressee, you are notified that no part of the e-mail or > any attachment may be disclosed, copied or distributed, and that any other > action related to this e-mail or attachment is strictly prohibited, and may > be unlawful. If you have received this e-mail by error, please notify the > sender immediately by return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission > of this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > >
archive and directory management class
Hi guys! I have hardly used the archive command myself but one of my customers now tries to archive some data for 5 years. He specifies the -archmc= commandline parameter and all files are correctly bound to the 5 years management class. The directories however are bound to the default management class (14 days). I know about the dirmc parameter, but this can only be added to the option file, it's not a valid commandline parameter. How does this work? I don't want to include the dirmc in the option file because we only want the 5 year retention once for this specific archive... Thanks for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286
Re: verify management class
I believe it should look for new domain default management class Besides , you should also consider increasing backup retention associated to policy domain. If any object bound to specific management class and if it doesn't found the same management class in your new domain then it will consider policy domain backup retention grace period. So it would also protect your data https://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=%2Fcom.ibm.itsmaixn.doc%2Fanragd55434.htm By Sarav +65-82284384 > On 22 Oct 2014, at 2:56 am, Hanover, Cameron wrote: > > While I search for answers elsewhere, maybe someone already has an answer > floating around in their head. > > TSM server 6.3. > > I have a user that has about 2 weeks worth of TDP/SQL backups. They have > turned off backups on the node. They have a 60 day retention policy > currently. They want to retain all two weeks of backups for 365 days, > including the inactive ones. > > My thought was this: > Create a new domain with a new default management class that has a 365 day > retention. Update the node to that domain, and all of its backups would be > assigned the default retention policy of the new domain. > > I was hoping that I could query the backups table to verify that this was the > case, but it doesn't appear to be that simple. > > select hl_name,ll_name,class_name,state from backups where > node_name='BF-SPDB01_SQL' > > HL_NAME: \WSS_Content_uhr\ > LL_NAME: full > CLASS_NAME: DEFAULT > STATE: ACTIVE_VERSION > > > When expiration runs, will it consider the default retention policy of the > domain when the backup was performed, or will it look at the new domain? > > My backup idea is to update the STANDARD management class on another server > instance to 365 days retention and export the node over there. > > -- > Cameron Hanover > chano...@umich.edu > > "A parade of thugs and fashion critics could pass through your living room > without you noticing, provided you were distracted by a sufficiently shiny > piece of tinfoil." > --Lore Sjöberg
Re: verify management class
I believe it will be the default management class of the domain where the data lives when expiration runs, not the domain where it originally backed up. So your first idea will work. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hanover, Cameron Sent: Tuesday, October 21, 2014 2:57 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] verify management class While I search for answers elsewhere, maybe someone already has an answer floating around in their head. TSM server 6.3. I have a user that has about 2 weeks worth of TDP/SQL backups. They have turned off backups on the node. They have a 60 day retention policy currently. They want to retain all two weeks of backups for 365 days, including the inactive ones. My thought was this: Create a new domain with a new default management class that has a 365 day retention. Update the node to that domain, and all of its backups would be assigned the default retention policy of the new domain. I was hoping that I could query the backups table to verify that this was the case, but it doesn't appear to be that simple. select hl_name,ll_name,class_name,state from backups where node_name='BF-SPDB01_SQL' HL_NAME: \WSS_Content_uhr\ LL_NAME: full CLASS_NAME: DEFAULT STATE: ACTIVE_VERSION When expiration runs, will it consider the default retention policy of the domain when the backup was performed, or will it look at the new domain? My backup idea is to update the STANDARD management class on another server instance to 365 days retention and export the node over there. -- Cameron Hanover chano...@umich.edu "A parade of thugs and fashion critics could pass through your living room without you noticing, provided you were distracted by a sufficiently shiny piece of tinfoil." --Lore Sjöberg
verify management class
While I search for answers elsewhere, maybe someone already has an answer floating around in their head. TSM server 6.3. I have a user that has about 2 weeks worth of TDP/SQL backups. They have turned off backups on the node. They have a 60 day retention policy currently. They want to retain all two weeks of backups for 365 days, including the inactive ones. My thought was this: Create a new domain with a new default management class that has a 365 day retention. Update the node to that domain, and all of its backups would be assigned the default retention policy of the new domain. I was hoping that I could query the backups table to verify that this was the case, but it doesn't appear to be that simple. select hl_name,ll_name,class_name,state from backups where node_name='BF-SPDB01_SQL' HL_NAME: \WSS_Content_uhr\ LL_NAME: full CLASS_NAME: DEFAULT STATE: ACTIVE_VERSION When expiration runs, will it consider the default retention policy of the domain when the backup was performed, or will it look at the new domain? My backup idea is to update the STANDARD management class on another server instance to 365 days retention and export the node over there. -- Cameron Hanover chano...@umich.edu "A parade of thugs and fashion critics could pass through your living room without you noticing, provided you were distracted by a sufficiently shiny piece of tinfoil." --Lore Sjöberg
Re: New management class
Hello, You can also look at ANE4960I messages in the actlog. On 3 juillet 2014 17:35:48 CEST, Remco Post wrote: >Op 3 jul. 2014, om 15:04 heeft Ehresman,David E. > het volgende geschreven: > >> If I move a node to a new management class (e.g. "include * 15day"), >is there a message in either the server actlog or the client >dsmched.log that indicates that backup entries have been rebound to the >new class? I looking for some indication that the change to the new >management class was effective. >> > >if the client is not ‘quiet’ every file rebound to a new mgmt class is >logged in the schedule log. > >> David -- Erwann SIMON Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
Re: New management class
Op 3 jul. 2014, om 15:04 heeft Ehresman,David E. het volgende geschreven: > If I move a node to a new management class (e.g. "include * 15day"), is there > a message in either the server actlog or the client dsmched.log that > indicates that backup entries have been rebound to the new class? I looking > for some indication that the change to the new management class was effective. > if the client is not ‘quiet’ every file rebound to a new mgmt class is logged in the schedule log. > David -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622
Re: New management class
The 'dsmc query backup' command reports management classes as part of the information it displays about backup files. You can also start the GUI client, select 'Restore', and expand the part of the file tree you are interested in. The file characteristics shown include management classes. Once you have examined the files you are interested in you can exit without starting a restore. Thomas Denier Thomas Jefferson University Hospital -Original Message- If I move a node to a new management class (e.g. "include * 15day"), is there a message in either the server actlog or the client dsmched.log that indicates that backup entries have been rebound to the new class? I looking for some indication that the change to the new management class was effective. David The information contained in this transmission contains privileged and confidential information. It is intended only for the use of the person named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. CAUTION: Intended recipients should NOT use email communication for emergent or urgent health care matters.
Antwort: [ADSM-L] New management class
Hi David, you should see that after the next backup operation from he TSM client statistics in dsmsched.log. See line 'Total number of objects rebound: ' Best regards, Rainer Von:"Ehresman,David E." An: ADSM-L@VM.MARIST.EDU Datum: 03.07.2014 15:05 Betreff: [ADSM-L] New management class Gesendet von: "ADSM: Dist Stor Manager" If I move a node to a new management class (e.g. "include * 15day"), is there a message in either the server actlog or the client dsmched.log that indicates that backup entries have been rebound to the new class? I looking for some indication that the change to the new management class was effective. David
New management class
If I move a node to a new management class (e.g. "include * 15day"), is there a message in either the server actlog or the client dsmched.log that indicates that backup entries have been rebound to the new class? I looking for some indication that the change to the new management class was effective. David
Re: bind all files except .pst to new management class?
Thomas, Thank you for responding, and for your analysis of the effect of the includes. Keith On Jun 24, 2014, at 11:40 AM, Thomas Denier wrote: > I think this would have the desired effect on backup copies of files that > still exist on the client system, including backup copies of older versions > of those files. The proposed change would not affect management class > assignments for backup copies of files that have been deleted from the client > system. > > Thomas Denier > Thomas Jefferson University Hospital > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of > Arbogast, Warren K > Sent: Tuesday, June 24, 2014 10:50 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] bind all files except .pst to new management class? > > A user wishes to bind all files except .pst files to a new management class > with more ample retention settings. What's the best way to do this? Is it > sufficient to bind all .pst files to a second management class --to keep them > from being bound to the new management class? > > Something like this: > include ?:\...\*ample-mc > include ?:\...\*.pst meager-mc > > Thank you, > Keith Arbogast > Indiana University > > > The information contained in this transmission contains privileged and > confidential information. It is intended only for the use of the person named > above. If you are not the intended recipient, you are hereby notified that > any review, dissemination, distribution or duplication of this communication > is strictly prohibited. If you are not the intended recipient, please contact > the sender by reply email and destroy all copies of the original message. > > CAUTION: Intended recipients should NOT use email communication for emergent > or urgent health care matters.
Re: bind all files except .pst to new management class?
Wanda, Thank you for responding, and for the refinement of the include statements. Keith On Jun 24, 2014, at 11:24 AM, Prather, Wanda wrote: > That will work. > But, if they really want *all* non-pst files bound to the new mgmt. class, > just change the copy group/retention settings for the default mgmt. class. > Then all you need is: > > include ?:\...\*.pst meager-mc > > > That would have a slight advantage, in that files that are inactive because > they no longer exist on the drive (which cannot be rebound) would be governed > by the new rules. And it's simpler. > > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of > Arbogast, Warren K > Sent: Tuesday, June 24, 2014 10:50 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] bind all files except .pst to new management class? > > A user wishes to bind all files except .pst files to a new management class > with more ample retention settings. What's the best way to do this? Is it > sufficient to bind all .pst files to a second management class --to keep them > from being bound to the new management class? > > Something like this: > include ?:\...\*ample-mc > include ?:\...\*.pst meager-mc > > Thank you, > Keith Arbogast > Indiana University > >
Re: bind all files except .pst to new management class?
I think this would have the desired effect on backup copies of files that still exist on the client system, including backup copies of older versions of those files. The proposed change would not affect management class assignments for backup copies of files that have been deleted from the client system. Thomas Denier Thomas Jefferson University Hospital -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Arbogast, Warren K Sent: Tuesday, June 24, 2014 10:50 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] bind all files except .pst to new management class? A user wishes to bind all files except .pst files to a new management class with more ample retention settings. What's the best way to do this? Is it sufficient to bind all .pst files to a second management class --to keep them from being bound to the new management class? Something like this: include ?:\...\*ample-mc include ?:\...\*.pst meager-mc Thank you, Keith Arbogast Indiana University The information contained in this transmission contains privileged and confidential information. It is intended only for the use of the person named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. CAUTION: Intended recipients should NOT use email communication for emergent or urgent health care matters.
Re: bind all files except .pst to new management class?
That will work. But, if they really want *all* non-pst files bound to the new mgmt. class, just change the copy group/retention settings for the default mgmt. class. Then all you need is: include ?:\...\*.pst meager-mc That would have a slight advantage, in that files that are inactive because they no longer exist on the drive (which cannot be rebound) would be governed by the new rules. And it's simpler. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Arbogast, Warren K Sent: Tuesday, June 24, 2014 10:50 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] bind all files except .pst to new management class? A user wishes to bind all files except .pst files to a new management class with more ample retention settings. What's the best way to do this? Is it sufficient to bind all .pst files to a second management class --to keep them from being bound to the new management class? Something like this: include ?:\...\*ample-mc include ?:\...\*.pst meager-mc Thank you, Keith Arbogast Indiana University
bind all files except .pst to new management class?
A user wishes to bind all files except .pst files to a new management class with more ample retention settings. What's the best way to do this? Is it sufficient to bind all .pst files to a second management class --to keep them from being bound to the new management class? Something like this: include ?:\…\*ample-mc include ?:\…\*.pst meager-mc Thank you, Keith Arbogast Indiana University
Re: Assigning management class to VM backups
Stefan, Thanks for the tip on include.vm. That is apparently new in VE 7.1 and is a feature I have been needing for over a year. David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Stefan Folkerts Sent: Saturday, April 05, 2014 11:08 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Assigning management class to VM backups Have a look at include.vm http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.client.doc%2Fr_opt_includevm.html On Sat, Apr 5, 2014 at 1:55 AM, Bill Boyer wrote: > I have a bunch of VM's that need to be handled differently than most of the > others being backed up. I created a mgmt. class for it and in the script > file used to run the dsmc backup vm -optfile=, I specified the -VMMC=. But > they did not get assigned to that class. I have different opt files for the > VM backups specifying the DOMAIN.VMFULL= of the ones I want to process. I > tried putting the VMMC in the opt file and still the don't get assigned > correctly. Is there an INCLUDE or something I also need to specific? > > > > I have a lot of VM's that only need a once a week full backup, so I have > them spread out across each day. Each day has its own opt file with the > DOMAIN.VMFULL speicying the VM's for that day. I then have a .CMD file to > run the DSMC BACKUP VM command with -OPTFILE= for that day of week. I just > can't seem to get the VM's to be assigned to other than the default > management class. I don't want to have to create a whole new policy domain > and set of nodes for this. > > > > Any help is appreciated as always. > > > > Bill Boyer > DSS, Inc. > (610) 927-4407 > "Enjoy life. It has an expiration date." - ?? >
Re: Assigning management class to VM backups
Have a look at include.vm http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.client.doc%2Fr_opt_includevm.html On Sat, Apr 5, 2014 at 1:55 AM, Bill Boyer wrote: > I have a bunch of VM's that need to be handled differently than most of the > others being backed up. I created a mgmt. class for it and in the script > file used to run the dsmc backup vm -optfile=, I specified the -VMMC=. But > they did not get assigned to that class. I have different opt files for the > VM backups specifying the DOMAIN.VMFULL= of the ones I want to process. I > tried putting the VMMC in the opt file and still the don't get assigned > correctly. Is there an INCLUDE or something I also need to specific? > > > > I have a lot of VM's that only need a once a week full backup, so I have > them spread out across each day. Each day has its own opt file with the > DOMAIN.VMFULL speicying the VM's for that day. I then have a .CMD file to > run the DSMC BACKUP VM command with -OPTFILE= for that day of week. I just > can't seem to get the VM's to be assigned to other than the default > management class. I don't want to have to create a whole new policy domain > and set of nodes for this. > > > > Any help is appreciated as always. > > > > Bill Boyer > DSS, Inc. > (610) 927-4407 > "Enjoy life. It has an expiration date." - ?? >
Assigning management class to VM backups
I have a bunch of VM's that need to be handled differently than most of the others being backed up. I created a mgmt. class for it and in the script file used to run the dsmc backup vm -optfile=, I specified the -VMMC=. But they did not get assigned to that class. I have different opt files for the VM backups specifying the DOMAIN.VMFULL= of the ones I want to process. I tried putting the VMMC in the opt file and still the don't get assigned correctly. Is there an INCLUDE or something I also need to specific? I have a lot of VM's that only need a once a week full backup, so I have them spread out across each day. Each day has its own opt file with the DOMAIN.VMFULL speicying the VM's for that day. I then have a .CMD file to run the DSMC BACKUP VM command with -OPTFILE= for that day of week. I just can't seem to get the VM's to be assigned to other than the default management class. I don't want to have to create a whole new policy domain and set of nodes for this. Any help is appreciated as always. Bill Boyer DSS, Inc. (610) 927-4407 "Enjoy life. It has an expiration date." - ??
Re: How to move directories to different management class?
> I do not want to keep directories in new MC and added DIRMC into dsm.opt on > all nodes, but I still can see directories in new MC. The usual advisory here: unless using CAD, the dsmc schedule process would have to be restarted for the options file changes to be in effect. And, generally, directories will show up in storage pool volumes if the client type is Windows, but not if Unix. Richard Sims
Re: How to move directories to different management class?
I am very sorry. You can ignore my previous messages. I have found some small portions of data - not directories. I have moved data to correct STG by MOVE NODEDATA. Grigori Solonovitch, Senior Systems Architect, IT, Ahli United Bank Kuwait, www.ahliunited.com.kw -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: 09 02 2014 9:13 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to move directories to different management class? Not clear what you refere to. Where exactly do you see directories in the new MC? From restore GUI, or a Select or what? When you add DIRMC, and you do the next backup, directories that still exist on the drive should get rebound to the new MC. Any objects that are already inactive and don't exist on the drive, I do not think can be rebound to new MC. (If it is something important, you could cheat by recreating a directory with the same name, then do a backup to force rebind, then remove the directory again, if that doesn't' cause a problem with your # of backup versions of the directory.) Wanda -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Grigori Solonovitch Sent: Friday, February 07, 2014 2:44 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How to move directories to different management class? I have domain with a few management classes. All directories are usually coming to MC with the longest expiry period. I have added new MC with very long expiry period for some specific data and all directories from nodes without DIRMC in dsm.opt immediately came to new MC. I do not want to keep directories in new MC and added DIRMC into dsm.opt on all nodes, but I still can see directories in new MC. How to move directories from one MC to other? Thank you very much in advance. Grigori Solonovitch, Senior Systems Architect, IT, Ahli United Bank Kuwait, www.ahliunited.com.kw CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software. Please consider the environment before printing this Email. CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software.
Re: How to move directories to different management class?
It is not clear for me as well. I could see list of directories by: q cont node= - for node, which should not be on this volume. I have tried to move data by: move nodedata but it says "No match found using this criteria." Grigori Solonovitch, Senior Systems Architect, IT, Ahli United Bank Kuwait, www.ahliunited.com.kw -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: 09 02 2014 9:13 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to move directories to different management class? Not clear what you refere to. Where exactly do you see directories in the new MC? From restore GUI, or a Select or what? When you add DIRMC, and you do the next backup, directories that still exist on the drive should get rebound to the new MC. Any objects that are already inactive and don't exist on the drive, I do not think can be rebound to new MC. (If it is something important, you could cheat by recreating a directory with the same name, then do a backup to force rebind, then remove the directory again, if that doesn't' cause a problem with your # of backup versions of the directory.) Wanda -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Grigori Solonovitch Sent: Friday, February 07, 2014 2:44 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How to move directories to different management class? I have domain with a few management classes. All directories are usually coming to MC with the longest expiry period. I have added new MC with very long expiry period for some specific data and all directories from nodes without DIRMC in dsm.opt immediately came to new MC. I do not want to keep directories in new MC and added DIRMC into dsm.opt on all nodes, but I still can see directories in new MC. How to move directories from one MC to other? Thank you very much in advance. Grigori Solonovitch, Senior Systems Architect, IT, Ahli United Bank Kuwait, www.ahliunited.com.kw CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software. Please consider the environment before printing this Email. CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software.
Re: How to move directories to different management class?
Not clear what you refere to. Where exactly do you see directories in the new MC? From restore GUI, or a Select or what? When you add DIRMC, and you do the next backup, directories that still exist on the drive should get rebound to the new MC. Any objects that are already inactive and don't exist on the drive, I do not think can be rebound to new MC. (If it is something important, you could cheat by recreating a directory with the same name, then do a backup to force rebind, then remove the directory again, if that doesn't' cause a problem with your # of backup versions of the directory.) Wanda -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Grigori Solonovitch Sent: Friday, February 07, 2014 2:44 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How to move directories to different management class? I have domain with a few management classes. All directories are usually coming to MC with the longest expiry period. I have added new MC with very long expiry period for some specific data and all directories from nodes without DIRMC in dsm.opt immediately came to new MC. I do not want to keep directories in new MC and added DIRMC into dsm.opt on all nodes, but I still can see directories in new MC. How to move directories from one MC to other? Thank you very much in advance. Grigori Solonovitch, Senior Systems Architect, IT, Ahli United Bank Kuwait, www.ahliunited.com.kw CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software. Please consider the environment before printing this Email.
How to move directories to different management class?
I have domain with a few management classes. All directories are usually coming to MC with the longest expiry period. I have added new MC with very long expiry period for some specific data and all directories from nodes without DIRMC in dsm.opt immediately came to new MC. I do not want to keep directories in new MC and added DIRMC into dsm.opt on all nodes, but I still can see directories in new MC. How to move directories from one MC to other? Thank you very much in advance. Grigori Solonovitch, Senior Systems Architect, IT, Ahli United Bank Kuwait, www.ahliunited.com.kw CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software. Please consider the environment before printing this Email.
Antwort: Re: [ADSM-L] Re: Oracle rman - specify management class
Hi there, this is what I did implement at customer sites: Include-Exclude Options File inclexcl.ora_sid.opt used by TDP for Oracle Unix Example of a TSM include/exclude file *==* * TDPO Client Include/Exclude File - testdb - * *==* Exclude * include.file/TDPO-testdb/.../*.rdb mc-oracle-db include.file/TDPO-testdb/.../*.rctl mc-oracle-log include.file/TDPO-testdb/.../*.rarc mc-oracle-log The suffix of the different type of RMAN objects coming along have been given to me by the Oracle admins. They are having a possibility inside of RMAN to use some kind of 'format' parameter to 'construct' teh object (piece) names. Hope this helps. Regards, Rainer Von:David Bronder An: ADSM-L@VM.MARIST.EDU Datum: 04.02.2014 17:14 Betreff:Re: [ADSM-L] Re: Oracle rman - specify management class Gesendet von: "ADSM: Dist Stor Manager" I believe you can also configure RMAN to format the object names differently for different backup types. If so, you could tailor include statements to direct the different types to different management classes and still just use one tdpo.opt and dsm.opt. =Dave On 02/04/2014 09:15 AM, Michael Prix wrote: > Hello Steven, > > it is possible, but a bit tricky: > Via "Open Channel..." you reference a tdpo.opt. In this tdpo.opt you > name a dsm.opt, and in this dsm.opt you can specify via "include > //.../* MC_NAME" your > managment-class. > > The differenciation between db-backups and log-backups are done in the > rman-script. In one you do a "backup database", in the other a "backup > archivelogs". > You have to have two different scripts, or close and open the channels > in between.Each "open channel" sources a different tdpo.opt which calls > a different dsm.opt. During the "backup database", some archivelogs will > also be backed up, but this might not be the problem in this construct. > > -- > Mit freundlichen Grüßen / kind regards > > Michael Prix > > On 02/04/2014 02:54 PM, Steven Langdale wrote: >> All >> >> We have quite a few large oracle nodes that backup via RMAN & TDPO. They >> currently run LAN Free. >> >> Does anyone know if it's possible to do the main DB LAN Free and specify a >> different management class for the archive redo logs? they are ~1GB each, >> so a disk pool is a better destination. >> >> The Oracle nodes are AIX if that makes a difference. >> >> Thanks >> >> Steven -- Hello World.David Bronder - Systems Architect Segmentation Fault ITS-EI, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. david-bron...@uiowa.edu
Re: Oracle rman - specify management class
We do this by using separate rman/tdpo.opt/dsm.opt/tsmnode setups for the database backups and archive logs. This means for each database we backup with RMAN we have 2 tsm nodes: an archive log node with a management class that points to a disk pool, and a database backup node that points to a tape pool and is lanfree. Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Michael Prix Sent: Tuesday, February 04, 2014 10:16 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Oracle rman - specify management class Hello Steven, it is possible, but a bit tricky: Via "Open Channel..." you reference a tdpo.opt. In this tdpo.opt you name a dsm.opt, and in this dsm.opt you can specify via "include //.../* MC_NAME" your managment-class. The differenciation between db-backups and log-backups are done in the rman-script. In one you do a "backup database", in the other a "backup archivelogs". You have to have two different scripts, or close and open the channels in between.Each "open channel" sources a different tdpo.opt which calls a different dsm.opt. During the "backup database", some archivelogs will also be backed up, but this might not be the problem in this construct. -- Mit freundlichen Grüßen / kind regards Michael Prix On 02/04/2014 02:54 PM, Steven Langdale wrote: > All > > We have quite a few large oracle nodes that backup via RMAN & TDPO. They > currently run LAN Free. > > Does anyone know if it's possible to do the main DB LAN Free and specify a > different management class for the archive redo logs? they are ~1GB each, > so a disk pool is a better destination. > > The Oracle nodes are AIX if that makes a difference. > > Thanks > > Steven - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
Re: Re: Oracle rman - specify management class
I believe you can also configure RMAN to format the object names differently for different backup types. If so, you could tailor include statements to direct the different types to different management classes and still just use one tdpo.opt and dsm.opt. =Dave On 02/04/2014 09:15 AM, Michael Prix wrote: > Hello Steven, > > it is possible, but a bit tricky: > Via "Open Channel..." you reference a tdpo.opt. In this tdpo.opt you > name a dsm.opt, and in this dsm.opt you can specify via "include > //.../* MC_NAME" your > managment-class. > > The differenciation between db-backups and log-backups are done in the > rman-script. In one you do a "backup database", in the other a "backup > archivelogs". > You have to have two different scripts, or close and open the channels > in between.Each "open channel" sources a different tdpo.opt which calls > a different dsm.opt. During the "backup database", some archivelogs will > also be backed up, but this might not be the problem in this construct. > > -- > Mit freundlichen Grüßen / kind regards > > Michael Prix > > On 02/04/2014 02:54 PM, Steven Langdale wrote: >> All >> >> We have quite a few large oracle nodes that backup via RMAN & TDPO. They >> currently run LAN Free. >> >> Does anyone know if it's possible to do the main DB LAN Free and specify a >> different management class for the archive redo logs? they are ~1GB each, >> so a disk pool is a better destination. >> >> The Oracle nodes are AIX if that makes a difference. >> >> Thanks >> >> Steven -- Hello World.David Bronder - Systems Architect Segmentation Fault ITS-EI, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. david-bron...@uiowa.edu
Re: Oracle rman - specify management class
Hello Steven, it is possible, but a bit tricky: Via "Open Channel..." you reference a tdpo.opt. In this tdpo.opt you name a dsm.opt, and in this dsm.opt you can specify via "include //.../* MC_NAME" your managment-class. The differenciation between db-backups and log-backups are done in the rman-script. In one you do a "backup database", in the other a "backup archivelogs". You have to have two different scripts, or close and open the channels in between.Each "open channel" sources a different tdpo.opt which calls a different dsm.opt. During the "backup database", some archivelogs will also be backed up, but this might not be the problem in this construct. -- Mit freundlichen Grüßen / kind regards Michael Prix On 02/04/2014 02:54 PM, Steven Langdale wrote: > All > > We have quite a few large oracle nodes that backup via RMAN & TDPO. They > currently run LAN Free. > > Does anyone know if it's possible to do the main DB LAN Free and specify a > different management class for the archive redo logs? they are ~1GB each, > so a disk pool is a better destination. > > The Oracle nodes are AIX if that makes a difference. > > Thanks > > Steven
Re: Oracle rman - specify management class
I no longer have any Rman clients, but I'd do a Q CONTENT to see if there's a naming convention you can exploit for an INCLUDE rule to specify the management class. As I recall, it was trivially easy to identify full backups in a prior environment, and Rman/TDPO honored the management class specification. HTH, Nick On Tuesday, February 4, 2014, Steven Langdale wrote: > All > > We have quite a few large oracle nodes that backup via RMAN & TDPO. They > currently run LAN Free. > > Does anyone know if it's possible to do the main DB LAN Free and specify a > different management class for the archive redo logs? they are ~1GB each, > so a disk pool is a better destination. > > The Oracle nodes are AIX if that makes a difference. > > Thanks > > Steven >
Oracle rman - specify management class
All We have quite a few large oracle nodes that backup via RMAN & TDPO. They currently run LAN Free. Does anyone know if it's possible to do the main DB LAN Free and specify a different management class for the archive redo logs? they are ~1GB each, so a disk pool is a better destination. The Oracle nodes are AIX if that makes a difference. Thanks Steven
Re: Domain, Management Class and Copy Group Best Practices
Thanks, guys! I had fallen asleep monitoring this thread and I just now caught up on it. Yes, there's a lot of unknowns at this juncture of our re-architecture of the TSM environment. We're introducing TSM DD as much as possible into the environment, along with replication between our two datacenters for failover (still manual in the TSM server world, but better than before). Between the DD, replication and other advanced functions, I had to rethink all the practices that we did back in the TSM v5 days. Right now, I'm leaning to have domains separated by BA and TDP (one per TDP, i.e. oracle, mssql, ve would be still OS files) clients. There would be an OS domain, TDP Oracle, TDP SQL, and potentially TDP VE domain. The storage pools I'm trying to get to as few as possible to reduce management and improve DD ratios (however, this may end up to be a waste of processing time). But at least I'll give it a try. Administrative timing for all sorts of work to happen on one single Dedupe stgpool is a concern. However, I'm relying on my replication server to handle a lot of that work. The production TSM server (the one that all clients will write to) will no longer have to do a copy storagepool. All it will do is a replication job, and then the replication server will do all the work for offsiting, including reclamation, copy stgpool, etc. Since all if it will be on disk, daily migration of primary pools will be a thing of the past. I think it's an aggressive architecture, and I'm not even sure if it's technically feasible. But I'll find out here in the next month or so. Sergio
Re: Domain, Management Class and Copy Group Best Practices
FWIW, here's the characteristics we use to split up our storage pools: * Backup vs archive - we segregate archives from backups since their retention (and subsequent reclamation) is so much longer than backups * Library - obviously we need to have separate storage pool hierarchies for separate libraries * Simultaneous copy - some of our clients are so slow that they can't make effective use of simultaneous copy, so we have a separate hierarchy on one server for those systems that does not do simultaneous copy. I guess in my mind a file from Windows is no different than a file from UNIX, so it doesn't make sense to segregate storage based on source platform. -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine On 05/08/13 12:43, Rick Adamson wrote: > Hi Wanda, > Note that in my situation not only were domains combined, but also storage > pools. > Combining the domains resulted in more clients utilizing the same disk, > primary, and copy pools, which ultimately increased the time needed to > migrate, backup, and reclaim specific pools. The end result was the need to > revisit my admin task scheduling and in some cases disk pool sizes. > > Obviously, this may not be an issue for admins who use a single storage pool > structure for multiple domains but many systems I have run into have storage > pools dedicated by platform (following their domain model). > So I just thought it worth mentioning > ~Rick
Re: Domain, Management Class and Copy Group Best Practices
Hi Wanda, Note that in my situation not only were domains combined, but also storage pools. Combining the domains resulted in more clients utilizing the same disk, primary, and copy pools, which ultimately increased the time needed to migrate, backup, and reclaim specific pools. The end result was the need to revisit my admin task scheduling and in some cases disk pool sizes. Obviously, this may not be an issue for admins who use a single storage pool structure for multiple domains but many systems I have run into have storage pools dedicated by platform (following their domain model). So I just thought it worth mentioning ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Wednesday, May 08, 2013 11:45 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices I find that shocking. Changing domain structure shouldn't do that. Did you open a performance PMR, or get any feedback from Tivoli? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick Adamson Sent: Wednesday, May 08, 2013 11:34 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices Just my 2 cents :) One of my TSM worlds consists of several TSM servers and roughly 900 clients (mix of BA, TDP, etc.). When the time came for an upgrade the original system was configured where domains and storage boundries were designed by platform. My management team asked the question "why not just have one, or multiple, generic domains and storage pols, would it not be easier to manage?". So I set out to combine and streamline where possible. One thing that I learned an wished I'd have given more consideration to when making these decisions was processing time. Since the operation is tapeless mount-points were not an issue, but the time required to perform migrations, storage pool backups, etc. increased exponentially. You may find it helpful to also consider these issues when making your design decisions... ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Wednesday, May 08, 2013 11:15 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices Agreed. No reason to create different domains due to platform, TSM doesn't care. I always tell my new customers to stick with minimal domains until they have a reason to add more. Start simple. It's easier to get more complex later, not as easy to merge/simplify. The primary reasons to create more domains: a) different default retention requirements or storage hierarchies that make sense in your organization b) the ability to give a different group of administrators control of "their" systems to define nodes, change passwords, set schedules (always outsource the work if you can!) c) different reporting requirements (this isn't strictly necessary, but sure makes it easier to segregate reporting.) d) domain for "Frozen" or "litigation hold" clients W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill Smoldt Sent: Tuesday, May 07, 2013 4:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices Sergio, Having developed some of the early training, way before V5, I can tell you that the rationale for platform domains was strictly organizational. In those days, most IT shops were organized by platform and had retention control over their own systems. Free of the organizational restriction it makes sense to create and populate domains specific to common retention parameters so that you aren't stuck with a lot of include statements. ___ Bill Smoldt President www.storserver.com 719-266-8777 x7103 On May 7, 2013, at 1:58 PM, Sergio O. Fuentes wrote: > Hello all, > > Back in the early TSM 5 days, or at least once when I went to training, it > was advised that each individual platform had its own DOMAIN for retention > and destination control. Now, since I'm evaluating a TSM v6 environment, I'm > rethinking whether that is necessary across the board. Sure, it's advisable > to have platform domains for TDP or NDMP type nodes, because of the way those > platforms handle retention settings for backups. However, have any of you > decided to 'squish' each of the standard OS B/A client domains into one > singular domain? I'm imagining having just one domain for standard B/A > client nodes.(In reality, I'll have many domains for standard B/A client > nodes, but that's for other reasons, i.e. different stgpool hierarchy). > > Is there any
Re: Domain, Management Class and Copy Group Best Practices
I find that shocking. Changing domain structure shouldn't do that. Did you open a performance PMR, or get any feedback from Tivoli? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick Adamson Sent: Wednesday, May 08, 2013 11:34 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices Just my 2 cents :) One of my TSM worlds consists of several TSM servers and roughly 900 clients (mix of BA, TDP, etc.). When the time came for an upgrade the original system was configured where domains and storage boundries were designed by platform. My management team asked the question "why not just have one, or multiple, generic domains and storage pols, would it not be easier to manage?". So I set out to combine and streamline where possible. One thing that I learned an wished I'd have given more consideration to when making these decisions was processing time. Since the operation is tapeless mount-points were not an issue, but the time required to perform migrations, storage pool backups, etc. increased exponentially. You may find it helpful to also consider these issues when making your design decisions... ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Wednesday, May 08, 2013 11:15 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices Agreed. No reason to create different domains due to platform, TSM doesn't care. I always tell my new customers to stick with minimal domains until they have a reason to add more. Start simple. It's easier to get more complex later, not as easy to merge/simplify. The primary reasons to create more domains: a) different default retention requirements or storage hierarchies that make sense in your organization b) the ability to give a different group of administrators control of "their" systems to define nodes, change passwords, set schedules (always outsource the work if you can!) c) different reporting requirements (this isn't strictly necessary, but sure makes it easier to segregate reporting.) d) domain for "Frozen" or "litigation hold" clients W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill Smoldt Sent: Tuesday, May 07, 2013 4:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices Sergio, Having developed some of the early training, way before V5, I can tell you that the rationale for platform domains was strictly organizational. In those days, most IT shops were organized by platform and had retention control over their own systems. Free of the organizational restriction it makes sense to create and populate domains specific to common retention parameters so that you aren't stuck with a lot of include statements. ___ Bill Smoldt President www.storserver.com 719-266-8777 x7103 On May 7, 2013, at 1:58 PM, Sergio O. Fuentes wrote: > Hello all, > > Back in the early TSM 5 days, or at least once when I went to training, it > was advised that each individual platform had its own DOMAIN for retention > and destination control. Now, since I'm evaluating a TSM v6 environment, I'm > rethinking whether that is necessary across the board. Sure, it's advisable > to have platform domains for TDP or NDMP type nodes, because of the way those > platforms handle retention settings for backups. However, have any of you > decided to 'squish' each of the standard OS B/A client domains into one > singular domain? I'm imagining having just one domain for standard B/A > client nodes.(In reality, I'll have many domains for standard B/A client > nodes, but that's for other reasons, i.e. different stgpool hierarchy). > > Is there any reason not to do this? Domain definitions have a default > management class that defines a copy group with retention, destination and > serialization parameters. I can see serialization getting in the way, but > that has only happened ONCE in 8 years of TSM 5. Other domain specific > options like frequency, and mode don't really impact us much. For Windows, > the system state mgmt class is non standard, but since it's not the default, > I don't see why I can't just add it as a non-default Management Class. I'm > already moving away from a directory management class, how about moving away > from the platform-specific domain? > > Thoughts, ideas? Gotchas, that I might be missing? > > As always, thanks, > > Sergio >
Re: Domain, Management Class and Copy Group Best Practices
Just my 2 cents :) One of my TSM worlds consists of several TSM servers and roughly 900 clients (mix of BA, TDP, etc.). When the time came for an upgrade the original system was configured where domains and storage boundries were designed by platform. My management team asked the question "why not just have one, or multiple, generic domains and storage pols, would it not be easier to manage?". So I set out to combine and streamline where possible. One thing that I learned an wished I'd have given more consideration to when making these decisions was processing time. Since the operation is tapeless mount-points were not an issue, but the time required to perform migrations, storage pool backups, etc. increased exponentially. You may find it helpful to also consider these issues when making your design decisions... ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Wednesday, May 08, 2013 11:15 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices Agreed. No reason to create different domains due to platform, TSM doesn't care. I always tell my new customers to stick with minimal domains until they have a reason to add more. Start simple. It's easier to get more complex later, not as easy to merge/simplify. The primary reasons to create more domains: a) different default retention requirements or storage hierarchies that make sense in your organization b) the ability to give a different group of administrators control of "their" systems to define nodes, change passwords, set schedules (always outsource the work if you can!) c) different reporting requirements (this isn't strictly necessary, but sure makes it easier to segregate reporting.) d) domain for "Frozen" or "litigation hold" clients W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill Smoldt Sent: Tuesday, May 07, 2013 4:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices Sergio, Having developed some of the early training, way before V5, I can tell you that the rationale for platform domains was strictly organizational. In those days, most IT shops were organized by platform and had retention control over their own systems. Free of the organizational restriction it makes sense to create and populate domains specific to common retention parameters so that you aren't stuck with a lot of include statements. ___ Bill Smoldt President www.storserver.com 719-266-8777 x7103 On May 7, 2013, at 1:58 PM, Sergio O. Fuentes wrote: > Hello all, > > Back in the early TSM 5 days, or at least once when I went to training, it > was advised that each individual platform had its own DOMAIN for retention > and destination control. Now, since I'm evaluating a TSM v6 environment, I'm > rethinking whether that is necessary across the board. Sure, it's advisable > to have platform domains for TDP or NDMP type nodes, because of the way those > platforms handle retention settings for backups. However, have any of you > decided to 'squish' each of the standard OS B/A client domains into one > singular domain? I'm imagining having just one domain for standard B/A > client nodes.(In reality, I'll have many domains for standard B/A client > nodes, but that's for other reasons, i.e. different stgpool hierarchy). > > Is there any reason not to do this? Domain definitions have a default > management class that defines a copy group with retention, destination and > serialization parameters. I can see serialization getting in the way, but > that has only happened ONCE in 8 years of TSM 5. Other domain specific > options like frequency, and mode don't really impact us much. For Windows, > the system state mgmt class is non standard, but since it's not the default, > I don't see why I can't just add it as a non-default Management Class. I'm > already moving away from a directory management class, how about moving away > from the platform-specific domain? > > Thoughts, ideas? Gotchas, that I might be missing? > > As always, thanks, > > Sergio >
Re: Domain, Management Class and Copy Group Best Practices
Agreed. No reason to create different domains due to platform, TSM doesn't care. I always tell my new customers to stick with minimal domains until they have a reason to add more. Start simple. It's easier to get more complex later, not as easy to merge/simplify. The primary reasons to create more domains: a) different default retention requirements or storage hierarchies that make sense in your organization b) the ability to give a different group of administrators control of "their" systems to define nodes, change passwords, set schedules (always outsource the work if you can!) c) different reporting requirements (this isn't strictly necessary, but sure makes it easier to segregate reporting.) d) domain for "Frozen" or "litigation hold" clients W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill Smoldt Sent: Tuesday, May 07, 2013 4:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Domain, Management Class and Copy Group Best Practices Sergio, Having developed some of the early training, way before V5, I can tell you that the rationale for platform domains was strictly organizational. In those days, most IT shops were organized by platform and had retention control over their own systems. Free of the organizational restriction it makes sense to create and populate domains specific to common retention parameters so that you aren't stuck with a lot of include statements. ___ Bill Smoldt President www.storserver.com 719-266-8777 x7103 On May 7, 2013, at 1:58 PM, Sergio O. Fuentes wrote: > Hello all, > > Back in the early TSM 5 days, or at least once when I went to training, it > was advised that each individual platform had its own DOMAIN for retention > and destination control. Now, since I'm evaluating a TSM v6 environment, I'm > rethinking whether that is necessary across the board. Sure, it's advisable > to have platform domains for TDP or NDMP type nodes, because of the way those > platforms handle retention settings for backups. However, have any of you > decided to 'squish' each of the standard OS B/A client domains into one > singular domain? I'm imagining having just one domain for standard B/A > client nodes.(In reality, I'll have many domains for standard B/A client > nodes, but that's for other reasons, i.e. different stgpool hierarchy). > > Is there any reason not to do this? Domain definitions have a default > management class that defines a copy group with retention, destination and > serialization parameters. I can see serialization getting in the way, but > that has only happened ONCE in 8 years of TSM 5. Other domain specific > options like frequency, and mode don't really impact us much. For Windows, > the system state mgmt class is non standard, but since it's not the default, > I don't see why I can't just add it as a non-default Management Class. I'm > already moving away from a directory management class, how about moving away > from the platform-specific domain? > > Thoughts, ideas? Gotchas, that I might be missing? > > As always, thanks, > > Sergio >
Re: Domain, Management Class and Copy Group Best Practices
On 05/08/2013 09:40 AM, Skylar Thompson wrote: > We've offered labs policy authority, although so far they're all happy > letting us suffer with managing the entire thing. :P > Heh. Well, we've been doing one variation or another on this service for more than 10 years, so I've had training time. :) - Allen S. Rout
Re: Domain, Management Class and Copy Group Best Practices
We've offered labs policy authority, although so far they're all happy letting us suffer with managing the entire thing. :P -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine On 05/08/13 06:37, Allen S. Rout wrote: > On 05/07/2013 04:32 PM, Skylar Thompson wrote: >> >> We now have moved to a model where the unit generating the >> backup/archive usage is charged per byte per year via a cost center. > > We've got a very similar structure here at UF, with the addition that > there are "local admins" designated for each (most) domain. These folks > can register new nodes, delete their data, etc. > > We assign charging authority by-domain and by-node. > > - Allen S. Rout > >
Re: Domain, Management Class and Copy Group Best Practices
On 05/07/2013 04:32 PM, Skylar Thompson wrote: > > We now have moved to a model where the unit generating the > backup/archive usage is charged per byte per year via a cost center. We've got a very similar structure here at UF, with the addition that there are "local admins" designated for each (most) domain. These folks can register new nodes, delete their data, etc. We assign charging authority by-domain and by-node. - Allen S. Rout
Re: Domain, Management Class and Copy Group Best Practices
I work in a large research department, with 31 labs that basically function as autonomous businesses, along with a few institutes and centers with their own funding. Of those 31 labs, 13 of them have some form of dedicated computational resources. We used to have one big policy domain, with one or more management classes defined for each of the labs. This would allow each lab to define (more specifically, tell us to define) its own retention and data placement policies. In the old days, this worked because the department funded all backups and archives centrally. We now have moved to a model where the unit generating the backup/archive usage is charged per byte per year via a cost center. It became difficult for us to track which lab a particular node is associated with. We've since split each unit (lab, center, institute, central department) into a separate policy domain. We then have reports that create aggregate data on the policy domain level we use for billing from the cost center. Whether the node is UNIX, Windows, or something else has no bearing on the policy domain; the usage from the cost center perspective is all that matters. The retention and placement policies from the old days is carried over too. This got a little tricky for systems that are jointly owned by multiple units. In these cases, there are specific data volumes that we can assign to a specific unit. We then create a node in that policy domain for that volume with its own backup schedule and restricted backup domain so that we can account for this split in the cost center. -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine On 05/07/13 12:58, Sergio O. Fuentes wrote: > Hello all, > > Back in the early TSM 5 days, or at least once when I went to training, it > was advised that each individual platform had its own DOMAIN for retention > and destination control. Now, since I'm evaluating a TSM v6 environment, I'm > rethinking whether that is necessary across the board. Sure, it's advisable > to have platform domains for TDP or NDMP type nodes, because of the way those > platforms handle retention settings for backups. However, have any of you > decided to 'squish' each of the standard OS B/A client domains into one > singular domain? I'm imagining having just one domain for standard B/A > client nodes.(In reality, I'll have many domains for standard B/A client > nodes, but that's for other reasons, i.e. different stgpool hierarchy). > > Is there any reason not to do this? Domain definitions have a default > management class that defines a copy group with retention, destination and > serialization parameters. I can see serialization getting in the way, but > that has only happened ONCE in 8 years of TSM 5. Other domain specific > options like frequency, and mode don't really impact us much. For Windows, > the system state mgmt class is non standard, but since it's not the default, > I don't see why I can't just add it as a non-default Management Class. I'm > already moving away from a directory management class, how about moving away > from the platform-specific domain? > > Thoughts, ideas? Gotchas, that I might be missing? > > As always, thanks, > > Sergio >
Re: Domain, Management Class and Copy Group Best Practices
Sergio, Having developed some of the early training, way before V5, I can tell you that the rationale for platform domains was strictly organizational. In those days, most IT shops were organized by platform and had retention control over their own systems. Free of the organizational restriction it makes sense to create and populate domains specific to common retention parameters so that you aren't stuck with a lot of include statements. ___ Bill Smoldt President www.storserver.com 719-266-8777 x7103 On May 7, 2013, at 1:58 PM, Sergio O. Fuentes wrote: > Hello all, > > Back in the early TSM 5 days, or at least once when I went to training, it > was advised that each individual platform had its own DOMAIN for retention > and destination control. Now, since I'm evaluating a TSM v6 environment, I'm > rethinking whether that is necessary across the board. Sure, it's advisable > to have platform domains for TDP or NDMP type nodes, because of the way those > platforms handle retention settings for backups. However, have any of you > decided to 'squish' each of the standard OS B/A client domains into one > singular domain? I'm imagining having just one domain for standard B/A > client nodes.(In reality, I'll have many domains for standard B/A client > nodes, but that's for other reasons, i.e. different stgpool hierarchy). > > Is there any reason not to do this? Domain definitions have a default > management class that defines a copy group with retention, destination and > serialization parameters. I can see serialization getting in the way, but > that has only happened ONCE in 8 years of TSM 5. Other domain specific > options like frequency, and mode don't really impact us much. For Windows, > the system state mgmt class is non standard, but since it's not the default, > I don't see why I can't just add it as a non-default Management Class. I'm > already moving away from a directory management class, how about moving away > from the platform-specific domain? > > Thoughts, ideas? Gotchas, that I might be missing? > > As always, thanks, > > Sergio >
Domain, Management Class and Copy Group Best Practices
Hello all, Back in the early TSM 5 days, or at least once when I went to training, it was advised that each individual platform had its own DOMAIN for retention and destination control. Now, since I'm evaluating a TSM v6 environment, I'm rethinking whether that is necessary across the board. Sure, it's advisable to have platform domains for TDP or NDMP type nodes, because of the way those platforms handle retention settings for backups. However, have any of you decided to 'squish' each of the standard OS B/A client domains into one singular domain? I'm imagining having just one domain for standard B/A client nodes.(In reality, I'll have many domains for standard B/A client nodes, but that's for other reasons, i.e. different stgpool hierarchy). Is there any reason not to do this? Domain definitions have a default management class that defines a copy group with retention, destination and serialization parameters. I can see serialization getting in the way, but that has only happened ONCE in 8 years of TSM 5. Other domain specific options like frequency, and mode don't really impact us much. For Windows, the system state mgmt class is non standard, but since it's not the default, I don't see why I can't just add it as a non-default Management Class. I'm already moving away from a directory management class, how about moving away from the platform-specific domain? Thoughts, ideas? Gotchas, that I might be missing? As always, thanks, Sergio
Re: TSM for VE management class
Since nobody else has responded, I'll put in my 2cents: AFAIK, the answer is no. (I think an INCLUDE statement will only work if you have a pattern match on the filename, not the filesystem name.) I haven't tried this yet, but what about using a 2nd data mover? Could even be a 2nd scheduler on the same system, but would give you a 2nd dsm.opt where you could use a different management class. Has anybody else tried this? W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ehresman,David E. Sent: Thursday, May 02, 2013 11:04 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM for VE management class Does TSM for VE honor "include FILESPACE MANAGEMENTCLASS" statements to direct selected VMs to a non-default management class? If so, can anyone give me a working example Include \VMFULL-Dsit1 nr is not having any effect for me. David
TSM for VE management class
Does TSM for VE honor "include FILESPACE MANAGEMENTCLASS" statements to direct selected VMs to a non-default management class? If so, can anyone give me a working example Include \VMFULL-Dsit1 nr is not having any effect for me. David
Re: TDP for MSSQL management class
Data Protection for SQL supports legacy (VDI) and VSS backup types. Backups using VSS utilize the VSSPOLICY statements in the .CFG file. Backups using Legacy utilize the INCLUDE statements in the .OPT file. Thanks, Del "ADSM: Dist Stor Manager" wrote on 04/18/2013 11:32:12 AM: > From: "Schaub, Steve" > To: ADSM-L@vm.marist.edu, > Date: 04/18/2013 11:38 AM > Subject: Re: TDP for MSSQL management class > Sent by: "ADSM: Dist Stor Manager" > > So does that mean that for TDP 6.3 and higher, we can't use client > option sets to direct these backups anymore? We need to use the > VSSPOLICY statements in each server's tdpsql.cfg file? > Steve Schaub > Systems Engineer II, Windows Backup/Recovery > BlueCross BlueShield of Tennessee > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On > Behalf Of Grigori Solonovitch > Sent: Thursday, April 18, 2013 2:07 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] FW: TDP for MSSQL management class > > I have found solution - just put nest line into tdpsql.cfg: > > VSSPOLICY GEN-DB-PROD * * TSM MSSQL > > I am very sorry for disturbance > > Grigori G. Solonovitch > Senior Systems Architect Ahli United Bank Kuwait www.ahliunited.com.kw > > Please consider the environment before printing this E-mail > > From: Grigori Solonovitch > Sent: 18 04 2013 8:10 AM > To: ADSM: Dist Stor Manager (ADSM-L@VM.MARIST.EDU) > Subject: TDP for MSSQL management class > > TSM Server 6.3.3.100, TSM Client 6.4.0, TDP for MS SQL 6.3.1 MS SQL > backups are coming to domain default management class. > I have tried next include statements from dsm.smp (it was > successfully used on TSM Server 5.5.6 with older version of TDP for MS SQL): > > INCLUDE "\...\meta\...\*" MSSQL > INCLUDE "\...\data\...\*" MSSQL > INCLUDE "\...\meta\...\log*" MSSQL > INCLUDE "\...\data\...\log*" MSSQL > > It does not work. I think because all TDP for MS SQL are coming to > filespaces \SqlServerWriter\.. instead of ...\meta\... and ...\data\ > I have tried to change to: > > INCLUDE "\...\SqlServerWriter\...\*" MSSQL > > but it did not help as well. > > What is a right way to specify management class for TDP for MS SQL backups? > > > Grigori G. Solonovitch > Senior Systems Architect Ahli United Bank Kuwait www.ahliunited.com.kw < > http://www.ahliunited.com.kw> > > Please consider the environment before printing this E-mail > > > > > CONFIDENTIALITY AND WAIVER: The information contained in this > electronic mail message and any attachments hereto may be legally > privileged and confidential. The information is intended only for > the recipient(s) named in this message. If you are not the intended > recipient you are notified that any use, disclosure, copying or > distribution is prohibited. If you have received this in error > please contact the sender and delete this message and any > attachments from your computer system. We do not guarantee that this > message or any attachment to it is secure or free from errors, > computer viruses or other conditions that may damage or interfere > with data, hardware or software. > > > Please consider the environment before printing this Email. > - > Please see the following link for the BlueCross BlueShield of > Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm >
Re: TDP for MSSQL management class
So does that mean that for TDP 6.3 and higher, we can't use client option sets to direct these backups anymore? We need to use the VSSPOLICY statements in each server's tdpsql.cfg file? Steve Schaub Systems Engineer II, Windows Backup/Recovery BlueCross BlueShield of Tennessee -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Grigori Solonovitch Sent: Thursday, April 18, 2013 2:07 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] FW: TDP for MSSQL management class I have found solution - just put nest line into tdpsql.cfg: VSSPOLICY GEN-DB-PROD * * TSM MSSQL I am very sorry for disturbance Grigori G. Solonovitch Senior Systems Architect Ahli United Bank Kuwait www.ahliunited.com.kw Please consider the environment before printing this E-mail From: Grigori Solonovitch Sent: 18 04 2013 8:10 AM To: ADSM: Dist Stor Manager (ADSM-L@VM.MARIST.EDU) Subject: TDP for MSSQL management class TSM Server 6.3.3.100, TSM Client 6.4.0, TDP for MS SQL 6.3.1 MS SQL backups are coming to domain default management class. I have tried next include statements from dsm.smp (it was successfully used on TSM Server 5.5.6 with older version of TDP for MS SQL): INCLUDE "\...\meta\...\*" MSSQL INCLUDE "\...\data\...\*" MSSQL INCLUDE "\...\meta\...\log*" MSSQL INCLUDE "\...\data\...\log*" MSSQL It does not work. I think because all TDP for MS SQL are coming to filespaces \SqlServerWriter\.. instead of ...\meta\... and ...\data\ I have tried to change to: INCLUDE "\...\SqlServerWriter\...\*" MSSQL but it did not help as well. What is a right way to specify management class for TDP for MS SQL backups? Grigori G. Solonovitch Senior Systems Architect Ahli United Bank Kuwait www.ahliunited.com.kw<http://www.ahliunited.com.kw> Please consider the environment before printing this E-mail CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software. Please consider the environment before printing this Email. - Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
FW: TDP for MSSQL management class
I have found solution - just put nest line into tdpsql.cfg: VSSPOLICY GEN-DB-PROD * * TSM MSSQL I am very sorry for disturbance Grigori G. Solonovitch Senior Systems Architect Ahli United Bank Kuwait www.ahliunited.com.kw Please consider the environment before printing this E-mail From: Grigori Solonovitch Sent: 18 04 2013 8:10 AM To: ADSM: Dist Stor Manager (ADSM-L@VM.MARIST.EDU) Subject: TDP for MSSQL management class TSM Server 6.3.3.100, TSM Client 6.4.0, TDP for MS SQL 6.3.1 MS SQL backups are coming to domain default management class. I have tried next include statements from dsm.smp (it was successfully used on TSM Server 5.5.6 with older version of TDP for MS SQL): INCLUDE "\...\meta\...\*" MSSQL INCLUDE "\...\data\...\*" MSSQL INCLUDE "\...\meta\...\log*" MSSQL INCLUDE "\...\data\...\log*" MSSQL It does not work. I think because all TDP for MS SQL are coming to filespaces \SqlServerWriter\.. instead of ...\meta\... and ...\data\ I have tried to change to: INCLUDE "\...\SqlServerWriter\...\*" MSSQL but it did not help as well. What is a right way to specify management class for TDP for MS SQL backups? Grigori G. Solonovitch Senior Systems Architect Ahli United Bank Kuwait www.ahliunited.com.kw<http://www.ahliunited.com.kw> Please consider the environment before printing this E-mail CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software. Please consider the environment before printing this Email.
TDP for MSSQL management class
TSM Server 6.3.3.100, TSM Client 6.4.0, TDP for MS SQL 6.3.1 MS SQL backups are coming to domain default management class. I have tried next include statements from dsm.smp (it was successfully used on TSM Server 5.5.6 with older version of TDP for MS SQL): INCLUDE "\...\meta\...\*" MSSQL INCLUDE "\...\data\...\*" MSSQL INCLUDE "\...\meta\...\log*" MSSQL INCLUDE "\...\data\...\log*" MSSQL It does not work. I think because all TDP for MS SQL are coming to filespaces \SqlServerWriter\.. instead of ...\meta\... and ...\data\ I have tried to change to: INCLUDE "\...\SqlServerWriter\...\*" MSSQL but it did not help as well. What is a right way to specify management class for TDP for MS SQL backups? Grigori G. Solonovitch Senior Systems Architect Ahli United Bank Kuwait www.ahliunited.com.kw Please consider the environment before printing this E-mail CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software. Please consider the environment before printing this Email.
Re: management class for systemstate
INCLUDE.SYSTEMSTATE ALL mc_name (mc_name is the name of the management class to which you want system state backups bound) Best regards, Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager "ADSM: Dist Stor Manager" wrote on 2012-10-23 11:59:41: > From: Tim Brown > To: ADSM-L@vm.marist.edu, > Date: 2012-10-23 12:05 > Subject: management class for systemstate > Sent by: "ADSM: Dist Stor Manager" > > Can one assign a management class to the systemstate backup. > > I coded this: > > INCLUDE SYSTEMSTATE SSTATE > > But when I open the GUI I see DEFAULT assigned to a systemstate > entries Bootable, Cluster Database... > > Thanks, > > Tim Brown > Supervisor Computer Operations > Central Hudson Gas & Electric > 284 South Ave > Poughkeepsie, NY 12601 > Email: tbr...@cenhud.com<mailto:tbr...@cenhud.com> <<mailto:tbr...@cenhud.com > >> > Phone: 845-486-5643 > Fax: 845-486-5921 > Cell: 845-235-4255 > > > "This message contains confidential information and is only for the > intended recipient. If the reader of this message is not the > intended recipient, or an employee or agent responsible for > delivering this message to the intended recipient, please notify the > sender immediately by replying to this note and deleting all copies > and attachments." >
management class for systemstate
Can one assign a management class to the systemstate backup. I coded this: INCLUDE SYSTEMSTATE SSTATE But when I open the GUI I see DEFAULT assigned to a systemstate entries Bootable, Cluster Database... Thanks, Tim Brown Supervisor Computer Operations Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com<mailto:tbr...@cenhud.com> <<mailto:tbr...@cenhud.com>> Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 "This message contains confidential information and is only for the intended recipient. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please notify the sender immediately by replying to this note and deleting all copies and attachments."
Re: Management class assigned to Domino backups
The windows native gui does not have this column, but you can choose the 'nsf view' from the backup archive's client gui and it does. If you are running an older backup archive client gui, say 5.5.3, you can see this same view from the web client. Frank Ramke From: Bill Boyer To: ADSM-L@vm.marist.edu Date: 05/11/2011 02:47 PM Subject: Management class assigned to Domino backups Sent by:"ADSM: Dist Stor Manager" Is there a way to list the management class a particular Domino mailbox backup is assigned? I need to verify that specific mailbox backups are assigned to a different management class than "DEFAULT" which has a longer retention policy. For remediation. The GUI for restore doesn't list that as a column. TIA, Bill
Re: Management class assigned to Domino backups
Yep, connecting as a BA client to the domino node works and will give you what you need. On Wed, 11 May 2011 15:34:17 -0400, Bill Boyer wrote: I was hoping to not have to query the BACKUPS table. Even using a key column it runs slow at best. I could always try connecting at the Domino nodename with the client an -VIRTUALNODE=, then doing a QUERY BACKUP. That works with Oracle RMAN and SQLServer nodes. Haven't tried it on a Domino node, yet. Always a first time... You remember the last TSMUG meeting I was discussing a client that was implementing the Cybernetics VTL dedupe unit? Well, they're still trying to implement it! No Schmidt. It still doesn't work worth a darn with TSM. They are actually trying to write new firmware code to try and get around some of the limitations they've found using TSM. Wish I could make it next week to the TSMUG meeting. Sounds like some interesting topics. We have a coworker out and he's got some big shoes to be filled. Had a major heart attack last weekend. Only a couple years older than me! Yikes!!! Bill -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Wednesday, May 11, 2011 2:51 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Management class assigned to Domino backups select hl_name, ll_name, class_name from backups where node_name='DOMINO-CLIENT-NAME-ALLCAPS' You'll get better performance if you can also specify ... and filespace_name='blah' but I don't' know how those are named for Domino -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill Boyer Sent: Wednesday, May 11, 2011 2:43 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Management class assigned to Domino backups Is there a way to list the management class a particular Domino mailbox backup is assigned? I need to verify that specific mailbox backups are assigned to a different management class than "DEFAULT" which has a longer retention policy. For remediation. The GUI for restore doesn't list that as a column. TIA, Bill
Re: Management class assigned to Domino backups
I was hoping to not have to query the BACKUPS table. Even using a key column it runs slow at best. I could always try connecting at the Domino nodename with the client an -VIRTUALNODE=, then doing a QUERY BACKUP. That works with Oracle RMAN and SQLServer nodes. Haven't tried it on a Domino node, yet. Always a first time... You remember the last TSMUG meeting I was discussing a client that was implementing the Cybernetics VTL dedupe unit? Well, they're still trying to implement it! No Schmidt. It still doesn't work worth a darn with TSM. They are actually trying to write new firmware code to try and get around some of the limitations they've found using TSM. Wish I could make it next week to the TSMUG meeting. Sounds like some interesting topics. We have a coworker out and he's got some big shoes to be filled. Had a major heart attack last weekend. Only a couple years older than me! Yikes!!! Bill -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Wednesday, May 11, 2011 2:51 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Management class assigned to Domino backups select hl_name, ll_name, class_name from backups where node_name='DOMINO-CLIENT-NAME-ALLCAPS' You'll get better performance if you can also specify ... and filespace_name='blah' but I don't' know how those are named for Domino -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill Boyer Sent: Wednesday, May 11, 2011 2:43 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Management class assigned to Domino backups Is there a way to list the management class a particular Domino mailbox backup is assigned? I need to verify that specific mailbox backups are assigned to a different management class than "DEFAULT" which has a longer retention policy. For remediation. The GUI for restore doesn't list that as a column. TIA, Bill
Re: Management class assigned to Domino backups
select hl_name, ll_name, class_name from backups where node_name='DOMINO-CLIENT-NAME-ALLCAPS' You'll get better performance if you can also specify ... and filespace_name='blah' but I don't' know how those are named for Domino -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill Boyer Sent: Wednesday, May 11, 2011 2:43 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Management class assigned to Domino backups Is there a way to list the management class a particular Domino mailbox backup is assigned? I need to verify that specific mailbox backups are assigned to a different management class than "DEFAULT" which has a longer retention policy. For remediation. The GUI for restore doesn't list that as a column. TIA, Bill
Management class assigned to Domino backups
Is there a way to list the management class a particular Domino mailbox backup is assigned? I need to verify that specific mailbox backups are assigned to a different management class than "DEFAULT" which has a longer retention policy. For remediation. The GUI for restore doesn't list that as a column. TIA, Bill
Re: Verify management class usage on an AIX TSM client
Hi, try something with 'dsmc query backup -ina' you'll find the mc info included in the output. This is usually really fast. As Wanda said, the client is the right tool for this. On 19 okt 2010, at 16:48, Moyer, Joni M wrote: > Hi Everyone, > > How can I verify that a particular management class is being used, in this > case: mcnlv365d, on a particular AIX TSM client at version 5.5.2.0 for > filesystem: /usr/grok/lun08? The full path of the data is: > /usr/grok/lun08/23184/ and they're looking for all files that are: > 810452492.*. > > Can anyone tell me how to verify that that management class is bound to those > particular files from the AIX TSM client? And is there also a way to verify > this from the TSM server? > > Any help is appreciated! Thanks! > > > This e-mail and any attachments to it are confidential and are intended > solely for use of the individual or entity to whom they are addressed. If you > have received this e-mail in error, please notify the sender immediately and > then delete it. If you are not the intended recipient, you must not keep, > use, disclose, copy or distribute this e-mail without the author's prior > permission. The views expressed in this e-mail message do not necessarily > represent the views of Highmark Inc., its subsidiaries, or affiliates.
Re: Verify management class usage on an AIX TSM client
Open the GUI on the client, click RESTORE, navigate to those files like you were going to select them for restore. Last column on the right shows the mgmt class the client is bound to. That's the easy way. On the server end, the only way is to craft a SELECT out of the BACKUPS table for those files. And running SELECT on the BACKUPS table can be painful. Much easier (and faster!) to have them do it on the client end. W -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Moyer, Joni M Sent: Tuesday, October 19, 2010 10:48 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Verify management class usage on an AIX TSM client Hi Everyone, How can I verify that a particular management class is being used, in this case: mcnlv365d, on a particular AIX TSM client at version 5.5.2.0 for filesystem: /usr/grok/lun08? The full path of the data is: /usr/grok/lun08/23184/ and they're looking for all files that are: 810452492.*. Can anyone tell me how to verify that that management class is bound to those particular files from the AIX TSM client? And is there also a way to verify this from the TSM server? Any help is appreciated! Thanks! This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.
Verify management class usage on an AIX TSM client
Hi Everyone, How can I verify that a particular management class is being used, in this case: mcnlv365d, on a particular AIX TSM client at version 5.5.2.0 for filesystem: /usr/grok/lun08? The full path of the data is: /usr/grok/lun08/23184/ and they're looking for all files that are: 810452492.*. Can anyone tell me how to verify that that management class is bound to those particular files from the AIX TSM client? And is there also a way to verify this from the TSM server? Any help is appreciated! Thanks! This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.
Assign management class to Hyper-V VM image backups
Is there a way to assign the Hyper-V BACKUP VM backups to a different management class? "Life is not about waiting for the storms to pass... It's about learning how to dance in the rain." - ?? Bill Boyer
Re: Access to Management Class for TSM Clients
Unfortunately force=yes is not valid for option set includes (or other additive option set options) but server side include/excludes are always enforced before client side include/excludes so in this case it will work. Just bind everything to the default MC in your option set. This will limit you and make it very messy to have individual include/excludes on a host by host basis, but that is in fact what you are asking for. -km On 12/08, Huebschman, George J. wrote: > You could use a client option set on the TSM Server with an include for > a specific management class with force=yes. > But, I don't think you could hide the other management classes. > We have some client option sets with includes for management class for > specific directories, but not all directories. It could get messy if > you have a variety of retention policies and client configurations. > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of > Abid Ilias > Sent: Thursday, August 12, 2010 3:47 PM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Access to Management Class for TSM Clients > > We have some longer management classes defined in a policy domain for > some specific purpose, but our management does not want TSM clients to > see or use them. Our management wants the TSM admins to have this > control and bind the data to different management class as per requests. > I have not seen any way to prevent users from doing this. Is there a > way to prevent TSM clients from using a management class other than > default. > > Any input would be greatly appreciated. > > Thanks > Abid > > IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason > therefore recommends that you do not send any confidential or sensitive > information to us via electronic mail, including social security numbers, > account numbers, or personal identification numbers. Delivery, and or timely > delivery of Internet mail is not guaranteed. Legg Mason therefore recommends > that you do not send time sensitive > or action-oriented messages to us via electronic mail. > > This message is intended for the addressee only and may contain privileged or > confidential information. Unless you are the intended recipient, you may not > use, copy or disclose to anyone any information contained in this message. If > you have received this message in error, please notify the author by replying > to this message and then kindly delete the message. Thank you.
Re: Access to Management Class for TSM Clients
You could use a client option set on the TSM Server with an include for a specific management class with force=yes. But, I don't think you could hide the other management classes. We have some client option sets with includes for management class for specific directories, but not all directories. It could get messy if you have a variety of retention policies and client configurations. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Abid Ilias Sent: Thursday, August 12, 2010 3:47 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Access to Management Class for TSM Clients We have some longer management classes defined in a policy domain for some specific purpose, but our management does not want TSM clients to see or use them. Our management wants the TSM admins to have this control and bind the data to different management class as per requests. I have not seen any way to prevent users from doing this. Is there a way to prevent TSM clients from using a management class other than default. Any input would be greatly appreciated. Thanks Abid IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Re: Access to Management Class for TSM Clients
On Aug 12, 2010, at 3:49 PM, Remco Post wrote: > On 12 aug 2010, at 21:46, Abid Ilias wrote: > >> We have some longer management classes defined in a policy domain for some >> specific purpose, but our management does not want TSM clients to see or >> use them. Our management wants the TSM admins to have this control and >> bind the data to different management class as per requests. I have not >> seen any way to prevent users from doing this. Is there a way to prevent >> TSM clients from using a management class other than default. >> > > use a different policy domain only for those clients that should have access > is a step in the right direction. Other than that, I'm sorry, no. Just a further note: Management classes with a longer RETonly value may implicitly be used, without explicit specification, in the backup of Windows directories, according to TSM architectural norms. The client DIRMc option may have to be used to keep the directories in the same management class as the data - and prevent mysterious, unexpected tape mounts during backup and restore because of the use of differing storage pools.
Re: Access to Management Class for TSM Clients
On 12 aug 2010, at 21:46, Abid Ilias wrote: > We have some longer management classes defined in a policy domain for some > specific purpose, but our management does not want TSM clients to see or use > them. Our management wants the TSM admins to have this control and bind the > data to different management class as per requests. I have not seen any way > to prevent users from doing this. Is there a way to prevent TSM clients from > using a management class other than default. > use a different policy domain only for those clients that should have access is a step in the right direction. Other than that, I'm sorry, no. > Any input would be greatly appreciated. > > Thanks > Abid -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622
Access to Management Class for TSM Clients
We have some longer management classes defined in a policy domain for some specific purpose, but our management does not want TSM clients to see or use them. Our management wants the TSM admins to have this control and bind the data to different management class as per requests. I have not seen any way to prevent users from doing this. Is there a way to prevent TSM clients from using a management class other than default. Any input would be greatly appreciated. Thanks Abid
Re: Changing management class wihtout retransferring all data
Wanda Prather writes: >[...] > There is not a way to change the management class for inactive files > that no longer exist on the hard drive. More precisely: You can't change the management class _name_. What you can do (if you have to), is modifying the management class and copy group having the _name_ that is attached to the files in question (and displayed by "dsmc query backup"). Best done when the relevant node is in a domain of its own - which can be had via COPY DOMAIN, UPDATE NODE DOMAIN=, and re-creating schedules & administrative rights as required. Sure, by this approach you affect all (inactive, at least) of the node's files having the same management class - but often that's much better than having files expire too early. And be warned that it ain't a pretty sight, and may be utterly confusing to someone else, when - after such a change - you have a management class named "2WEEKS" keeping its files for 10 years ... but sure it's possible. Regards, Wolfgang J. Moeller Tel. +49 551 201-1516 ... not representing ... GWDG, Goettingen, Germany -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Alexander F?isch Sent: Wednesday, June 23, 2010 9:49 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Changing management class wihtout retransferring all data Hi, is there a possibility to change the management class without transfering the data again to TSM server? We have to change the management class of approx. 50TB of data (12 millions files) and we don't want to backup all the data again. Thanks. Alex
Re: Changing management class wihtout retransferring all data
Potential exceptions to this (unlikely as they may be): - If the old management class has MODE=MODIFIED and the new management class has MODE=ABSOLUTE, that will drive backups of all the files. - If the old management class has a relatively high FREQUENCY setting compared to the new management class, that could drive unexpected backups of files. Best regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/i...@ibmus Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2010-06-23 09:56:11: > From: "Prather, Wanda" > To: ADSM-L@vm.marist.edu > Date: 2010-06-23 10:09 > Subject: Re: Changing management class wihtout retransferring all data > Sent by: "ADSM: Dist Stor Manager" > > If you change the management class (for example by adding an INCLUDE > statement to bind a file to a different management class), the next > time you run a backup you will see "files rebound n" in the > statistics. TSM will just change the management class for the files > it finds (files that still exist on the hard drive). It will not > resend the data. > > There is not a way to change the management class for inactive files > that no longer exist on the hard drive. > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On > Behalf Of Alexander Födisch > Sent: Wednesday, June 23, 2010 9:49 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Changing management class wihtout retransferring all data > > Hi, > > is there a possibility to change the management class without > transfering the data again to TSM server? > We have to change the management class of approx. 50TB of data (12 > millions files) and we don't want to backup all the > data again. > > > Thanks. > Alex
Re: Changing management class wihtout retransferring all data
If you change the management class (for example by adding an INCLUDE statement to bind a file to a different management class), the next time you run a backup you will see "files rebound n" in the statistics. TSM will just change the management class for the files it finds (files that still exist on the hard drive). It will not resend the data. There is not a way to change the management class for inactive files that no longer exist on the hard drive. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Alexander Födisch Sent: Wednesday, June 23, 2010 9:49 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Changing management class wihtout retransferring all data Hi, is there a possibility to change the management class without transfering the data again to TSM server? We have to change the management class of approx. 50TB of data (12 millions files) and we don't want to backup all the data again. Thanks. Alex
Changing management class wihtout retransferring all data
Hi, is there a possibility to change the management class without transfering the data again to TSM server? We have to change the management class of approx. 50TB of data (12 millions files) and we don't want to backup all the data again. Thanks. Alex
Re: How to find what management class is used per node
Hello Dwight, I have found your queries very good and developed some shell scripts, based on your queries, to produce reports for: 1) Domain - Node - File Space - Destination - Management Class - Copy Group Parameters (verexists, verdeleted,retextra, reatonly) for file backups; 2) Domain - Node - File Space - Destination - Management Class - Copy Group Parameters (verexists, verdeleted,retextra, reatonly) for directories (to control DIRMC); 3) Domain - Node - File Space - Destination - Management Class - Retain Versions for file archives; 4) Domain - Node - File Space - Destination - Management Class - Retain Versions for directory archives (to control DIRMC). Shell scripts are quite good: 1) produce exact information about used MC, polls and copy group parameters for all nodes; 2) running for acceptable time; 3) running without total overloading TSM Server. Scripts provide information like this: -- | AIX | Node1 | FS1 | SP1 | MC1 | NOLIMIT | NOLIMIT | 31 |31 | | | | FS2 | SP1 | MC1 | NOLIMIT | NOLIMIT | 31 |31 | | | | FS3 | SP1 | MC2 | NOLIMIT | NOLIMIT | 15 |15 | | | | FS3 | SP1 | MC3 | NOLIMIT | NOLIMIT | 62 |62 | |--+-+-+-+---+-+-+---+---| | NT | Node2 | FS4 | SP2 | MC4 | NOLIMIT | NOLIMIT |8 | 8 | . Scripts were developed under AIX, but I think they can be used under any UNIX with small modifications (see support for commands "tr" and "od" only). I can provide scripts to anybody, who is interesting in this kind of reports, by direct E-mail. Kindest regards, Grigori G. Solonovitch Senior Technical Architect Information Technology Bank of Kuwait and Middle East http://www.bkme.com Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: g.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Dwight Cook Sent: Wednesday, March 03, 2010 12:23 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to find what management class is used per node Try these: select distinct node_name as "Node Name ",filespace_name as "Filespace Name ",class_name as "Management Class Name" from backups where TYPE='FILE' group by node_name,filespace_name,class_name Node Name Filespace Name Management Class Name -- -- - TSMCLI01 / DEFAULT TSMCLI01 /home DEFAULT TSMCLI01 /opt DEFAULT TSMCLI01 /tmp DEFAULT TSMCLI01 /tsm DEFAULT TSMCLI01 /usr DEFAULT TSMCLI01 /var DEFAULT TSMCLI01 /wn001 DEFAULT and the same for the archives table you could always use the ~where node_name='HMPG1018'~ to limit the output to just that node select distinct node_name,filespace_name,class_name from backups group by node_name,filespace_name,class_name will show you everything, including directory information... NODE_NAME FILESPACE_NAME CLASS_NAME -- -- -- TSMCLI01 / B7.3_R35.95_A370_- DIRMC TSMCLI01 / DEFAULT TSMCLI01 /home B7.3_R35.95_A370_- DIRMC TSMCLI01 /home DEFAULT <...> TSMCLI01 /wn001 B7.3_R35.95_A370_- DIRMC TSMCLI01 /wn001 DEFAULT -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Moyer, Joni M Sent: Tuesday, March 02, 2010 2:21 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How to find what management class is used per node Hi, I was just wondering if anyone knows a script that I can run to find out what management class is utilized by node hmpg1018? Would I need to run: select * from backups where node_name='HMPG1018'? Thanks in advance for any help Joni Moyer Storage Administrator III (717)302-9966 joni.mo...@highmark.com This e-mail and any attachments to it are confidential and are intended solely for use of the indi
Re: How to find what management class is used per node
That is perfect! Thanks Dwight! That is exactly the output I was looking for! -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Dwight Cook Sent: Tuesday, March 02, 2010 4:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: How to find what management class is used per node Try these: select distinct node_name as "Node Name ",filespace_name as "Filespace Name",class_name as "Management Class Name" from backups where TYPE='FILE' group by node_name,filespace_name,class_name Node Name Filespace Name Management Class Name -- -- - TSMCLI01 / DEFAULT TSMCLI01 /home DEFAULT TSMCLI01 /opt DEFAULT TSMCLI01 /tmp DEFAULT TSMCLI01 /tsm DEFAULT TSMCLI01 /usr DEFAULT TSMCLI01 /var DEFAULT TSMCLI01 /wn001 DEFAULT and the same for the archives table you could always use the ~where node_name='HMPG1018'~ to limit the output to just that node select distinct node_name,filespace_name,class_name from backups group by node_name,filespace_name,class_name will show you everything, including directory information... NODE_NAME FILESPACE_NAME CLASS_NAME -- -- -- TSMCLI01 / B7.3_R35.95_A370_- DIRMC TSMCLI01 / DEFAULT TSMCLI01 /home B7.3_R35.95_A370_- DIRMC TSMCLI01 /home DEFAULT <...> TSMCLI01 /wn001 B7.3_R35.95_A370_- DIRMC TSMCLI01 /wn001 DEFAULT -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Moyer, Joni M Sent: Tuesday, March 02, 2010 2:21 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How to find what management class is used per node Hi, I was just wondering if anyone knows a script that I can run to find out what management class is utilized by node hmpg1018? Would I need to run: select * from backups where node_name='HMPG1018'? Thanks in advance for any help Joni Moyer Storage Administrator III (717)302-9966 joni.mo...@highmark.com This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.
Re: How to find what management class is used per node
Try these: select distinct node_name as "Node Name ",filespace_name as "Filespace Name",class_name as "Management Class Name" from backups where TYPE='FILE' group by node_name,filespace_name,class_name Node Name Filespace Name Management Class Name -- -- - TSMCLI01 / DEFAULT TSMCLI01 /home DEFAULT TSMCLI01 /opt DEFAULT TSMCLI01 /tmp DEFAULT TSMCLI01 /tsm DEFAULT TSMCLI01 /usr DEFAULT TSMCLI01 /var DEFAULT TSMCLI01 /wn001 DEFAULT and the same for the archives table you could always use the ~where node_name='HMPG1018'~ to limit the output to just that node select distinct node_name,filespace_name,class_name from backups group by node_name,filespace_name,class_name will show you everything, including directory information... NODE_NAME FILESPACE_NAME CLASS_NAME -- -- -- TSMCLI01 / B7.3_R35.95_A370_- DIRMC TSMCLI01 / DEFAULT TSMCLI01 /home B7.3_R35.95_A370_- DIRMC TSMCLI01 /home DEFAULT <...> TSMCLI01 /wn001 B7.3_R35.95_A370_- DIRMC TSMCLI01 /wn001 DEFAULT -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Moyer, Joni M Sent: Tuesday, March 02, 2010 2:21 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How to find what management class is used per node Hi, I was just wondering if anyone knows a script that I can run to find out what management class is utilized by node hmpg1018? Would I need to run: select * from backups where node_name='HMPG1018'? Thanks in advance for any help Joni Moyer Storage Administrator III (717)302-9966 joni.mo...@highmark.com This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.
Re: How to find what management class is used per node
Avoid that if you can. You probably can. If you can not, someone else will be able to. * Normally the node uses the default management class for the domain; then any MC specified by INCLUDE statements. * Log onto the client and run "q inclexcl". The q inclexcl command will show you all includes and excludes in the dsm.opt, inclexcl file, or client option set. Check the listing, looking for includes, then for mgmt class names next to the includes. * Also, directories will automatically use the management class with the longest retention in the domain (unless the client is using a "dirmc" option.) You certainly can run a select against the largest of the tables, but it should be done carefully. Smart folks advise against it. It is a very intensive query. If there are many objects for this client, try to limit the query as much as possible by using index keys. Try running the select against one filespace at a time for example. If you have many filespaces and that seems to tedious, it is an indicator that you need to do it! I was just wondering if anyone knows a script that I can run to find out what management class is utilized by node hmpg1018? Would I need to run: select * from backups where node_name='HMPG1018'? George H IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Re: How to find what management class is used per node
On 2 mrt 2010, at 21:21, Moyer, Joni M wrote: > Hi, > > I was just wondering if anyone knows a script that I can run to find out what > management class is utilized by node hmpg1018? Would I need to run: select * > from backups where node_name='HMPG1018'? > on the node itself run 'dsmc q backup / -ina -subdir=y' (assuming unix, but you get the drift) since each file can be bound to a different mgmt class, there is no such concept of a mgmt class used by a node, and the client is the proper place to run this query, not the server. > Thanks in advance for any help > > Joni Moyer > Storage Administrator III > (717)302-9966 > joni.mo...@highmark.com -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622
How to find what management class is used per node
Hi, I was just wondering if anyone knows a script that I can run to find out what management class is utilized by node hmpg1018? Would I need to run: select * from backups where node_name='HMPG1018'? Thanks in advance for any help Joni Moyer Storage Administrator III (717)302-9966 joni.mo...@highmark.com This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.
Re: Re: Bind management class to NFS mounted NAS device on Linux
Keith Arbogast wrote: > > Someone 'Richard and famous' caught a syntax error in my include > statement. It is corrected to: > include.fs.nas /nfs/evs05/opt/oracle/rman rman The "include.fs.nas" statement is for NDMP backups, not for backing up an NFS filesystem mounted on the TSM client node. Try this: include /nfs/evs05/opt/oracle/rman/.../* rman -- Hello World.David Bronder - Systems Admin Segmentation Fault ITS-SPA, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. david-bron...@uiowa.edu
Re: Bind management class to NFS mounted NAS device on Linux
Someone 'Richard and famous' caught a syntax error in my include statement. It is corrected to: include.fs.nas /nfs/evs05/opt/oracle/rman rman Yet, when I ran a selective backup no files were rebound. 02/12/2010 14:54:15 ANE4952I (Session: 20869, Node: ESDBD10) Total number of objects inspected: 172 (SESSION: 20869) 02/12/2010 14:54:15 ANE4954I (Session: 20869, Node: ESDBD10) Total number of objects backed up: 172 (SESSION: 20869) 02/12/2010 14:54:15 ANE4958I (Session: 20869, Node: ESDBD10) Total number of objects updated: 0 (SESSION: 20869) 02/12/2010 14:54:15 ANE4960I (Session: 20869, Node: ESDBD10) Total number of objects rebound: 0 (SESSION: 20869) 02/12/2010 14:54:15 ANE4957I (Session: 20869, Node: ESDBD10) Total number of objects deleted: 0 (SESSION: 20869) 02/12/2010 14:54:15 ANE4970I (Session: 20869, Node: ESDBD10) Total number of objects expired: 0 (SESSION: 20869) 02/12/2010 14:54:15 ANE4959I (Session: 20869, Node: ESDBD10) Total number of objects failed: 0 (SESSION: 20869) 02/12/2010 14:54:15 ANE4961I (Session: 20869, Node: ESDBD10) Total number of bytes transferred: 1.77 GB (SESSION: 20869) 02/12/2010 14:54:15 ANE4963I (Session: 20869, Node: ESDBD10) Data transfer time: 13.19 sec (SESSION: 20869) 02/12/2010 14:54:15 ANE4966I (Session: 20869, Node: ESDBD10) Network data transfer rate:141,453.72 KB/sec (SESSION: 20869) 02/12/2010 14:54:15 ANE4967I (Session: 20869, Node: ESDBD10) Aggregate data transfer rate: 105,510.62 KB/sec (SESSION: 20869) 02/12/2010 14:54:15 ANE4968I (Session: 20869, Node: ESDBD10) Objects compressed by:0% (SESSION: 20869) 02/12/2010 14:54:15 ANE4964I (Session: 20869, Node: ESDBD10) Elapsed processing time:00:00:17 (SESSION: 20869) What is special about NFS mounts or NAS devices that might be resulting in this behavior? Best wishes, Keith Arbogast
Bind management class to NFS mounted NAS device on Linux
I am unable to bind a non-default management class to an NFS mounted NAS device using the usual 'include / syntax. Backed up files are bound to the default management class instead. Does someone see my mistake? The TSM client is version 5.5.2.6 on Redhat Linux. It is using dsmcad to start the client scheduler. We are running ordinary incremental backups of the filesystem. __ The filesystem is on a NAS device and is mounted like this in /etc/ fstab: evs05-g:/RMAN /nfs/evs05/opt/oracle/rmannfs rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp,nolock __ The output of 'mount' looks like this: r...@esdbd10 bin]# mount evs05-g:/RMAN on /nfs/evs05/opt/oracle/rman type nfs (rw,addr=10.0.111.181) __ 'root equivalency' is setup to allow root to read the files __ The domain statement in dsm.sys looks like this: domain ALL-LOCAL /nfs/evs05/opt/oracle/rman __ The include statement looks like this: include.fs.nas /nfs/evs05//opt/oracle/rman rman __ This version of the include statement also does not cause the needed binding: include /nfs/evs05/opt/oracle/rman rman __ The output of 'dsmc q inclexcl' looks like this: r...@esdbd10 bin]# dsmc q inclexcl IBM Tivoli Storage Manager Command Line Backup/Archive Client Interface Client Version 5, Release 5, Level 2.6 Client date/time: 02/12/2010 13:21:13 (c) Copyright by IBM Corporation and other(s) 1990, 2009. All Rights Reserved. Node Name: ESDBD10 Session established with server TSMBL01: Linux/x86_64 Server Version 5, Release 5, Level 4.1 Server date/time: 02/12/2010 13:21:13 Last access: 02/12/2010 13:18:54 *** FILE INCLUDE/EXCLUDE *** Mode Function Pattern (match from top down) Source File - -- - Excl Filespace /mnt/ORA_linux_install "/etc/adsm.inclexcl" Excl Filespace /tmp "/etc/adsm.inclexcl" Excl Directory /.../.TsmCacheDir TSM Excl Directory /opt/oracle/scripts"/etc/adsm.inclexcl" Excl Directory /opt/oracle/product"/etc/adsm.inclexcl" Excl Directory /opt/oracle/oraInventory "/etc/adsm.inclexcl" Excl Directory /opt/oracle/doc"/etc/adsm.inclexcl" Excl Directory /opt/oracle/ddl"/etc/adsm.inclexcl" Excl Directory /opt/oracle/backup "/etc/adsm.inclexcl" Excl Directory /opt/oracle/a01"/etc/adsm.inclexcl" Excl Directory /var/tmp "/etc/adsm.inclexcl" Excl Directory /.../.TsmCacheDir "/etc/adsm.inclexcl" Include NAS /nfs/evs05//opt/oracle/rman"/etc/adsm.inclexcl" Exclude All /nfs/evs05/opt/oracle/rman/.snapshot/.../* "/etc/ adsm.inclexcl" Include All /var/brte/.../*"/etc/adsm.inclexcl" Include All /opt/oracle/l03/.../* "/etc/adsm.inclexcl" Include All /opt/oracle/l02/.../* "/etc/adsm.inclexcl" Include All /opt/oracle/l01/.../* "/etc/adsm.inclexcl" Include All /opt/oracle/admin/.../*"/etc/adsm.inclexcl" Include All /opt/tivoli/tsm/client/ba/bin/dsm.opt "/etc/ adsm.inclexcl" Include All /opt/tivoli/tsm/client/ba/bin/dsm.sys "/etc/ adsm.inclexcl" Exclude All /opt/tivoli/.../* "/etc/adsm.inclexcl" Exclude All /source1/adsm/*.log"/etc/adsm.inclexcl" Exclude All /.../core "/etc/adsm.inclexcl" No DFS include/exclude statements defined. If I have left out an essential piece of the puzzle please let me know. I will be glad to provide it. If someone has any insights into binding a management class to a NFS mounted NAS device on Linux I would most grateful to receive them. Best wishes, Keith Arbogast Indiana University
Re: SQL Query find nodes associated with management class
Thanks for All your replies! I was able to come up with SQL query to display the nodes and their Management Classes Best Regards! Richard Sims wrote: On Jan 28, 2010, at 11:16 AM, Timothy Hughes wrote: Hi all, I am trying to find all nodes that are associated with a particular management class, does anyone have a SQL statement that will produce this information? A frequently asked question: see the ADSM-L archives for the many responses. Nodes are not assigned to management classes: individual file system objects are, where such binding can vary by Include spec and TSM directory processing rules. The SQL query to scan millions of files to determine this fully is infeasible. The only realistic thing to do is to sample a few representative files. Richard Sims
Re: SQL Query ...associated w/ management class
Lindsay Morris wrote: Right, we did some magic on the dsmc client... But I see this question here repeatedly: "how can I list all of my backup files?" And the answer is always "Don't do that, or tread carefully" like Richard just said. ... So why are people wanting to do this? Hey, you lurkers who think about doing this: will you speak up and say why, please? What are you really after, reducing wasted storage? tuning up retention policies? What? lind...@tsmworks.com A.Lurker responds "Yes" to both of the above, e.g., Upon finding DONT_DOIT policy in effect @ (inherited) NoClue TSM: tsm: NOCLUE>q co dont_doit act* PolicyPolicyMgmt Copy Versions Versions Retain Retain DomainSet Name Class Group Data DataExtraOnly NameName NameExists Deleted Versions Version - - - - --- DONT_DOIT ACTIVESPECIAL STANDARD30 30 999 999 DONT_DOIT ACTIVESTANDARD STANDARD 42 30 60 tsm: NOCLUE> [names changed, but unfortunately, this is not imaginary!] The now responsible TSM v5.5 SysAdm wants to know (who,what,howmuch) will be affected if we eliminate SPECIAL Mgmt Class, but would *not* dare to select node_name, filespace_name, filespace_id, HL_name, LL_name,- count(LL_name) as "#InActive", sum(file_size) as "NoAggr(MB)"- from backups,contents where state='Inactive'- and days(current_time)-days(deactivate_date)>30- and backups.object_id=contents.object_id- and aggregated='No'- /* because "actual" filesize isn't always available, but it should be! */ group by node_name, filespace_name, filespace_id, HL_name, LL_name The potential TSM v6.1.5 SysAdm wonders if, with the new DB2 basis, this/similar selection could actually return accurate information within the time that a reasonable person would be willing to wait? -- jim.o...@yale.edu (w#203.432.6693, c#203.494.9201, h#203.387.3030)
Re: SQL Query find nodes associated with management class
Hello Timothy,
I am using next scripts:
define script F3_Node_Backup_Copy_Groups description=" Active backup copy
groups for node"
update script F3_Node_Backup_Copy_Groups \
"select b.node_name, a.domain_name, a.class_name as Management_Class,
a.destination as Destination_Pool, \
a.verexists as MAX_Versions, a.verdeleted as Max_Deleted, a.retextra as
Days_Inactive, a.retonly Days_Last_Deleted \
from bu_copygroups a, backups b \
where a.class_name = b.class_name and a.set_name = 'ACTIVE' and b.node_name =
upper('\$1') \
group by b.node_name, a.domain_name, a.class_name, a.destination, a.verexists,
a.verdeleted, a.retextra, a.retonly"
define script F4_Node_Archive_Copy_Groups description=" Active archive
copy groups for node"
update script F4_Node_Archive_Copy_Groups \
"select b.node_name, a.domain_name, a.class_name as Management_Class,
a.destination as Destination_Pool, a.retver as Retention \
from ar_copygroups a, backups b \
where a.class_name = b.class_name and a.set_name = 'ACTIVE' and b.node_name =
upper('\$1') \
group by b.node_name, a.domain_name, a.class_name, a.destination, a.retver"
If you are ready to wait some time (sometimes huge), run
Re: SQL Query find nodes associated with management class
From: ADSM: Dist Stor Manager [ads...@vm.marist.edu] On Behalf Of Timothy Hughes [timothy.hug...@oit.state.nj.us] Sent: Thursday, January 28, 2010 7:16 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL Query find nodes associated with management class Hi all, I am trying to find all nodes that are associated with a particular management class, does anyone have a SQL statement that will produce this information? Thanks Please consider the environment before printing this Email. "This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in error, or if you are not the named recipient(s), please delete this email after notifying the sender immediately. BKME cannot guarantee the integrity of this communication and accepts no liability for any damage caused by this email or its attachments due to viruses, any other defects, interception or unauthorized modification. The information, views, opinions and comments of this message are those of the individual and not necessarily endorsed by BKME."
Re: SQL Query find nodes associated with management class
Right, we did some magic on the dsmc client so it can masquerade as other clients. Then, from our ART restore-testing appliance, we can run "dsmc query backup.." masquerading as each production node in turn, and do a restore test on a randomly selected file from that node. So ART can do random-sample restore testing on all 500 machines you back up. (Sorry. Marketing hat off.) But I see this question here repeatedly: "how can I list all of my backup files?" And the answer is always "Don't do that, or tread carefully" like Richard just said. But our ART tool DOES have a way to list all the backed-up files, and their sizes, and their management class.. ... for ALL the machines you back up with all your TSM servers ... without hurting your TSM server's performance. So why are people wanting to do this? Hey, you lurkers who think about doing this: will you speak up and say why, please? What are you really after, reducing wasted storage? tuning up retention policies? What? Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Thu, Jan 28, 2010 at 11:51 AM, Huebschman, George J. < gjhuebsch...@lmus.leggmason.com> wrote: > That is true. The dsmc q backup IS much more efficient. Some server > admins don't have access to clients though. In his case he wants to > look at all of his clients. I don't know how many he has, but the time > to go into each could be considerable. You mention a way of doing it > without log on to each client. You got me there. > > Richard's point is also very important. The query should be limited to > certain objects or filespaces that you would expect to be using that MC, > or the opposite if you want to be sure that if you want to be sure that > the MC is not being used where it shouldn't. For example, if you have > one long retention for ComplianceData and another for everything else, > you might care if system files are being bound to the Outrageos_Retn MC. > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of > Lindsay Morris > Sent: Thursday, January 28, 2010 11:34 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] SQL Query find nodes associated with management > class > > We deal with this problem by using the dsmc client, rather than the > dsmadmc client. > "dsmc query backup..." seems to be more efficient that "dsmadmc select > ... > from backups.." > > Requires some clever setup, though, so you don't have to go log on to > the client itself to run dsmc. > > Lindsay Morris > CEO, TSMworks > Tel. 1-859-539-9900 > lind...@tsmworks.com > > > On Thu, Jan 28, 2010 at 11:28 AM, Huebschman, George J. < > gjhuebsch...@lmus.leggmason.com> wrote: > > > The only way I know to get that directly is from the backups table. > > Running a select against the backups table for all nodes on a server > > is not a good thing...believe me (don't ask). > > > > If you want to do it, make the select as precise as possible and run > > it for one node at a time. > > > > select distinct node_name, filespace_name, class_name from backups > > where node_name='NODENAMEXYZ' and filespace_id=x (or > > filespace_name='whateveryerlookinfer') and type='FILE' and > > state='ACTIVE' > > > > Wanda advised me to limit such queries with index key paramaters as > > much as possible to keep the select processing as light as possible. > > > > George Huebschman > > > > -Original Message- > > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf > > Of Timothy Hughes > > Sent: Thursday, January 28, 2010 11:16 AM > > To: ADSM-L@VM.MARIST.EDU > > Subject: [ADSM-L] SQL Query find nodes associated with management > > class > > > > Hi all, > > > > > > I am trying to find all nodes that are associated with a particular > > management class, does anyone have a SQL statement that will produce > > this information? > > > > > > Thanks > > > > IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason > > > therefore recommends that you do not send any confidential or > > sensitive information to us via electronic mail, including social > > security numbers, account numbers, or personal identification numbers. > > > Delivery, and or timely delivery of Internet mail is not guaranteed. > > Legg Mason therefore recommends that you do not send time sensitive or > > > action-oriented messages to us via electronic mail. > > > > This message is
Re: SQL Query find nodes associated with management class
That is true. The dsmc q backup IS much more efficient. Some server admins don't have access to clients though. In his case he wants to look at all of his clients. I don't know how many he has, but the time to go into each could be considerable. You mention a way of doing it without log on to each client. You got me there. Richard's point is also very important. The query should be limited to certain objects or filespaces that you would expect to be using that MC, or the opposite if you want to be sure that if you want to be sure that the MC is not being used where it shouldn't. For example, if you have one long retention for ComplianceData and another for everything else, you might care if system files are being bound to the Outrageos_Retn MC. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Thursday, January 28, 2010 11:34 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL Query find nodes associated with management class We deal with this problem by using the dsmc client, rather than the dsmadmc client. "dsmc query backup..." seems to be more efficient that "dsmadmc select ... from backups.." Requires some clever setup, though, so you don't have to go log on to the client itself to run dsmc. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Thu, Jan 28, 2010 at 11:28 AM, Huebschman, George J. < gjhuebsch...@lmus.leggmason.com> wrote: > The only way I know to get that directly is from the backups table. > Running a select against the backups table for all nodes on a server > is not a good thing...believe me (don't ask). > > If you want to do it, make the select as precise as possible and run > it for one node at a time. > > select distinct node_name, filespace_name, class_name from backups > where node_name='NODENAMEXYZ' and filespace_id=x (or > filespace_name='whateveryerlookinfer') and type='FILE' and > state='ACTIVE' > > Wanda advised me to limit such queries with index key paramaters as > much as possible to keep the select processing as light as possible. > > George Huebschman > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf > Of Timothy Hughes > Sent: Thursday, January 28, 2010 11:16 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] SQL Query find nodes associated with management > class > > Hi all, > > > I am trying to find all nodes that are associated with a particular > management class, does anyone have a SQL statement that will produce > this information? > > > Thanks > > IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason > therefore recommends that you do not send any confidential or > sensitive information to us via electronic mail, including social > security numbers, account numbers, or personal identification numbers. > Delivery, and or timely delivery of Internet mail is not guaranteed. > Legg Mason therefore recommends that you do not send time sensitive or > action-oriented messages to us via electronic mail. > > This message is intended for the addressee only and may contain > privileged or confidential information. Unless you are the intended > recipient, you may not use, copy or disclose to anyone any information > contained in this message. If you have received this message in error, > please notify the author by replying to this message and then kindly > delete the message. Thank you. > IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Re: SQL Query find nodes associated with management class
We deal with this problem by using the dsmc client, rather than the dsmadmc client. "dsmc query backup..." seems to be more efficient that "dsmadmc select ... from backups.." Requires some clever setup, though, so you don't have to go log on to the client itself to run dsmc. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Thu, Jan 28, 2010 at 11:28 AM, Huebschman, George J. < gjhuebsch...@lmus.leggmason.com> wrote: > The only way I know to get that directly is from the backups table. > Running a select against the backups table for all nodes on a server is > not a good thing...believe me (don't ask). > > If you want to do it, make the select as precise as possible and run it > for one node at a time. > > select distinct node_name, filespace_name, class_name from backups where > node_name='NODENAMEXYZ' and filespace_id=x (or > filespace_name='whateveryerlookinfer') and type='FILE' and > state='ACTIVE' > > Wanda advised me to limit such queries with index key paramaters as much > as possible to keep the select processing as light as possible. > > George Huebschman > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of > Timothy Hughes > Sent: Thursday, January 28, 2010 11:16 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] SQL Query find nodes associated with management class > > Hi all, > > > I am trying to find all nodes that are associated with a particular > management class, does anyone have a SQL statement that will produce > this information? > > > Thanks > > IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason > therefore recommends that you do not send any confidential or sensitive > information to us via electronic mail, including social security numbers, > account numbers, or personal identification numbers. Delivery, and or timely > delivery of Internet mail is not guaranteed. Legg Mason therefore recommends > that you do not send time sensitive > or action-oriented messages to us via electronic mail. > > This message is intended for the addressee only and may contain privileged > or confidential information. Unless you are the intended recipient, you may > not use, copy or disclose to anyone any information contained in this > message. If you have received this message in error, please notify the > author by replying to this message and then kindly delete the message. Thank > you. >
Re: SQL Query find nodes associated with management class
The only way I know to get that directly is from the backups table. Running a select against the backups table for all nodes on a server is not a good thing...believe me (don't ask). If you want to do it, make the select as precise as possible and run it for one node at a time. select distinct node_name, filespace_name, class_name from backups where node_name='NODENAMEXYZ' and filespace_id=x (or filespace_name='whateveryerlookinfer') and type='FILE' and state='ACTIVE' Wanda advised me to limit such queries with index key paramaters as much as possible to keep the select processing as light as possible. George Huebschman -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Timothy Hughes Sent: Thursday, January 28, 2010 11:16 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL Query find nodes associated with management class Hi all, I am trying to find all nodes that are associated with a particular management class, does anyone have a SQL statement that will produce this information? Thanks IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Re: SQL Query find nodes associated with management class
On Jan 28, 2010, at 11:16 AM, Timothy Hughes wrote: > Hi all, > > > I am trying to find all nodes that are associated with a particular > management class, does anyone have a SQL statement that will produce > this information? A frequently asked question: see the ADSM-L archives for the many responses. Nodes are not assigned to management classes: individual file system objects are, where such binding can vary by Include spec and TSM directory processing rules. The SQL query to scan millions of files to determine this fully is infeasible. The only realistic thing to do is to sample a few representative files. Richard Sims
SQL Query find nodes associated with management class
Hi all, I am trying to find all nodes that are associated with a particular management class, does anyone have a SQL statement that will produce this information? Thanks
Output summary of data backed up per management class
Hi Everyone, I am trying to find out how much data I have backed up/archived per node per management class. Is there a way to get this data? I know of q auditocc, but that doesn't break it down as far as I would like to go. Any help/suggestions are greatly appreciated! Joni Moyer Highmark Storage Systems, Storage Mngt Analyst III Phone Number: (717)302-9966 Fax: (717) 302-9826 joni.mo...@highmark.com
Re: query what data binded against what management class
On Jan 21, 2009, at 8:35 PM, Cheung, Richard wrote: Hello.. Is it possible to run a command that can show me, for a specific node, what data has been backed up within that node, and against what management class this data is binded against? Conversely, is it possible to do a command that lists how much data is binded against all managementclasses?? Get familiar with what data is available in the customer-exposed Tables in the TSM db so that you can then go after things you need in queries. Run 'SELECT * FROM SYSCAT.COLUMNS > TSM_syscat_columns' to have a reference for such pursuits. The info you want is in the Archives and Backups tables. Whereas there is a table entry for every file system object, there can be millions of them, and thus traversal is arduous, such that such Selects are avoided unless absolutely necessary. I'd recommend not doing that unless there was a very compelling reason. Richard Sims
