Re: Connection of TSM DB to Other Softwares

2004-08-26 Thread Sujay Dinakar R.
Thanks For all, I would like to create a catalog, and clisify the files on the type of File or on project, and i would like to write a program to resotre the required frile from the TSM, using the DB. Regards Sujay "Barnes, Kenny" <[EMAIL PROTECTED]> wrote: Tivoli Storage Manager for Windows i

Sub: Connecting the TSM DB to other softwares

2004-08-26 Thread Sujay Dinakar R.
Dear All, Does any one know how to connect the TSM Database, to make a personnel catalog using the existing database. Thanks in advance Regards Sujay Dinakar R. Regards Siujay Dinakar R. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has th

Re: Export quesion

2004-08-26 Thread Tab Trepagnier
Mark, Any machine that has 3.7TB worth of files is *begging* to be broken up into multiple node names, each node responsible for backing up a portion of a physical machine. Particularly if you're using slow tape technology like DLT. I agree with you, and in fact, we've done that with our main

Re: Export quesion

2004-08-26 Thread Rajesh Oak
I would agree with that. I just lost 4 days of export because of an I/O error on a scratch Tape it could not mount. It was on it's last 200GB of it 2.1TB when this happenedWhat is up with that? It's really frustrating. TSM should be able to pick another scratch tape. Rajesh Oak Blue Cross Blue S

Re: Export quesion

2004-08-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tab Trepagnier >This is an opportunity for an enhancement. I've been bit by >that situation also. > >The problem is that an export is a single transaction. Either >it fails or it succeeds. As I write this I'm holding my >br

Re: Windows 2003 Storage Server

2004-08-26 Thread TSM_User
I have customers running it on Dell NAS. It works fine for them as well. We have noticed that the TSM client can scan more objects per hour on Windows 2003 NAS than on the exact same hardware running Windows 2003. It seems the same optimization made for file server also helps the TSM client.

Re: Export quesion

2004-08-26 Thread Tab Trepagnier
Wanda / IBM, This is an opportunity for an enhancement. I've been bit by that situation also. The problem is that an export is a single transaction. Either it fails or it succeeds. As I write this I'm holding my breath hoping that the last 100 GB of the current _3.7 TB_ export complete witho

Re: Oracle Backup

2004-08-26 Thread Mark D. Rodriguez
Orin Rehorst wrote: I stopped using the TSM Oracle Agent...very complicated...and am just doing full exports to a file server. TSM then backs up the export. Mgmt. says, "Hey, you're not getting the full benefit of a backup with redo logs, etc." Please comment. Should I be using RMAN instead of exp

Re: IRIX and 5.2.3 client ????

2004-08-26 Thread Andrew Raibeck
There is no IRIX client at the TSM 5.2 release level. The APAR was originally opened against the 5.1.6 IRIX client, but is applicable to all operating systems. the APAR abstract that you cited should more properly read "CLIENT SCHEDULER CORE DUMPS AFTER BACKUP". A fix at the 5.1.x level for IRIX

Oracle Backup

2004-08-26 Thread Orin Rehorst
I stopped using the TSM Oracle Agent...very complicated...and am just doing full exports to a file server. TSM then backs up the export. Mgmt. says, "Hey, you're not getting the full benefit of a backup with redo logs, etc." Please comment. Should I be using RMAN instead of export? TIA Regard

Re: Need to keep data for a client forever

2004-08-26 Thread Thomas Denier
> There's a somewhat easier way: > 1. Create a new management class for the domain the node currently > belongs to. Make sure this new class contains a backup copygroup that > sets number of copies kept to UNLIMITED. > 2. Edit the node's client option file to contain the line > include *:\.

Re: Need to keep data for a client forever

2004-08-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier >>I use TSM 5.1.6.0 and have a situation where they need me to not >>expire any data for A particular node [including those already backed >>up]. There is a lot of clients using same policy /management class >>t

Re: Need help with select command

2004-08-26 Thread Mark D. Rodriguez
Karla Ross wrote: I am trying to find the tapes needed to recover only the "active" backups of a client. I used the following select command and it gives me a list of all tapes for all backups of that client. How can I narrow the search to just "active" backups? select volume_name,filespace_name

Re: Need help with select command

2004-08-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Karla Ross >I am trying to find the tapes needed to recover only the >"active" backups of a client. I used the following select >command and it gives me a list of all tapes for all backups of >that client. How can I narrow t

Re: Export quesion

2004-08-26 Thread Prather, Wanda
You will have to start the EXPORT from the beginning. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Ouzen Sent: Wednesday, August 25, 2004 5:53 PM To: [EMAIL PROTECTED] Subject: Export quesion Hi to all Today I ran an export command of a

Need help with select command

2004-08-26 Thread Karla Ross
I am trying to find the tapes needed to recover only the "active" backups of a client. I used the following select command and it gives me a list of all tapes for all backups of that client. How can I narrow the search to just "active" backups? select volume_name,filespace_name from volumeusage

IRIX and 5.2.3 client ????

2004-08-26 Thread Zoltan Forray/AC/VCU
I found this in the "readme" for the AIX 5.2.3.1 client: ** * This TSM Interim Fix addresses the following problems/issues: * IC40710 IRIX CLIENT SCHEDULER CORE DUMPS AFTER BACKUP. Well, I am confused since there is no 5

Re: Need to keep data for a client forever

2004-08-26 Thread Thomas Denier
> I use TSM 5.1.6.0 and have a situation where they need me to not expire any > data for > A particular node [including those already backed up]. There is a lot of > clients using same policy /management class that should not have their > expiration changed. I would like to know what would be the

Re: Selectively duplicating client data across servers

2004-08-26 Thread Mark D. Rodriguez
Hi Everyone, I have deleted the thread of this email since I am sure everyone has read a couple of times already. I figure I would throw my $0.02 into the mix as well. I have done a few configs like this over the years so I have some experience in this area. I think you have been getting some go

Re: database and recovery log protection..

2004-08-26 Thread Prather, Wanda
q status Check the output for the line: "LOG MODE:" ... about 2/3 down. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin Sent: Thursday, August 26, 2004 12:25 PM To: [EMAIL PROTECTED] Subject: database and recovery log protecti

Re: Firewall Issues:

2004-08-26 Thread Marc Levitan
The issue was that I was using: "managedservices schedule webclient" in the dsm.sys AND dsmsched in the startup script!!! Once I removed the dsmsched from the startup script and bounced the client, everything worked... Thanks, Marc Levitan Storage Management PFPC Global Funds Services |

Need to keep data for a client forever

2004-08-26 Thread Bala Krishnamurthy
Hi, I use TSM 5.1.6.0 and have a situation where they need me to not expire any data for A particular node [including those already backed up]. There is a lot of clients using same policy /management class that should not have their expiration changed. I would like to know what would be the clea

Re: TSM server recovery with database copy2 volumes

2004-08-26 Thread Prather, Wanda
Hi Mubashir!- Yes, you should be OK if you lose filesystem A. If filesystem A dies, you should ge a message in the activity log showing the error, and TSM will just keep on running with the DB copy on filesystem B. If you have to restart the TSM server and it can't find filesystem A, it will sti

SQL database restore question

2004-08-26 Thread Moses Show
Hi people, Have been trying to restore a database to a different location on a different server but am having problems. Was wondering if anyone can shed any light as to where I am going wrong. First I queried the TSM server for the fileinfo of the database I want to restore from the new in

database and recovery log protection..

2004-08-26 Thread Luc Beaudoin
Hi all Is there an easy way, like a command, to know what is my setup ... normal mode or roll-forward mode my TSM server is a Windows 2000 thanks

Re: how do you checkin or checkout tape

2004-08-26 Thread Prather, Wanda
That sounds familiar. Used to be that you were required to set the CAP priority and mode to use ACSLS with TSM. I don't have an ACSLS/TSM library anymore, things may have changed a lot. But according to my notes, we had to enter the ACSLS console commands to: Set CAP mode to automatic Set CAP pri

Re: how do you checkin or checkout tape

2004-08-26 Thread Warren, Matthew (Retail)
Do you have tape volumes already in the IO bay of the library? Does TSM show any requests are outstanding? 'query requests' Matt. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Weinstein, Stephen Sent: Thursday, August 26, 2004 3:54 PM To: [EMAIL

Re: Selectively duplicating client data across servers

2004-08-26 Thread Prather, Wanda
I agree. Multiple storage pools really aren't difficult to manage, and it will make your process very simple, and incremental. With backupsets, you have to copy ALL the data onto a new backupset, which will be time-consuming. Another disadvantage of using backupsets, think about what happens if A

Re: Problem with delete volhist type=dbb

2004-08-26 Thread Mark D. Rodriguez
Tom, I just thought I might point out that you are licensed for DRM automatically! You have a library with 10 drives that immediately requires you to purchase ITSM EE which comes with DRM included. So be thankful, you can now manage your offsite tapes like the rest of us The DRM commands will mak

Re: how do you checkin or checkout tape

2004-08-26 Thread PINNI, BALANAND (SBCSI)
Did you check acs_ssi process is running or not? What status do u see when you query from TSM Server? root 16776 1 0 Jun 06 - 72:55 /usr/tivoli/tsm/devices/bin/ssi 1 3690 50004 23 Thanks Balanand Pinni -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTEC

Re: how do you checkin or checkout tape

2004-08-26 Thread Weinstein, Stephen
already checked with storage tek. They have me eject the tape from the ACSLS console and it worked fine. THey told me to call TIVOLI. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Stapleton, Mark Sent: Thursday, August 26, 2004 11:31 AM To: [EMAIL

Re: how do you checkin or checkout tape

2004-08-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Weinstein, Stephen >I have a new tivoli server 5.2.3 running on windows 2003 >connected to a storagetek L5500 library running ACSLS. when >ever I try to checkout a tape I get the following failure. > > >ANR8855E ACSAPI(acs_eje

Re: Firewall Issues:

2004-08-26 Thread Prather, Wanda
I've got Windows clients running through a firewall at 5.2.0.2 and 5.2.2.5, no issues. Polling mode works fine, and the only port you need open for the scheduler to work is 1500. However, I'm not using managed services (dsmcad), just the regular old scheduler. I'm not sure what the effect is of us

Re: TSM migration from 5.1 to 5.2

2004-08-26 Thread Lloyd Dieter
Mostly because it typically takes a *very* long time to run (meaning many hours or even days) on a database of any size, and isn't usually necessary, unless something is badly broken. -Lloyd On Thu, 26 Aug 2004 08:41:08 -0500 "Park, Rod" <[EMAIL PROTECTED]> wrote thusly: > Just curious Why

[no subject]

2004-08-26 Thread Zoltan Forray/AC/VCU
I found this in the "readme" for the AIX 5.2.3.1 client: == IBM Tivoli Storage Manager (TSM) README 32bit Backup-Archive Client for AIX 5.1 and AIX 5.2 PPC Version 5, Release 2, Level 3.1

how do you checkin or checkout tape

2004-08-26 Thread Weinstein, Stephen
I have a new tivoli server 5.2.3 running on windows 2003 connected to a storagetek L5500 library running ACSLS. when ever I try to checkout a tape I get the following failure. ANR8855E ACSAPI(acs_eject_volume) response with unsuccessful status, status=STATUS_CAP_IN_USE.

Re: Problem with delete volhist type=dbb

2004-08-26 Thread Kauffman, Tom
We don't do the DRM stuff (we're che/// frugal and didn't want to pop the money way back when) and with this exception, our processes have worked flawlessly. And it just dawned on me how to fix this one. I think my brain has fossilized or something. My previous challenge was to keep the database b

Re: Select on tsm server version?

2004-08-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Christian Bagard >It's amazing but no! We have looked for it. >You can get versions of nodes from NODES table but not for server. It's not in the STATUS or SERVER tables, either. Weird. -- Mark Stapleton ([EMAIL PROTECTED]) Ber

Re: Select on tsm server version?

2004-08-26 Thread Christian Bagard
Hi, It's amazing but no! We have looked for it. You can get versions of nodes from NODES table but not for server. Best regards Christian Bagard email : [EMAIL PROTECTED] SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France www.sos-restore.com (only in french, sorry) - Original

Re: Windows 2003 Storage Server

2004-08-26 Thread Doug Thorneycroft
Yes, I'm running ITSM 5.2.10 Client on an HP NAS. It is working just like any other Client. Doug Thorneycroft County Sanitation Districts of Los Angeles County (562) 699-7411 Ext. 1058 FAX (562) 699-6756 [EMAIL PROTECTED] -Original Message- From: Imre Kloknicer [mailto:[EMAIL PROTECTED

Re: TSM migration from 5.1 to 5.2

2004-08-26 Thread Lawrence Clark
Oh, you would NOT do an auditdb because it runs a very long time >>> [EMAIL PROTECTED] 08/26/2004 9:41:08 AM >>> Just curious Why would you not do an audit DB and what all does an audit DB do? -Original Message- From: Henrik Wahlstedt [mailto:[EMAIL PROTECTED] Sent: Th

Re: TSM migration from 5.1 to 5.2

2004-08-26 Thread Lawrence Clark
Checks the internal consistency of the data and fixes/ resolves inconsistencies. I recall this was recommended when we upgraded from ADSM 3.0 to TSM 4.0. At the time we were told that if the upgrade process found problems with the database when the database upgrade was in process, the upgrade would

Re: Problem with delete volhist type=dbb

2004-08-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kauffman, Tom >I'm using a dedicated pool of tapes for off-site database >backups, which seems to be working OK - almost. The problem is >that the delete volhist returns the tape to scratch status, >making it available to the

Problem with delete volhist type=dbb

2004-08-26 Thread Kauffman, Tom
I'm using a dedicated pool of tapes for off-site database backups, which seems to be working OK - almost. The problem is that the delete volhist returns the tape to scratch status, making it available to the next process that wants a scratch tape. 15 days later (my rotation) the database backup fai

Windows 2003 Storage Server

2004-08-26 Thread Imre Kloknicer
Hi, Is Windows 2003 Storage Server supported by TSM? Is there anyone who backs up data stored on a NAS with Windows 2003 Storage Server? I'm looking for some experience but I didn't really find anything on the net. Regards, Imre

Re: Running periodic Full backups

2004-08-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Dourado >I have used MOVE NODEDATA and included all nodes associated >with a particular non-collocated tape pool, the advantages >are obvious. > >Is there any advantage in using MOVE NODEDATA with co-located nodes ? No

Re: TSM migration from 5.1 to 5.2

2004-08-26 Thread Park, Rod
Just curious Why would you not do an audit DB and what all does an audit DB do? -Original Message- From: Henrik Wahlstedt [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 8:34 AM To: [EMAIL PROTECTED] Subject: Re: TSM migration from 5.1 to 5.2 No! I would not do an audit db

Re: TSM migration from 5.1 to 5.2

2004-08-26 Thread Henrik Wahlstedt
No! I would not do an audit db if I dont have been told to do one by IBM support, or if I have strong evidence that I need to do an audit. The upgrade itself does not require an audit db! //Henrik |+-> || Lawrence Clark | |

Re: Running periodic Full backups

2004-08-26 Thread Bill Dourado
I have used MOVE NODEDATA and included all nodes associated with a particular non-collocated tape pool, the advantages are obvious. Is there any advantage in using MOVE NODEDATA with co-located nodes ? Is there any advantage in using MOVE NODEDATA over reclamation for co-located nodes ? Bi

Re: Connection of TSM DB to Other Softwares

2004-08-26 Thread Dale Jolliff
A simple way to extract information from the TSM DB is to do selects from each table using -commadelimited output -- it will import directly into most Databases as CSV is a pretty universal format. My question would be why are you trying to re-invent the wheel? Lawrence Clark <[EMAIL PROTE

TSM migration from 5.1 to 5.2

2004-08-26 Thread Lawrence Clark
Hi: We are getting set for the migration from TSM 5.1 to 5.2. For people who have already done this, did you precede the install of the 5.2 software with an 'audit db fix=yes'?

Re: Connection of TSM DB to Other Softwares

2004-08-26 Thread Lawrence Clark
Do you have a more specific explanation of what you are trying to do? You can use the supplied ODBC client and connect to the TSM DB via ACCESS for query purposes, but not update. You could put some sort of application interface in front of that. >>> [EMAIL PROTECTED] 08/26/2004 9:00:19 AM >>> Dea

Re: Connection of TSM DB to Other Softwares

2004-08-26 Thread Barnes, Kenny
Tivoli Storage Manager for Windows installs an ODBC plug-in. I use it to run against the TSM database using MSAccess. Kenny Barnes Systems Analyst GmacInsurance 336-770-8280 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Sujay

Re: Running periodic Full backups

2004-08-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Cargill, Bill > Does anyone know how to easily force a full backup? I know >about changing the management class attribute copymode to >absolute. What I'm trying to do is run a monthly full backup >to improve our restore perfor

Connection of TSM DB to Other Softwares

2004-08-26 Thread Sujay Dinakar R.
Dear All, Does any one know how to connect the TSM Database, to make a personnel catalog using the existing database. Regards Sujay Dinakar R. Regards Siujay Dinakar R. - Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages!

Re: Licensing

2004-08-26 Thread David E Ehresman
Yes, the node that used to be lan free is still an active node and still has (lots) of data on tsm. It just does not use lan free anymore. The Server definition for the storage agent that the lan free client used to use was removed from tsm over a year ago. David >>> [EMAIL PROTECTED] 8/25/2

Re: Running periodic Full backups

2004-08-26 Thread Bill Boyer
What about running image backups? There's a section of the client manual discussing image backups and incrementals for restore/recovery. Bill Boyer "A Life? Cool!! Where can I download one of those?" - ??? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf O

Select on tsm server version?

2004-08-26 Thread Henrik Wahlstedt
Hi, Is there a table where TSM holds it´s server version that I can use in a select statement? I know I get the info from q stat but I rather not do that on 1+ servers. //Henrik --- The information contained in this message may be C

Re: Running periodic Full backups

2004-08-26 Thread John Naylor
Maybe, worth another think about this Are tape mount delays really the problem ? If you have tape robot this is rarely a major factor in slow restores, Usually it is the network or the client that is the bottleneck Have you looked at the restore session stats. If you really think that tape mounts a

Re: How to see what files are being backed up.

2004-08-26 Thread PAC Brion Arnaud
Jason, Give the undocumented command "show version" a chance. Use it on TSM server like "show version node_name /filespace_name" or if this doesn't work "show version node_name XX nametype=fsid", with XX beeing the targeted FSID found with "q fi node_name". This command will show you all files bee

Re: How to see what files are being backed up.

2004-08-26 Thread John Naylor
Something like this SELECT HL_NAME,LL_NAME FROM BACKUPS - WHERE NODE_NAME='YOURNODE' - AND BACKUP_DATE BETWEEN '2004-08-25 18:00' AND '2004-08-26 08:00' Jason Couto <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 25/08/2004 19:32 Please respond to "ADSM: Dist Stor M