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 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 s
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
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 'u
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 ru
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 8
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 info
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
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, count(d
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
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 v543
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
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 pa
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 INVENT
Avy,
I tried your query on my machine and it has worked fine.
See results:
~~
AUCFTSM01_PROD>select 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
vu.node_name
.
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
16 matches
Mail list logo