Hi to all
In a sever Windows 2003 with SQL database I saw that a log increase very much
( to +26 GB) , it was programmed with the option Recovery Model: Full
I run every day a full backup (not any log backup) with the command:
tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt
/l
Hi,
DIRMC option could help you a lot depend on how you configure it.
Make sure you configure DIRMC to save it's data on Disk only.
Best Regards
Christian Svensson
Cell: +46-70-325 1577
E-mail: christian.svens...@cristie.se
Skype: cristie.christian.svensson
___
Hello,
Some information I've got from TSM support that can be good to know about
DIRMC don't need to be configured to back up directories to a (separate)
disk storage pool
DIRMC specifies the management class (MC) for directories to bind to.
If not specified, by default, the MC class in the ac
On Jan 21, 2009, at 4:35 PM, Fred Johanson wrote:
We've got two machines which are identical in every way, same
hardware, same AIX, same TSM level, same options set, same storage
pools, domains, everything except one has the DB and Log on local
disk. On this box things run very slowly: expirati
On Jan 21, 2009, at 8:35 PM, Cheung, Richard wrote:
Hello..
Is it possible to run a command that can show me, for a specific node,
what data has been backed up within that node, and against what
management class this data is binded against?
Conversely, is it possible to do a command that lists
http://www-01.ibm.com/software/cn/tivoli/products/download/analystreports/ar-tsm-comparing-sum.pdf
old doc from 2002, i guess netbackup would have an sql backend these
days...
WBR
Gabriel Peter
2009/1/20 Gill, Geoffrey L.
> Hi all,
>
>
>
> I am trying to put together an email stating all the
Can someone explain what the Objects rebound in the backup summary means? I
tried to Google it but didn't really fine a good explanation. Thank you
Node NameSession IDObjects InspectedObjects Backed UpObjects UpdatedObjects
ReboundObjects DeletedObjects ExpiredObjects FailedBytes MovedElapsed
On Jan 22, 2009, at 8:41 AM, Ramiro Ruiz wrote:
Can someone explain what the Objects rebound in the backup summary
means? I tried to Google it but didn't really fine a good
explanation. Thank you
SeeRebinding
in http://people.bu.edu/rbs/ADSM.QuickFacts
for a summary.
Richard Sims
Robert,
You need to run a LOG backup in order to truncate the logs.
BTW, truncating the transaction log does not reduce the size of a
physical log file; it reduces only the size of the logical log file.
To reduce the size of a physical log file, it is necessary to shrink the
file,
using, for exam
Great document, Thank you
>>>
From: Richard Sims
To:
Date: 1/22/2009 8:55 AM
Subject: Re: [ADSM-L] Rebound
On Jan 22, 2009, at 8:41 AM, Ramiro Ruiz wrote:
> Can someone explain what the Objects rebound in the backup summary
> means? I tried to Google it but didn't really fine a good
> explanati
Hello,
I am facing a very strange situation:
We have archived using TSM about 270 of data in past.Now when we try to
retrieve the data, the retrieve process runs for some hours approx 3.5
hrs,then without transferring a file dsmc process crashes with error
ANS1899I * Examined 4,625,000 files
On Jan 22, 2009, at 10:29 AM, ashish sharma wrote:
One more question:Is it true that that all TSM Unix clients are 32
bits
applications and could not address more than 4GB of memory?
No. See the client manual and IBM Technotes 1243309 and 1052223.
Your posting doesn't say exactly what client
Hi TSM-ers,
Environment:
Client: Windows XP SP 2, TSM Client 5.5.1.0 and 5.5.1.6
Server: Windows 2003, TSM Server 5.3.2.1.
DSM.OPT:
ENCRYPTIONTYPE: AES128
ENCRYPTKEY: SAVE
I understand that the encryption password is stored in the registry
using the hostname to encrypt it.
When I copy the TSM re
Hello All,
I've got a customer who uses a NAS as a repository for various log files
from many servers. These log files are organized by server, then by year
and month in the directory structure on the file space. For example, any
log file from July of 2008 will be in a directory called
...\servern
Instead of trying to deal with the naming convention of the directories, I
would create an archive file list by simply doing a file search for any
file/directory that is older than 90 days. I'm sure you can find a
windows version of "gnu find" that can do this.
Regards,
Shawn
___
In older versions of TSM "insturment:detail" used to give you diagnostic
information like this:
Detailed Instrumentation statistics for
Thread: 6328 Elapsed time 20937,580 sec
Section Actual (sec) Average(msec) Frequency used
That might work, if there weren't also other, non-log files and
directories on that share that are older than 90 days, that we do NOT want
archived and deleted.
But it's worth keeping in mind. Thanks for the suggestion!
Robben Leaf
From:
Shawn Drew
To:
ADSM-L@VM.MARIST.EDU
Date:
01/22/2009 1
Hi,
Just put the "testflag instrument:detail" in your dsm.sys or dsm.opt (or
use it as an option (whith a preceding dash) for dsmc.
Note there is now one tsminstr.report file created by operation, with
the PID appended to its name.
--
Best regards / Cordialement / مع تحياتي
Erwann SIMON
David E
Did you know the "IBM Tivoli Storage Manager: How to Migrate the Library
Manager Function" Redpaper ?
http://www.redbooks.ibm.com/abstracts/redp0140.html
--
Best regards / Cordialement / مع تحياتي
Erwann SIMON
David E Ehresman a écrit :
> I am in the process of setting up a test library manager/
SQLServer 2005 on Windows2003.
TSM Server 5.5.0.3 on Windows2003.
TDP Sql 5.5.0.0
There are 3 databases on this SQLServer that are mirrors from another (not a
cluster) and I have them specified in the DSM.OPT to be excluded. During the
BACKUP * FULL I receive errors about the status of the d
what is the best way to export data from a node to tape before
deleting the node ?
Have you considered robocopy to move the data by date and file spec to an
archive location then grabbing the whole thing with TSM?
Andy Huebner
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Robben
Leaf
Sent: Thursday, January 22, 2009 1:42 PM
I think I got it worked out. It goes a little like this:
set MONTH=%date:~4,2%
if (%MONTH%) == (01) set ARCHFOLDER=m09
if (%MONTH%) == (02) set ARCHFOLDER=m10
... etc. for all 12 months
net use W: \\IP_address\vol0 /user:username password
W:
FOR /F %%d IN ('dir /s /b %%ARCHFOLDER%%') DO (C:\path\d
If you don't go to ADMS QuickFacts *first* when you have a TSM
question, you are doing yourself a disservice. I wish Richard got paid
for this, it's superb.
On Thu, Jan 22, 2009 at 10:02 AM, Ramiro Ruiz wrote:
> Great document, Thank you
>
> From: Richard Sims
> To:
> Date: 1/22/2009 8:55 A
On Jan 22, 2009, at 6:42 PM, Steve Stackwick wrote:
If you don't go to ADMS QuickFacts *first* when you have a TSM
question, you are doing yourself a disservice. I wish Richard got paid
for this, it's superb.
Thanks, Steve. I'll send you that $10 we agreed on.
R.;-)
Hi Bill,
Take a look at the "/EXCLUDEdb=db-name" option:
The User's Guide is here:
http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=/com.ibm.itsmfd.doc/dpsql.htm
/EXCLUDEdb=db-name,...
The /excludedb parameter specifies the name of the databases to exclude
from the backu
I'm confused; TSM doesn't support restoring system state to a different
hostname, so I don't know what would be considered "working as designed" in
that case!
How are you moving the registry?
On Thu, Jan 22, 2009 at 12:12 PM, Thomas Rupp wrote:
> Hi TSM-ers,
>
> Environment:
> Client: Windows
Fred,
Mounting the filesystems containing DB and log with the dio flag can make a
huge performance difference on AIX. It bypasses all the AIX read forward
and write behind stuff. Just don't trust topas afterward as it bypasses
the stats there as well.
Regards
Steve
Steven Harris
TSM admin, S
Can that log backup be run within TDP Sql or does it have to be run
using MSSQL?
Thanks & Regards
Paul
Paul Dudley
Senior IT Systems Administrator
ANL Container Line Pty Limited
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Del Hoobler
Sent:
Thanks, Del. I'll give that a shot tomorrow, but could you explain the
difference between this and the exclude option in the dsm.opt file? I was
just reading the user's guide and maybe it's just too late after a long day,
but I don't understand the difference.
Bill Boyer
"The ride is the objective
Hi,
I have TSM Server configured on Linux Server. I have 3 client, one running
on the TSM server only and two Windows Clients on other servers.
When I am running expiration only the client data is getting expired which
is on TSM server, But it is not showing any File space related to the
Wind
What are you expecting to see Kiran, and what are you seeing that is
different to your expectation?
Steven Harris
TSM Admin, Sydney Australia
KIRAN-SYSTEMS
To
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
Hi Paul,
Here I quote from the IBM Technote:
SQL Server log truncation occurs at the completion of any BACKUP LOG statement.
When using the DP for SQL to backup the logs, this would be performed by
issuing the command:
tdpsqlc back DBName log /truncate=yes
The default for the "tdpsqlc backup ..
When I run expiration I should see file spaces related to the windows also
should run expiration .
Regards,
Kiran M
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Steven Harris
Sent: Friday, January 23, 2009 11:44 AM
To: ADSM-L@VM.MARIST.EDU
Sub
34 matches
Mail list logo
