Re: how to tell how my DB is being backed up

2008-04-01 Thread Len Boyle
Hello Damon You can use a command like this to find out when the backup command is running. Then run a query actl with a small delta of time less then the time reported and you should see the method used to issue the command. As the backup command can be shorted to BA you might have to vary the

Why the wait time on this export?

2008-04-01 Thread Evans, Bill
This Export finally completed, however, I can't figure why it was waiting so long for a volume. (Waiting for input volume(s): B00580L3,(58779 Seconds)) Any ideas on where to look? Two libraries, 20 LTO3 drives, There was not much happening at the time, backups had completed already. TSM Server

Re: Top 20 (or so) misunderstood things about TSM

2008-04-01 Thread Richard Mochnaczewski
The difference between a backup and an archive. Rich -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Andy Huebner Sent: Tuesday, April 01, 2008 2:29 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Top 20 (or so) misunderstood things about TSM #1 -

Re: Top 20 (or so) misunderstood things about TSM

2008-04-01 Thread Andy Huebner
#1 - A TSM incremental backup is equivalent to a full backup by traditional products. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Curtis Preston Sent: Monday, March 31, 2008 4:49 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Top 20

Re: ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Bill Boyer
Sorry but I already backed it off to the 532 version. I did several uninstalls and removed the data source to have AV recreate it. Sent from my Verizon Wireless BlackBerry -Original Message- From: Andrew Raibeck <[EMAIL PROTECTED]> Date: Tue, 1 Apr 2008 09:49:16 To:ADSM-L@VM.MA

Re: ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Andrew Raibeck
Hi Bill, FYI, there is no dependency between ODBC driver and installed TSM client. The ODBC driver is a self-contained entity. So at least for the purposes of ODBC, changing client levels has no effect. I have seen this reported by several customers, but we are unable to recreate this in the lab.

Re: ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Bill Boyer
No we have it running at multiple sites on different levels of the client with no problem. I backed it off to 5320 and it now works. I did several installs and uninstalls of the 535 code with reboots with no luck. 532 is working and I will just leave it alone for now. Sent from my Verizon Wirel

Re: how to tell how my DB is being backed up

2008-04-01 Thread Damon Jongbloed
Thanks for the help - I couldn't remember the q sched t=a stuff. I found the schedule that it is using now I'm just having trouble finding the acutal scripting that it is using to do the back up Damon Jongbloed Associate Database Administrator Jennie-O Turkey Store

Re: ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Howard Coles
You need to update the client to match if you haven't already, otherwise it will not work. Not only that but it could very well be an Autovault problem, Autovault tends to be version specific. We ran it at one site, but didn't keep it. See Ya' Howard > -Original Message- > From: ADSM: Di

Re: how to tell how my DB is being backed up

2008-04-01 Thread Howard Coles
Do a "q volhist type=dbb" and possibly "q volhist type=dbsnapshot" and you'll see what volumes are being used, which will also reveal whether your doing all fulls, or a combo of full and incrementals. You can also "q db f=d" and it will show when the last backup completed. Then you'll need to loo

Re: how to tell how my DB is being backed up

2008-04-01 Thread Choudarapu, Ramakrishna (GTI)
DB backup is normally done using admin schedules. Check with Q SCHED T=A F=D, you may find an admin sched which runs BACKUP DB command. Q VOLHIST T=DBB will display the database backup volumes. Q DB F=D will indicate when the last backup of DB was taken and how much of DB was changes since the las

Re: how to tell how my DB is being backed up

2008-04-01 Thread Neil Sharp
Damon >From the TSM Admin command line run 'query db'. This will display the date when the DB was last backed up and whether there is a backup in progress On 01/04/2008, Damon Jongbloed <[EMAIL PROTECTED]> wrote: > > > I am wondering if anyone can tell me if there is an easy way to tell how > my

ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Bill Boyer
I have Autovault running on aa Windows2000 server with an old 5.1 client and ODBC drive. I upgraded the ODBC to 5.3.5 and the thing just stopped working. I don't think it's an Autovault issue. Turning on the ODBC trace I see the error. Unfortunately this server doesn't have Excel loaded. Tue Apr

how to tell how my DB is being backed up

2008-04-01 Thread Damon Jongbloed
I am wondering if anyone can tell me if there is an easy way to tell how my DB is being backed up. I can tell that I am keeping 4 copies of it but I don't know how it's being backed up. I'm sure it's being done via a script but I can't find out where it's at. Any help would be greatly apprecia

Re: Restoring files from backupsets with TOC

2008-04-01 Thread Andrew Raibeck
Hi Bill, Yes, TOC support for backup sets was first introduced in TSM version 5.4. (It actually first appeared in TSM Express, and was subsequently made available in the enterprise version in 5.4.) Best regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Developm

Re: Top 20 (or so) misunderstood things about TSM

2008-04-01 Thread Howard Coles
1. Retention - how it works and why, which would include variations introduced by various Data Protection agents. (tape verses file, active vs. inactive, live verses deleted, incremental forever, SQL Server Retention vs ORACLE Retention vs Exchange, or file). 2. Archive vs. Backup in TSM. 3. Mo

Restoring files from backupsets with TOC

2008-04-01 Thread Bill Dourado
Hi, We have just upgraded our Windows TSM Server to 5,4,2, and I have successfully generated a backupset with TOC for a Windows Client V5.3.0.0 Node Name: S2632 Backup Set Name: E_31_03.192721067 Data Type: File Date/Time: 03/31/

Re: Deleting and Adding nodes.

2008-04-01 Thread Jeff White
Our policy is to move the 'old' node to another domain, which in our case is called 'REDUNDANT'. Therefore i know which of the servers have been decommissioned as they are all in this domain. It also depends on your sites' retention policies, but i have the redundant domain to remove data after 180