SL500 installation
Hi, I´m running TSM 5.3.4.0 on w2k3 and have a STK9710 and 6 DLT7000 drives connected to TSM, (all scsi). When I connect a Sun SL500 with 4 IBM LTO3 (all FC) plug an play finds the drives but not the library. I manually update the library driver to tsmscsi.sys (driver properties in dev. manager). Reboot and define librray and path in TSM, ok. I run the latest IBM LTO3 driver IBMTape.x86_6141.zip. IBMTape updates all drivs but I cant connect to STK9710 or DLT7000 drives. When I look at c:\...\console\tsmdlst TSMscsi is stopped (or disabled). In TSM mgmt console\device information the device name have been updated for all libraries and drives from ex. mt.1.0.0.1 to \\.\1. TSM names remains the same. A reboot doesnt change the behavour. Questions. Why does IBMTape disable TSMscsi? My old HW depends on TSMscsi driver... How do I install the new drives properly? Any hints are appreciated. //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: SL500 installation
Hi, Forget the questions.. //Educated... -Original Message- From: Henrik Wahlstedt Sent: den 5 december 2006 09:09 To: 'ADSM: Dist Stor Manager' Subject: SL500 installation Hi, I´m running TSM 5.3.4.0 on w2k3 and have a STK9710 and 6 DLT7000 drives connected to TSM, (all scsi). When I connect a Sun SL500 with 4 IBM LTO3 (all FC) plug an play finds the drives but not the library. I manually update the library driver to tsmscsi.sys (driver properties in dev. manager). Reboot and define librray and path in TSM, ok. I run the latest IBM LTO3 driver IBMTape.x86_6141.zip. IBMTape updates all drivs but I cant connect to STK9710 or DLT7000 drives. When I look at c:\...\console\tsmdlst TSMscsi is stopped (or disabled). In TSM mgmt console\device information the device name have been updated for all libraries and drives from ex. mt.1.0.0.1 to \\.\1. TSM names remains the same. A reboot doesnt change the behavour. Questions. Why does IBMTape disable TSMscsi? My old HW depends on TSMscsi driver... How do I install the new drives properly? Any hints are appreciated. //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: Client node will not talk to TSM server
Paul - Don't use GUIs in debugging client - server connectivity problems: use basic commands for clarity and isolation. Don't attempt more complex scheduler starts until basic interactivity is established. The ANS2604S from the Web GUI may or may not have resulted in useful messages in your dsmwebcl.log, so check there, as well as the dsmerror.log. Check the timestamps on the /etc/adsm/TSM.PWD (or whereever a PASSWORDDIR client option may be pointing) on that Linux client for when it was last changed, and assure that the file was not deleted or damaged. The general approach is to start with baby steps, then work your way up to high-level TSM functions in isolating the problem. I would start by performing 'dsmc query session', as root on the client, and see what results on the client, and TSM server Activity Log. This may result in a password re-establishment interaction, which may cure the problem. You can then graduate to 'dsmc query backup ...', when then gets deeper into client work, to see what comes of that. If that works, then perform 'dsmc incremental ' on an individual file and see if that works. Whereas your Query Admin indicates that an ANL2 admin of type Client Owner exists, try some basic dsmadmc interactions and see what results there. Refer to the TSM Problem Determination Guide for general guidance. Richard Sims
Re: Keeping only the current version in a pool
My understanding is that this feature is coming soon, possibly as soon as TSM 5.4, which should be early in 2007. In the meantime, what you can do is: -Define your COPAN pool as a sequential tape pool -Change your management classes to point to COPAN as the target destination for backups (or if you are keeping a DISK pool as your target destination for backups, change the DISK NEXTSTGPOOL to COPAN) -In the COPAN pool set NEXTSTGPOOL to the TAPE pool -For COPAN, set your migration thresholds to something like highmig 90, lowmig 70 -For COPAN, set MIGDELAY to 7 and MIGCONTINUE to YES Now your clients will back up to COPAN (or backup to DISK which migrates to COPAN) When COPAN gets more than 90% full, it will migrate data out to tape. BUT it will only take data that is more than 7 days old, unless it has to take more to get down to the 70% threshold. That will give you the most-recently-backed up data on COPAN, which I realize is not what you asked for, but it's the best you can do right now. And ask Santa for the new feature for Christmas! Wanda Prather I/O, I/O, It's all about I/O -(me) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Eric J Sent: Monday, December 04, 2006 6:21 AM To: ADSM-L@VM.MARIST.EDU Subject: Keeping only the current version in a pool Good Morning. We are running TSM 5.2.2 server on AIX 5.2 and the clients are all running TSM 5.2.2 on Windows 2000/2003, AIX 5.1, 5.2 and Solaris 7, 8, 9 and 10. A COPAN unit was purchased for us which is basically hard drives that simulate tapes so we could get faster restores, etc.. What we would like to do is setup the COPAN as one of the pools and only keep the most recent version of the files(for fast restores), we also have our regular tape library that we keep up to 90 versions(90 days) of the file along with a COPYPOOL for our off-site storage. I have not seen a way to keep only the most recent version of a file on the COPAN unit and have everything else deleted/expired. Thanks Eric.
Re: Reply: copypools on disk on AIX?
I believe define volume can only be used on devclass of disk, not file. [EMAIL PROTECTED] 12/05/06 2:25 AM Hi all, just my two cents on file-deviceclass: I agree with Kelly that Volumes should be predfined to avoid fragmentation. In addition I would very strongly recommend running the define volume command with a wait=yes to format them sequentially. While this looks a pain, volumes will be formatted without fragmentation one would get formatting several volumes at a time. Pre-formatting volumes may take it´s time (to be percise, formatting on Sun Solaris can be very slow, while W2K3 is rather quick due to differences in the filsystem!), but you just run it once and it can be run in the background. Regards, Markus -- Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail oder von Teilen dieser Mail ist nicht gestattet. Wir haben alle verkehrsüblichen Maßnahmen unternommen, um das Risiko der Verbreitung virenbefallener Software oder E-Mails zu minimieren, dennoch raten wir Ihnen, Ihre eigenen Virenkontrollen auf alle Anhänge an dieser Nachricht durchzuführen. Wir schließen außer für den Fall von Vorsatz oder grober Fahrlässigkeit die Haftung für jeglichen Verlust oder Schäden durch virenbefallene Software oder E-Mails aus. Jede von der Bank versendete E-Mail ist sorgfältig erstellt worden, dennoch schließen wir die rechtliche Verbindlichkeit aus; sie kann nicht zu einer irgendwie gearteten Verpflichtung zu Lasten der Bank ausgelegt werden. __ This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail or of parts hereof is strictly forbidden. We have taken precautions to minimize the risk of transmitting software viruses but nevertheless advise you to carry out your own virus checks on any attachment of this message. We accept no liability for loss or damage caused by software viruses except in case of gross negligence or willful behaviour. Any e-mail messages from the Bank are sent in good faith, but shall not be binding or construed as constituting any kind of obligation on the part of the Bank. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
Migrating to new TSM server - first timer
Hello All, I am getting ready to migrate and upgrade a TSM server currently at 5.2.8 on a Red Hat server to a Suse Linux 10 server. After the migration I would like to upgrade to TSM 5.3. Does anyone have any good procedures or docs that discusses this? I would like to make sure I have everything covered and done properly. thanks, James
HELP! NAS NDMP Restore Issue
Hi Everyone, I have a TSM 5.2.7.1 server which resides on AIX 5.3. We have a Celerra at 5.5 that we backup differentially every night by utilizing the NDMP protocol. Today I tried to do a restore of the filespace: /root_vdm_4/HMCH1015_G from last night and I received the message: Filespace not found. When I did a point in time restore option, it only goes as far as 11/30/2006. In the activity log I can see the following: Date/Time Message -- 12/04/06 19:00:03 ANR0984I Process 9019 for BACKUP NAS (DIFFERENTIAL) started in the FOREGROUND at 19:00:03. (SESSION: 477606, PROCESS: 9019) 12/04/06 19:00:03 ANR1064I Differential backup of NAS node NAS_SERVER_2, file system /root_vdm_4/HMCH1015_G, started as process 9019 by administrator LIDZR8V. (SESSION: 477606, PROCESS: 9019) 12/04/06 19:00:03 ANR2753I (NAS_2-DIFFERENTIAL):ANR0984I Process 9019 for BACKUP NAS (SESSION: 477606) 12/04/06 19:00:03 ANR2753I (NAS_2-DIFFERENTIAL):process 9019 by administrat or LIDZR8V. (SESSION: 477606) 12/04/06 19:09:16 ANR0513I Process 9019 opened output volume N01008. (SESSION: 477606, PROCESS: 9019) 12/04/06 20:13:15 ANR1067I NAS Backup process 9019 completed. (SESSION: 477606, PROCESS: 9019) 12/04/06 20:13:15 ANR2753I (NAS_2-DIFFERENTIAL):ANR1067I NAS Backup process 9019 (SESSION: 477606) 12/04/06 20:13:15 ANR0988I Process 9019 for BACKUP NAS (DIFFERENTIAL) running in the FOREGROUND processed 56,186,078,204 bytes with a completion state of SUCCESS at 20:13:15. (SESSION: 477606, PROCESS: 9019) Does anyone have any idea what my issue might be here? I am at a complete loss... Any help would be appreciated. Thanks! Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED]
HP LTO3 drives
Has anyone had trouble with firmware HP Ultirum 3 drives under windows? We have two HP LTO3 960's (I believe, no-one is certain and I'm doing this all remotely) on an Adaptec ultra320 SCSI card, in a quantum M1500 library consisting of two stacks. We are currently seeing intermittent read/write errors on all drives connected to a scsi card at the same time, but only during reclamation. migration / stgpool backup go fine. I havent tested move data yet. The sense data and description seem to fit this problem for Sony AIT drives; http://www-1.ibm.com/support/docview.wss?uid=swg21207591 But on downloading firmware from HP for LTO3 drives, replacing TSM drivers with HP lto drivers so the HP Library and TapeTools can upgrade the firmware, the firmware upgrade fails stating 'The firmware is for the wrong personality of drive' or similar. .. I am chasing up that these drives are actually what people claim although this seems to be info lost to the ether. All I can see is 'Hewlett packard LTO Ultrium 3 drive' under windows - no differentaition as to wether 960 / 920 or an OEM version. Still, there is no firmware available I can find for the 920's, only the 960's. Any help on how to determine exactly what drives they are under windows would help :) Thanks, Matt. -- Matthew Warren. TSM Technical Specialist. AIX SAN Administrator. Thesaurus Computing Services. www.i-tcs.com
Re: copypools on disk on AIX?
I am in the process of formatting some now on /var/diskpool/satacopyvolf (the directory that hasn't had many allocations. It was added to the initial set and I then did an upd devclass. I was given an error when I tried using 5000 as a formatsize; it took a 1000. So now I assume I can delete the volumes auto created in the other directories and then use the def vol to repopulate the space. I've noticed some volumes are 0 percent used but TSM reports out of space ( on new volume creates). This was also when volf was showing 0 percent utilization. Question. We have several LARGE files that span multiple physical volumes. Will TSM allow a backup of a file that spans the size it the virtual volume it creates on disk? Device Class Name: CPSATABG Device Access Strategy: Sequential Storage Pool Count: 1 Device Type: FILE Format: DRIVE Est/Max Capacity (MB): 2,048.0 Mount Limit: 7 Mount Wait (min): Mount Retention (min): Label Prefix: Library: Directory: /var/diskpool/satacopyvola,/var/diskpool/satac- opyvolb,/var/diskpool/satacopyvoc,/var/diskpo- ol/satacopyvold,/var/diskpool/satacopyvole,/v- ar/diskpool/satacopyvolf [EMAIL PROTECTED] 12/04/06 1:37 PM And then after you have all the underlying AIX work done, you should create the copy storage pool device class using some reasonable size maxcap value. I've had reasonable success with 5000M as a starter. Then instead of using scratch volumes (set maxscratch on the pool to zero), use define vol stgpool /ld1/of formatsize=5000 numberofvol=256 to create the volumes. This will create 256 files named /ld1/of, of0001, etc. Repeat until you fill up the logical drive. By creating the volumes like this you avoid fragmentation on your drives. If you need more detail about the commands to set this up, let me know. The key to successful use of file device class on devices of this sort is large write back caches. I assume you will RAID5 the drives in the DS4800. Since RAID5 is not particularly good for write, the cache is very important. We have had good luck with large disk pools using the file device class. Our shelves, though, have 1GB of cache. Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Carlson Sent: Monday, December 04, 2006 10:24 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] copypools on disk on AIX? We tried file device class with our onsite pool with disappointing results. I believe the problem was our decision not to stripe across LUN's. This would have made performance much better, at the cost of a LUN failure causing more damage than if we used them indicidually. Now, I can't remember the last time I saw a LUN failure, but YMMV. We will probably address this issue again when the decision is made to move our copy pool to disk. On 12/1/06, Lawrence Clark [EMAIL PROTECTED] wrote: We are migrateing our copypool from cartridge to a DS4800. From the manuals copypools only support FILE type devices. My assumptions ( on AIX) are: -I create logical volumes and file systems -Define the device class -TSM then creates the files in the filesystem Anyone ever done this with copypools on AIX? [EMAIL PROTECTED] 12/01/06 9:56 AM Know of anyone using a vaulting service with transmissions over the Internet with TSM? We're at capacity and looking for options. Regards, Orin Orin Rehorst The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments. -- Andy Carlson --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain
Re: HP LTO3 drives
What Operational System and Device Drive Version?
Re: HP LTO3 drives
Any help on how to determine exactly what drives they are under windows would help :) Look in the TSM management console under TSM device driver, - Reports - Device Information Doesn't matter if you aren't using the TSM device driver, the hardware info is still there. I think it reports what the firmware sends back, rather than what the Windows device driver says. Wanda Prather I/O, I/O, It's all about I/O -(me)
Re: HELP! NAS NDMP Restore Issue
Joni - I'm NAS-impaired, but you need to do basic looksee... Do 'dsmc Query Filespace' to see what viable filespaces the client generally has. Also do 'Query NASBAckup' in the TSM server to see what it specifically has. Pay particular heed to what the Unix client manual says about the restorability of Full NAS images, in its documentation of the MODE option. This may well be your problem. Richard Sims
Re: Reply: copypools on disk on AIX?
Markus, Good catch! I did hear, though, that due to the file system design, perhaps pre-formatting volumes on AIX will cause fragmentation rather than preventing it. I'm not an AIX guy but would hope that someone who is would weigh in here. Thanks, Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Markus Engelhard Sent: Tuesday, December 05, 2006 12:25 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Reply: copypools on disk on AIX? Hi all, just my two cents on file-deviceclass: I agree with Kelly that Volumes should be predfined to avoid fragmentation. In addition I would very strongly recommend running the define volume command with a wait=yes to format them sequentially. While this looks a pain, volumes will be formatted without fragmentation one would get formatting several volumes at a time. Pre-formatting volumes may take it´s time (to be percise, formatting on Sun Solaris can be very slow, while W2K3 is rather quick due to differences in the filsystem!), but you just run it once and it can be run in the background. Regards, Markus -- Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail oder von Teilen dieser Mail ist nicht gestattet. Wir haben alle verkehrsüblichen Maßnahmen unternommen, um das Risiko der Verbreitung virenbefallener Software oder E-Mails zu minimieren, dennoch raten wir Ihnen, Ihre eigenen Virenkontrollen auf alle Anhänge an dieser Nachricht durchzuführen. Wir schließen außer für den Fall von Vorsatz oder grober Fahrlässigkeit die Haftung für jeglichen Verlust oder Schäden durch virenbefallene Software oder E-Mails aus. Jede von der Bank versendete E-Mail ist sorgfältig erstellt worden, dennoch schließen wir die rechtliche Verbindlichkeit aus; sie kann nicht zu einer irgendwie gearteten Verpflichtung zu Lasten der Bank ausgelegt werden. __ This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail or of parts hereof is strictly forbidden. We have taken precautions to minimize the risk of transmitting software viruses but nevertheless advise you to carry out your own virus checks on any attachment of this message. We accept no liability for loss or damage caused by software viruses except in case of gross negligence or willful behaviour. Any e-mail messages from the Bank are sent in good faith, but shall not be binding or construed as constituting any kind of obligation on the part of the Bank.
remote buffer overflow (important!)
Hi All, pay attention, Yesterday a remote buffer overflow for TSM was disclosed on bugtraq. All TSM servers 5.3.4 or 5.2.9 are vulnerable, so please upgrade if your server is reachable from networks you don't trust 100%. See: http://www-1.ibm.com/support/docview.wss?uid=swg21250261 I'm disappointed IBM hasn't warned me about this for the tons of euro's I pay them for support. -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16 B3F6 048A 02BF DC93 94EC I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end. -- Douglas Adams
Re: Reply: copypools on disk on AIX?
Kelly Lipp wrote: Markus, Good catch! I did hear, though, that due to the file system design, perhaps pre-formatting volumes on AIX will cause fragmentation rather than preventing it. I'm not an AIX guy but would hope that someone who is would weigh in here. I'm very curious how this would work. JFS2 dos have a block-allocation scheme, like any other FS, but preallocation will at least never be disadvantageous, I'm very sure. -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16 B3F6 048A 02BF DC93 94EC I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end. -- Douglas Adams
Re: Reply: copypools on disk on AIX?
And Remco, I trust! Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Remco Post Sent: Tuesday, December 05, 2006 1:09 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Reply: copypools on disk on AIX? Kelly Lipp wrote: Markus, Good catch! I did hear, though, that due to the file system design, perhaps pre-formatting volumes on AIX will cause fragmentation rather than preventing it. I'm not an AIX guy but would hope that someone who is would weigh in here. I'm very curious how this would work. JFS2 dos have a block-allocation scheme, like any other FS, but preallocation will at least never be disadvantageous, I'm very sure. -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16 B3F6 048A 02BF DC93 94EC I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end. -- Douglas Adams
Re: Using the DBI::TSM module, memory problem
Allen S. Rout a écrit :
On Mon, 4 Dec 2006 19:46:07 +0100, Hans Christian Riksheim [EMAIL PROTECTED]
said:
I essentially want to stream the output of the sql through a
filter while it is returned from the TSM-server, not glob it up in
memory first and then process it later. Have not found out yet with
DBI.
And you won't.
TSM::Function.pm:
138 sub tsm_execute {
139 my ($sth,$statement)[EMAIL PROTECTED];
140
[...]
160 while ($ch) {
161 $errstr.=$_ if m/^[A-Z][A-Z][A-Z]\d\d\d\d[^I]/;
162 chomp;
In Perl, that means it's going to read until it's done. I've noodled
around a bit thinking about ways to buffer or stall that reading, but
I can't guaruntee that you won't just have the entire stream pile up
somewhere else in the system; will the server stop the SELECT process
just becaus the thing listening to dsmadmc's STDOUT has stalled? Ew.
My recommendation is that, if you're going to do big dataset stuff,
don't bother with PERL for your primary analysis (and I'm a perl
addict, BTW). do something like
dsmadmc -dataonly=yes -comma | awk [...]
Many of the questions I ask of my server come down to
dsmadmc | cut [somehow] | sort | uniq -c | sort -rn
which streams nicely. Or you can even
dsmadmc | bzip2 -c tempfile
and then mess with that. Remember, database selects tend to compress
VERY nicely.
Some database guy suggested use of cursors which make it possible to
fetch one row at a time and have the database keep track of your
progress, but I don't know the first thing about cursors and I don't
think the TSM database is designed for those needs anyway.
Agreed. The ODBC path you're already working at is probably a better
solution for the big queries.
- Allen S. Rout
Hello,
I had two problems when I wrote this module.
First, some people use this module on Windows platform. So, I store all
the result of dsmadmc command in memory with qx() statement.
Second, DBI need to return the dataset as a memory perl structure. For
instance, for AIX, il you need to retrieve more than 256Mo you could get
few problems.
It's not a Perl limitation but the or my implementation for DBI (any
good Idea is accepted).
In Perl, you could do it as is (only on UNIX) :
my $cmd = dsmadmc ;
open my $cmd_h, $cmd | or die Cannot fork: $!\n;
while ($cmd_h) {
# You have one line in $_
# Do what you want with $_ but don't store it in memory
# write result in an other file... print it to STDOUT, ...
}
close $cmd_h or die Error in '$cmd' command: $!\n;
Will TSM ever support BMR for windows systems?
Does anyone know if Tivoli is working on a product that will support BMR on windows systems. I know Cristie can be used but I don't want another third party product and ASR recovery on Win2003 takes forever. You would think that TSM would be able to clone or ghost a windows system at least. **EMAIL DISCLAIMER*** This email and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. If you have received this e-mail in error, please delete it and notify the sender or contact Health Information Management 312.413.4947.
wildcard del vol?
Ah... Since I'm redoing the volumes on SAN and need to delete the ones auto generated by TSM, is there a way of wholesale deleteing the existing volumes without doing an explicit del vol on each? The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
Re: copypools on disk on AIX?
Kelly Lipp wrote: This looks good, but I would still create these volumes using define vol numberofvol rather than letting TSM create them. I found that TSM tries to format all of these volumes at once... To prevent fragmentation, I used a small one-liner to dsmfmt the volumes and then define them in TSM. Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: Monday, December 04, 2006 11:43 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] copypools on disk on AIX? Yes, thank you. After posting my question I went to the 5.3 Admin Ref and saw I needed a file type device class for copypools. Defined then, changed the script, and since TSM saw them as a new copypool it copied all the data over, over this past weekend. about 2 TB of copypool data. We just have the large volumes ( that are RAID5) on a DS4800. TSM auto creates the volumes: /var/diskpool/satacopyv- CPSATABG CPSATABG 2,048.00.0 Empty oc/8733.BFS /var/diskpool/satacopyv- CPSATABG CPSATABG 2,048.0 77.1 Filling oc/8738.BFS /var/diskpool/satacopyv- CPSATABG CPSATABG 2,048.0 51.4 Filling oc/873E.BFS /var/diskpool/satacopyv- CPSATABG CPSATABG 2,048.0 98.6 Filling oc/8743.BFS /var/diskpool/satacopyv- CPSATABG CPSATABG 2,048.0 98.6 Filling oc/8747.BFS From AIX mounted filesystem view: /dev/lvvgsata2 1042022400 0 100% 266 1% /var/diskpool/satacopy vola /dev/lvvgsata3 1042022400 0 100% 265 1% /var/diskpool/satacopy volb /dev/lvvgsata4 1042022400 0 100% 266 1% /var/diskpool/satacopy voc /dev/lvvgsata5 1042022400 0 100% 265 1% /var/diskpool/satacopy vold /dev/lvvgsata6 1042022400 0 100% 265 1% /var/diskpool/satacopy vole /dev/lvvgsata1 1042022400 10378713201% 17 1% /var/dispool/satacopy volf [EMAIL PROTECTED] 12/04/06 12:24 PM We tried file device class with our onsite pool with disappointing results. I believe the problem was our decision not to stripe across LUN's. This would have made performance much better, at the cost of a LUN failure causing more damage than if we used them indicidually. Now, I can't remember the last time I saw a LUN failure, but YMMV. We will probably address this issue again when the decision is made to move our copy pool to disk. On 12/1/06, Lawrence Clark [EMAIL PROTECTED] wrote: We are migrateing our copypool from cartridge to a DS4800. From the manuals copypools only support FILE type devices. My assumptions ( on AIX) are: -I create logical volumes and file systems -Define the device class -TSM then creates the files in the filesystem Anyone ever done this with copypools on AIX? [EMAIL PROTECTED] 12/01/06 9:56 AM Know of anyone using a vaulting service with transmissions over the Internet with TSM? We're at capacity and looking for options. Regards, Orin Orin Rehorst The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments. -- Andy Carlson --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New
Re: wildcard del vol?
Ah, No. But wouldn't it be nice? You could download a trial copy of our SSM product and delete them with that. Perhaps the ISC has some functionality. You could also issue a q vol temp.mac and edit that file with the appropriate del vol commands... Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: Tuesday, December 05, 2006 2:22 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] wildcard del vol? Ah... Since I'm redoing the volumes on SAN and need to delete the ones auto generated by TSM, is there a way of wholesale deleteing the existing volumes without doing an explicit del vol on each? The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
Re: wildcard del vol?
SELECT is your friend! Select 'DELETE VOL', volume_name from volumes where stgpool_name='BLAH' Cut the output and paste it in as a TSM script! (If the volume names are very long, you may have to run it from a cmd prompt with dsmadmc) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kelly Lipp Sent: Tuesday, December 05, 2006 4:54 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: wildcard del vol? Ah, No. But wouldn't it be nice? You could download a trial copy of our SSM product and delete them with that. Perhaps the ISC has some functionality. You could also issue a q vol temp.mac and edit that file with the appropriate del vol commands... Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: Tuesday, December 05, 2006 2:22 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] wildcard del vol? Ah... Since I'm redoing the volumes on SAN and need to delete the ones auto generated by TSM, is there a way of wholesale deleteing the existing volumes without doing an explicit del vol on each? The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
Re: Will TSM ever support BMR for windows systems?
Dearman, Richard wrote: Does anyone know if Tivoli is working on a product that will support BMR on windows systems. I know Cristie can be used but I don't want another third party product and ASR recovery on Win2003 takes forever. You would think that TSM would be able to clone or ghost a windows system at least. isn't that what the ASR things are for in windows backups? Not as advanced as cristie, but works on similar hardware I'd think. I guess it's somewhere in the fine manual :) **EMAIL DISCLAIMER*** This email and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. If you have received this e-mail in error, please delete it and notify the sender or contact Health Information Management 312.413.4947. -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16 B3F6 048A 02BF DC93 94EC I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end. -- Douglas Adams
Re: wildcard del vol?
On Tue, 5 Dec 2006 16:21:47 -0500, Lawrence Clark [EMAIL PROTECTED] said: Since I'm redoing the volumes on SAN and need to delete the ones auto generated by TSM, is there a way of wholesale deleteing the existing volumes without doing an explicit del vol on each? dsmadmc -dataonly -tab select 'del vol ',volume_name,' wait=yes' where your_criterion_here something.macro then TSM:your_server macro something.macro - Allen S. Rout
Re: wildcard del vol?
On Tue, 5 Dec 2006 17:05:50 -0500, Prather, Wanda [EMAIL PROTECTED] said: SELECT is your friend! Select 'DELETE VOL', volume_name from volumes where stgpool_name='BLAH' Oh, piffle. I was late to the dance again. - Allen S. Rout
Re: Will TSM ever support BMR for windows systems?
On Tue, 5 Dec 2006 15:15:47 -0600, Dearman, Richard [EMAIL PROTECTED] said: Does anyone know if Tivoli is working on a product that will support BMR on windows systems. I know Cristie can be used but I don't want another third party product and ASR recovery on Win2003 takes forever. You would think that TSM would be able to clone or ghost a windows system at least. Huge pain in the tush, for no return. Other folks have that space very nicely explored, and BMR for [platform A] just encourages folks to ask for it for the rest of them. - Allen S. Rout
FW: Help Please
I have been thrown into an environment supporting TSM (among other things) because the AIX/TSM guy was fired. I've been trying to install the integrated solutions console (ISC) on my desktop. I have registered it through the register node command, on the server residing on an LPAR on our AIX box. For some reason, the software instructions are quite lacking. This is for installing ISC 6.01 for TSM 5.3.2 I have contacted IBM support and they have referred me to a number of documents for doing the install each of which have conflicting and/or incomplete information. The IBM (TSM) tech I have been working with has told me they get a lot of questions on how to do this install. One would think by now they would have compiled so good instructions However, they haven't. Does anyone have any instructions or a valid site for instructions to accomplish this? Thanks :-) Kerry *** CONFIDENTIALITY NOTICE*** This message and any included attachments are from MedSynergies, Inc. and are intended only for the addressee. The contents in this message contain confidential information belonging to the sender that is legally protected. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or contact MedSynergies, Inc. at [EMAIL PROTECTED]
Re: wildcard del vol?
Use the SQL contatenation operator: Select 'del vol ' || volume_name from volumes where stgpool_name='WHATEVERINCAPS'... Do it right from the dsmadmc command prompt and cut 'n paste right back to execute them. You may have to issue SET SQLDISPLAYMODE WIDE so it all fits on a single line. Actually now that I think about it, if you try to cut n' paste it back in to the dsmadmc command line, you get prompted Yes or No after the first DEL VOL command is issued. Probably better to pipe the output to a file and then use the macro command like Allen used. Bill Boyer Select * from USERS where CLUE0 0 rows returned - ?? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: Tuesday, December 05, 2006 5:32 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: wildcard del vol? On Tue, 5 Dec 2006 16:21:47 -0500, Lawrence Clark [EMAIL PROTECTED] said: Since I'm redoing the volumes on SAN and need to delete the ones auto generated by TSM, is there a way of wholesale deleteing the existing volumes without doing an explicit del vol on each? dsmadmc -dataonly -tab select 'del vol ',volume_name,' wait=yes' where your_criterion_here something.macro then TSM:your_server macro something.macro - Allen S. Rout
Re: Re: Using the DBI::TSM module, memory problem
Hans Christian Riksheim wrote: I essentially want to stream the output of the sql through a filter while it is returned from the TSM-server, not glob it up in memory first and then process it later. Have not found out yet with DBI. Some database guy suggested use of cursors which make it possible to fetch one row at a time and have the database keep track of your progress, but I don't know the first thing about cursors and I don't think the TSM database is designed for those needs anyway. I haven't used the DBI::TSM module, nor am I a database guy. But the TSM implementation of SQL SELECT does support the use of cursors. I've seen various tools use them (there's a STORServer tool that uses them, and I wouldn't be surprised if TSM Operational Reporting used them). Not being a database guy, though, I couldn't tell you _how_ to use them, or if DBI::TSM supports the use of them. -- Hello World.David Bronder - Systems Admin Segmentation Fault ITS-SPA, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. [EMAIL PROTECTED]
