Re: RS/6000 AIX

2005-09-22 Thread Richard van Denzel
Aaron,

You should free up space in the / filesystem. Mksysb will create some
files in there and they cannot be created. 
The low power would probably indicate a faulty power supply or something
like that, but I really need the errpt -a information on that warning to
give you more information.

Met vriendelijke groet, With kind regards,
Richard van Denzel.
 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
AARON BECAR
Sent: woensdag 21 september 2005 20:29
To: ADSM-L@VM.MARIST.EDU
Subject: Re: RS/6000 AIX

Sorry this question is not about TSM, maybe the wrong place to be
asking, but for about the past week, every other day we are experiencing
this error.  If anyone has seen this before could you give some input?
Thank you so much.  We are running an RS/6000 on AIX I believe it is
4.3.

Here is the error message.

0512-018 mkszfile: The backup could not continue because the 20 Kbytes
of free work space on the / filesystem that are necessary were not
found.  Before you reissue this command, you should extend the /
filesystem (chfs) or free up space to provide a total of 20 Kbytes of
free work space in the / filesystem.


0512-008 mksysb: The mkszfile command failed.  Backup canceled.

Just a note also, we get warnings about low power?  Does this make a
difference?

Thanks!

Aaron


Backup strategy for Lotus Domino

2005-09-22 Thread Nicolas Savva
__


Hi to all

I need to keep my incremental backups for 3 months. What is the Backup Copy
Group i have to define?

Thanks in advance

Nicolas Savva


DB2 Redirect Restore

2005-09-22 Thread Herrmann, Boris
Hello there!

We are trying to restore a DB2 Database over SAN. The StorageAgent mount a
tape and the restore begins (creating the containers). After about 70
minutes we got the following error : An I/O error -72 occured on media TSM.


We've tried this a lot of times with the same result. Does anyone know why
this happens?

Kind regards,
Boris Herrmann


Re: DB2 Redirect Restore

2005-09-22 Thread Leigh Reed
Can you audit the primary volume that is erroring ?

If you manually offsite your copy pool tapes, can you recall the copy
pool tapes and try a restore with them.



If you know the primary volume name that it is failing on, then enter
the following



   restore volume xx preview=yes (where xx is the volume
name of the primary volume that is giving the error)



The activity log will show you the list of copy pool volumes that the
primary tape is over. If your DB2 db is fairly large then this shouldn't
be too many tapes.

Checkin the copy pool tapes, mark the primary tape in error unavailable
and submit the restore again.



Do you have a fabric for your tape SAN ?

If so, are you aware that when making changes to your fabric (Zoning), a
message called an RSCN (registered state change notification) is
broadcasted throughout the SAN. This causes all traffic to be
interrupted for a few milliseconds. SAN attached disk can recover easily
from this, however tape does not and any data that is being written at
the time is corrupted and it is a 'silent' corruption. Therefore, you do
not see it until you come to do the restore. Single large files like
db's are particularly prone to this as even a millisecond
outage/corruption and the whole file is useless.



One point, if your initial db backup was going straight to tape when the
corruption occurred, then the 'backup stg  tapepool copypool' will have
replicated the error.

If you have a fabric tape SAN, ensure all tape operation is quiesced
when making any fabric changes.



Before anybody shoots me down, there are now FC HBA's available that
offer the ADISC/PDISC function, instead of PLOGI/FLOGI upon receiving an
RSCN and if your tape devices support FCP Tape, data transfer can
recover from an RSCN. Personally, I still stop tape operation before
making changes to the fabric.





Leigh





-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Herrmann, Boris
Sent: 22 September 2005 08:59
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] DB2 Redirect Restore



Hello there!



We are trying to restore a DB2 Database over SAN. The StorageAgent mount
a

tape and the restore begins (creating the containers). After about 70

minutes we got the following error : An I/O error -72 occured on media
TSM.





We've tried this a lot of times with the same result. Does anyone know
why

this happens?



Kind regards,

Boris Herrmann


TSM client on NAS?

2005-09-22 Thread James Marcinek
Hello All,

I haven't worked with TSM on a NAS device; however I understand from reading
some TSM guides that this client is installed on IBM NAS devices and works with
NDMP. I would like to know if this client will also work on other vendor NAS
devices?

Thanks,

James


Which Tape Technology?

2005-09-22 Thread Richard Rhodes
Hi Everyone,

Currently our tape environment consists of IBM 3494 libraries with 3590H
(60gb) drives.  It's possible that we may need to greatly expand our
environment with some new libraries and drives.  This has brought up a
discussion about what tape technology we would use.  Our environment
consists of a mix of large file backups (Oracle databases), small file
backups (Netware servers) and lots of stuff in between.  If we have to do
this, I really can't see purchasing more 3590H drives with cartridges that
are only 60gb.  I would think we would want to go to the newest 3592 drives
or LTO2/LTO3.

What are your thoughts/comments/experiences with . . . . .

1)  Given our mix of large and small file backups, would LTO tape drives
work as well as our current 3590's?
2)  Does anyone have any experience using IBMs newest 3592 tape drives?
3)  If LTO, is LTO3 the way to go, or stick with older LTO2?
4)  Or, should we stick with 3590 drives?

With any of the new tape drives, I'm concerned with throughput issues.  The
newest drives (3592 and LTO3) are so fast that I wonder if it becomes a
problem keeping data streaming to them.  The capacity is great, but if I
can't keep them spinning I wonder if the new drives could cause more
problems than they solve.

Of course, another option would be a VTL or just local DISK on the TSM
server.  We've done some initial pricing of some configurations (tape
libraries/drives/tapes,  disk, and vtl) and so far tape is the least
expensive.

Just looking for others experiences with this kind of decision . . . .

Thanks!

Rick


-
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is
strictly prohibited. If you have received this communication in error,
please notify us immediately, and delete the original message.


Exchange backups

2005-09-22 Thread LeBlanc, Patricia
 I recently turned on compression for my exchange backups.  All backup
times improved, with the exception of two servers who are now taking 2
hours longer to backup.

Clients are w2k3.  TSM Server is AIX.

Anyone using compression on exchange?


TDP For Exchange performance

2005-09-22 Thread Rane, Yashwant
Hi,

TDP Exchange 5.2.2, Windows 2003/Exchange 2003, TSM Server 5.2.2.5, Tape
Drive 3590. LAN 1Gbps.

We do full exchange backup using TDP everyday of size 300GB over LAN to
tape drive 3590 and getting a Throughput rate:  14 Mb/sec.

 

Is there anyone getting higher Throughput rate than this?  

 

If yes, then with what technology and @ what Throughput rate?

 

Regards

Yashwant Rane

 

 

 

 


Re: Which Tape Technology?

2005-09-22 Thread David McClelland
Hi Rick,

I haven't time to respond to all of the below, but on your point on LTO
drives/streaming:

 With any of the new tape drives, I'm concerned with throughput issues.
 The
 newest drives (3592 and LTO3) are so fast that I wonder if it becomes
a
 problem keeping data streaming to them.  The capacity is great, but if
I
 can't keep them spinning I wonder if the new drives could cause more
 problems than they solve.

The good news about LTO2 and LTO3 drives (as opposed to older LTO1s) is
that they have an adaptive ability to match the speed at which they spin
to as close a rate as possible as the data coming in to reduce the
'backhitch effect' - I think one of the terms for this is DSM or Digital
Speed Matching. Additionally, they have increased buffer sizes (64 or
128MB? Maybe more now).

I personally haven't ever done a comparison between small/large file
access times and 3590/LTO-based drives - but I'm sure someone out there
will have...

David McClelland





Richard Rhodes [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
22/09/2005 12:56
Please respond to
ADSM: Dist Stor Manager


To
ADSM-L@VM.MARIST.EDU
cc

Subject
[ADSM-L] Which Tape Technology?






Hi Everyone,

Currently our tape environment consists of IBM 3494 libraries with 3590H
(60gb) drives.  It's possible that we may need to greatly expand our
environment with some new libraries and drives.  This has brought up a
discussion about what tape technology we would use.  Our environment
consists of a mix of large file backups (Oracle databases), small file
backups (Netware servers) and lots of stuff in between.  If we have to do
this, I really can't see purchasing more 3590H drives with cartridges that
are only 60gb.  I would think we would want to go to the newest 3592
drives
or LTO2/LTO3.

What are your thoughts/comments/experiences with . . . . .

1)  Given our mix of large and small file backups, would LTO tape drives
work as well as our current 3590's?
2)  Does anyone have any experience using IBMs newest 3592 tape drives?
3)  If LTO, is LTO3 the way to go, or stick with older LTO2?
4)  Or, should we stick with 3590 drives?

With any of the new tape drives, I'm concerned with throughput issues. The
newest drives (3592 and LTO3) are so fast that I wonder if it becomes a
problem keeping data streaming to them.  The capacity is great, but if I
can't keep them spinning I wonder if the new drives could cause more
problems than they solve.

Of course, another option would be a VTL or just local DISK on the TSM
server.  We've done some initial pricing of some configurations (tape
libraries/drives/tapes,  disk, and vtl) and so far tape is the least
expensive.

Just looking for others experiences with this kind of decision . . . .

Thanks!

Rick


-
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is
strictly prohibited. If you have received this communication in error,
please notify us immediately, and delete the original message.


Re: Which Tape Technology?

2005-09-22 Thread Barnes, Kenny
We switched from 8-3590E1A drives and the 3494 librar to 8-3592 drives
and a 3584 library and trimmed 6 hrs off backup times.  We backup 1.3 tb
data per night with 90% going to disk pools and then off to tape.  We
are also essentially getting the work done using four of the drives. 

Infrastructure is all 2gb fibre with tape drives connected to 2-9216
cisco's with four drives each. 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Rhodes
Sent: Thursday, September 22, 2005 7:57 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Which Tape Technology?

Hi Everyone,

Currently our tape environment consists of IBM 3494 libraries with 3590H
(60gb) drives.  It's possible that we may need to greatly expand our
environment with some new libraries and drives.  This has brought up a
discussion about what tape technology we would use.  Our environment
consists of a mix of large file backups (Oracle databases), small file
backups (Netware servers) and lots of stuff in between.  If we have to
do this, I really can't see purchasing more 3590H drives with cartridges
that are only 60gb.  I would think we would want to go to the newest
3592 drives or LTO2/LTO3.

What are your thoughts/comments/experiences with . . . . .

1)  Given our mix of large and small file backups, would LTO tape drives
work as well as our current 3590's?
2)  Does anyone have any experience using IBMs newest 3592 tape drives?
3)  If LTO, is LTO3 the way to go, or stick with older LTO2?
4)  Or, should we stick with 3590 drives?

With any of the new tape drives, I'm concerned with throughput issues.
The newest drives (3592 and LTO3) are so fast that I wonder if it
becomes a problem keeping data streaming to them.  The capacity is
great, but if I can't keep them spinning I wonder if the new drives
could cause more problems than they solve.

Of course, another option would be a VTL or just local DISK on the TSM
server.  We've done some initial pricing of some configurations (tape
libraries/drives/tapes,  disk, and vtl) and so far tape is the least
expensive.

Just looking for others experiences with this kind of decision . . . .

Thanks!

Rick


-
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is
strictly prohibited. If you have received this communication in error,
please notify us immediately, and delete the original message.
--
Note:  The information contained in this message may be privileged and 
confidential
and protected from disclosure.  If the reader of this message is not the 
intended recipient,
or an employee or agent responsible for delivering this message to the intended 
recipient,
you are hereby notified that any dissemination, distribution or copying of this 
communication
is strictly prohibited.  If you have received this communication in error, 
please notify us 
immediately by replying to the message and deleting it from your computer.  
Thank you.
--

Re: Exchange backups

2005-09-22 Thread Petur Eythorsson

is there any power diffrence between
the clinets, compression takes cpu time from the client, and if you had
fairly powerful cpu machines with slow network, then ofcouse youre backuptime
would be reduced, but if on the other hand if you had a old cpu´s and a
network that where flying, comression on the client would slow the backup
process.


It´s better to aim at perfection
and miss than it is to aim at imperfection and hit it
Founder
Thomas J. Watson






Kær kveðja / Best regards,
Pétur
Eyþórsson · Tæknilegur ráðgjafi
eServer  Storage · Tivoli Advanced Storage Solutons Techical Expert
· MCSE · SNIA Professional ·
SNIA FC-SAN Practitioner · IBM C AIX S · TSM CP · TSRM
CP · TASS DP · IBM SAN P
Sími/tel: +354 569-7700 · GSM: +354 863-0560 
www.nyherji.is







LeBlanc, Patricia
[EMAIL PROTECTED] 
Sent by: ADSM: Dist Stor Manager
ADSM-L@VM.MARIST.EDU
22.09.2005 11:57



Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU





To
ADSM-L@VM.MARIST.EDU


cc



Subject
[ADSM-L] Exchange backups








I recently turned on compression for my exchange
backups. All backup
times improved, with the exception of two servers who are now taking 2
hours longer to backup.

Clients are w2k3. TSM Server is AIX.

Anyone using compression on exchange?



Re: Operation Report customized by contact question

2005-09-22 Thread Richard Sims

Ryan - Look into online SQL info regarding efficient queries:
   some forms can be painful.
In your case, use the SQL clause IN rather than using a string of ORs:

  ...WHERE MSGNO IN (4005,4007,4018,4037,4987)...

 Richard Sims

On Sep 21, 2005, at 6:07 PM, Ryan Cooper wrote:


Hey got a few questions.
First my goal is to deliver a report that contains Client
Schedules, and
Files missed to each person who is listed as a contact for a node.
This
report must only include data for nodes that they are a contact for.

So I create a Report with the following.
Client Schedule Status  Select node_name from nodes where contact like
'%%Contact name%%'
Then I added a new item with the following statement select
nodename,substr(char(date_time), 1, 16) as TME,message from
actlog where
(msgno=4005 or msgno=4007 or msgno=4018 or msgno=4037 or
msgno=4987) and
(date_time between current_timestamp - 24 hours and
current_timestamp) and
nodename in (select node_name from nodes where contact like '%contact
name%') order by nodename asc

This works great but I'm wondering A: is this the best way to get this
report done?  B: If this one report takes 15 minutes to run what is
going
to happen to the server if I run 25 of these reports at about the same
time?

Also does anyone know what process name this shows up on the server
as.

TSM Version 5.2 Level 4.1 On AIX
Thanks for any help or input.
Ryan Cooper



TSM

2005-09-22 Thread johnny cochran

Looking for a good beginners TSM guide link / redbook

_
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


Re: [SPAM: 3.115] [ADSM-L] TSM

2005-09-22 Thread Leigh Reed
Johnny

http://people.bu.edu/rbs/ADSM.QuickFacts
http://www.lascon.co.uk/d005104.htm
http://www.redbooks.ibm.com/cgi-bin/searchsite.cgi?query=tsm

HTH.

Leigh

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
johnny cochran
Sent: 22 September 2005 15:38
To: ADSM-L@VM.MARIST.EDU
Subject: [SPAM: 3.115] [ADSM-L] TSM

Looking for a good beginners TSM guide link / redbook

_
On the road to retirement? Check out MSN Life Events for advice on how
to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


Betr.: TSM (Afwezig!)

2005-09-22 Thread Frank Verhoeven
Ik ben t/m woensdag 12 oktober 2005 afwezig.

Dringende zaken gelieve te sturen naar de Helpdesk: [EMAIL PROTECTED]


==

Dit bericht is uitsluitend bestemd voor de geadresseerde.
Het bericht kan vertrouwelijke informatie bevatten.
Als u dit bericht per abuis hebt ontvangen, wordt u
verzocht onmiddellijk de afzender te informeren. Ook
verzoeken wij u het bericht te vernietigen en de inhoud
niet onder derden te verspreiden of te gebruiken.

This message is intended exclusively for the addressee.
It may contain information that is confidential.
If you are not the intended recipient, we request that
you notify the sender immediately. In that case, we
also request that you destroy the message and that
you neither use the contents nor disclose them in any
manner to third parties.
==


Re: TSM

2005-09-22 Thread David McClelland
Johnny,

I'd recommend this one as a good all round starting point:

IBM Tivoli Storage Management Concepts

This IBM Redbook describes the features and functions of IBM Tivoli
Storage Manager. It introduces Tivoli Storage Management concepts for
those new to storage management, in general, and to IBM Tivoli Storage
Manager, in particular.

http://www.redbooks.ibm.com/abstracts/sg244877.html?Open

Rgds,

David McClelland




johnny cochran [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
22/09/2005 15:38
Please respond to
ADSM: Dist Stor Manager


To
ADSM-L@VM.MARIST.EDU
cc

Subject
[ADSM-L] TSM






Looking for a good beginners TSM guide link / redbook

_
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


Re: [SPAM: 3.115] [ADSM-L] TSM

2005-09-22 Thread johnny cochran

very nice Thanks  Leigh !

http://people.bu.edu/rbs/ADSM.QuickFacts
http://www.lascon.co.uk/d005104.htm
http://www.redbooks.ibm.com/cgi-bin/searchsite.cgi?query=tsm





From: Leigh Reed [EMAIL PROTECTED]
Reply-To: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] [SPAM: 3.115] [ADSM-L] TSM
Date: Thu, 22 Sep 2005 15:44:45 +0100

Johnny




HTH.

Leigh

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
johnny cochran
Sent: 22 September 2005 15:38
To: ADSM-L@VM.MARIST.EDU
Subject: [SPAM: 3.115] [ADSM-L] TSM

Looking for a good beginners TSM guide link / redbook

_
On the road to retirement? Check out MSN Life Events for advice on how
to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


95% missed backups last night

2005-09-22 Thread Gill, Geoffrey L.
TSM server AIX 5.2

TSM version 5.2.6.1

 

I recently upgraded from AIX 4.3.3 to 5.2, ran the system for a week with no
issues, then upgraded TSM from 5.1.6.3 to 5.2.6.1. One week has passed and
things seemed to be somewhat normal till last night. About 98% of the
backups reported missed last night and at the moment I haven’t a clue as to
why. I typically keep a console window open to watch what is going on and
this morning I see started and ended sessions being refused because it says
the administrator name is not registered. The name it shows is very odd in
that it is a bunch of odd characters and smiley faces instead of the server
name. I also can’t seem to get in via the web and query the activity log
from last night, it just seems to hang after send so much data. I could
still use the dos window to run queries while that was happening.

 

The missed backups reported 

 

These are odd to say the least.

ANR0423W Session 39175 for administrator ^AL☺☻'YTED☺☺ ( ) refused -
administrator name not

ANR0423W Session 39177 for administrator PU►☺► ( ) refused - administrator
name not registered.

ANR0423W Session 39160 for administrator ^AK☺+0YTD%C☺☺ ( ) refused -
administrator name not registered.

ANR0423W Session 39158 for administrator ^AK☺+0YTEC☺☺ ( ) refused -
administrator name not registered.

ANR0423W Session 39164 for administrator ^AJ☺+0YTEB☺☺ ( ) refused -
administrator name not registered.

 

I have restarted the server with the hope of cleaning things up but the
problem is I need to find out what’s happened. So there are 2 basic
questions I’ll ask to see if I can get some help from the list while I go
off and try to get the server going again.

 

1.  Has anyone seen this behavior before? I was running perfectly well
on AIX 4.3.3 and TSM 5.1.6.3.
2.  Are there any AIX settings I should look at that might be causing
this?

 

 

Thanks,

 

Geoff Gill

TSM Administrator

SAIC M/S-G1b

(858)826-4062

Email:  mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

 

 

 


Select Question

2005-09-22 Thread Spearman, Wayne

I'm trying to see what Clients are using what management classes. For
instance, server1 is using management class 1week and 1year. I can't
seem to find the right tables or selects. Any help would be appreciated.

Wayne




-
This message and any included attachments are from NOVANT HEALTH INC.
and are intended only for the addressee(s). The information contained
herein may include trade secrets or privileged or otherwise
confidential information. Unauthorized review, forwarding, printing,
copying, distributing, or using such information is strictly prohibited
and may be unlawful. If you received this message in error, or have
reason to believe you are not authorized to receive it, please promptly
delete this message and notify the sender by e-mail.
If you believe that any information contained in this message is
disparaging or harassing on the basis of gender, race, age, disability,
religion, or national origin, please contact Novant Health, Inc. at 1
-888-378-8250 or 1-800-350-0094 or forward the e-mail to
[EMAIL PROTECTED]
Thank you.



95% missed backups last night ( found the problem but what is the easy fix)

2005-09-22 Thread Gill, Geoffrey L.
Ok here's an update on my own post. While waiting for a callback from

support I seem to have discovered what the problem is. It seems that the

passwords have not kept in synch between client and server. Yes

passwordaccess generate is set on all the nodes so I don't understand the

problem.



I logged on to one of my clients and opened the baclient. It asked for the

password when it should not have. I changed the password on the server to a

known value and entered that in the client window and it connected. I was

then able to restart the scheduler service and the client connected properly

instead of showing the odd characters on the TSM server.



The problem now is we have 250 nodes that need fixing and the only way I

know to fix them is to do what I did. I have no clue what the passwords are

of these nodes and neither does anyone else. So after I change all of them I

have to then tell the administrators so they can do what I did.



Boy is there going to be a bunch of pissed people, including me, if I can't

do something on the server to fix this.



The next question is how long is it going to be till this happens again?







Thanks,



Geoff Gill

TSM Administrator

SAIC M/S-G1b

(858)826-4062

Email:  mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]


Re: Select Question

2005-09-22 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of Spearman, Wayne
I'm trying to see what Clients are using what management classes. For
instance, server1 is using management class 1week and 1year. I can't
seem to find the right tables or selects. Any help would be 
appreciated.

This has been discussed repeatedly; check the list archives for other
aspects of this discussion.

Management classes are tied to files, not to nodes. That's why you can't
find anything. Depending on how the include statements are built, I
could back up files on any given client to a hundred (or more)
management classes.

--
Mark Stapleton ([EMAIL PROTECTED])
IBM Certified Advanced Deployment Professional
 Tivoli Storage Management Solutions 2005
IBM Certified Advanced Technical Expert (CATE) AIX
Berbee Information Networks
Office 262.521.5627


Re: Select Question

2005-09-22 Thread William Jean
This should work
 
select distinct backups.node_name, backups.class_name from backups
 
Here are the rest of the columns from backups
 
BACKUPS.BACKUP_DATE
BACKUPS.CLASS_NAME
BACKUPS.DEACTIVATE_DATE
BACKUPS.FILESPACE_ID
BACKUPS.FILESPACE_NAME
BACKUPS.HL_NAME
BACKUPS.LL_NAME
BACKUPS.NODE_NAME
BACKUPS.OBJECT_ID
BACKUPS.OWNER
BACKUPS.STATE
BACKUPS.TYPE
 


From: ADSM: Dist Stor Manager on behalf of Spearman, Wayne
Sent: Thu 9/22/05 12:40 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select Question




I'm trying to see what Clients are using what management classes. For
instance, server1 is using management class 1week and 1year. I can't
seem to find the right tables or selects. Any help would be appreciated.

Wayne




-
This message and any included attachments are from NOVANT HEALTH INC.
and are intended only for the addressee(s). The information contained
herein may include trade secrets or privileged or otherwise
confidential information. Unauthorized review, forwarding, printing,
copying, distributing, or using such information is strictly prohibited
and may be unlawful. If you received this message in error, or have
reason to believe you are not authorized to receive it, please promptly
delete this message and notify the sender by e-mail.
If you believe that any information contained in this message is
disparaging or harassing on the basis of gender, race, age, disability,
religion, or national origin, please contact Novant Health, Inc. at 1
-888-378-8250 or 1-800-350-0094 or forward the e-mail to
[EMAIL PROTECTED]
Thank you.


__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__


Re: 95% missed backups last night ( found the problem but what is the easy fix)

2005-09-22 Thread Scott Grover
I believe you'll need to set password expiration to 0 on node definitions so it
doesn't happen againbut you'll have to reset passwords individually from
each client for the current situation.



 Gill, Geoffrey L.
 [EMAIL PROTECTED]
 IC.COM To
 Sent by: ADSM: ADSM-L@VM.MARIST.EDU
 Dist Stor Manager  cc
 [EMAIL PROTECTED]
 DUSubject
 [ADSM-L] 95% missed backups last night
 ( found the problem but whatis the
 09/22/2005 12:01 PM easy fix)


  Please respond to
  ADSM: Dist Stor
  Manager
 [EMAIL PROTECTED]
 DU






Ok here's an update on my own post. While waiting for a callback from

support I seem to have discovered what the problem is. It seems that the

passwords have not kept in synch between client and server. Yes

passwordaccess generate is set on all the nodes so I don't understand the

problem.



I logged on to one of my clients and opened the baclient. It asked for the

password when it should not have. I changed the password on the server to a

known value and entered that in the client window and it connected. I was

then able to restart the scheduler service and the client connected properly

instead of showing the odd characters on the TSM server.



The problem now is we have 250 nodes that need fixing and the only way I

know to fix them is to do what I did. I have no clue what the passwords are

of these nodes and neither does anyone else. So after I change all of them I

have to then tell the administrators so they can do what I did.



Boy is there going to be a bunch of pissed people, including me, if I can't

do something on the server to fix this.



The next question is how long is it going to be till this happens again?







Thanks,



Geoff Gill

TSM Administrator

SAIC M/S-G1b

(858)826-4062

Email:  mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]


Re: 95% missed backups last night ( found the problem but what is the easy fix)

2005-09-22 Thread Sean M English
Geoff,

Was the server name changed by mistake on the TSM server side? We did this
once before when we migrated a TSM server to another server and we found
out the hard way that on the Windows side, not sure on AIX, the password is
stored in the registry based on the TSM server name and all our Windows
backups failed.


Sean English
ESS Team Lead

Re: 95% missed backups last night ( found the problem but what is the easy fix)

2005-09-22 Thread Doug
A password scheme may be a good idea also. We don't particularly have
it so that the clients know the passwords anyways, so having a
scheme may be a good idea for the future also so that you know ahead
of time what the password would be.

On 9/22/05, Scott Grover [EMAIL PROTECTED] wrote:
 I believe you'll need to set password expiration to 0 on node definitions so 
 it
 doesn't happen againbut you'll have to reset passwords individually from
 each client for the current situation.



  Gill, Geoffrey L.
  [EMAIL PROTECTED]
  IC.COM 
 To
  Sent by: ADSM: ADSM-L@VM.MARIST.EDU
  Dist Stor Manager  
 cc
  [EMAIL PROTECTED]
  DU
 Subject
  [ADSM-L] 95% missed backups last 
 night
  ( found the problem but whatis 
 the
  09/22/2005 12:01 PM easy fix)


   Please respond to
   ADSM: Dist Stor
   Manager
  [EMAIL PROTECTED]
  DU






 Ok here's an update on my own post. While waiting for a callback from

 support I seem to have discovered what the problem is. It seems that the

 passwords have not kept in synch between client and server. Yes

 passwordaccess generate is set on all the nodes so I don't understand the

 problem.



 I logged on to one of my clients and opened the baclient. It asked for the

 password when it should not have. I changed the password on the server to a

 known value and entered that in the client window and it connected. I was

 then able to restart the scheduler service and the client connected properly

 instead of showing the odd characters on the TSM server.



 The problem now is we have 250 nodes that need fixing and the only way I

 know to fix them is to do what I did. I have no clue what the passwords are

 of these nodes and neither does anyone else. So after I change all of them I

 have to then tell the administrators so they can do what I did.



 Boy is there going to be a bunch of pissed people, including me, if I can't

 do something on the server to fix this.



 The next question is how long is it going to be till this happens again?







 Thanks,



 Geoff Gill

 TSM Administrator

 SAIC M/S-G1b

 (858)826-4062

 Email:  mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]



3494 question

2005-09-22 Thread cc52
We are upgrading a TSM AIX 5.2 system from using   3494/3590 E1A's
to H1A's.  We would like to use Fibre instead of SCSI but our
3494 Library Manager can't run the level of code to support fibre
without upgrading the Library Manager machine.  (We're still trying to
find the 3494 feature code to do that).   If we don't do this the
H1A SCSI support is supposed to work in the existing Library Manager.
What type of difference is there in TSM thruput using fibre vs SCSI
on the H1A drives (Ballpark figure for management)?

Ron Greve
SDSU Admin and Research Computing


Re: 95% missed backups last night ( found the problem but what is the easy fix)

2005-09-22 Thread Gill, Geoffrey L.
Scanning the registry I don't see that entry anywhere.
Do you have the keys for that Sean?

Thanks,

Geoff Gill
TSM Administrator
SAIC M/S-G1b
(858)826-4062
Email: [EMAIL PROTECTED]


Re: 95% missed backups last night ( found the problem but what is the easy fix)

2005-09-22 Thread Gill, Geoffrey L.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Scott Grover
Sent: Thursday, September 22, 2005 10:45 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: 95% missed backups last night ( found the problem but what is
the easy fix)
I believe you'll need to set password expiration to 0 on node definitions so
it
doesn't happen againbut you'll have to reset passwords individually from
each client for the current situation.

_
Currently password expiration has no entry on the nodes.

Thanks,

Geoff Gill
TSM Administrator
SAIC M/S-G1b
(858)826-4062
Email: [EMAIL PROTECTED]


Re: 95% missed backups last night

2005-09-22 Thread Gill, Geoffrey L.
Here is another problem I have noticed with all the servers I have tried to
clean up so far. After the cleanup I try to run the web client. It asks for
the password but entering the proper password fails. If I remove the
services from the client and reinstall from scratch, using the proper
password when setting up the service, it still fails login attempts. I have
tried multiple versions of the client, including the newest.

Thanks,

Geoff Gill
TSM Administrator
SAIC M/S-G1b
(858)826-4062
Email: [EMAIL PROTECTED]


Re: 95% missed backups last night ( found the problem but what is the easy fix)

2005-09-22 Thread Andy Huebner
Hkey_Local_Machine\Software\IBM\ADSM\CurrentVersion\BackupClient\Nodes\N
odeName\ServerName

Andy Huebner

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gill, Geoffrey L.
Sent: Thursday, September 22, 2005 2:02 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] 95% missed backups last night ( found the problem
but what is the easy fix)

Scanning the registry I don't see that entry anywhere.
Do you have the keys for that Sean?

Thanks,

Geoff Gill
TSM Administrator
SAIC M/S-G1b
(858)826-4062
Email: [EMAIL PROTECTED]


This e-mail (including any attachments) is confidential and may be legally 
privileged. If you are not an intended recipient or an authorized 
representative of an intended recipient, you are prohibited from using, copying 
or distributing the information in this e-mail or its attachments. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and delete all copies of this message and any attachments.
Thank you.


Re: 3494 question

2005-09-22 Thread Andy Huebner
3590 E and H drives have the same data rate.  I would expect you will
not see a difference because SCSI-2 is faster than the tape drive.
The web site lists an 8MB/sec difference for the top end data rate
assuming you are getting 3:1 compression.

Andy Huebner

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
cc52
Sent: Thursday, September 22, 2005 1:39 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] 3494 question

We are upgrading a TSM AIX 5.2 system from using   3494/3590 E1A's
to H1A's.  We would like to use Fibre instead of SCSI but our
3494 Library Manager can't run the level of code to support fibre
without upgrading the Library Manager machine.  (We're still trying to
find the 3494 feature code to do that).   If we don't do this the
H1A SCSI support is supposed to work in the existing Library Manager.
What type of difference is there in TSM thruput using fibre vs SCSI
on the H1A drives (Ballpark figure for management)?

Ron Greve
SDSU Admin and Research Computing


This e-mail (including any attachments) is confidential and may be legally 
privileged. If you are not an intended recipient or an authorized 
representative of an intended recipient, you are prohibited from using, copying 
or distributing the information in this e-mail or its attachments. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and delete all copies of this message and any attachments.
Thank you.


Re: Which Tape Technology?

2005-09-22 Thread Johnson, Milton
We were in a similar situation with a 3494 and two 3590E drives.  We
went with a VTL for the primary stgpools using the 3494 just for offsite
copypools and have been very happy with it.  Most everything goes
straight to the VTL and during the night I do repeated backups of the
primary stgpools in the VTL to the copypool stgpool in the 3494.  In the
morning one final backup from VTL to the 3494 followed by a DB backup
and I'm ready to send tapes offsite.  Since the primary disk stgpools
were reduced to 1GB in size the migration time went to zip. We back up
about 1TB per night.

Milton
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Rhodes
Sent: Thursday, September 22, 2005 6:57 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Which Tape Technology?

Hi Everyone,

Currently our tape environment consists of IBM 3494 libraries with 3590H
(60gb) drives.  It's possible that we may need to greatly expand our
environment with some new libraries and drives.  This has brought up a
discussion about what tape technology we would use.  Our environment
consists of a mix of large file backups (Oracle databases), small file
backups (Netware servers) and lots of stuff in between.  If we have to
do this, I really can't see purchasing more 3590H drives with cartridges
that are only 60gb.  I would think we would want to go to the newest
3592 drives or LTO2/LTO3.

What are your thoughts/comments/experiences with . . . . .

1)  Given our mix of large and small file backups, would LTO tape drives
work as well as our current 3590's?
2)  Does anyone have any experience using IBMs newest 3592 tape drives?
3)  If LTO, is LTO3 the way to go, or stick with older LTO2?
4)  Or, should we stick with 3590 drives?

With any of the new tape drives, I'm concerned with throughput issues.
The newest drives (3592 and LTO3) are so fast that I wonder if it
becomes a problem keeping data streaming to them.  The capacity is
great, but if I can't keep them spinning I wonder if the new drives
could cause more problems than they solve.

Of course, another option would be a VTL or just local DISK on the TSM
server.  We've done some initial pricing of some configurations (tape
libraries/drives/tapes,  disk, and vtl) and so far tape is the least
expensive.

Just looking for others experiences with this kind of decision . . . .

Thanks!

Rick


-
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is
strictly prohibited. If you have received this communication in error,
please notify us immediately, and delete the original message.


TDP Oracle

2005-09-22 Thread Kurt Beyers
Good morning,

A rather general question.

Is it possible to take the backup of only 1 instance with the TDP for Oracle
(an instance that would be used for testing in TSM) and to take the backup
of the other (production) instances to a local tape with an RMAN script?

Both backups (TPD and local RMAN backup) do allocate 'sbt_tape' as channel.
In other backup solutions, a symbolic link of the Oracle library
$ORACLE_HOME/lib/libobk.sl is created to the library of the backup solution.
Which means that a backup to a local device using a RMAN script is no longer
possible.

I did not find out if this is the case too with the TDP for Oracle. Must all
Oracle instances be restarted after the installation of the TDP or only the
instance that you want to backup with the TDP or is there no restart at all.

Thanks,

Kurt Beyers