Tapepool to copypool and copypool to tapepool

2013-11-20 Thread mik
Hi Michael, Yes it's the only, for the move data we have create a new primary pool on a hard drive with virtual band ;) we move the data like that move data AXL3 stg=ECHANGE_BANDES reconst=yes -- to have a new LTO3 scratch. After that we do mode data X:\TSM\ECHANGE_BANDE_VOLXXX

Tapepool to copypool and copypool to tapepool

2013-11-20 Thread mik
Hi Michael, Yes it's the only, for the move data we have create a new primary pool on a hard drive with virtual band Wink we move the data like that move data AXL3 stg=ECHANGE_BANDES reconst=yes -- to have a new LTO3 scratch. After that we do mode data X:\TSM\ECHANGE_BANDE_VOLXXX

Re: Tapepool to copypool and copypool to tapepool

2013-11-20 Thread Michael Roesch
Hi Mickael, I don't know if this is currently a translation issue, but if you cannot read the old tapes anywhere, then there is no way move data will succeed, as TSM is mounting those tapes and reading data from them. And even if this wouldn't be neccessary and you could change only the entries

Tapepool to copypool and copypool to tapepool

2013-11-20 Thread mik
Hi Michael, What we are doing right now and it's work we have just one drive it's work We create a storage pool name named ECHANGE_BANDE device class name : FILE_DEV2 The storage pool name is locate on a HDD and his virtual band. We move the data of the tapepool to the ECHANGE_BANDES (i actually

Re: Tapepool to copypool and copypool to tapepool

2013-11-20 Thread Michael Roesch
Hi Mickael, What we are doing right now and it's work we have just one drive it's work You mean there's still one drive available on the old server that can read the LTO3 tapes? I don't know how much data you have to move, but maybe creating a server-to-server connection and using Export Node

Tapepool to copypool and copypool to tapepool

2013-11-20 Thread mik
Hi Michael, Thanks for all you reply ^^ We just want to recreat the tapepool (on server LTO3 with one drive (RW and R)) on new copypool (on server LTO6 2drive (RW and R)) after we want to recreat the tapepool (on the server LTO6) from the coopypool (LTO6) It's possible ?

Re: Tapepool to copypool and copypool to tapepool

2013-11-20 Thread Michael Roesch
Hi Mickael, I don't think that it will work the way you are planning to do the recreation. If your desired result is to have all the data in the tapepool on the new server (and a copy in a copy pool on that new server), then I would suggest that you either user export node toserver to move the

Tapepool to copypool and copypool to tapepool

2013-11-20 Thread mik
Hi Michael, The problem we have actually it's we have no copypool the copypool actual was damaged (one drive no copy :(, ...) and if we export the actual tapepool to the new tapepool if we have an error during this process we lost all no ??

Re: Tapepool to copypool and copypool to tapepool

2013-11-20 Thread Michael Roesch
Hi Mickael, the export command is just a copy and not a move of the data, other than the move data command. With export node it copies all the node data to the new server. You can even copy all your policy domains etc. from your old server to the new one, if you desire to do so. But I guess you

Tapepool to copypool and copypool to tapepool

2013-11-20 Thread mik
Hi Michael, Thanks for you reply i speak with my boss to that issue and i come back if that not possible. Regards, Mickael. +-- |This was sent by bobpatrick808...@yahoo.fr via Backup Central. |Forward SPAM to

SQL query in v6 server

2013-11-20 Thread Loon, EJ van - SPLXM
Hi TSM-ers! We just migrated a second server to v6 and now I need to 'patch' TSM Operational Reporter. Among others, the following SQL statement no longer works: select node_name, platform_name, date(lastacc_time) from nodes where cast((current_timestamp-lastacc_time)days as decimal) =2 and

Re: SQL query in v6 server

2013-11-20 Thread Ben Bullock
I recently upgraded the server from 5.5 to 6.3.4 and am also working at changing out the failing scripts. Having to add a lot of cast statements to get the column formatting to be nicely formatted. The date arithmetic is also the one that has me the most stymied. I have used the,

Re: Re: SQL query in v6 server

2013-11-20 Thread David Bronder
I'm working on the same task as I prepare for a 5.5 to 6.3 upgrade. Here's a good starting point for updating select statements for TSM 6: https://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/index.jsp?topic=%2Fcom.ibm.itsm.srv.upgrd.doc%2Fr_srv_upgrd_cmd_select.html There's also an IBM tech note

Re: SQL query in v6 server

2013-11-20 Thread Colwell, William F.
Hi Eric, the timestampdiff function will do what you need. This works - select node_name, platform_name, date(lastacc_time) - from nodes - where cast(timestampdiff(16, current_timestamp - lastacc_time) as decimal(4,1)) 2 The first number in timestampdiff can be - 1 Fractions of a second

Re: SQL query in v6 server

2013-11-20 Thread Chavdar Cholev
Hi Eric, give me you mail and I will send you ready for use operational reporting .hml for TSM 6.x You can use also IBM Tivoli monitoring for TSM and cognos to set/schedule some reports to be sent Regards Chavdar On 11/20/2013 18:40, Colwell, William F. wrote: Hi Eric, the timestampdiff

Re: SQL query in v6 server

2013-11-20 Thread Loon, EJ van - SPLXM
Thank you all for your help, I really appreciate it! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Colwell, William F. Sent: woensdag 20 november 2013 17:40 To: ADSM-L@VM.MARIST.EDU

Win2K client 6.4.1 volume mount points enumeration error

2013-11-20 Thread Prather, Wanda
Windows client 6.4.1 on Win2K8-64 When I start a backup of any drive (via scheduler, or via incr F: from the ba cmd line) I get this error for all drives at once: ANS1996W The volume mount points enumeration on 'C:\' volume failed. Windows system error code: 5; reason: 'Access is denied.'.