Re: Does TSM support 3-way NDMP backups?

2009-10-22 Thread Remco Post
On 22 okt 2009, at 02:01, Tribe wrote: Hi, I didn't find this in the TSM manual (I'm currently using TSM 5.5) so I was hoping to get some help here: Does TSM support 3-way NDMP backups as described here? http://www.ndmp.org/info/faq.shtml#9 I found the term 3-way in a few TSM docs, but it

Re: group by assistance.

2009-10-22 Thread Remco Post
Shawn, I think this is where you run into the limitations of the TSM SQL implementation. I can't think of a way of achieving what you want. Maybe Andy knows? On 21 okt 2009, at 23:20, Shawn Drew wrote: I'm having some trouble with the group by clause. It seems I can't group data that has

SV: [ADSM-L] group by assistance.

2009-10-22 Thread Carsten Møldrup
Hi Shawn select sum(CAST((bytes/1024/1024/1024) as decimal(8,2))) AS GB, cast(end_time as date) as Date from summary where activity='STGPOOL BACKUP' group by cast(end_time as date) ..would work Regards Carsten Moldrup -Oprindelig meddelelse- Fra: ADSM: Dist Stor Manager

websphere backup

2009-10-22 Thread Mehdi Salehi
*What is the current IBM solution for Websphere application server backup into TSM? *There used to be a software called *Storage Manager for Application Servers . I cannot find it in the following link: http://www-01.ibm.com/software/tivoli/products/storage-mgr/product-links.html Thanks, Mehdi *

Re: SV: [ADSM-L] group by assistance.

2009-10-22 Thread Shawn Drew
That didn't work for me. What version of TSM do you have? Regards, Shawn Shawn Drew Internet c...@cmoldrup.dk Sent by: ADSM-L@VM.MARIST.EDU 10/22/2009 03:01 AM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject [ADSM-L] SV:

Re: Does TSM support 3-way NDMP backups?

2009-10-22 Thread Shawn Drew
The way TSM does this is in the TSM 5.4 and 5.5 Technical Guide under the section 10.1.2 Filer-to-server They use the NDMPv2 3-way spec to perform this task, which is why they are calling it 3-way. The difference is that the library manager is acting as the destination data mover. It doesn't

Re: Does TSM support 3-way NDMP backups?

2009-10-22 Thread Strand, Neil B.
Shawn, You can set up NDMP backup destination to a TSM server via ethernet which is nice in that the data can be put in a regular storage pool and an offsite copy created. You can also set the NDMP backup destination to a tape drive(s) physically attached to a filer. I suspect that you may

Re: Does TSM support 3-way NDMP backups?

2009-10-22 Thread Shawn Drew
Right, which is what the section in the Technical Guide describes. But you can NOT backup a volume from one NAS to a tape drive connected to a second NAS. Which is what the 3-way spec describes Regards, Shawn Shawn Drew Internet

Ms windows cluster and tsm questions

2009-10-22 Thread Lee, Gary D.
Looking for experiences, dos, don'ts, etc. for using tsm to back up a ms windows cluster. I've read the sections in the v6.1 client manual, but know little or nothing about microsoft clustering. This is strictly a standard BA client setup, sql or exchange clients not involved. I've been

Re: SV: [ADSM-L] group by assistance.

2009-10-22 Thread Shawn Drew
FYI, My colleague showed me how to do this in perl, so in case any one is interested: dsmadmc -id=USER -pa=PASS -datao=yes select cast((bytes/1024/1024/1024) as decimal(8,2)), cast(end_time as date) from summary where activity='STGPOOL BACKUP' | perl -e ' while (){ chomp; s/ +/ /sg;

SV: [ADSM-L] Ms windows cluster and tsm questions

2009-10-22 Thread Anders Räntilä
Check out the Redbook IBM Tivoli Storage Manager in a Clustered Environment http://www.redbooks.ibm.com/abstracts/sg246679.html?Open /Anders Räntilä -Ursprungligt meddelande- Från: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] För Lee, Gary D. Skickat: den 22 oktober 2009 19:37

Re: Ms windows cluster and tsm questions

2009-10-22 Thread Grigori Solonovitch
Hello Gary, You can use TSM backups for the both active/passive and active Windows clusters. We are using a few Windows 2003 clusters. In general, you need: 1) configure sepatate TSM nodes for each server in cluster to backup not-clustered drives (usually C: and, sometimes, D:) with original

SV: [ADSM-L] SV: [ADSM-L] group by assistance.

2009-10-22 Thread Carsten Møldrup
Hi Shawn I am on 6.1 client/server. However it also worked with version 5's. Check the 2 queries below... Regards Carsten Moldrup tsm: TEST1_SERVER1select sum(CAST((bytes/1024/1024/1024) as decimal(8,2))) AS GB, cast(end_time as date) as Date from summary where activity='BACKUP' grou p by

Re: SV: [ADSM-L] SV: [ADSM-L] group by assistance.

2009-10-22 Thread Shawn Drew
That's odd. I put in the same command on my 5.5.3 server: tsm: TSM21select sum(CAST((bytes/1024/1024/1024) as decimal(8,2))) AS GB, cast(end_time as date) as Date from summary where activity='BACKUP' group by cast(end_time as date) ANR2904E Unexpected SQL key word token - 'CAST'.

Re: Ms windows cluster and tsm questions

2009-10-22 Thread Tchuise, Bertaut
Gary, The way we backup MS clusters in our environment is very similar to Grigori's procedure. Every node in the cluster backs up its own local resources under its own TSM Central Scheduler; for the sake of organization, you could create a separate node under the Cluster Manager name to backup

Re: Does TSM support 3-way NDMP backups?

2009-10-22 Thread Strand, Neil B.
I think there may be a lack of clarity with the reference to the link that Tribe provided. Does TSM support 3-way NDMP backups as described here? http://www.ndmp.org/info/faq.shtml#9 As I understand it, the TSM server is the NDMP client, the filer is the NDMP DATA server which then directs

Re: VCB fullvm Proxy Server - opinions?

2009-10-22 Thread Wanda Prather
Steve, Thanks for your reply. I can believe the Storserver agent would be a big help; trying to set up a schedule for 252 clients with the basic TSM function makes my head hurt! Am I correct that the limiting factor in the fullvm backups is the Ethernet interface between ESX and the Proxy

Performance and migration: AIX vs Linux

2009-10-22 Thread Dury, John C.
We are currently running TSM server v5530 under AIX. The AIX server has a mixture of different speed (266mhz and 133mhz, both 64bit) PCI-X slots. With 4 4g HBAs. Our system is connected to a Clariion CX3-80 where the TSM DB and Recovery Log and Disk Storage pools live. The disk parts of TSM

Re: Performance and migration: AIX vs Linux

2009-10-22 Thread Xav Paice
- John C. Dury jd...@duqlight.com wrote: 1.How hard is it to move from an AIX TSM server box to a Linux TSM server? I'm hoping it's as easy as building the new box (tape drive,stg pool etc) and then restoring the DB and tweaking the new config. I know there is more to it than

SV: SV: [ADSM-L] SV: [ADSM-L] group by assistance.

2009-10-22 Thread Christian Svensson
Hi Shown, To help you verify that command. I have a couple of TSM servers with diffrent Server Level on them and I got the same problem as you on TSM Server 5.5 but on TSM Server 6.1.2 does his command work perfekt. tsm: TSMDEMO55select sum(CAST((bytes/1024/1024/1024) as decimal(8,2))) AS GB,