Re: Trouble doing tsm db restore

2008-08-28 Thread Remco Post
On 28 aug 2008, at 14:49, Lee, Gary D. wrote: Howard Colse was correct. Did a db backup type=full, and restored from it ok. Now to get around the next difficulty. Totally different hardware config. My plan was to restore the db to the new server. However, the disk pools will be completely

Trouble doing tsm db restore

2008-08-28 Thread Lee, Gary D.
Howard Colse was correct. Did a db backup type=full, and restored from it ok. Now to get around the next difficulty. Totally different hardware config. My plan was to restore the db to the new server. However, the disk pools will be completely different, and it looks like you can't delete a

Command to audit DB and fix.

2008-08-28 Thread David Hensley
Running TSM 5.5.1 on Windows 2003 R2 SP2. Needing command to run an audit on my database and to fix issues. From what directory does it run from. Thanks for all help. Dave Hensley Technical Analyst McNeilus Companies, Inc. Desk: 1-507-374-8587 Cell: 1-507-244-0921 Although this e-mail and any

Re: Trouble doing tsm db restore

2008-08-28 Thread Kauffman, Tom
You CAN delete an off-line storage pool volume; you will need to specify 'discard=yes' to do it (I do it all the time at D/R). My approach, as a semi-paranoid admin, would be to start by marking all the disk storage pools read-only. Then migrate them to the next pool. And then update them to

Re: Command to audit DB and fix.

2008-08-28 Thread Remco Post
On 28 aug 2008, at 15:40, David Hensley wrote: Running TSM 5.5.1 on Windows 2003 R2 SP2. Needing command to run an audit on my database and to fix issues. From what directory does it run from. the IBM tech support person that instructed you to do an audit should have provided the command to

Re: Command to audit DB and fix.

2008-08-28 Thread Jeff White
Is this an AUDIT DB you are running or DSMSERV AUDITDB? DSMSERV AUDITDB is normally run as recommended by IBM support, who should tell you the parameters to use with it. Be aware that it can take a *very* long time to run. I ran one against a 120gb database during a DR test and stopped it after

Re: Trouble doing tsm db restore

2008-08-28 Thread Adrian Compton
Hi all The method I would use is to do a full DR recovery of the DB as you have done. I take it you are using the same library on the new system. If so then you will have to do a restore diskpools from your offsite tapes, your current tape pools will still be valid however. You can get this

Re: Trouble doing tsm db restore

2008-08-28 Thread Howard Coles
That's why I said DO NOT use the old devconfig file. However, I should have mentioned that before you do the DB Backup, empty and delete the old storage pool volumes. That makes life easier. Sorry I missed that step. See Ya' Howard -Original Message- From: ADSM: Dist Stor Manager

select statement

2008-08-28 Thread Avy Wong
Hello, The following is a select statement to provide a total data stored and tapes used per node in all storage pools. I have broken down the sql and double checked the tables and column names are all there. Can anyone see where the hangs ups are? select vu.node_name, ao.total_mb,

inactivate TDP SQL transaction logs?

2008-08-28 Thread Laughlin, Lisa
When I setup TDP for Oracle and used RMAN jobs , the transaction logs were archives ( archive deletes) and you needed to also schedule an RMAN job to inactivate the logs and synchronize between RMAN and TDP/TSM. It's been a while and my details may be fuzzy; but it doesn't seem that there is an

TSM Copy Services for Exchange 2007 Passive Node.

2008-08-28 Thread Patel, Ankur
Hi Everybody, I really need help on this. Maybe its something very simple for someone, but i am unable to resolve this Subject: [ADSM-L] TSM Copy Services for Exchange 2007 Passive Node. Target: To Backup Exchange 2007 Passive Node using TSM Copy Services. Environment: TSM Server

TSM database size?

2008-08-28 Thread Pahari, Dinesh P
Hi All, I have got a TSM server with the 80GB database size. It is already utilized above 80%. Could someone please let me know, what is the exact recommended database size by IBM? Any links with such information would be good. Kind Regards, Dinesh Pahari

Re: TSM database size?

2008-08-28 Thread Patel, Ankur
Dinesh, See if this helps. Extract from: http://en.wikipedia.org/wiki/IBM_Tivoli_Storage_Manager ITSM maintains a relational database (limit 534GB through ITSM v5.5) and recovery log (aka transaction log, limit 13.5GB) for logging, configuration, statistical information, and object metadata. DB

Re: TSM database size?

2008-08-28 Thread Wanda Prather
There is no exact recommended size, except that as Ankur said, there is a max size of 534GB. It depends on how well you can manage your data base with your existing hardware: . -You need to be able to back up the data base in a reasonable period of time; -You need to be able to run EXPIRE

Re: select statement

2008-08-28 Thread Patel, Ankur
Avy, I tried your query on my machine and it has worked fine. See results: ~~ AUCFTSM01_PRODselect vu.node_name, ao.total_mb, count(distinct vu.volume_name) as tapes, ao.total_mb/count(distinct vu. volume_name) as AVG MB/tape from volumeusage vu, auditocc ao where

Re: TSM database size?

2008-08-28 Thread Roger Deschner
. Everything Wanda said. We have a 377gb TSM database that mostly runs OK. (It only acts up when I'm on vacation.) It's on 15,000RPM SSA disks, in JBOD mode, with TSM mirroring. But you have to watch expiration closely. Basically, you have to expire as many objects as you back up, every day. Here