Re: Speeding up my SQL statement

Hi Paul! Thanks for your suggestion! I have tried your statement on our test server with just one Oracle node. It runs half an hour before result are returned. However, when I change "where node_name in (select node_name from nodes where node_name like '%-ORC')" into "where node_name='MYORACLENODE'

Archive copygroup retinit=event

Hi, can anyone explain the archive copy group parameters "RETINIT=EVENT" and "RETMIN=value"? I cannot found a complete documentation (tsm 5.2). The only hint is the help panel using the web admin interface. Regards Gerhard Ginzler

Re: Speeding up my SQL statement

Just running on a hunch - a really good query optimiser would have been able to do the right thing - but we all have to remember that TSM is designed first and foremost as a backup and recovery tool :) On Friday, Jul 2, 2004, at 18:40 Australia/Sydney, Loon, E.J. van - SPLXM wrote: Hi Paul! Thanks

Tivoli Software Download

Hi all Is it possible to download Tivoli Storage Manager for Windows and Tivoli Storage Manager Client for Windows as a try and buy software? Thanks for help, regards Werner Nussbaumer

Re: Tivoli Software Download

Hi Werner The packages are located at ftp://ftp.software.ibm.com/storage/tivoli-storage-management/ You'll have to download both the maintenance package and the patch package (located under /maintenance resp /patches) for the TSM server. For the client, you'll only have to download the patch v

Node just sitting in In-progress?

Hello, Thanks again to all who responded to my question about the 1501 port. Can anyone tell me why would a node show In-Progress and yet there are no sessions active? The Node did not complete successfully why doesn't it just say missed? This is happening with a Novell Client but I have seen it

pre and post script in AIX

Hi, I have a TSM server W2K 5.2.0.2 I have to backup a AIX server, but to do so . I have to run a script before and after the backup ... What option should I use ...?? I found 2 options to put in the DSM.SYS file (POSTSCHEDULECMD and PRESCHEDULECMD) but I'm not sure .. Should it work tha

AW: pre and post script in AIX

Hi Luc, yes, you should put these to keywords into dsm.sys. Example:PRESchedulecmd /usr/tivoli/tsm/client/ba/bin/precmd.sh I use the precmd to backup the system configuration to a flat file using cfg2html. HTH Thomas Rupp -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [m

Re: Tivoli Software Download

At least older versions I used seem to have a 30 day builtin try before you buy on at least the basics. A VAR could help you out I am sure! If you don't have one, go to IBMs web page and they will hook you up with a VAR (or at least a sales droid that can get you some help) in your area. -Ori

Re: Cannot show Command Line TSM5.2.2.5, W2K3

Try to download msjavx86.exe from Microsoft Site. Best Regards, Gokhan YILDIRIM -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tao Jiang Sent: Thursday, July 01, 2004 7:52 PM To: [EMAIL PROTECTED] Subject: Cannot show Command Line TSM5.2.2.5, W2K3

Re: Cannot show Command Line TSM5.2.2.5, W2K3

Thanks Gokhan. I downloaded Java Runtime Environment from Sun site. and installed it. It works now. Tao - Original Message - From: "Gokhan Yildirim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 02, 2004 8:54 AM Subject: Re: Cannot show Command Line TSM5.2.2.5, W2K3 Try

TSM 5.2/W2K3 ODBC and Snapshot error

Hi, TSM5.2.2.5/ Win2003 ODBC Get error, can not connect to TSM. 07/01/2004 17:15:04 cuGetAuthResult: Authorization failed. Result code: 2 07/01/2004 17:15:04 sessOpen: Error 137 from signon authentication. 07/01/2004 17:15:04 ANS1051E Invalid password When Client 5.2.2.5 archives files, it is su

Re: Node just sitting In-Progress

Timothy This is one of my pet hates about TSM. A scheduled backup which is actually in progress - ie actively transferring data between client and server - shows a status of 'Started'. A scheduled backup which started but encountered an error, dropped the session or whatever shows a status of 'In

Colocation readonly tape question

I have a new tapepool that I only use for a couple of nodes that is using colocation. Can I change the status of a tape that is in that pool to readonly so I can remove it, even though it is not full? Will TSM then grab a new tape to use, or will it complain because the "not full" tape is not avail

Re: Colocation readonly tape question

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On >I have a new tapepool that I only use for a couple of nodes >that is using >colocation. Can I change the status of a tape that is in that pool to >readonly so I can remove it, even though it is not full? Will >TSM then grab >a new tape

Re: Node just sitting In-Progress

At 12:11 PM 7/2/2004, you wrote: Timothy This is one of my pet hates about TSM. A scheduled backup which is actually in progress - ie actively transferring data between client and server - shows a status of 'Started'. A scheduled backup which started but encountered an error, dropped the session or

Re: Colocation readonly tape question

Thanks Mark and Richard, By the way Mark, we ARE doing backupsets of that node along with a regular backup also, I know, I know.. Thanks :) Mark Bertrand -Original Message- From: Stapleton, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, July 02, 2004 12:04 PM To: [EMAIL PROTECTED] Subj

Re: Colocation readonly tape question

I would be better to mark the tape unavailable. If you mark it read-only then TSM will still try to mount it for restores or reclamation. At times we have need to checkout primary tapes. When we do this we update vol acc=unav. Mark Bertrand <[EMAIL PROTECTED]> wrote:Thanks Mark and Richard,