Holger Bitterlich ist außer Haus.

2002-07-31 Thread Holger Bitterlich

Ich werde ab  01.08.2002 nicht im Büro sein. Ich kehre zurück am
20.08.2002.

Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten. In dringenden
Fällen wenden Sie sich bitte an meine Kollegen der FE 515/2 .

Vielen Dank

HBitterlich
Da E-Mails leicht unter fremdem Namen erstellt oder manipuliert werden
koennen, muessen wir zu Ihrem und unserem Schutz die rechtliche
Verbindlichkeit der vorstehenden Erklaerungen ausschliessen. Die fuer die
Stadtsparkasse Koeln geltenden Regeln ueber die Verbindlichkeit von
rechtsgeschaeftlichen Erklaerungen mit verpflichtendem Inhalt bleiben
unberuehrt.


Re: Expiring TDP for Oracle data

2002-07-31 Thread Cowperthwaite, Eric

Once the objects are deleted in RMAN, then you will need to run a TDPOSYNC
 and that will sync the RMAN
catalog and TSM database and expire the files on your TSM Server
 
Eric W. Cowperthwaite
EDS
 
-Original Message-
From: Holger Speh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 1:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Expiring TDP for Oracle data
 

Theresa, 

all Oracle backup objects are unique so there won't be any inactive versions
which you can expire via TSM. You have to expire them "manually" with an
RMAN script doing a RMAN report obsolete first to find all no longer needed
Oracle backups and them doing a RMAN delete on these objects. 

Mit freundlichen Grüssen / With kind regards, 
Holger Speh 
  
  

IBM Global Services - Integrated Technology Services 

Mobil: +49 (0)172 / 6365603 
Fax: +49 (0)5341 / 892803 

Notes: Holger Speh/Germany/IBM@IBMDE 
email: [EMAIL PROTECTED] 


  






 
Theresa Sarver <[EMAIL PROTECTED]> 
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 
31.07.2002 18:39 
Please respond to "ADSM: Dist Stor Manager" 

To:[EMAIL PROTECTED] 
cc: 
Subject:Expiring TDP for Oracle data 

   


Hello;

I've been searching the archives on this subject all morning and I just want
to double-check my findings.

Environment:
SP Model 9076 (1 Frame w/ 7 nodes)
AIX 4.3.3 ML8
P.S.S.P 3.2
ptfset 8
TSM 4.1.5
ORACLE 8.1.7/RMAN
TDP for Oracle v2.1.1 (I think?)

The DBA's have only been using TDP/RMAN for a few months now and around July
10 they decided to start exprining some old backups.  I noticed yesterday,
that the copy group had been setup improperly for TDP_Oracle:

STANDARD  ACTIVERMANCLASS STANDARD 11   0   1
STANDARD  STANDARD  RMANCLASS STANDARD 110   1

I modified the appropriate parameters last night (using TDP for Ocacle Admin
Guide) and think it's right now:

STANDARD  ACTIVERMANCLASS STANDARD 100   0
STANDARD  STANDARD  RMANCLASS STANDARD 100   0

I ran 'expire inventory' shortly thereafter, this however did not remove any
of the inactive databases:
/adsmorc : // cold_TESTR_1631_270302_22_1 (MC: DEFAULT)
Inactive, Inserted 03/27/02 16:32:19, Deactivated 07/10/02 15:18:10
ObjId: 0.58797993  

So, from what I've read I have 3 options:
1)  run some "delete object 0 xx" command  (Could someone please provide
me with any further information on this command?)
2)  Create a new filespace, then delete the old one after several days
3)  Using a TDPOSYNC command...depending on version.  Anyone know if 2.1.1
supports the use of this command? - Can't find any reference in the TDP for
Oracle Manuel.

Thanks 'yet again' for your help;
Theresa 



image001.gif
Description: GIF image


Re: Expiring TDP for Oracle data

2002-07-31 Thread Holger Speh

Theresa,

all Oracle backup objects are unique so there won't be any inactive versions which you can expire via TSM. You have to expire them "manually" with an RMAN script doing a RMAN report obsolete first to find all no longer needed Oracle backups and them doing a RMAN delete on these objects.

Mit freundlichen Grüssen / With kind regards, 
Holger Speh 
  



IBM Global Services - Integrated Technology Services 

Mobil: +49 (0)172 / 6365603
Fax: +49 (0)5341 / 892803

Notes: Holger Speh/Germany/IBM@IBMDE 
email: [EMAIL PROTECTED] 

  









Theresa Sarver <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
31.07.2002 18:39
Please respond to "ADSM: Dist Stor Manager"
        
        To:        [EMAIL PROTECTED]
        cc:        
        Subject:        Expiring TDP for Oracle data

       

Hello;

I've been searching the archives on this subject all morning and I just want to double-check my findings.

Environment:
SP Model 9076 (1 Frame w/ 7 nodes)
AIX 4.3.3 ML8
P.S.S.P 3.2
ptfset 8
TSM 4.1.5
ORACLE 8.1.7/RMAN
TDP for Oracle v2.1.1 (I think?)

The DBA's have only been using TDP/RMAN for a few months now and around July 10 they decided to start exprining some old backups.  I noticed yesterday, that the copy group had been setup improperly for TDP_Oracle:

STANDARD  ACTIVE    RMANCLASS STANDARD         1        1       0       1
STANDARD  STANDARD  RMANCLASS STANDARD         1        1        0       1

I modified the appropriate parameters last night (using TDP for Ocacle Admin Guide) and think it's right now:

STANDARD  ACTIVE    RMANCLASS STANDARD         1        0        0       0
STANDARD  STANDARD  RMANCLASS STANDARD         1        0        0       0

I ran 'expire inventory' shortly thereafter, this however did not remove any of the inactive databases:
/adsmorc : // cold_TESTR_1631_270302_22_1 (MC: DEFAULT)
Inactive, Inserted 03/27/02 16:32:19, Deactivated 07/10/02 15:18:10
ObjId: 0.58797993  

So, from what I've read I have 3 options:
1)  run some "delete object 0 xx" command  (Could someone please provide me with any further information on this command?)
2)  Create a new filespace, then delete the old one after several days
3)  Using a TDPOSYNC command...depending on version.  Anyone know if 2.1.1 supports the use of this command? - Can't find any reference in the TDP for Oracle Manuel.

Thanks 'yet again' for your help;
Theresa 



Backup of Win2`K Fileserver

2002-07-31 Thread Guillaume Gilbert

Hello

I have a BIG performance problem with the backup of a win2k fileserver. It used to be 
pretty long before but it was managable. But now the sysadmins put it on a compaq
storageworks SAN. By doing that they of course changed the drive letter. Now it has to 
do a full backup of that drive. The old drive had  1,173,414 files and 120 GB  of
data according to q occ. We compress at the client. We have backup retention set to 
2-1-NL-30. The backup had been running for 2 weeks!!! when we cancelled it to try to
tweak certain options in dsm.opt. The client is at 4.2.1.21 and the server is at 4.1.3 
(4.2.2.7 in a few weeks). Network is 100 mb. I know that journal backups will help
but as long as I don't get a full incremental in it doesn't do me any good. Some of 
the settings in dsm.opt :

TCPWindowsize 63
TxnByteLimit 256000
TCPWindowsize 63
compressalways yes
RESOURceutilization 10
CHAngingretries 2

The network card is set to full duplex. I wonder if an FTP test with show some 
Gremlins in the network...?? Will try it..

I'm certain the server is ok. It's a F80 with 4 processors and 1.5 GB of RAM, though I 
can't seem to get the cache hit % above 98. my bufpoolsize is 524288. DB is 22 GB
73% utilized.

I'm really stumped and I would appreciate any help

Thanks

Guillaume Gilbert



question on configuring large NT client for optimum restore proce ssing

2002-07-31 Thread Kauffman, Tom

What's the preferred method of configuring a large NT fileserver for optimum
data recovery speed?

Can I do something with co-location at the filesystem (what IS a filesystem
in NT/2000?) level?

We're bringing in an IBM NAS to replace four existing NT servers and our
recovery time for the existing environment stinks. The main server currently
has something over 800,000 files using 167 GB (current box actually uses NT
file compression, so it's showing as 80 GB on NT). We had to do a recovery
last year (raid array died) and it ran to 40+ hours; I'm getting the
feedback that over 20 hours will be un-acceptable.

The TSM server and the client code are relatively recent 4.2 versions and
will be staying at 4.2 for the rest of this year (so any neat features of
TSM 5 would be nice to know but otherwise unuseable :-)

To add to the fun and games, this will be an MS cluster environment. With
1.2 TB of disk on it. We do have a couple of weeks to play around and try
things out before getting serious. One advantage to the MSCS is that disk
compression is not allowed, so that should speed things up a bit on the
restore.

Tom Kauffman
NIBCO, Inc



Re: Restoring MSCS cluster node

2002-07-31 Thread Zlatko Krastev/ACIT

Full "bare metal" can also be assumed as restore with disk replacement. So
look at MS KB article Q243195.

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:

Subject:Restoring MSCS cluster node

Hi.

Has anyone got an idea how to perform "bare metal" restore of MSCS
cluster node (win2k, winNT)? I have performed a lot of tries to do that.
Sometimes it succeeds sometimes doesn't. According to the redbook
sg24-6141 "Deploying the TSM client in a win2k env" I restored ALL
system object including cluster db but cluster services were not running
(of course) and restore failed. So I restored system objects except
cluster db (first time it succeeded).

If you know any better redbook than above or if you have any
experience
in it please HELP ME!



--

--== KKus ==--



Expiring TDP for Oracle data

2002-07-31 Thread Theresa Sarver

Hello;

I've been searching the archives on this subject all morning and I just want to 
double-check my findings.

Environment:
SP Model 9076 (1 Frame w/ 7 nodes)
AIX 4.3.3 ML8
P.S.S.P 3.2
ptfset 8
TSM 4.1.5
ORACLE 8.1.7/RMAN
TDP for Oracle v2.1.1 (I think?)

The DBA's have only been using TDP/RMAN for a few months now and around July 10 they 
decided to start exprining some old backups.  I noticed yesterday, that the copy group 
had been setup improperly for TDP_Oracle:

STANDARD  ACTIVERMANCLASS STANDARD 11   0   1
STANDARD  STANDARD  RMANCLASS STANDARD 110   1

I modified the appropriate parameters last night (using TDP for Ocacle Admin Guide) 
and think it's right now:

STANDARD  ACTIVERMANCLASS STANDARD 100   0
STANDARD  STANDARD  RMANCLASS STANDARD 100   0

I ran 'expire inventory' shortly thereafter, this however did not remove any of the 
inactive databases:
/adsmorc : // cold_TESTR_1631_270302_22_1 (MC: DEFAULT)
Inactive, Inserted 03/27/02 16:32:19, Deactivated 07/10/02 15:18:10
ObjId: 0.58797993  

So, from what I've read I have 3 options:
1)  run some "delete object 0 xx" command  (Could someone please provide me with 
any further information on this command?)
2)  Create a new filespace, then delete the old one after several days
3)  Using a TDPOSYNC command...depending on version.  Anyone know if 2.1.1 supports 
the use of this command? - Can't find any reference in the TDP for Oracle Manuel.

Thanks 'yet again' for your help;
Theresa 



Re: TSM and Solaris 9

2002-07-31 Thread Bob Booth - UIUC

We did not hack the install package, and the install failed.  I would
be happy to have the details, and I would be happier if IBM/Tivoli would
provide a statement of direction for support on Solaris 9.

Thanks for you assistance!

Bob

On Wed, Jul 31, 2002 at 11:16:19AM -0400, Stephen E. Bacher wrote:
> Bob Booth - UIUC <[EMAIL PROTECTED]> wrote:
>
> >Has anyone heard when an ITSM client will be available for Solaris 9?
> >
> >We tried to install the latest patch level, and it failed.
>
> Do you mean the install failed?  The Solaris install package, as built
> by IBM/Tivoli, will reject a Solaris 9 system.  It is possible to hack
> the package to allow it to install (details available on request).
>
> Or do you mean you were able to install it but it didn't work?
>
> Please provide more specifics.
>
> Steve Bacher
> Draper Laboratory
> [EMAIL PROTECTED]



Re: Minimizing Database Utilization

2002-07-31 Thread Todd Lundstedt

We have no Oracle, DB2 or Exchange at the moment.  All we have is SQL and
Domino.  TDP for SQL v 1.1 (for SQL 6.5) works that way, and we are issuing
the commands to inactivate olderthan 10 days, and the management class is
set to 1/0/0/0.  TDP for SQL v 2.2 (for SQL 7.0/2000) and TDP for Domino
correctly use the management classes/definitions assigned without the need
for inactivate commands.

Still looking for why some of my SQL servers using storage agent are
starting and ending so many sessions per second.  I am sure that is one
reason why my database seems to be over utilized based on the number of
files I have managed in the database.


|+->
||  "MC Matt Cooper|
||  (2838)"|
||   |
||  Sent by: "ADSM:|
||  Dist Stor Manager" |
||  <[EMAIL PROTECTED]|
||  DU>|
|| |
|| |
||  07/31/02 09:59 AM  |
||  Please respond to  |
||  "ADSM: Dist Stor   |
||  Manager"   |
|| |
|+->
  
>---|
  |
   |
  |  To: [EMAIL PROTECTED]  
   |
  |  cc:   
   |
  |  Subject: Re: Minimizing Database Utilization  
   |
  
>---|




Look to make sure your TDP's are actually deleting their backups.
I
was burned by DB2, Oracle and MS-EXCHANGE platforms not sending the command
to TSM to delete their old backups.   These files are NOT really being
managed by the copygroup policy the way you may think they are.  The client
must tell the server that the file (the TDP backups are all date/time
stamped and therefore UNIQUE) has been deleted.  Then your deleted file
policy in the copygroup is in effect.
Matt

-Original Message-
From: Todd Lundstedt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:15 AM
To: [EMAIL PROTECTED]
Subject: Re: Minimizing Database Utilization

Expiration is working fine.  It starts every morning at 5 AM, and runs for
about 30-40 minutes.
*
ANR0812I Inventory file expiration process 295 completed:
 examined 944182 objects, deleting 37102 backup objects, 0
 archive objects, 0 DB backup volumes, and 0 recovery plan
 files. 0 errors were encountered
*
Does this mean I only have 944,182 objects being managed by the database?
If so, it sounds like I do have something bloating my database.  If Thomas
D. can get primary and copy pool backups for 4.8 million + files in a 10GB
database, and my 8GB database is filled nearly 70% utilized with less than
a million objects, something is wrong somewhere.

Also, I in looking for things that stand out, I found occasional instances
in my 30 days worth of activity log where a TDP for SQL server started/end
sessions for storage agent on the order of 5-40 times per second, sometimes
lasting 4-5 seconds, sometimes lasting 4-5 minutes.  I understand that
anything in the activity log is in the database, too.  Any ideas what could
be causing the storage agent to start/end sessions 40 times per second for
5 minutes?





|+>
||  Roger Deschner|
||  <[EMAIL PROTECTED]|
||  U>|
||  Sent by:  |
||  "ADSM: Dist   |
||  Stor Manager" |
||  <[EMAIL PROTECTED]|
||  IST.EDU>  |
|||
|||
||  07/31/02 01:14|
||  AM|
||  Please respond|
||  to "ADSM: Dist|
||  Stor Manager" |
|||
|+>

>
---
|
  |
|
  |  To: [EMAIL PROTECTED]
|
  |  cc:
|
  |  Subject: Re: Minimizing Database Utilization
|

>
---
|




Consider the possibility that you are not expiring well enough, which
could be causing database bloat. (Not to mention tape storage pool
bloat.) How

Re: Minimizing Database Utilization

2002-07-31 Thread Henk ten Have

On 31-Jul-02 Todd Lundstedt wrote:
> Expiration is working fine.  It starts every morning at 5 AM, and runs for
> about 30-40 minutes.
> *
> ANR0812I Inventory file expiration process 295 completed:
>  examined 944182 objects, deleting 37102 backup objects, 0
>  archive objects, 0 DB backup volumes, and 0 recovery plan
>  files. 0 errors were encountered
> *
> Does this mean I only have 944,182 objects being managed by the database?

  No, this means that you had 944,182 inactive objects.

> If so, it sounds like I do have something bloating my database.  If Thomas
> D. can get primary and copy pool backups for 4.8 million + files in a 10GB
> database, and my 8GB database is filled nearly 70% utilized with less than
> a million objects, something is wrong somewhere.

  Try a "select sum(num_files) as "File Count" from occupancy" and you know
  exactly how many object you have.
  My guess is you have 17230769 objectswell, between 16 an 17 million...

  Cheers,
  Henk ten Have.



Re: Backing Up Dir's

2002-07-31 Thread Jim Smith

Rikk,

Are you observing this behavior?  When NetWare is restoring files which do
not have a supporting directory structure, a temporary directory entry
(i.e., no trustee information) is created by Novell's backup API; when the
directory entries do come from the server at a later time they are
restored over the  temporary directory entry; the end result is that the
files and directories are restored fully and correctly regardless of their
ordering from the server.  If you are not seeing this behavior, I would
suggest talking to the service organization.

Thanks,
Jim

J.P. (Jim) Smith
TSM Client Development

>>>


We currently backup 12 Netware servers nightly, I also now need to backup
the directory structure as a seperate backup job.
The reason for this is that in a DR when you do a complete restore of a
Netware server if TSM attempts to restore a file before the dir for it has
been restored it skips the file, so the idea is to backup the dir's
seperatly then come DR to restore all the dir's then do a normal restore
over it.
What I need to know is how would I got about backing up just dirs to a
seperate pool?

Thanks in advance.

..Rikk


> iTNET
> Rikk Cahill
> 3rd Line Server Support
> [EMAIL PROTECTED]
> Equitas London 0207-342-2358
>
>



Equitas Limited, 33 St Mary Axe, London EC3A 8LL, UK
NOTICE: This message is intended only for use by the named addressee
and may contain privileged and/or confidential information.  If you are
not the named addressee you should not disseminate, copy or take any
action in reliance on it.  If you have received this message in error
please notify [EMAIL PROTECTED] and delete the message and any
attachments accompanying it immediately.

Equitas reserve the right to monitor and/or record emails, (including the
contents thereof) sent and received via its network for any lawful
business
purpose to the extent permitted by applicable law

Registered in England: Registered no. 3173352 Registered address above




Re: ANR8925W storage agent drive timeouts

2002-07-31 Thread Richard Cowen

I had a PMR on a similiar issue some time ago (Jan 2002)
PMR 28921,469 - retention timeout for storage agent
I don't know how my 20 minutes got to be your 10 minutes, though.


Richard,
   Final answer is that it's hard-coded 20 minutes.  Hopefully, your
storage agent doesn't die very often, so it shouldn't be too much of
an issue.  If this is not the case, or if you need anything further,
please let us know.
   Thank you for using Tivoli support.
.
Yours truly,
Josh Davis - TSM/TDP Support

-Original Message-
From: David E Ehresman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:18 AM
To: [EMAIL PROTECTED]
Subject: ANR8925W


Is there a parm that controls the time that tsm waits for a storage
agent to respond before issuing the "ANR8925W Drive DRIVE105 in library
3494 has not been confirmed for use by server MINERVA_SA for over 600
seconds. Drive will be reclaimed for use by others" message?

David



ANR8925W

2002-07-31 Thread David E Ehresman

Is there a parm that controls the time that tsm waits for a storage
agent to respond before issuing the "ANR8925W Drive DRIVE105 in library
3494 has not been confirmed for use by server MINERVA_SA for over 600
seconds. Drive will be reclaimed for use by others" message?

David



Re: Minimizing Database Utilization

2002-07-31 Thread Todd Lundstedt

Expiration is working fine.  It starts every morning at 5 AM, and runs for
about 30-40 minutes.
*
ANR0812I Inventory file expiration process 295 completed:
 examined 944182 objects, deleting 37102 backup objects, 0
 archive objects, 0 DB backup volumes, and 0 recovery plan
 files. 0 errors were encountered
*
Does this mean I only have 944,182 objects being managed by the database?
If so, it sounds like I do have something bloating my database.  If Thomas
D. can get primary and copy pool backups for 4.8 million + files in a 10GB
database, and my 8GB database is filled nearly 70% utilized with less than
a million objects, something is wrong somewhere.

Also, I in looking for things that stand out, I found occasional instances
in my 30 days worth of activity log where a TDP for SQL server started/end
sessions for storage agent on the order of 5-40 times per second, sometimes
lasting 4-5 seconds, sometimes lasting 4-5 minutes.  I understand that
anything in the activity log is in the database, too.  Any ideas what could
be causing the storage agent to start/end sessions 40 times per second for
5 minutes?





|+>
||  Roger Deschner|
||  <[EMAIL PROTECTED]|
||  U>|
||  Sent by:  |
||  "ADSM: Dist   |
||  Stor Manager" |
||  <[EMAIL PROTECTED]|
||  IST.EDU>  |
|||
|||
||  07/31/02 01:14|
||  AM|
||  Please respond|
||  to "ADSM: Dist|
||  Stor Manager" |
|||
|+>
  
>---|
  |
   |
  |  To: [EMAIL PROTECTED]  
   |
  |  cc:   
   |
  |  Subject: Re: Minimizing Database Utilization  
   |
  
>---|




Consider the possibility that you are not expiring well enough, which
could be causing database bloat. (Not to mention tape storage pool
bloat.) How long does your expiration process take? Does it seem to
never end? If so, you may be in an expiration bound death spiral.

If you are having trouble with expiration as it is, you are in no
position to take on an additional large client system, as was the start
of this thread. Dramatically lengthening expiration process run times
are a true sign that a TSM server is out of gas, and needs an upgrade
just for its present workload, not to mention adding more work to it.

Roger Deschner  University of Illinois at Chicago [EMAIL PROTECTED]

On Tue, 30 Jul 2002, Todd Lundstedt wrote:

>Well, well.. I totally read my book the wrong way.  I will go recalculate.
>Thanks for pointing out this huge error on my part.  Now I have to go
>figure out where the rest of my database utilization is going, too.



Re: RMAN error

2002-07-31 Thread Lisa Cabanas






Neil-- you're right, I (the TSM admin) wanted it done thru the scheduler,
so I would have the central point of management.  However, the deal breaker
was the complexity of setting up the schedulers, so the DBAs assumed
responsibility of monitoring those backups and ran them thru Oracle's CRON.

In hindsight, maybe it worked out for the best after all;-)

lisa


|-+>
| |   Neil Rasmussen   |
| |   <[EMAIL PROTECTED]|
| |   COM> |
| |   Sent by: "ADSM:  |
| |   Dist Stor|
| |   Manager"  |
| ||
| ||
| |   07/31/2002 09:06 |
| |   AM   |
| |   Please respond to|
| |   "ADSM: Dist Stor |
| |   Manager" |
| ||
|-+>
  
>--|
  |
  |
  |   To:   [EMAIL PROTECTED]   
  |
  |   cc:  
  |
  |   Subject:  Re: RMAN error 
  |
  
>--|




Lisa,

Really, for the most part I do not use the scheduler except where testing
in a development environment is concerned. So with regards to specific
scenarios I believe that, you, the customer are the experts on each of
your specific systems. What I do know is that using CRON for Rman backups
is the easiest to set up. However, what CRON does not offer is a central
point of managing schedules. In most cases I have seen a clear line of
responsibility between the Oracle DBA and the TSM DBA. This means that
usually when it comes to scheduling backups to the TSM Server the TSM DBA
will determine how the backups will be managed and therefor chooses the
TSM scheduler.


Regards,

Neil Rasmussen
Software Development
TDP for Oracle
[EMAIL PROTECTED]







Re: RMAN error

2002-07-31 Thread Neil Rasmussen

Lisa,

Really, for the most part I do not use the scheduler except where testing
in a development environment is concerned. So with regards to specific
scenarios I believe that, you, the customer are the experts on each of
your specific systems. What I do know is that using CRON for Rman backups
is the easiest to set up. However, what CRON does not offer is a central
point of managing schedules. In most cases I have seen a clear line of
responsibility between the Oracle DBA and the TSM DBA. This means that
usually when it comes to scheduling backups to the TSM Server the TSM DBA
will determine how the backups will be managed and therefor chooses the
TSM scheduler.


Regards,

Neil Rasmussen
Software Development
TDP for Oracle
[EMAIL PROTECTED]



Re: Backing Up Dir's

2002-07-31 Thread Talafous, John G.

Along this thread...  Are there any guidelines for retention and number of
copies in the DIRMC management class? I've looked and looked and it seems
the best scenario is to clone your management class with the longest
retention. But, is this correct?

John G. Talafous  IS Technical Principal
The Timken CompanyGlobal Software Support
P.O. Box 6927 Data Management
1835 Dueber Ave. S.W. Phone: (330)-471-3390
Canton, Ohio USA  44706-0927  Fax  : (330)-471-4034
[EMAIL PROTECTED]   http://www.timken.com


**
This message and any attachments are intended for the
individual or entity named above. If you are not the intended
recipient, please do not forward, copy, print, use or disclose this
communication to others; also please notify the sender by
replying to this message, and then delete it from your system.

The Timken Company
**



7337 DLT Lib and Volume Management

2002-07-31 Thread Theresa Sarver

Hello;

TSM Environment:
S80
7337 DLT lib
AIX 4.3.3 ML10
TSM 4.2.1

Anyone out there know anything about the 7337 DLT libs?  I have worked extensively 
with the 3570's but not DLTs...My question is that there are 10 magazine in the front 
of the lib that contains 10 tapes.  However, there is something in back called "Fixed 
Cells" and there are 5 tapes in these cells - so the library is housing 15 tapes 
total...however when I do a 'q libv'  I only see 13 tapes.  Also, my 'q libv' and 'q 
vol' don't match up - for instance the 'q vol' shows a tape (DSM010) as empty, 
however, the 'q libv' doesn't even show the tape in the library.  ???  Does TSM write 
to these "Fixed Cell" tapes as well? - Or just the 10 tapes in the Magazine?

Lastly, the compression setting (if there is one) doesn't appear to be correct.  These 
tapes are 35/70GB, however I only have 2 tapes out of 9 that are getting 70GB - the 
rest are getting around 35GB (q vol).  Anyone know of where I can look to resolve this 
issue?

Here is some more data which I hope will help:

7337 TAPE LAYOUT:
The following tapes are located inside the 7337 Magazine:
015, 016, 002, 017, 004, 005, 006, 018, 008, 009

The next 5 cartridges are located in the 5 "Fixed Cells":
010, 011, 012, 013, 014

TSM INFORMATION:

q vol:

Volume Name   Storage  Device  EstimatedPct  
Volume 
  Pool NameClass Name   Capacity   Util  
Status 
(MB) 
  ---  --  -  - 

DSM004DLTPOOL  AUTOCLASS70,000.0   22.0 
Filling 
DSM006DLTPOOL  AUTOCLASS38,991.2   98.0   
Full  
DSM008DLTPOOL  AUTOCLASS38,574.2   62.6   
Full  
DSM009DLTPOOL  AUTOCLASS70,000.0   66.8 
Filling 
DSM010DLTPOOL  AUTOCLASS 0.00.0  
Empty  
DSM011DLTPOOL  AUTOCLASS31,799.3   71.4   
Full  
DSM014DLTPOOL  AUTOCLASS33,817.9   46.9   
Full  
DSM016DLTPOOL  AUTOCLASS38,772.4   48.4   
Full  
DSM018DLTPOOL  AUTOCLASS 0.00.0  
Empty  

q libv:

Library Name   Volume Name   Status   OwnerLast UseHome
Element
   ---   --   --   -  

AUTOLIBDSM002Scratch   2   
   
AUTOLIBDSM004Private   Data4   
   
AUTOLIBDSM006Private   Data6   
   
AUTOLIBDSM008Private   Data8   
   
AUTOLIBDSM009Private   Data9   
   
AUTOLIBDSM011Private   Data11  
   
AUTOLIBDSM012Scratch   12  
   
AUTOLIBDSM013Private   Data13  
   
AUTOLIBDSM014Private   Data14  
   
AUTOLIBDSM015Private   DbBackup0   
   
AUTOLIBDSM016Private   Data1   
   
AUTOLIBDSM017Private   DbBackup3   
   
AUTOLIBDSM018Private   Data7   
   

Thanks for your assistance;
Theresa



Re: Backing Up Dir's

2002-07-31 Thread Niklas Lundstrom

Define a separate management class for the directories, then use the DIRMC
parameter i the OPT-file

Regards
Niklas

-Original Message-
From: Cahill, Ricky [mailto:[EMAIL PROTECTED]]
Sent: den 31 juli 2002 13:04
To: [EMAIL PROTECTED]
Subject: Backing Up Dir's


We currently backup 12 Netware servers nightly, I also now need to backup
the directory structure as a seperate backup job. The reason for this is
that in a DR when you do a complete restore of a Netware server if TSM
attempts to restore a file before the dir for it has been restored it skips
the file, so the idea is to backup the dir's seperatly then come DR to
restore all the dir's then do a normal restore over it. What I need to know
is how would I got about backing up just dirs to a seperate pool?

Thanks in advance.

  ..Rikk


> iTNET
> Rikk Cahill
> 3rd Line Server Support
> [EMAIL PROTECTED]
> Equitas London 0207-342-2358
>
>




Equitas Limited, 33 St Mary Axe, London EC3A 8LL, UK
NOTICE: This message is intended only for use by the named addressee and may
contain privileged and/or confidential information.  If you are not the
named addressee you should not disseminate, copy or take any action in
reliance on it.  If you have received this message in error please notify
[EMAIL PROTECTED] and delete the message and any attachments
accompanying it immediately.

Equitas reserve the right to monitor and/or record emails, (including the
contents thereof) sent and received via its network for any lawful business
purpose to the extent permitted by applicable law

Registered in England: Registered no. 3173352 Registered address above





Restoring MSCS cluster node

2002-07-31 Thread Krzysztof Kus

Hi.

Has anyone got an idea how to perform "bare metal" restore of MSCS
cluster node (win2k, winNT)? I have performed a lot of tries to do that.
Sometimes it succeeds sometimes doesn't. According to the redbook
sg24-6141 "Deploying the TSM client in a win2k env" I restored ALL
system object including cluster db but cluster services were not running
(of course) and restore failed. So I restored system objects except
cluster db (first time it succeeded).

If you know any better redbook than above or if you have any experience
in it please HELP ME!



--

--== KKus ==--



Re: Crashed diskpool volume

2002-07-31 Thread Loon, E.J. van - SPLXM

Hi Paul!
>From the TDP for Oracle manual:

Displays formatted output to the screen (files that exist on TSM but not on
RMAN)

And indeed after some investigation: TDPOSYNC will not work. It removes
obsolete backup pieces from TSM, it will not remove obsolete recovery
catalog entries.
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 00:22
To: [EMAIL PROTECTED]
Subject: Re: Crashed diskpool volume


Look at TDPOSYNC to sync the catalog with TSM.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 11:01 AM
To: [EMAIL PROTECTED]
Subject: Crashed diskpool volume


Hi *SM-ers!
One of my diskpool volumes (SSA 36 Gb. disk) crashed. The disk has been
replaced and I started a restore volume for the disk. Now I need to find out
which files are lost (because the files were written to the disk after the
last backup stgpool). This because I need to know which Oracle backups are
now incomplete, so we can update the Oracle Recovery catalog. I cannot find
any way to retrieve this information from TSM. Does anybody know a way to do
this? Thanks in advance for any reply! Kindest regards, Eric van Loon KLM
Royal Dutch Airlines


**
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may
be disclosed, copied or distributed, and that any other action related to
this e-mail or attachment is strictly prohibited, and may be unlawful. If
you have received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message. Koninklijke Luchtvaart
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be
liable for the incorrect or incomplete transmission of this e-mail or any
attachments, nor responsible for any delay in receipt.
**



[no subject]

2002-07-31 Thread Jeff White

*

This e-mail may contain confidential information or be privileged. It is intended to 
be read and used only by the named recipient(s). If you are not the intended 
recipient(s) please notify us immediately so that we can make arrangements for its 
return: you should not disclose the contents of this e-mail to any other person, or 
take any copies. Unless stated otherwise by an authorised individual, nothing 
contained in this e-mail is intended to create binding legal obligations between us 
and opinions expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the Financial 
Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life 
assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  - for unit 
trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for 
ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   
Internet  http://www.cis.co.uk   E-mail [EMAIL PROTECTED]

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank 
p.l.c., registered in England and Wales number 990937, P.O. Box 101, 1 Balloon Street, 
Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of 
the Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited





Odd message for NT cluster backup

2002-07-31 Thread Jeff White

The backup for one of our NT clusters fail every week or so. I see a
message in the DSMERROR.LOG

30.07.2002 15:57:57 TcpInit(): SearchPath(WININET.DLL): Win32 RC = 0 .

Anyone seen this before, or have an idea what it means?

Jeff White
Systems Programming
CIS
Manchester UK

*

This e-mail may contain confidential information or be privileged. It is intended to 
be read and used only by the named recipient(s). If you are not the intended 
recipient(s) please notify us immediately so that we can make arrangements for its 
return: you should not disclose the contents of this e-mail to any other person, or 
take any copies. Unless stated otherwise by an authorised individual, nothing 
contained in this e-mail is intended to create binding legal obligations between us 
and opinions expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the Financial 
Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life 
assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  - for unit 
trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for 
ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   
Internet  http://www.cis.co.uk   E-mail [EMAIL PROTECTED]

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank 
p.l.c., registered in England and Wales number 990937, P.O. Box 101, 1 Balloon Street, 
Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of 
the Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited





Re: Crashed diskpool volume

2002-07-31 Thread Loon, E.J. van - SPLXM

Hi Wanda!
That will not work. The failing disk has already been removed from the SSA
drawer, so I can't do an audit.
Also, an audit will only show you the damaged files, not whether these
damaged files were backed up (and thus restorable) or not.
However, Dwight Cook gave me the perfect answer. When you issue a q cont
after the restore volume, it only lists the files that could not be
restored. This is exactly what I wanted to know.
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


-Original Message-
From: Prather, Wanda [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 21:35
To: [EMAIL PROTECTED]
Subject: Re: Crashed diskpool volume


An AUDIT on the disk volume should do it.
I would run FIX=NO on the first pass, I think that will give you a list of
the damaged (in this case, MISSING) files in the activity log.


-Original Message-
From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 11:01 AM
To: [EMAIL PROTECTED]
Subject: Crashed diskpool volume


Hi *SM-ers!
One of my diskpool volumes (SSA 36 Gb. disk) crashed. The disk has been
replaced and I started a restore volume for the disk.
Now I need to find out which files are lost (because the files were written
to the disk after the last backup stgpool). This because I need to know
which Oracle backups are now incomplete, so we can update the Oracle
Recovery catalog.
I cannot find any way to retrieve this information from TSM.
Does anybody know a way to do this?
Thanks in advance for any reply!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


**
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may
be disclosed, copied or distributed, and that any other action related to
this e-mail or attachment is strictly prohibited, and may be unlawful. If
you have received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message. Koninklijke Luchtvaart
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be
liable for the incorrect or incomplete transmission of this e-mail or any
attachments, nor responsible for any delay in receipt.
**



Expiration problem with TSM 5.1.1.1 on AIX 4.3.3

2002-07-31 Thread Gerhard Rentschler

Hello,
after one day I got the first more severe problem. I started expiration and
afterward migration for a storage pool. Later I started migration for
another storage pool. Aftwards I noticed that the expiration and the other
migration processes have stopped advancing their counters. Cancelling the
processes doesn't help. For the expiration I get ANR0819I Cancel in
progress. For the last migration process the cancel was accepted, but there
was no effect. Everything else (Backup sessions, admin commands) seems to
work.Colleagues from a neighbour university have this problem as well. They
say after one hour they get an error message and the processes resume work.

Has anyone else seen this? Is there a circumvention for this?

I created PMR 88563, branch 070, country 724.
Best regards
Gerhard
---
Gerhard Rentschleremail:[EMAIL PROTECTED]
Regional Computing Center tel.   ++49/711/685 5806
University of Stuttgart   fax:   ++49/711/682357
Allmandring 30a
D 70550
Stuttgart
Germany



Re: Managedservice

2002-07-31 Thread Christo Heuer

Hi Thomas, Manuel,

The dsmcad exists on both AIX and NT/2000 - it is
just on NT the service is called "tsm client acceptor".
The part of it stopping and starting(Managing) the scheduler
process came into effect in 4.2 client code. The client's
dsm.opt can contain a line called
managedservices schedule webclient
When this is specified you do not start the Tsm Scheduler
process - the dsmcad is the only process that runs and controls
the starting/stopping of the client scheduler.
The purpose of the dsmcad was originally for the web
client, and then modified (in 4.2), to control the tsm
scheduler if you choose to do so. The whole idea was
to release memory every time the scheduler is stopped
and started - in 4.2.2 these memory issues were addressed
so you do not need the dsmcad to manage the services.
OK - that was a mouthfull - but I think you get the
picture?

Regards
Christo Heuer


Thomas,
On AIX, DSMCAD is the Client Aceptor Daemon, and it
will let you establish sessions using any browser (
IE, Netscape, etc.), however it will not start the
scheduler.
To start the scheduler use: nohup dsmc schedule.
This is the output of the ps command grepping for
dsmc:

my_server:/ $ ps -ef|grep dsmc
root 16522 1   0   Jun 18  -  4:14
./dsmcad
root 19100 1   0   Jun 18  - 22:52 dsmc
schedule
root 27066 34528   1 16:07:08  pts/4  0:00 grep
dsmc

Manuel

--- "Rupp Thomas (Illwerke)" <[EMAIL PROTECTED]>
wrote:
> Hi TSM-ers,
>
> is my understanding correct that on
> AIX I just start DSMCAD and let it start the
> Scheduler and/or the Client
> Agent
> and on
> Windows NT/2000 I have to define all 3 Services (TSM
> Client Acceptor, TSM
> Remote
> Client Agent and TSM Schedule) but only start the
> TSM Client Acceptor?
>
> Thanks for your support!
>
> Greetings from Austria
> Thomas Rupp
> Vorarlberger Illwerke AG
> MAIL:   [EMAIL PROTECTED]
> TEL:++43/5574/4991-251
> FAX:++43/5574/4991-820-8251
>
>
>
>

--
> Dieses eMail wurde auf Viren geprueft.
>
> Vorarlberger Illwerke AG
>

--


=
Thanks,
Manuel J Sanchez
Senior UNIX SA
Assurant Group
(305) 252-7035 x32153

__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com

__
"The information contained in this communication is confidential and
may be legally privileged.  It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it.  If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking action
in reliance of the contents of this information is strictly prohibited
and may be unlawful.  Absa is neither liable for the proper, complete
transmission of the information contained in this communication, any
delay in its receipt or that the mail is virus-free."



Re: select statement using filespaces and tapes

2002-07-31 Thread John Naylor

Marc,
Don't think you can do this, including backup date.
I am posting a select which does the rest

/*  Script Name:  Q_TAPE_VOLS*/
/*  Description: Display the TAPES that  */
/*   relate to a specific node   */
/*   and filespace   */
/*  Parameter:   node name filespace name*/
/*   and storage pool*/
/*  Example:  run q_tape_vols test2  test2\data:  tape2 */
select distinct volume_name,node_name,filespace_name from -
  volumeusage where node_name = upper('$1') -
  and filespace_name = upper('$2') -
  and stgpool_name = upper('$3')





Marc Lowers <[EMAIL PROTECTED]> on 07/30/2002 05:00:29 PM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSE)
Subject:  select statement using filespaces and tapes



I'm looking for a select statement which will provide me with a list of
tapes associated with a given node, filespace name and backup date.  I've
been looking into linking the backups table with another to provide the
result  but this has been unsuccessful so far.

Am I close or miles off with this method?


Marc.








**
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**