Re: Tape question

2003-02-18 Thread DFrance
You will probably need the nested form of the query, something like... select a.volume_name from volumeusage where blah blah blah and - a.volumn_name in (select b.volume_name from volumes where - last_write_date>current date - 60 day) We are requesting an en

Residency Announcement: TI-A303 Tivoli Storage Management Concepts, Getting Started with TSM - Update

2003-02-18 Thread Charlotte Brooks
For your consideration - a residency in San Jose to update the very popular redbooks, "TSM Concepts", and "Getting Started with TSM: A Practical Implementation Guide" Residency Announcement: TI-A303 Tivoli Storage Management Concepts, Getting Started with TSM - Update Benefits to Resident: Resid

Re: Stop Bagging TSM Developers.

2003-02-18 Thread Andrew Raibeck
> Perhaps a command line switch to > eliminate the header and trailer... Watch for an option to display just the data in an upcoming release. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e

Re: Mixing 3590E and 3590K volumes

2003-02-18 Thread Richard Sims
>My 3494 is filled with 3590E carts. Well, you have something I've never seen... I know about 3590J tapes, and 3590K tapes, but never seen a 3590E tape. ;-) >If I were to start introducing the longer format carts into my system, >would TSM use them interchangeably with the old ones, i.e., would

Re: Mixing 3590E and 3590K volumes

2003-02-18 Thread Seay, Paul
If your 3590 drives have the green 2x sticker on the back of them (open the cabinet and look), they can support K cartridges. 3590H drives can support K-Carts. The K carts have a different knotch configuration than the J cartridges. There is no issue with having a mixed bag except it throws off

Re: Semote storage pool

2003-02-18 Thread GUILLAUMONT Etienne
I know but my customer want to do that. In fact, he bought two new servers, one with W2K and one with linux, and planned to install TSM on the linux server, but it is so complicated that we decided to install it on the W2K server. And we have 200 Gb on the Linux Server and 70 Gb on W2K So we would

Re: Tape Reliability Recommendations

2003-02-18 Thread Kelly J. Lipp
I have done a significant amount of testing and have quite a lot of practical experience with what I will refer to as the Big Three tape technologies: AIT3 LTO1 SDLT320 Of the three, I know AIT the best. It's always good to know where someone sits before they tell you where they stand. In a TSM

Re: Tape Reliability Recommendations

2003-02-18 Thread Greg Redell
We were getting a fair amount of "36 errors" on our 3584 and they corresponded to I/O errors I was seeing in TSM. After talking to IBM and our CE, we wound up updating our library firmware to 3060 and (knock on wood) we haven't seen any errors since. Library 3584 4 fiber attached LTO drives Libra

Re: Semote storage pool

2003-02-18 Thread Emil S. Hansen
On Tue, Feb 18, 2003 at 04:46:05PM -0500, Remeta, Mark wrote: >> It doesn't matter how you use it. Forcing TSM to work its I/O at network >> speeds when it is designed to work at bus speeds will show badly. You'll >> be disappointed. > I agree.. besides that's what off-site copy pools are for! I h

Q BA syntax on *nix

2003-02-18 Thread Ted Byrne
Please feel free to point me to the documentation if I've overlooked something here, but I'm running into a brick wall... Client version 5.1.5.5 Client OS - AIX 5.1 ML 02 Server version 5.1.5.4 Server OS - AIX 5.1 ML 02 I've been asked to produce a list of all current

Re: Tivoli pubs email address evaporated

2003-02-18 Thread Andrew Raibeck
Hi Zlatko, I understand your and everyone else's frustration. When it comes to the TSM product code, ADSM-L is one of the best places to be because your message gets to people who write the code. In a similar fashion, the feedback mechanism that I mentioned yesterday will enable your message about

Re: Semote storage pool

2003-02-18 Thread Stapleton, Mark
> On Tue, Feb 18, 2003 at 10:22:35AM -0600, Stapleton, Mark wrote: >>Why would you want to do this? Disk (particularly local >>disk) is cheap >>these days. The lag resultant from Windows drive mappings or >>(shudder!) NFS mounts will greatly slow your throughput. From: Emil S. Hansen [mailto:[

Re: Stop Bagging TSM Developers.

2003-02-18 Thread Bill Boyer
A "workaround" is to create a macro file of the command(s) you want, and redirect each of them to a file. Them run DSMADMC with MACRO and the results will be without the headers. I like to use -TAB and -ITEMCOMMIT options. like this: Q ACT BEGINT=-01:00 > QACT.TXT and you'll get your output, ta

Mixing 3590E and 3590K volumes

2003-02-18 Thread Fred Johanson
My 3494 is filled with 3590E carts. If I were to use 3590K carts, my robot wouldn't be so filled. This is the current definition of the DEVC TAPE: Device Class Name: TAPE Device Access Strategy: Sequential Storage Pool Count: 8 Device Type: 3590 Format:

5.1.6.2 is out

2003-02-18 Thread Gill, Geoffrey L.
This morning I've seen email asking us to lay off IBM. Does anyone have any further experience with any level of 5.1.6 that can convince anyone it's stable? Is anyone on 5.1.5x satified with that delivery? Is anyone who is on 5.1.6.0 satisfied with the delivery? Is anyone on 5.1.6.1 satisfied wit

Re: Semote storage pool

2003-02-18 Thread Emil S. Hansen
On Tue, Feb 18, 2003 at 10:22:35AM -0600, Stapleton, Mark wrote: > Why would you want to do this? Disk (particularly local disk) is cheap > these days. The lag resultant from Windows drive mappings or (shudder!) > NFS mounts will greatly slow your throughput. Offsite storage? -- Best Regards Emil

Re: 5.1.6.2 is out

2003-02-18 Thread jane.bamberger
Hi, I upgraded approx 3-4 weeks ago from 4.2.x to 5.1.6.0. (AIX 433 server) I had intermittently the node table access crashes everyone else did. IBM thought that had been fixed, and worked very diligently with me to get core dumps, and information to discover the problem. They called me shortl

Re: Tape Reliability Recommendations

2003-02-18 Thread Peter Pijpelink - P.L.C.S. BV Storage Consultants
I would be very curious to hear what type of reliability problems you have seen with LTO. I have posted here before, but we have been experiencing an incredibly high number of read errors with our 3584 LTO library. We regularly see errors when trying to restore data from tapes. We have been aud

RES: SQL TDP fails to run with scheduler

2003-02-18 Thread T_MML
Philip, Attention for the parameter "OPTIONS" The configuration file " progra~1\tivoli\tsm\tdpsql\sqlfull.cmd " it must be placed in OBJECTS ... OK! 02/18/2003 02:37:35 Schedule Name: ENTERPRISE_SQL_BACKUP 02/18/2003 02:37:3

Re: 5.1.6.2 is out

2003-02-18 Thread Theresa Sarver
Just upgraded our [AIX433 ML10] TSM Server from 415 to 5162 yesterday. No problems to speak of so far and the upgrade went suprisingly smooth. Thanks; Theresa >>> [EMAIL PROTECTED] 02/18/03 10:06AM >>> This morning I've seen email asking us to lay off IBM. Does anyone have any further experie

Re: DB Cache Hit Rate Question

2003-02-18 Thread Alex Paschal
Farren, I'm not sure exactly how the TSM database internals work, but typically a database cache is populated with "cache prefetch." This isn't _exactly_ correct, but it'll do conceptually. The db goes to read one row (check a file for expiration). That one db row request loads one or more bloc

Re: Tape Reliability Recommendations

2003-02-18 Thread Peter Ford
> -Original Message- > From: Kelly J. Lipp [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 18, 2003 10:32 AM > To: [EMAIL PROTECTED] > Subject: Re: Tape Reliability Recommendations > > As for reliability. That turns out to be a very mixed bag. <...snip...> > For instance, > we hav

ENC: SQL TDP fails to run with scheduler

2003-02-18 Thread T_MML
Philip, Attention for the parameter "OPTIONS" The configuration file " progra~1\tivoli\tsm\tdpsql\sqlfull.cmd " it must be placed in OBJECTS ... OK! 02/18/2003 02:37:35 Schedule Name: ENTERPRISE_SQL_BACKUP 02/18/2003 02:37:3

Re: Will the IBM lurkers here be joining iSeries community?

2003-02-18 Thread Stapleton, Mark
From: Rob Berendt [mailto:[EMAIL PROTECTED]] > IBM has announced a FAQ lookup, instant messaging group, and > a lot of other functions to help assist people. > http://community.ngi.ibm.com/ How will this affect the > participation of the many IBM people who participate in these lists? We'll se

Re: SQL TDP fails to run with scheduler

2003-02-18 Thread Del Hoobler
Philip, What does your TSM Server schedule definition look like? Is the SQLFULL.CMD being executed at all? I would bet that it isn't. Take a closer look at the schedule definition to see if there is a problem with it. One example, I have seen is that if there is a space in the path name to the SQ

Re: AW: Ndmp Backup to primary Diskpool

2003-02-18 Thread shekhar Dhotre
NDMP backups will go directly to dedicated tape drives . Stefan Holzwarth <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/18/2003 03:17 AM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:AW: Nd

Re: Stop Bagging TSM Developers.

2003-02-18 Thread Jolliff, Dale
I'm sure being a TSM developer isn't much fun these days - I can sympathize with them a bit from the aspect of some things being out of their control. I have been writing some scripts for TSM this morning, and I'm in a bit of a bad mood - hence the snipe at the developers. Now that I'm venting up

Re: Recovery log

2003-02-18 Thread PAC Brion Arnaud
Hi Mark, You are probably suffering from so called "log pinning" symptom. To make it short : log is working on a circular basis, and can only be freed if all transactions that where written into it are commited to TSM DB. If not done, you reach a point where the log bites it's own tail : older rec

SQL TDP fails to run with scheduler

2003-02-18 Thread Hamlin, Philip
I am having trouble getting the SQL TDP v2.2.1 to run with the scheduler. Here is the system description: Both the TSM server and the SQL server are running Windows 2000 with SP3. The SQL server is running SQL 2000 patched to SP3. TSM server version 4.2.1.12 TSM BAClient version 4.2.2.8 TSM Tivol

Re: ANR2576W An attempt was made to update an event record for a scheduled operation which has already been executed

2003-02-18 Thread Jon Evans
I have seen this exact same problem. Running 5.1.1.0 server and 5.1.1.0 client. W2K platform. I have had this problem for weeks and weeks I could not figure it out either.. Presumably a bug?? -Original Message- From: PAC Brion Arnaud [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 13

Re: DB Cache Hit Rate Question

2003-02-18 Thread Richard Sims
>I'm a little confused about the cache hit ratio information. If I run >expiration on a database, surely the TSM server has to trawl through the >entire thing on disk as it does not already reside in the buffer. So how >would I expect to see hit ratios of 99% or higher. I won't go into details >her

TSM Upgrade frequency

2003-02-18 Thread Todd Lundstedt
For you folks that patch your TSM server frequently (like the individual from Oxford University who upgraded from some version to 5.1.6.0 on Feb3, then to 5.1.6.1 on Feb7, and now planning to upgrade to 5.1.6.2 within a couple weeks), how many of you have Storage Agent nodes? I am still on 4.2.1.7

Re: A query about NDMP support

2003-02-18 Thread shekhar Dhotre
I am assuming that these disk vols are nfs mounted over some of the hosts systems in your environment . I use to backup these disks vols locally from the server where it is mounted .There is a option to backup nfs mounted fliesystems . Yes - $4500 per NDMP license . Thanks & regards . Sh

Will the IBM lurkers here be joining iSeries community?

2003-02-18 Thread Rob Berendt
IBM has announced a FAQ lookup, instant messaging group, and a lot of other functions to help assist people. http://community.ngi.ibm.com/ How will this affect the participation of the many IBM people who participate in these lists? Rob Berendt -- "They that can give up essential liberty to obtain

DB Cache Hit Rate Question

2003-02-18 Thread Farren Minns
Good afternoon all TSMers. I'm a little confused about the cache hit ratio information. If I run expiration on a database, surely the TSM server has to trawl through the entire thing on disk as it does not already reside in the buffer. So how would I expect to see hit ratios of 99% or higher. I wo

Re: 5.1.6.2 is out

2003-02-18 Thread Sheelagh Treweek
In the spirit of sharing experiences: > Is anyone who is on 5.1.6.0 satisfied with the delivery? We found strange issues at 5160 upgrade time; we ran one server for a few days at 5160 (from 3 February) which was quite satisfactory but were advised by support to go to 5161 ... > Is anyone on 5.1.

Re: ANR2576W An attempt was made to update an event record for a scheduled operation which has already been executed

2003-02-18 Thread Stapleton, Mark
From: PAC Brion Arnaud [mailto:[EMAIL PROTECTED]] > Could someone help me with that one : I get a client node > (win2k) for which TSM reports following message every night : > > 02/18/03 03:29:01 ANR2576W An attempt was made to update an > event record for a scheduled operation which has alread

Re: Semote storage pool

2003-02-18 Thread Stapleton, Mark
From: GUILLAUMONT Etienne [mailto:[EMAIL PROTECTED]] > I would like to know if it is possible to have a storage pool > on a remote machine without installing TSM on it. Typically, > what I wan't to do is to use space on a remote server to have > a disk or a file storage pool on it. I tried with

Re: Tivoli Protection for Mail, Domino edition

2003-02-18 Thread Stapleton, Mark
From: Emil S. Hansen [mailto:[EMAIL PROTECTED]] > My TSM server is version 4.1.5 running on AIX. I know it > isn't supported, but it is danm stable. > > Now I want to install TSM for Mail, Notes Edittion which I > think is the old "TDP for Domino v. 1.1.2". Does any one know > if it is possibl

Re: Recovery log

2003-02-18 Thread Niklas Lundstrom
Hello One gig is too small. I've had the same problem, when slow clients backed up alot of data it took several hours and the log began filling up. Regards Niklas -Original Message- From: Mark Hayden [mailto:[EMAIL PROTECTED]] Sent: den 18 februari 2003 16:06 To: [EMAIL PROTECTED] Subjec

TSM Memory Usage

2003-02-18 Thread Farren Minns
Hi all you TSMers out there I have a vague memory question here. I'm running TSM on a Solaris 2.7 machine and what I want to know is, when I start the TSM server, does it automatically grab a chunk of the free memory regardless of what it is doing at the time. Thanks Farren Minns John Wiley & S

Re: Stop Bagging TSM Developers.

2003-02-18 Thread Kauffman, Tom
And for my 2 cents worth, I see this as a TSM management and not development problem. There seems to be no regression test suite, and no change control/revision control process. Tom Kauffman NIBCO, Inc. -Original Message- From: Jolliff, Dale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, Febr

Re: Semote storage pool

2003-02-18 Thread Jozef Zatko
Hi Etienne, it is easy. I suppose you have a server with disk capacity, which you want use for TSM to store data. I do not know if that remote machine is Windows or Unix system. It is possible to use both of them (I actually worked only with Windows system but with NFS in Unix it should be also pos

Re: A query about NDMP support

2003-02-18 Thread Jelinek, David G.
Since I've received no response from the list, I decided to spend a day reading through both the TSM documentation on NDMP and the documentation on NDMP itself. I had thought that NDMP was just a backup protocol that TSM could support. It is not. It is a complete backup system itself. It requires t

Re: Stop Bagging TSM Developers.

2003-02-18 Thread Jolliff, Dale
Just my opinion, but based on the bug releases of late, they are doing a pretty good bagging job on their own.

Re: TSM on Linux

2003-02-18 Thread Lloyd Dieter
Etienne, Probably not. I tried this as well, and ultimately had to back down to RH 7.2 with a kernel upgrade to get things working. The TSMSCSI modules appear to be VERY fussy about loading into *exactly* the kernel specified. Once you meet the requirements, however, it seems to work pretty wel

Re: Backup via a script

2003-02-18 Thread PAC Brion Arnaud
Nicolas, Could you provide us a little bit more details on what you're willing to do, and on your knowledge of TSM and AIX, that we have a better idea of what you're trying to achive and the means to do it ? TIA. Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Pa

ANR2576W An attempt was made to update an event record for a scheduled operation which has already been executed

2003-02-18 Thread PAC Brion Arnaud
Hi list ! Could someone help me with that one : I get a client node (win2k) for which TSM reports following message every night : 02/18/03 03:29:01 ANR2576W An attempt was made to update an event record for a scheduled operation which has already been executed - multiple client schedulers may be

Tivoli Protection for Mail, Domino edition

2003-02-18 Thread Emil S. Hansen
Hello list. My TSM server is version 4.1.5 running on AIX. I know it isn't supported, but it is danm stable. Now I want to install TSM for Mail, Notes Edittion which I think is the old "TDP for Domino v. 1.1.2". Does any one know if it is possible to run it with my old server? My plan is to inst

Re: Semote storage pool

2003-02-18 Thread Chandrasekhar, C.R
Ing. Jozef Zatko, Can you share the steps to achieve this remote storage pool. Thanks, chandrasekhar -Original Message- From: Jozef Zatko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 3:03 PM To: [EMAIL PROTECTED] Subject: Re: Semote storage pool Hi Etienne, you can use

Re: Semote storage pool

2003-02-18 Thread Jozef Zatko
Hi Etienne, you can use remote disks for file device class. I am not sure about 5.1 version, but I did this on 4.2 version and it worked fine. I had problems with using disk device class on remote disks, but file device class worked for me. You can even use UNC names for file volumes (it is better

TSM on Linux

2003-02-18 Thread GUILLAUMONT Etienne
Hello, I tried to install TSM 5.1.5 server on Linux but I have a problem because my level is 7.3 red hat with a 2.4.18.24 kernel and for the devices, TSM requires an older kernel. Is there any possibility to have TSM work on my linux level ? Etienne GUILLAUMONT e-mail : [EMAIL PROTECTED] RGB Te

Semote storage pool

2003-02-18 Thread GUILLAUMONT Etienne
Hello, I would like to know if it is possible to have a storage pool on a remote machine without installing TSM on it. Typically, what I wan't to do is to use space on a remote server to have a disk or a file storage pool on it. I tried with a file device class and it allows only local disks. A di

AW: Ndmp Backup to primary Diskpool

2003-02-18 Thread Stefan Holzwarth
I want to put the ndmp datastream on diskpools (type file or disk), but i don't know whether it's possible. Regards Stefan holzwarth -Ursprüngliche Nachricht- Von: PINNI, BALANAND (SBCSI) [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 17. Februar 2003 20:43 An: [EMAIL PROTECTED] Betreff: Re