select question on backups table

2013-05-07 Thread Lee, Gary
Tsm server 5.5.4. Windows client 6.3.0 Will the following select show me all backups at and below the designated subdirectory? select * from backups where node_name='CASTSTORAGE' AND - upper(hl_NAME) like '\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY' If not, where have I gone wrong?

Re: Exchange 2010 Backup issue

2013-05-07 Thread Swartz, Jerome
Hi Del, The Backups are working fine but the Exchange guys have come back and said the service account I use has too much authority within Exchange. How do i define what the minimum level of access I require within Exchange? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-

Re: Exchange 2010 Backup issue

2013-05-07 Thread Del Hoobler
Jerome, As documented in the Data Protection for Exchange User's Guide: Security requirements for Data Protection for Exchange backup and restore tasks on Exchange Server 2010 To perform backup and restore tasks on Exchange Server 2010, Data Protection for Exchange must be operating in an acco

Re: Exchange 2010 Backup issue

2013-05-07 Thread Jeanne Bruno
We gave our TSM Exchange Service 'domain administrator' rights. And it works with the TSM schedules. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: Tuesday, May 07, 2013 9:29 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L

Re: select question on backups table

2013-05-07 Thread Prather, Wanda
To get other subdirectories, you'll need to add the wildcard designator % (without a wildcard, "like" is the same as "=") upper(hl_NAME) like '%\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY%' -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of

Re: select question on backups table

2013-05-07 Thread Thomas Denier
-Gary Lee wrote: - >Tsm server 5.5.4. > >Windows client 6.3.0 >Will the following select show me all backups at and below the >designated subdirectory? > >select * from backups where node_name='CASTSTORAGE' AND - >upper(hl_NAME) like '\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE >STUDY' > >I

Fw: select question on backups table

2013-05-07 Thread Andrew Raibeck
One more thing... My examples assume that the HL_NAME is complete, i.e., it is in the root of the file system. If \BIOMECHANICS is NOT in the root of the file system, then you will need to use 'like' in both cases I described earlier, and prefix the HL_NAME with a '%', like this: To see all objec

Re: select question on backups table

2013-05-07 Thread Andrew Raibeck
Hi Gary, If this is a Windows client, you do not need to upper-case the HL_NAME as long as the actual pattern you specify is in upper case. This is because file system backups on Windows are always stored in upper case. The HL_NAME specification should have a terminating backslash. If you want t

Re: select question on backups table

2013-05-07 Thread Andrew Raibeck
> upper(hl_NAME) like '%\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY%' This is pretty close to what I also responded with. However, it will pick up entries not only in '..\FATIGUE STUDY', but also in '..\FATIGUE STUDY - PRELIMINARY' or '..\FATIGUE STUDY2', which might not be desirable. This i

ANR0429W message

2013-05-07 Thread Robert Ouzen
Hi to all I notice for this warning on the actlog about a node EXCHSRVA 05/07/2013 17:26:29 ANR0429W (Session: 54758, Origin: EXCHSRVAN_SA) Session 9887 for node EXCHSRVA (WinNT) refused - maximum server sessions (4) exceeded. (SESSION: 54758) I check the opt server tsm: ADSM2>q opt m

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Ben Bullock
That sounds like a great RFE, one I could have used a couple times in the past. How can we "vote" on this? I'm not familiar with how to do that with IBM RFEs. Thanks, Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vandeventer, Harold [BS]

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Skylar Thompson
I'd also like to vote this up. We're a research organization so we don't have litigation per se, but there are times when we need to freeze expiration for other reasons. -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-

select question in backups table

2013-05-07 Thread Lee, Gary
Thanks all. Got it working now. Forgot the % as all found.

Re: ANR0429W message

2013-05-07 Thread Andrew Carlson
Is this a scheduled session? There is another setting, maxschedsessions, that controls the percentage of the total sessions that can be scheduled sessions. If that is set really low (like 2%, seems unlikely now that I think about it), then that would be the 4 sessions. On Tue, May 7, 2013 at 9:

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Reese, Michael A (Mike) CIV USARMY 93 SIG BDE (US)
I agree this is a great RFE, and I have added my vote to it. Go to http://www.ibm.com/developerworks/rfe/?BRAND_ID=90. You will need to sign in with your IBM ID to vote. Search by RFE ID to go to the desired RFE. Open the RFE and then click "Add vote" under RFE actions. _

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Ben Bullock
Got it. Voted. Thanks -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Reese, Michael A (Mike) CIV USARMY 93 SIG BDE (US) Sent: Tuesday, May 07, 2013 11:01 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM RFE regarding Litigation Hold I agr

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Plair, Ricky
Sure could have used this in the past! Got my vote! -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ben Bullock Sent: Tuesday, May 07, 2013 1:06 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM RFE regarding Litigation Hold Got it. Voted.

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Schneider, Jim
Ditto -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Plair, Ricky Sent: Tuesday, May 07, 2013 12:52 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM RFE regarding Litigation Hold Sure could have used this in the past! Got my vote! -O

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Paul Zarnowski
We deal with a variety of types of litigation hold here, as well. What you can do now, easily, is to setup a parallel policy domain (i.e., LITHOLD) that has all the same management classes, but different retention policy (i.e., retain forever). Then, to avoid expiration you just have to do thi

Re: Back side of a standard TS3500 D23 frame

2013-05-07 Thread Zoltan Forray
Can someone who has a TS300 Service Console (TSSC) please send me the physical dimensions - e.g. the depth is what we are looking for. All documentation I find simply says 1U. We are trying to see how shallow of a rack we can get away with. On Mon, May 6, 2013 at 9:30 PM, Richard Rhodes wrote:

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Vandeventer, Harold [BS]
Great ideas Paul I'm preparing to build the alternate server without expiration approach as soon as I can scare up some resources. I'll look at the alternate Domain approach also. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul Zarn

Domain, Management Class and Copy Group Best Practices

2013-05-07 Thread Sergio O. Fuentes
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.

Re: Domain, Management Class and Copy Group Best Practices

2013-05-07 Thread Bill Smoldt
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 restri

Re: Domain, Management Class and Copy Group Best Practices

2013-05-07 Thread Skylar Thompson
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

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Richard Rhodes
Our approach has been to export/import the node to another TSM instance under a different node name with a suffix or prefix that indicated the hold. THe mgt class is set to no-expire.We stop expiration until this copy is made. This approach has lets the node be processed as usual, and the cop

Re: TSM RFE regarding Litigation Hold

2013-05-07 Thread Skylar Thompson
Unfortunately we've had expiration holds for tens of terabytes of data, so we haven't been able to use this approach. -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medic