Re: Select and SQL literal token - 'S', 2:nd try...
The list also returned my message (it said something about sending the same message twice) but apparently both our messages appeared on the list anyway. Regards, Alexander -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Henrik Wahlstedt Sent: zondag 11 juni 2006 20:35 To: ADSM-L@VM.MARIST.EDU Subject: Select and SQL literal token - 'S', 2:nd try... Hi, ADSM-L returned my message even tough Alexander have answered it... And it isnt on the web so I resend it if some of you have any clue. //Henrik -Original Message- From: Henrik Wahlstedt Sent: 9. juni 2006 10:52 To: ADSM: Dist Stor Manager Subject: Select and SQL literal token - 'S' Hi, If I use this select which I thought was OK before I tested it... tsm:select s.schedule_name, s.STARTTIME, a.node_name from CLIENT_SCHEDULES s, ASSOCIATIONS a where s.schedule_name=a.schedule_name ANR2906E Unexpected SQL literal token - 'S'. | ...V... ode_name from CLIENT_SCHEDULES s, ASSOCIATIONS a where s.schedu ANS8001I Return code 3. Instead of using S i use SS, and it works.. select ss.schedule_name, ss.STARTTIME, a.node_name from CLIENT_SCHEDULES ss, ASSOCIATIONS a where ss.schedule_name=a.schedule_name What magic lies behind SQL literal token - 'S'. Are there more tokens that I should be aware of? Etc? Thanks Henrik --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: TDP for SQL on Win 2003 64-bit
Chip, Since Data Protection for SQL is a separately priced product that includes a license file, new packages that contain license files are only posted to the Passport Advantage download site and not the general FTP site. Interim fix and PTF packages will be posted to the general FTP site when needed. The Data Protection for SQL x64 package is brand new and therefore only appears on the Passport Advantage download site at this time. You can download it there and obtain the Windows x64 version. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 06/09/2006 05:14:50 PM: Well, I think I found my answer. We don't have the latest and greatest in-house yet, and I didn't see it available for download either. Here is a recent quote from Del Hoobler... Data Protection for SQL - Windows x64 Package is now available. For those of you that have asked about the Windows x64 version of Data Protection for SQL... it is now available. This package has been tested on AMD64 and EM64T hardware. You can obtain the package through Passport Advantage. The package name is: IBM Tivoli Storage Manager for Databases V5.3.3(Data Protection for Microsoft SQL), Windows, Multiplatform (C913CML) 08-May-2006. We'll just refresh our software through Passport and scrape the SQL from flat file in the meantime, I guess. :) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Schaub, Steve Sent: Friday, June 09, 2006 2:42 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for SQL on Win 2003 64-bit Sounds to me like you got the IA64 instead of the x64 version. Also, if you have any sql2000 instances loaded, you will need to run a ms patch for vss - talk to your ms support people. Steve Schaub Systems Engineer, WNI BlueCross BlueShield of Tennessee 423-752-6574 (desk) 423-785-7347 (cell) ***public*** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bell, Charles (Chip) Sent: Friday, June 09, 2006 2:16 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP for SQL on Win 2003 64-bit Trying to install TDP for SQL on a Windows 2003 64-bit client, running MS SQL 8.0. Getting message saying This installation package is not supported by this processor type. Contact your product vendor when attempting to install the 64 bit SQL agent. Getting The operating system is not adequate for running IBM Tivoli Storage Manager for Databases - MS SQL when attempting to install the 32 bit SQL agent. What's the deal? Is this environment not supported yet? Also, someone just loaded SQL 2005 on one of our client machines. What do I do there? God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional (ITSM 5.2) Baptist Health System Birmingham, AL - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information. Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: TSM - Can't define drives to library for copy storage pool.
Well, I've made a lot of progress on this. Seems that resolving the myriad of tape drives in /dev/IBMTape# to the output produced by cat /proc/scsi/scsi is mostly by guess and by gosh. I managed to get the right ones and the copy storage pool completed. Yay! Now, I fear that it may only be temporary. Apparently the support for stuff on Linux is not at the level I am used to for i5/os. TSM had me open a problem with hardware. They helped me out but then sent me this email that basically says that if I bounce the linux servers the driver names may change. I really don't want to reconfigure TSM every time I bounce the server. So, how do I set up this persistent binding? snip Rob as we discussed, this problem looks like a persistent Binding issue. What Persistent Binding does is assign a specific SCSI id to each individual WWN. If the Host server is power down or crashes for any reason, the adapter will hold the SCSI bindings. when the server is powered up again and all WWN devices are visible the adapter will assign the specific id to the WWN requiring it. This is good for the backup application because they store the type/serial and SCSI id. They compare the stored data with the devices that are registered to the server. If the data does not match what is stored then the backup program will have a communication problem with the devices it is looking for. I am not sure how you would set the adapters PB function on Linux. You can search IBM's knowledge base on the web for the 5704 adapter or contact IBM Software Support to find out how to set adapter functions in Linux OS. Thanks For Calling IBM Service. /snip Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com
TSM on Linux hosted on i5 outperforms TSM running on i5/os PASE.
We were running TSM 5.2.4 on i5/OS PASE. Since IBM dropped support for i5/OS PASE for TSM we migrated to a Linux lpar hosted on the same box. Running a newer version of TSM. Basically we carved out a Linux lpar out of the existing i5/os lpar and used the same exact hardware: 5704 card to IBM 2109-F16 SAN switch to IBM 3582-L23 tape drive. The time it takes to fill up a 3582 cartridge dropped from 6 hours to 3. Just goes to show you that the PASE API's for tape suck. And IBM freely admits this. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com
Trace on client
Hello everyone, We were trying to run a trace on a solaris client in order to determine where most of the time is being spent during an archive process. What is the best trace that can be run in order to determine this information? It is going against a TSM AIX 5.3 server at level 5.2.7.1. Thanks! Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED]
Re: Quantum DX30 virtual tape library - cartridge sizing
I did professional services for that library, the best practices I found that worked were 32 200GB tapes. Never had any problems at that level. Hope that helps. jeremy -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thorneycroft, Doug Sent: Monday, June 12, 2006 3:49 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Quantum DX30 virtual tape library - cartridge sizing I just had a Quantum DX30 VTL installed last week. the configured available storage is 5.11 TB. the installer set the cartridge size to 35 GB. which gave me 136 35 GB dlt carts for a total of 4.65 TB. meaning that almost 500GB of disk space is unused. Quantum support suggest using a larger cartridge size, but didn't give any suggestions for what would be optimal. Is anyone else using a DX30 (16X400 GB drives)? If so, what cartridge size are you using, and how many carts did the system give you? Doug Thorneycroft Systems Analyst County Sanitation Districts of Los Angeles County 1955 Workman Mill Road Whittier, CA 90601 Tel: (562)699-7411, Ext. 1058 Fax:(562)695-6756 www.lacsd.org
tsm command to archive client data that is older than 60 days
hi Presently I have schedule task that runs monthly which archives\deletes a particular directory of a netware server. example: des=corpact_4th_quarter -verbose -archmc=10yarchive -subdir=yes -deletefiles SHARE4:470FINAN/Archives/ Now I need to archive\delete a specific directory from a netware client server only if the data in the path is older that 60 days. Does any know a date parm I could code on the command line ? I'm using tsm server 5.3 tsm client 5.1.6 netware 6 sp5 tsafs.nlm (version 6.51) thanks, Gary
TSM on Linux hosted on i5 outperforms TSM running on i5/os PASE.
We were running TSM 5.2.4 on i5/OS PASE. Since IBM dropped support for i5/OS PASE for TSM we migrated to a Linux lpar hosted on the same box. Running a newer version of TSM. Basically we carved out a Linux lpar out of the existing i5/os lpar and used the same exact hardware: 5704 card to IBM 2109-F16 SAN switch to IBM 3582-L23 tape drive. The time it takes to fill up a 3582 cartridge dropped from 6 hours to 3. Just goes to show you that the PASE API's for tape are abominable. And IBM freely admits this. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com
Re: tsm command to archive client data that is older than 60 days
This question comes up every so often. No, there are no command line parms to do what you want. You would need to use an external tool to determine which files you want to archive, then archive the specific files (or use the external tool to build a file list that can be processed via the -filelist option). Before you take this on, have a look at APAR IC49009, because it might possibly affect you. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 06/12/2006 01:07:06 PM: hi Presently I have schedule task that runs monthly which archives\deletes a particular directory of a netware server. example: des=corpact_4th_quarter -verbose -archmc=10yarchive - subdir=yes -deletefiles SHARE4:470FINAN/Archives/ Now I need to archive\delete a specific directory from a netware client server only if the data in the path is older that 60 days. Does any know a date parm I could code on the command line ? I'm using tsm server 5.3 tsm client 5.1.6 netware 6 sp5 tsafs.nlm (version 6.51) thanks, Gary