My manager came to me today with an interesting problem: It appears that
the event logs that are sent to him at 8am, and again at 5pm, differ in that
the second lacks some events reported on the earlier server.
As far as I can tell, this may be because I made a change to the schedule in
question
How do I determine how many physical slots my 3494 library has?
How do I determine how many tapes are offsite?
How do I determine how many tapes total I have?
How do I determine the average capacity per tape?
Thanks for any help,
Dan.
Very helpful answers, Joshua. All were right on the money.
I have two questions though:
1: Which table contains the data "estimated capacity". I want to create an
SQL statement to find out how much average I'm getting out of each tape.
2: Where can I find a man page for mtlib? (A previous
How do I find out the total storage used by a node, and what are the best
ways to break that down into
useful information as to what is making up that total?
I've got a node that appears to be taking up more space than it should, and
need to find out why.
Brian, my ADSM server choked on your SQL statement... it didn't like the
"as". However, I did work this out on my own:
select node_name, sum(capacity * (PCT_UTIL/100)) from filespaces group by
node_name
It works the way I want it to, but I'd like to round the result... I tried a
few obvious syn
Brian, your SQL statement worked like a charm, however, I am having trouble
reconciling the difference between the following outputs, which I think
should be the same:
adsm> select total_MB from auditocc where node_name='U1_APPS'
TOTAL_MB
---
7396917
---AND---
adsm> select node_name, c
doesnt do any percentages and so on - so just for a set of
> totals
> my command works ok and the figures are ok
>
> Regards,
>
> Brian Johnson
> 212 647 3557
>
> > -Original Message-
> > From: Daniel Swan/TM [SMTP:[EMAIL PROTECTED]]
> > Sent: Wedn
Here's the deal, we've got tons of tapes offsite, that are recalled daily as
the data expires, and tapes are reclaimed. Unfortunately, we've ran out of
space inside of the tape library, and are unable to put the tapes back in,
and the tapes are sitting beside the library.
Each day, a list is gen
> -Original Message-
> From: Walker, Lesley R [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, September 26, 2000 9:35 PM
> To: [EMAIL PROTECTED]
> Subject: How long does a HALT take?
>
> I suppose it's like asking "how long is a piece of string", but, here's
> the
> question:
>
Mi
For archives, see: www.adsm.org
> -Original Message-
> From: Claudio Cofre Caro [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 28, 2000 8:48 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Database Corrupted after Full Restore (TDP for Exchange)
>
> Hi Del,
>
> The FIXTEST 1.1
How can I track client restores from a cental location?
u may look at them:
>
> q restore
>
>
> --
> Joshua S. Bassi
> Senior Technical Consultant
> Symatrix Technology, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Daniel Swan/TM
> Se
To keep on top of backup failures, I have written a small perl scrip that
does a "q ev" every ten minutes, and pages me if there is an exception. It
has just ocurred to me, however, that often backups do not become
marked as an exception until long after they were expected to start.
In the case
Regarding restores, I'd like to thank everyone for their input. I have no
found out how to determine
when a client asked for a restore, and how much data was transferred, but I
am unable
to tell WHAT was transfefred, and hold old the data restored was.
Is there any way to glean this data from a
Does anyone have any ballpark statistics on the average age of files that
are being restored?
That is, I am curious to see if a file is most likely to be restored one day
after creation, one week, two weeks, or six months.
Any data, speculation, or statistics appreciated.
Daniel Swan
HP Unix T
I've calculated my capacity as follows, but the numbers don't jibe. Here
are how I calculate.
1) Total offsite: select count(*) from drmedia
2) Total tapes: select count(*) from volumes where devclass_name='DEV3590'
3) Total Scratch: select count(*) from libvolumes where status ='Scratch'
4)
Yes, and Richard Sims posted an excellent script here last week which well
help read the data-rich dsmaccnt file.
Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 403-530-1726
fax: 403-530-1066
> -Original Message-
> From: Anton Herrero, Angel [SMTP:[EMAIL PRO
It could be that the backup took longer than it's assigned duration... this
one always annoys me, as it sends the managers into a frenzy when they get
their reports. I'd much rather it say 'warning' or some such thing.
Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 40
Gents and ladies, I'd like an idea of how many exceptions you see on a
daily basis, how many clients total you have, as well as
the degree of flux your site is in.
My own site is in constant flux, with upgrades/migrations going on
constantly, and a couple of new nodes per week. I get about 1 ex
Although I agree with the seniment of throwing it out, you may want to trade
it in... I know we keep out tapes, as some manufacturers guarantee forever,
and will replace (At least from what I have been told).
At $100 per tape, it's a quick way to save some ADSM bucks.
Daniel Swan
HP Unix Team
For the sake of capacity planning, I'd like to monitor my drive usage, and
find out at what times we are maxed, and for how long. I'm thinking a combo
of a cron job that does a 'q mount' every 10 minutes, to gather the
information, and then using gnuplot or excel to plot it.
But before I go abou
I've noticed that after time, my HP-UX 11 servers build up stale 'dmstat'
processes that havn't been used in several days.
Anyone have any idea what these are, and why they don't go away on their
own?
A fellow I know works for a consulting company the specializes in the
installation and configuration of backup hardware and software has worked
with both products.
When asked which is superior, he says "off the record... adsm by far is
superior".
OTOH, netbackup may be better suited to smaller e
My manager say's he's gonna buy me an ADSM mentor for Xmas, if I can track
one down.
I'm unable to provide any info as to reloc allow, salary, but these details
can be worked out. Reply to sending address if interested.
An imperfect way is to have another file elsewhere contain the passwords,
and have your korn shell script read the file.
$pass=tail -1 /var/tmp/dsmaccess
$user=head -1 /var/tmp/dsmaccess
dsmadmc -id=$user -pa=$pass
> -Original Message-
> From: Ruth Robertson [SMTP:[EMAIL PROTECTED]]
This weekend, our ATM segment will be retired, and we will be falling back
on our 100MB Ethernet.
Our server is constantly doing backups, and generally carrying a high load.
Our local network architect doesn't think this will have a significant
impact, but I am unconvinced.
Does anyone out ther
I'm going to be signing off the list later this afternoon, but just want to
take a moment to say 'bye' to everyone.
I'd like to thank everyone on this list for all of the help and guidance
you've given. I've been very impressed with the
level of skill and professionality on this list. In the ne
Agreed, Shekhar... I have received incredible useful advice from many people
on this list. Too many to thank individually.
It will be a pleasure to contribute some knowledge back as I get more
experience.
Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 403-530-1726
fa
I'm re-engineering our schedule, and I'd like to dedicate blocks of time to
particular tasks. I think I have a rough understanding of what
I require, but please tell me if I am missing anything. Of course, you
folks don't know my exact requirements, but if anything jumps out at your
that seems
Today I've been learning SQL to help gather info about my ADSM setup, and
I'm absolutely ecstatic it's power and flexibility.
A week ago, a 'SQL for ADSM' cheat sheet would have been indispensible to
me, but I didn't know of one. Does such a thing
exist? If it doesn't, I think I'll write one up
delete filespace nodname filespacename
or
delete filespace nodename *
But be careful... typos can cost you.
Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 403-530-1726
fax: 403-530-1066
> -Original Message-
> From: Ken Sedlacek [SMTP:[EMAIL PROTECTED
I'm a fairly new ADSM admin with a Unix background, and the NT team has been
insisting that ADSM doesn't backup
open files, and that an add-on product is required to do so. This seems
quite odd to me, but perhaps they know something I don't.
OTOH, perhaps they have confused open files for runnin
Isn't Signal 11 typically a symtom of bad memory, i/o timing, or other
hardware flakiness?
Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 403-530-1726
fax: 403-530-1066
> -Original Message-
> From: Fluker, Tom R [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, Augus
I am presently reviewing our backup policies, and I see that we are using
SHRSTATIC, but it seems to me it
would make more sense to use SHRDYNAMIC, which eventually forces the backup
of open files.
Is there a reason not to use SHRDYNAMIC?
Best regards,
Dan.
I don't think I'd ever suffer Disaster Recovery Manager Withdrawl,
but if you do, there are treatments available.
up while open the first time.
>
> Kelly J. Lipp
> Storage Solutions Specialists, Inc.
> PO Box 51313
> Colorado Springs CO 80949-1313
> (719) 531-5926
> Fax: (719) 260-5991
> Email: [EMAIL PROTECTED]
> www.storsol.com
> www.storserver.com
>
>
> -Original Mess
, and why?
Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 403-530-1726
fax: 403-530-1066
> -Original Message-
> From: Kelly J. Lipp [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 15, 2000 10:39 AM
> To: 'Daniel Swan/TM'; [EMAIL PR
Using the QUERY EVENT command, I see a list of completed, missed, and failed
backups.
I assume that the 'missed' are due to a defunct/inactive client scheduler,
or a loss of connectivity to the host.
Are there other possible reasons, perhaps scheduling oriented or otherwise,
to explain why a cli
AIX Virii do exist, but mostly in development scenarios, or virus 'zoos'.
Getting them to spread is problematic, because:
A) Most software is provided by the vendor, not 'borrowed from my buddy
jake', or downloaded from the ftp site at 'warezpirates.com'.
B) AIX servers tend to exist as island
Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 403-530-1726
fax: 403-530-1066
> -Original Message-
> From: Fenstermaker,Bob [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, September 08, 2000 10:22 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MS Exchange Increment
My org has determined that they'd like to incorporate ADSM into our existing
alert infrastructure. I figure it's a matter of parsing the event log,
formatting the
information, and writing it to a logfile. The logfile is then read by a
daemon, and
forwarded to the Alert/Logging server. Failed/m
I have a nodename, prodwf01, that backs up successfully each day.
However, the hostname 'prodwf01' isn't resolved by either DNS, nor does it
exist in the
host file. The client scheduler is set to 'prompted'.
How the heck is ADSM getting in touch with prodwf01? How is the nodename
resolving to
We had a similar, *HELLISH* connectivity problem at my site... it was a
massive pain in the butt
to pinpoint, much less diagnose.
The symptoms were many concurrent SQLbacktrack connexions that would
initiate, and die, within one second, and then re-initiate, and re-die.
This would go on for hour
; > server? This is located in the dsm.opt file (or dsm.sys) on the client
> > machine.
> >
> >
> > Regards,
> >
> > Sean M. English
> > Distributed Support Services/ADSM
> > IBM Global Services South, Charlotte, NC
> >
> >
> >
44 matches
Mail list logo
