Hi Luc,
For documentation on SELECT commands and options;
TSM provides a subset of SQL for querying it's database. The SELECT
commands are generally the same as SQL SELECT commands, so looking at
SQL docs will help there.
Also, 'help select' on the TSM server may help a little.
To see what
I have been experimenting with a virtual tape library connected to TSM
(Windows 2k3 5.1.6.3 server)
All seems to work perfectly and TSM is none the wiser. However, The
maximum cartridge size in this virtual library is 2GB. I am currently
using LTO1 and getting upto 100 times this amount of
On May 19, 2005, at 4:34 PM, Luc Beaudoin wrote:
Is there a document for all the SELECT commands and options ...???
In http://people.bu.edu/rbs/ADSM.QuickFacts see topics Select and
SQL, and the SQL references near the bottom of the QuickFacts.
Your server install also provided you with a
On May 19, 2005, at 5:05 PM, David Nicholson wrote:
...The Intel folks tell me they
recently turned on O/S level Auditing of the DATA drive on almost
all of
the Windows servers. ...
This is an issue for site management to address. If those wonderful
Windows administrators capriciously made a
On May 19, 2005, at 4:35 PM, Sung Y Lee wrote:
The value for tcp_name does not appear to be depended on the
dsm.sys/dsm.opt.
Anyone else seeing samething I am seeing?
See the client manuals' description of the Nodename option, which
explains derivation.
Earlier TSM client programming leaves the
have a server with over a folder that has about 860,000 text
files that had been created by an application when the users
were trying to debug a problem, i hadnt coded the excude
for the files originally since i wanst aware that there were being
created and that there were so many of them
i
Hi Rich,
For the record, this change was communicated we just didn't fully
appreciate the impact it would have.
Thanks for your concern.
Dave
Richard Sims [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
05/20/2005 07:13 AM
Please respond to ADSM: Dist
THANKS WANDA!! Your awesome...sure is nice to know what is going on!
It all makes perfect sense...now... :(
Based on what little I know about OS Level Auditing, I am thinking
this is a 1 time blip for all the servers to get backed up because of this
attribute change,
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
Behalf Of David Nicholson
For the record, this change was communicated we just
didn't fully
appreciate the impact it would have.
A bit OT, but we're seeing this more and more these days. Administrators
who don't *really*
== On Thu, 19 May 2005 08:38:38 -0400, Richard Sims [EMAIL PROTECTED] said:
Recovery is documented in the Admin Guide topic Restoring Your
Server Using Mirrored Volumes.
I've been unable to find docs on starting a server on only one half of a
mirror. Anybody ever done this?
For most of the
I have two tapes that are in volume history as status Remote. The
instance
of TSM they are supposedly remote on no longer have any information about
these volumes. When I try to enter them as scratch, they are rejected:
ANR8443E CHECKIN LIBVOLUME: Volume 110330 in library 3584LIB cannot be
Hi,
Most VTL's that I have encountered emulate a real tape drive (ie. Brand
and model) and thus their cartridge size is based on this (ie. 200 GB
for LTO1, etc). I would find out why this vtl has this limitation.
As to the db growth, others may have a better idea, but I have always
found that
Allen,
As I understand it, the list of all db and log volumes is maintained on
each and every db and log volume. The dsmserv.dsk file only needs to point
to one of these volumes. When TSM comes up, it will read that volume,
obtain the full list, and access the others. Someone from IBM can
On Fri, May 20, 2005 at 08:39:58AM -0500, Andrew Carlson wrote:
I have two tapes that are in volume history as status Remote. The
instance
of TSM they are supposedly remote on no longer have any information about
these volumes. When I try to enter them as scratch, they are rejected:
On Fri, 20 May 2005 09:02:29 -0500, Bob Booth - CITES [EMAIL PROTECTED]
wrote:
On Fri, May 20, 2005 at 08:39:58AM -0500, Andrew Carlson wrote:
I have two tapes that are in volume history as status Remote. The
instance
of TSM they are supposedly remote on no longer have any information
about
these
There is no useful data on the tape - it is gone from the remote TSM
instance. I could
check it in as private, but then what? It ultimately needs to be scratch.
Check it in as private, then 'del vol xx discarddata=yes' to get rid of the
data obsolete data references.
David Ehresman
== On Fri, 20 May 2005 09:44:58 -0400, Paul Zarnowski [EMAIL PROTECTED] said:
Years ago, I actually went through the scenario you describe. We split the
DB mirror, and brought up TSM on only half of the mirrors, while we ran an
auditdb on the other half of the mirrors.
[ And I mused about
You can do a delete volume ## discard=yes. This will delete all
references to data on that volume from the TSM database.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Carlson
Sent: Friday, May 20, 2005 9:15 AM
To: ADSM-L@VM.MARIST.EDU
There is an excellent document on using TSM with SQL in Appendix A of
the TSM 5.1 Technical Guide.
Go to www.redbooks.ibm.com and search on SG24-6554.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Warren, Matthew (Retail)
Sent: Friday, May 20,
On Fri, 20 May 2005 09:24:08 -0500, David E Ehresman
[EMAIL PROTECTED] wrote:
There is no useful data on the tape - it is gone from the remote TSM
instance. I could
check it in as private, but then what? It ultimately needs to be
scratch.
Check it in as private, then 'del vol xx
Based on what little I know about OS Level Auditing, I am
thinking
this is a 1 time blip for all the servers to get backed up because of
this
attribute change, but once I get through this initial backup things
should
return to normal for me . is this a correct assumption?
That's
Anyone backing up one of these?
I'm getting the impression that it's just a Windows box tuned for file
sharing, and that a regular TSM Windows client will do nicely for backing
it up...but I'd like to hear from anyone else who's done it.
Also, anyone know if it is NDMP capable? I didn't find
In TSM for Databases, each backup file has a unique name and rman is
responsible for deleting them, thus triggering the TSM expiration cycle.
Does Backtrack work the same way?
[EMAIL PROTECTED] 05/19/05 2:34 PM
Hi:
We've just discovered q peculiar problem with expiration involing the
On Fri, 20 May 2005 09:27:39 -0500, Ochs, Duane [EMAIL PROTECTED] wrote:
You can do a delete volume ## discard=yes. This will delete all
references to data on that volume from the TSM database.
I had the volume checked in. The volume now shows up in q libv:
tsm: TSMLIBMq libv 3584lib 110544
We have two clients on NT boxes with oracle databses. (One TSM install).
One is the flat file backup, the 2nd with its own dsm.opt file is for
SQl-BACKTRACK.
We cannot query the backups on SQL-BACTRACK since the dsmc invokes with
the flat file client dsm.opt ( and hence can't do a set access for
Yes, SQL-BACKTRACK is responsible for updating the status of the
uniquely name file.
[EMAIL PROTECTED] 05/20/2005 10:43:53 AM
In TSM for Databases, each backup file has a unique name and rman is
responsible for deleting them, thus triggering the TSM expiration
cycle. Does Backtrack work the
When our array went down, we were able to simply start TSM. It came up with
half of the mirrors off-line and ran fine. We did not do anything special.
I do not know were it is documented.
Andy Huebner
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
On Fri, May 20, 2005 at 09:59:06AM -0500, Andrew Carlson wrote:
On Fri, 20 May 2005 09:27:39 -0500, Ochs, Duane [EMAIL PROTECTED] wrote:
You can do a delete volume ## discard=yes. This will delete all
references to data on that volume from the TSM database.
I had the volume checked in.
Hello *SM'ers,
Has anyone observed the following;
We are experienceing performance problems with LanFree backups. The
issue goes away with a retsart of the storage agent, but at some point
in the future comes back, requiring another restart of the stoarge agent
etc..
Now, when the backups are
Hi all
Quick question, which I know is in the manuals somewhere, but I need a
quick answer and don't have time to look just now, so was hoping someone
could point me in the right direction..
If I deployed multiple TSM servers all sharing the same Library, do they
all have their own
If not clustered, they have separate databases and configured
separately. One owns the library to the extent that it controls the
robot. At least that is my understanding. I haven't done it.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Jon
Yes, they should be having their own databases and data movement
between them has to be done using export/import commands...
rgds,
Aleem
On 5/20/05, Jon Evans [EMAIL PROTECTED] wrote:
Hi all
Quick question, which I know is in the manuals somewhere, but I need a
quick answer and don't
I guess chlv -n ... would work. In our environment, the /dev/r... files
are owned by the same userid that runs the TSM server image that accesses
them, so we just had to change the ownership of these (as I recall - it was
many years ago).
At 10:25 AM 5/20/2005, Allen S. Rout wrote:
== On Fri, 20
Yes, that is correct. Each TSM server has it's own database.
At 12:08 PM 5/20/2005, Coats, Jack wrote:
If not clustered, they have separate databases and configured
separately. One owns the library to the extent that it controls the
robot. At least that is my understanding. I haven't done it.
Hello everyone!
I run the report below to see the level of our nas toc disk pool and I was
wondering if there is a way to also have another column called GB Utilized
which multiplies total gb x percent utilized? I have tried this in so many
different ways and I have not been successful. I'm not
Hi All,
I received a weird request from potential customer. Because we will
charge him per space occupied on our server, he wants to backup only
files less than a year old. He doesn't want to go into each folder and
try to find files that meet the criteria. I know that Arcserve has that
filter
A 2 GB limit seems a bit restrictive, I wonder if that is a file system
limit on the VTL. My VTL has no such restriction. When I installed my
VTL I did not notice any change in TSM DB size due to an increase in the
number of volumes. The amt of data per volume seems minimal.
H. Milton
Sure, just add a column that multiples the two columns together
(est_capacity_mb * pct_utilized) and divide by 1024.0 to get GB, and again
by 100 (to express the pct_utilized as a fractional value):
cast(est_capacity_mb * pct_utilized / 102400.0 as decimal(6,0)) as Used
GB
Regards,
Andy
Andy
Try this,
select stgpool_name as Storage Pool,cast(est_capacity_mb/1024 as
decimal(6,0)) as Total GB,pct_utilized as Percent Utilized,
cast((EST_CAPACITY_MB*pct_utilized/100/1024) as decimal(15,2))
total_data_by_GB from stgpools where stgpool_name='NAS_TOC'
I will throw out one i use for list of
Thanks Andy! It worked like a charm! I appreciate the help!
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]
Andrew Raibeck
[EMAIL PROTECTED]
OM
There is no filtering option in TSM to do this.
Using the age of a file to determine whether to back it up is, in my own
opinion, ill-advised. If the customer does not care to back up these
files, then why not simply cut to the chase and delete them? After all,
if the disk were to be lost
On May 20, 2005, at 1:30 PM, Joe Crnjanski wrote:
Hi All,
I received a weird request from potential customer. Because we will
charge him per space occupied on our server, he wants to backup only
files less than a year old. He doesn't want to go into each folder and
try to find files that meet the
Have you tried 'dsmc -virtualnode= . . .'?
[EMAIL PROTECTED] 05/20/05 11:02 AM
We have two clients on NT boxes with oracle databses. (One TSM install).
One is the flat file backup, the 2nd with its own dsm.opt file is for
SQl-BACKTRACK.
We cannot query the backups on SQL-BACTRACK since the dsmc
Then, since TSM see them all as still active, I'd guess that Backtrack is not
expiring the files.
David
[EMAIL PROTECTED] 05/20/05 11:05 AM
Yes, SQL-BACKTRACK is responsible for updating the status of the
uniquely name file.
[EMAIL PROTECTED] 05/20/2005 10:43:53 AM
In TSM for Databases,
Any clues in the dsmerror.log?
[EMAIL PROTECTED] 05/20/05 11:41 AM
Hello *SM'ers,
Has anyone observed the following;
We are experienceing performance problems with LanFree backups. The
issue goes away with a retsart of the storage agent, but at some point
in the future comes back, requiring
We've attached a new NAS to an existing TSM system, with a 3584 and 6
3592s. Following the steps in Chapter 6 of the Admin Guide, everything
went smoothly until step 6, Defining Tape Drives and Paths. Since the
drives already exist in TSM it looks like all I should have to do is define
the path
Andy, et al.
I have no solution, but found your email thread as I'm looking to solve
exactly the same problem. It's a tough nut to crack!
We have 6 tapes in a shared 3584 w/ exactly that problematic status:
The Library Mgr TSM's VolHistory shows tape as PRIVATE,REMOTE owned by other
TSM, but the
47 matches
Mail list logo
