Re: bu single dir
Why not just backup the whole machine at 23:45 and don't even use the 20:00 one. Unless I'm misunderstanding you requirement? Steven Chris Lenssens chris.lenss...@sezz.be Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 14/11/2010 09:26 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] bu single dir Caterpillar: Confidential Green Retain Until: 14/12/2010 Hi, I'm not the TSM expert so I need some advice: The daily schedule at 20:00 backups the 2 partitions of my W2003-server except - so exlude.dir in dsm.opt - D:\XYZ; so far so good. That single directory D:\XYZ (also content and subdirectories) must be backup at 23:45 (than I can shutdown the database during 20 minutes). I was thinking about a new schedule with a new opt-file but what should I specify in that new tsm-file? Any - other - ideas/suggestions? Thanks in advance. Chris
select statement to display readonly and filling tapes
Hi I am trying to add filling tapes to this select statement and I am having no luck does anyone have a select statement that shows this? I already have most of the statement below i just need to add filling to the statement select VOLUME_NAME,ACCESS from volumes where access ='READONLY' thanks for any help
Re: select statement to display readonly and filling tapes
How about: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' Steven Timothy Hughes timothy.hug...@oit.state.nj.us Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 15/11/2010 13:39 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] select statement to display readonly and filling tapes Caterpillar: Confidential Green Retain Until: 15/12/2010 Hi I am trying to add filling tapes to this select statement and I am having no luck does anyone have a select statement that shows this? I already have most of the statement below i just need to add filling to the statement select VOLUME_NAME,ACCESS from volumes where access ='READONLY' thanks for any help
Re: select statement to display readonly and filling tapes
thanks steve! I tried that command failed, and also I want to select the readonly tapes that say filling also. So I replaced the or with and. this command failed also tsm: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' ANR0162W Supplemental database diagnostic information: -1:42601:-104 ([IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token END-OF-STATEMENT was found following cess = 'READONLY' or. Expected tokens may include: boolean_term. SQLSTATE=42601 ). ANR0516E SQL processing for statement select VOLUME_NAME , ACCESS from volumes where access = 'READONLY' or failed. ANS8001I Return code 3. tsm: status='FILLING' ANS8001I Return code 3. tsm: TSMCORE tsm: TSMCORE On 11/15/2010 8:48 AM, Steven Langdale wrote: How about: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' Steven Timothy Hughestimothy.hug...@oit.state.nj.us Sent by: ADSM: Dist Stor ManagerADSM-L@VM.MARIST.EDU 15/11/2010 13:39 Please respond to ADSM: Dist Stor ManagerADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] select statement to display readonly and filling tapes Caterpillar: Confidential Green Retain Until: 15/12/2010 Hi I am trying to add filling tapes to this select statement and I am having no luck does anyone have a select statement that shows this? I already have most of the statement below i just need to add filling to the statement select VOLUME_NAME,ACCESS from volumes where access ='READONLY' thanks for any help
Re: select statement to display readonly and filling tapes
If you only want to find tapes in FILLING this select should be more than enough: Select VOLUME_NAME from VOLUMES where status='FILLING' El nov 15, 2010 10:50 a.m., Steven Langdale steven.langd...@cat.com escribió: How about: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' Steven Timothy Hughes timothy.hug...@oit.state.nj.us Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 15/11/2010 13:39 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] select statement to display readonly and filling tapes Caterpillar: Confidential Green Retain Until: 15/12/2010 Hi I am trying to add filling tapes to this select statement and I am having no luck does anyo...
Re: select statement to display readonly and filling tapes
According to Timothy Hughes: thanks steve! I tried that command failed, and also I want to select the readonly tapes that say filling also. So I replaced the or with and. this command failed also tsm: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' ANR0162W Supplemental database diagnostic information: -1:42601:-104 ([IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token END-OF-STATEMENT was found following cess = 'READONLY' or. Expected tokens may include: boolean_term. SQLSTATE=42601 ). ANR0516E SQL processing for statement select VOLUME_NAME , ACCESS from volumes where access = 'READONLY' or failed. ANS8001I Return code 3. tsm: status='FILLING' ANS8001I Return code 3. select VOLUME_NAME,ACCESS from volumes where status in ('FILLING','FULL') Heinz -- Karlsruher Institut fuer Technologie (KIT) Steinbuch Centre for Computing (SCC) D-76131 Karlsruhe --
Re: select statement to display readonly and filling tapes
How about this for TSM: select VOLUME_NAME,ACCESS from volumes where access ='READONLY', STATUS from media where VOLUME_NAME='FILLING' Keith M Williams/Dubuque/IBM Unix System Administrator, IBM Dubuque ITDelivery, Global Technology Services kwill...@us.ibm.com From: Timothy Hughes timothy.hug...@oit.state.nj.us To: ADSM-L@vm.marist.edu Date: 11/15/2010 07:40 AM Subject: select statement to display readonly and filling tapes Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi I am trying to add filling tapes to this select statement and I am having no luck does anyone have a select statement that shows this? I already have most of the statement below i just need to add filling to the statement select VOLUME_NAME,ACCESS from volumes where access ='READONLY' thanks for any help
Re: bu single dir
You definitely do not want to use different options files with different include/exclude lists. EXCLUDE and EXCLUDE.DIR are not intended to exclude files sometimes but not always. Rather, they are intended for the case where you do not need backups for the files at all. One better approach is to bind these files to a management class with a nonzero FREQUENCY value (and probably higher than '1', make it something like '7'), then schedule a separate SELECTIVE backup for the directory in question. This way, if the files are backed up daily by the SELECTIVE, the FREQUENCY setting will prevent them from being backed up during INCREMENTAL processing. Best regards, 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 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 2010-11-14 04:25:47: From: Chris Lenssens chris.lenss...@sezz.be To: ADSM-L@vm.marist.edu Date: 2010-11-14 04:26 Subject: bu single dir Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi, I'm not the TSM expert so I need some advice: The daily schedule at 20:00 backups the 2 partitions of my W2003-server except - so exlude.dir in dsm.opt - D:\XYZ; so far so good. That single directory D:\XYZ (also content and subdirectories) must be backup at 23:45 (than I can shutdown the database during 20 minutes). I was thinking about a new schedule with a new opt-file but what should I specify in that new tsm-file? Any - other - ideas/suggestions? Thanks in advance. Chris
Re: select statement to display readonly and filling tapes
Perhaps this would also work: Select VOLUME_NAME from VOLUMES where status='FILLING' and access='READONLY' El nov 15, 2010 11:30 a.m., Keith M Williams kwill...@us.ibm.com escribió: How about this for TSM: select VOLUME_NAME,ACCESS from volumes where access ='READONLY', STATUS from media where VOLUME_NAME='FILLING' Keith M Williams/Dubuque/IBM Unix System Administrator, IBM Dubuque ITDelivery, Global Technology Services kwill...@us.ibm.com From: Timothy Hughes timothy.hug...@oit.state.nj.us To: ADSM-L@vm.marist.edu Date: 11/15/2010 07:40 AM Subject: select statement to display readonly and filling tapes Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi I am trying to add filling tapes to this select statement and I am having no luck does anyo...
how many parallel server-to-server sessions can be?
hello, how many parallel server-to-server sessions can be opened, if you start a backup stgpool ... process between source and target tsm server? and if, where are they defined? with best regards stefan savoric
Re: De-dup ratio's
Hi David, I am doing dedup with v6, no appliance involved. On a server for windows systems, I am getting 3 to 1 savings. The 'q stg f=d' command shows the savings - Duplicate Data Not Stored: 77,638 G (67%) I exclude pst files and any other file larger than 1 GB from dedup. On another server for linux, solaris, mac clients, the savings are - Duplicate Data Not Stored: 26,558 G (58%) I also exclude 1 GB files and the oracle/rman backups. Thanks, Bill Colwell Draper Lab -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Druckenmiller, David Sent: Friday, November 12, 2010 11:24 AM To: ADSM-L@VM.MARIST.EDU Subject: De-dup ratio's I'm curious what others are seeing for de-dup ratios for various methods. We're using IBM's ProtecTier for our TSM (5.5) primary pools and only see about a 4 to 1 ratio. This is less than half of what IBM was projecting for us. We have roughly 400 clients (mostly Windows servers) totalling about 135TB of data. Biggest individual uses are Exchange and SQL Dumps. Just wondering what others might be getting for other appliances or with TSM v6? Thanks Dave - CONFIDENTIALITY NOTICE: This email and any attachments may contain confidential information that is protected by law and is for the sole use of the individuals or entities to which it is addressed. If you are not the intended recipient, please notify the sender by replying to this email and destroying all copies of the communication and attachments. Further use, disclosure, copying, distribution of, or reliance upon the contents of this email and attachments is strictly prohibited. To contact Albany Medical Center, or for a copy of our privacy practices, please visit us on the Internet at www.amc.edu.
Re: select statement to display readonly and filling tapes
-Timothy Hughes wrote: - I tried that command failed, and also I want to select the readonly tapes that say filling also. So I replaced the or with and. this command failed also tsm: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' ANR0162W Supplemental database diagnostic information: -1:42601:-104 ([IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token END-OF-STATEMENT was found following cess = 'READONLY' or. Expected tokens may include: boolean_term. SQLSTATE=42601 ). ANR0516E SQL processing for statement select VOLUME_NAME , ACCESS from volumes where access = 'READONLY' or failed. ANS8001I Return code 3. tsm: status='FILLING' ANS8001I Return code 3. The error messages suggest that you tried to split a command into two lines without using the appropriate continuation character at the end of the first line (a hyphen for a TSM macro or an interactive dsmadmc session, a backslash for the more commonly used Unix shells, or a caret for the Windows command line environment).
Re: how many parallel server-to-server sessions can be?
From 1-999. It is detailed in the help documentation for backup stgpool. I strongly suggest that you give this careful consideration because as you can use up to 999 processes, it may be limited by the resources you have, such as number of tape drives, other processes that may be running at the same time, etc. The options is MAXPRocess=### For example: Backup stgpool primary_pool_name copy_pool_name maxprocess=4 ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of TSM Sent: Monday, November 15, 2010 10:03 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] how many parallel server-to-server sessions can be? hello, how many parallel server-to-server sessions can be opened, if you start a backup stgpool ... process between source and target tsm server? and if, where are they defined? with best regards stefan savoric
Re: Cost of moving to collocation by filespace
-Bill Evans wrote: - Some things I can figure out, like it will require 30+ minimum scratch tapes per night (typically we run with 5). And each collation group will have its own 'filling' tape. Other than the extra library slots, are there any other things I haven't thought of that will increase my h/w costs or administration time? If you are planning for collocation by filespace for a copy storage pool with volumes shipped to an offsite vault, your are correct about the 30+ scratch tapes per night. In addition, I think your offsite reclamation processing will end up moving far more data, settling for a much lower average tape occupancy, or some compromise between the two. If you are only planning for collocation of a primary storage pool that stays in the tape library, I don't think you will need 30+ scratch tapes per night. When the configuration change is first made there will be an initial surge in demand for scratch tapes in order to provide each collocation group with its own filling volume. After that I would expect, on average, five collocation groups to need scratch tapes each night. The variability in the consumption of scratch tapes will be greater than it is now. The storage pool might, for example, need seven scratch tapes one night and three the next night, rather than five each night.
Re: select statement to display readonly and filling tapes
Heey Timothy Seems you accidently copied 2 lines, in stead of the command in 1 line. status='FILLING' has been processed as an other command, so both lines gave errors. Try again the same command, but be sure it's in 1 line. Or use a - at the end of each line to continue, but best is to just use 1 line. Regards, Maurice 2010/11/15 Timothy Hughes timothy.hug...@oit.state.nj.us: thanks steve! I tried that command failed, and also I want to select the readonly tapes that say filling also. So I replaced the or with and. this command failed also tsm: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' ANR0162W Supplemental database diagnostic information: -1:42601:-104 ([IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token END-OF-STATEMENT was found following cess = 'READONLY' or. Expected tokens may include: boolean_term. SQLSTATE=42601 ). ANR0516E SQL processing for statement select VOLUME_NAME , ACCESS from volumes where access = 'READONLY' or failed. ANS8001I Return code 3. tsm: status='FILLING' ANS8001I Return code 3. tsm: TSMCORE tsm: TSMCORE On 11/15/2010 8:48 AM, Steven Langdale wrote: How about: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' Steven Timothy Hughestimothy.hug...@oit.state.nj.us Sent by: ADSM: Dist Stor ManagerADSM-L@VM.MARIST.EDU 15/11/2010 13:39 Please respond to ADSM: Dist Stor ManagerADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] select statement to display readonly and filling tapes Caterpillar: Confidential Green Retain Until: 15/12/2010 Hi I am trying to add filling tapes to this select statement and I am having no luck does anyone have a select statement that shows this? I already have most of the statement below i just need to add filling to the statement select VOLUME_NAME,ACCESS from volumes where access ='READONLY' thanks for any help
Re: how many parallel server-to-server sessions can be?
the MAXNUMMP value on the server-type node name on the target server will also need to be adjusted Regards, Shawn Shawn Drew Internet rickadam...@winn-dixie.com Sent by: ADSM-L@VM.MARIST.EDU 11/15/2010 11:07 AM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject Re: [ADSM-L] how many parallel server-to-server sessions can be? From 1-999. It is detailed in the help documentation for backup stgpool. I strongly suggest that you give this careful consideration because as you can use up to 999 processes, it may be limited by the resources you have, such as number of tape drives, other processes that may be running at the same time, etc. The options is MAXPRocess=### For example: Backup stgpool primary_pool_name copy_pool_name maxprocess=4 ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of TSM Sent: Monday, November 15, 2010 10:03 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] how many parallel server-to-server sessions can be? hello, how many parallel server-to-server sessions can be opened, if you start a backup stgpool ... process between source and target tsm server? and if, where are they defined? with best regards stefan savoric This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc.
Using TSM to restore a mailbox
We are in the process of transitioning from Exchange 2000 to Exchange 2007. Our TSM server is at 5.5.4.1 (we are going to 6.x within 6 months or so). We are currently doing legacy backups using the 5.x TDP for Exchange. We plan to start out doing legacy backups with the 6.x TDP on the new server and then switch over to VSS once we get the 6.x TSM server up and running. Currently if a user accidently deletes something from their mailbox we use a product called Exchange Recovery Manager from a company called Quest. I do a TSM restore of an older Exchange backup into the Quest recovery manager and I can then bring back whatever the user lost. We have never used the Quest product as a part of our DR plan, we only use it for accident prone users. At this point we are just learning about all the new features in Exchange 2007 and one of the items we are looking at is the Recovery Storage Group within Exchange 2007. It appears that we can use that group to do essentially the same thing as the Quest product for our accident prone users. It looks like we can do a restore from backup into the Recovery Storage Group and then restore mailboxes and or emails. Are we going down the right road or our we completely off base here? Thanks David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: Using TSM to restore a mailbox
David, Please give these two links a read. I believe you'll find them very instructive. Cmd line http://technet.microsoft.com/en-us/library/aa997694(EXCHG.80).aspx Gui http://www.petri.co.il/using_rsg_in_exchange_2007.htm Ray -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tyree, David Sent: Monday, November 15, 2010 4:35 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Using TSM to restore a mailbox We are in the process of transitioning from Exchange 2000 to Exchange 2007. Our TSM server is at 5.5.4.1 (we are going to 6.x within 6 months or so). We are currently doing legacy backups using the 5.x TDP for Exchange. We plan to start out doing legacy backups with the 6.x TDP on the new server and then switch over to VSS once we get the 6.x TSM server up and running. Currently if a user accidently deletes something from their mailbox we use a product called Exchange Recovery Manager from a company called Quest. I do a TSM restore of an older Exchange backup into the Quest recovery manager and I can then bring back whatever the user lost. We have never used the Quest product as a part of our DR plan, we only use it for accident prone users. At this point we are just learning about all the new features in Exchange 2007 and one of the items we are looking at is the Recovery Storage Group within Exchange 2007. It appears that we can use that group to do essentially the same thing as the Quest product for our accident prone users. It looks like we can do a restore from backup into the Recovery Storage Group and then restore mailboxes and or emails. Are we going down the right road or our we completely off base here? Thanks David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message.
Re: Using TSM to restore a mailbox
Hi David, Also, keep in mind that Data Protection for Exchange added Individual Mailbox Restore (IMR) and individual item-level in Data Protection for Exchange 6.1. It accomplishes this through use of the Recovery Storage Group on Exchange Server 2007. It automates the entire process for you. You can see more details in the Data Protection for Exchange Server Installation and User’s Guide: http://www.ibm.com/support/docview.wss?uid=swg27018572 If you still prefer Quest Recovery Manager, you can perform a Data Protection for Exchange RESTOREFILES command to restore your legacy backup (.EDB and .LOG files) to an alternate directory and then use Quest Recovery Manager to extract the items you want. Thanks, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/15/2010 04:34:33 PM: From: Tyree, David david.ty...@sgmc.org To: ADSM-L@vm.marist.edu Date: 11/15/2010 04:41 PM Subject: Using TSM to restore a mailbox Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu We are in the process of transitioning from Exchange 2000 to Exchange 2007. Our TSM server is at 5.5.4.1 (we are going to 6.x within 6 months or so). We are currently doing legacy backups using the 5.x TDP for Exchange. We plan to start out doing legacy backups with the 6.x TDP on the new server and then switch over to VSS once we get the 6.x TSM server up and running. Currently if a user accidently deletes something from their mailbox we use a product called Exchange Recovery Manager from a company called Quest. I do a TSM restore of an older Exchange backup into the Quest recovery manager and I can then bring back whatever the user lost. We have never used the Quest product as a part of our DR plan, we only use it for accident prone users. At this point we are just learning about all the new features in Exchange 2007 and one of the items we are looking at is the Recovery Storage Group within Exchange 2007. It appears that we can use that group to do essentially the same thing as the Quest product for our accident prone users. It looks like we can do a restore from backup into the Recovery Storage Group and then restore mailboxes and or emails. Are we going down the right road or our we completely off base here? Thanks David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.