Re: Output manipulation on selects

2009-03-26 Thread BEYERS Kurt
Ullrich, When you have an sql statement that either contains single or double quotes, it is better to save it first into a file (eg /tmp/sql.scr). And define afterwards a script in TSM that uses the file as input: Tsm: TSMSERVER def scr sql_statement file=/tmp/sql.scr Than you can execute it

Re: What are you using TSM and ????

2009-03-26 Thread Remco Post
On 25 mrt 2009, at 18:34, Gill, Geoffrey L. wrote: About 4 years ago some people here decided to bring in Netbackup. No good reason at the time but everyone involved is making it sound as if TSM was the problem. In a meeting we had yesterday to discuss moving everything to TSM they are now

Antwort: Re: [ADSM-L] Output manipulation on selects

2009-03-26 Thread Ullrich Mänz
Hi Kurt, many thanks for that hint. Previously we are executing the selects from a macro file (foregroud processing was for demo only). Moving the macro into a TSM server script gives the results we were looking for. It works on Linunx and Windows! Best regards Ullrich Mänz BEYERS Kurt

Re: Output manipulation on selects

2009-03-26 Thread Andrew Raibeck
Try storing the command in a file, then running it as a macro. For example, put the following in a file called tsm.macro: select 'update thosts set tsm=''T'' where host_name=''' || node_name || ''';' from nodes Then run it like this: dsmadmc -id=adminid -pa=x -commadelimited -dataonly=yes

Re: VTL and Dedup ( TS7569G)

2009-03-26 Thread Hart, Charles A
Hitachi 9990x front end with FC disk for Protectier Meta Data FS and SATA Drives for Repository FS. The FC infrastructure form host to storage is 4gb. We are using the non-clustered cfg and achieving up to 500MB writes while doing 200MB reads from DB and Exchange Clients going direct to the VTL.

Re: define path problems

2009-03-26 Thread Alexander Lazarevich
Thank you Mel. Alex On Thu, 26 Mar 2009, Dennis, Melburn (IT Solutions US) wrote: ANR8466E command: Invalid update request for drive drive name in library library name. Explanation: An invalid update request has been made for the given drive. This can occur if a new device name is

Website and Call for Papers for TSM Symposium 2009

2009-03-26 Thread Claus Kalle
Please find updated CFP information about the TSM Symposium 2009 at http://tsm2009.uni-koeln.de/ It is being hosted by University of Cologne in September 2009 taking place at Grandhotel Petersberg. At this time please consider submitting a paper proposal during the next days. Thanks in

Re: What are you using TSM and ????

2009-03-26 Thread Howard Coles
See Below See Ya' Howard -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Gill, Geoffrey L. Sent: Wednesday, March 25, 2009 12:34 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] What are you using TSM and About 4 years ago some

Re: define path problems

2009-03-26 Thread Richard Sims
On Mar 26, 2009, at 12:33 PM, Alexander Lazarevich wrote: One clue is that since I replaced the drives (delete drives, update library path, define drives, define drive paths) the new drives are showing up as a new device type GENERICTAPE1: That could be a device driver issue. See IBM Technote

Re: define path problems

2009-03-26 Thread Dennis, Melburn (IT Solutions US)
It looks like you need to reinstall the drivers for the new drives. Your OS is seeing the drives, but TSM needs specific drivers for them to be associated as LTO class devices. If they are IBM drives, you can go the IBM ftp site and download the latest drivers

Re: define path problems

2009-03-26 Thread Alexander Lazarevich
Well, we have HP drives that came with the Overland Neo 4100 library. Any idea where to get the HP drivers for LTO2 drives? I've looked on HP's website and can only find the Windows drivers, not TSM. It also seems odd that these are identical drivers to the ones that were replaced, shouldn't the

Re: define path problems

2009-03-26 Thread Kelly Lipp
You use the IBM TSM driver for HP drives, not the IBM drivers or the HP drivers... Kelly Lipp CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 x7105 www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On

Re: define path problems

2009-03-26 Thread Kelly Lipp
When you put the new drives in the library, Device Manager found them. You will need to right click on each drive and update the driver to use the TSM driver. The HP driver probably bound to the drive automatically after the reboot. You must have the IBM TSM Device Driver controlling these

Re: define path problems

2009-03-26 Thread Richard Sims
On Mar 26, 2009, at 3:39 PM, Alexander Lazarevich wrote: Well, we have HP drives that came with the Overland Neo 4100 library. Any idea where to get the HP drivers for LTO2 drives? I've looked on HP's website and can only find the Windows drivers, not TSM. It also seems odd that these are