SV: Snapmirror to tape

Hi Sam, Is TCP Port 1-6 open both ways from NetApp to TSM? Just to inform you. You should set in TSM to only use minimal TCP Ports for NDMP. Minimum is 100 TCP Ports. Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Skype: cristie.christian.sve

Query for inactive data summary

Good morning, We have a lot of old inactive folders that I would like to delete but I need to gather some information to present to my customer before I can do this. I am looking for a query that will summarize the data, just the inactive folder name and amount of data in it. I can do the ds

Re: Query for inactive data summary

Debbie, I think the new storage reports on our ART product will help you: http:downloads.tsmworks.com/ARTProductDemo.ppt, slides 27-29. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Mar 26, 2010 at 10:26 AM, Haberstroh, Debbie (IT) < habe...@vo

Re: Query for inactive data summary

Sorry, meant that for Debbie, not the list. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Mar 26, 2010 at 10:35 AM, Lindsay Morris wrote: > Debbie, I think the new storage reports on our ART product will help you: > http:downloads.tsmworks.com

Re: Query for inactive data summary

Just ignore Lindsay, he doesn't even know the correct syntax for an URL :) select node_name,filespace_name,capacity,pct_util from filespaces where backup_start Debbie, I think the new storage reports on our ART product will help you: > http:downloads.tsmworks.com/ARTProductDemo.ppt, slides 27-29.

Re: Snapmirror to tape

Sam, If you are backing up a CIFs share, I would encourage you to investigate the "-snapdiff" option run from a windows server. This will create a snapshot of the volume on the filer and then you only backup the snapshot (or what has changed since the last snapshot) - like an incremental backup

Re: Query for inactive data summary

Thanks, I can get the occupancy for the filespaces; I am trying to get an actual list of inactive directory folders from the client and how much data they contain. I am currently using this query from the client: dsmc q backup -subdir=yes -inactive "\\location\foldername\*.*" > c:\output.txt T

Re: TSM 6.2.0.0 Linux client crash

I asked my sole Linux 6.2 client (who is having the crash) to confirm if his /etc/issue is > 127 bytes and if this could be his crash cause. He said: It is likely, as I usually add additional information to the /etc/issue file and its 607 bytes. I will test at my next opportunity. That is a very

Re: Query for inactive data summary

On Mar 26, 2010, at 11:49 AM, Haberstroh, Debbie (IT) wrote: > Thanks, I can get the occupancy for the filespaces; I am trying to get > an actual list of inactive directory folders from the client and how > much data they contain. > > I am currently using this query from the client: > > dsmc q

Re: Query for inactive data summary

Thanks Richard, I'll just keep going with this. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Sims Sent: Friday, March 26, 2010 11:04 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Query for inactive data summary On Mar 26, 2010, at

query node vs select * from nodes

Hi TSMers, If i do: q event * *  begind=today-1 i get a lot of output for events that happened yesterday. If i issue: select * from events where days(current_timestamp)-days(scheduled_start)>1 i get no results. Can someone explain the difference? What does q event do other than selecting inform

Re: query node vs select * from nodes

Fraustratingly, you'll need to use an absolute date (rather than relative date as below) when selecting from the events table. /David Mc --Original Message-- From: Guenther Bergmann Sender: ADSM: Dist Stor Manager To: ADSM-L@VM.MARIST.EDU ReplyTo: ADSM: Dist Stor Manager Subject: [ADSM-

Re: query node vs select * from nodes

The Events table is an odd duck (remember that SQL is a meta layer on top of a B-tree db in TSMv4,5) where performing a function on its timestamps will cause your quandry. Instead, try a construct like: select * from events where scheduled_start <= (current_timestamp-12 hours) Richard Sim

TSM Exclude/Expiration

Good Afternoon. We have a TSM AIX server running TSM 5.4 and a Windows 2008 running TSM client 5.5 We currently have 53 million files on a single partition and plan to break it up into 3 partitions to help with backup times, etc.. The plan was to move about 1/3 of the data to the other partition,

Re: TSM Exclude/Expiration

On Mar 26, 2010, at 2:05 PM, Jones, Eric J wrote: > Good Afternoon. > We have a TSM AIX server running TSM 5.4 and a Windows 2008 running TSM > client 5.5 > We currently have 53 million files on a single partition and plan to break it > up into 3 partitions to help with backup times, etc.. > The

Re: query node vs select * from nodes

I think problem is not in query format: "select * from events" only information for current day. In addition, most possible "q events" takes data from table SUMMARY, not from EVENTS. By the way, I am not sure I am right. From: ADSM: Dist Stor Manager [ad