how to free licenses ??

2001-07-12 Thread Arnaud Brion

Hi *SM'ers !

A little embarrassing problem : a few days ago I got a message from  TSM server, 
telling me I was not in compliance with license terms : - so far I agree, I added few 
new nodes to the system ...
 I then decided to remove some old nodes that where not in use anymore, with the goal 
freeing some licenses ... Guess what ? I still have the same number of managed servers 
in use !!!
How is it possible to update this value ??
Any help would be greatly appreciated ...
TIA
Arnaud.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78/Fax: +41 61 226 17 01 |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=



Re: how to free licenses ??

2001-07-12 Thread Tom Melton

Arnaud,

What TSM version?  If the newer version, actually TSM vs ADSM (I
believe), it is supposed to work such that only "active clients" are
counted in the license figure and after so many days of inactivity they
are no longer counted.

Let us know the TSM version, and I bet someone will have the specific
info to assist.

Tom Melton
Emory HealthCare

>>> [EMAIL PROTECTED] 07/12/01 02:28AM >>>
Hi *SM'ers !

A little embarrassing problem : a few days ago I got a message from
TSM server, telling me I was not in compliance with license terms : - so
far I agree, I added few new nodes to the system ...
 I then decided to remove some old nodes that where not in use anymore,
with the goal freeing some licenses ... Guess what ? I still have the
same number of managed servers in use !!!
How is it possible to update this value ??
Any help would be greatly appreciated ...
TIA
Arnaud.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78/Fax: +41 61 226 17 01 |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=



Re: how to free licenses ??

2001-07-12 Thread Arnaud Brion

Sorry I forgot this parameter : our server (AIX 4.3.3) hosts a 4.1.3 TSM version

-Original Message-
From: Tom Melton
Sent: Donnerstag, 12. Juli 2001 10:15
To: [EMAIL PROTECTED]
Subject: Re: how to free licenses ??


Arnaud,

What TSM version?  If the newer version, actually TSM vs ADSM (I
believe), it is supposed to work such that only "active clients" are
counted in the license figure and after so many days of inactivity they
are no longer counted.

Let us know the TSM version, and I bet someone will have the specific
info to assist.

Tom Melton
Emory HealthCare

>>> [EMAIL PROTECTED] 07/12/01 02:28AM >>>
Hi *SM'ers !

A little embarrassing problem : a few days ago I got a message from
TSM server, telling me I was not in compliance with license terms : - so
far I agree, I added few new nodes to the system ...
 I then decided to remove some old nodes that where not in use anymore,
with the goal freeing some licenses ... Guess what ? I still have the
same number of managed servers in use !!!
How is it possible to update this value ??
Any help would be greatly appreciated ...
TIA
Arnaud.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78/Fax: +41 61 226 17 01 |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=



TSM-Server wieder erreichbar

2001-07-12 Thread Hermann Frasch

Sehr geehrte Betreuer/innen von TSM-Clients!

Client-Sessions mit dem TSM-Server sind ab sofort wieder moeglich.

Mit freundlichem Gruss
Hermann Frasch

--
Hermann Frasch   | Tel.  : (++49)711/685 5952
Rechenzentrum der| Fax   : (++49)711/682357
Universität Stuttgart (RUS)  | Email : [EMAIL PROTECTED]
Allmandring 30   |
70550 Stuttgart-Vaihingen|
WWW:
http://servwww.rus.uni-stuttgart.de/ZSDNEU/People/frasch_de_noframe.html



WIN2k DNS Backup

2001-07-12 Thread Amini, Mehdi

Can someone please answer this.
We are moving our DNS server from Sun Box to Windows 2000 and was wondering
if anyone has done a backup of DNS on WIN2K and if they had a problem
backing this and if yes what was the workaround?

Thanks

Mehdi Amini
LAN/WAN Engineer
ValueOptions
3110 Fairview Park Drive
Falls Church, VA 22042
Phone: 703-208-8754
Fax: 703-205-6879





**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender by email, delete and destroy this message and its
attachments.


**



Re: WIN2k DNS Backup

2001-07-12 Thread Richard Sims

>Can someone please answer this.
>We are moving our DNS server from Sun Box to Windows 2000 and was wondering
>if anyone has done a backup of DNS on WIN2K and if they had a problem
>backing this and if yes what was the workaround?

Mehdi - I don't have an answer for you; but I think the more compelling
question is whether a restoral of a DNS server with then-old
data would be a viable concept.  Certainly, restoring the software and
static data would be appropriate, but then there is all the temporal
DNS information...

   Richard Sims, BU



Audit vol fails

2001-07-12 Thread Palmadesso Jack

Good mornining all,

One of my DLT IV tapes seems to have gone bad last night.  When I try to run
an audit vol fix=yes on the volume the system complains that there was an
i/o error while trying to read the vol label.  This causes the process to
fail.  I have no way of mounting this vol and there is data on it.  Other
than recreating the vol from the copy pool is there another way to fix this?

Jack Palmadesso



Tape/Drive problems

2001-07-12 Thread Gill, Geoffrey L.

Hello all and welcome to tape/drive hell.

Last night I just happened to be looking at TSM from home when I discovered
2 tape drives offline. When I tried to change the status I received the
following message:
07/11/01 20:41:26 ANR8413E UPDATE DRIVE: Drive RMT4 is currently in use.

07/11/01 20:54:15 ANR8413E UPDATE DRIVE: Drive RMT1 is currently in use.


I called operations and discovered they had had an alert on rmt1. A tape was
mounted and could not be removed by TSM so they removed it. Seems as though
an almost exact thing happened to rmt4 and the tape would not come out. Did
they call me, no...did they call IBM, noI took care of that, fortunately
I just happened to be online and discovered this.

IBM says it sounds as if the tape that was in rmt4 sounds as if it's
dragging so they removed it from the library. That's great, now I have a
tape, possibly 2, with data on it and it sounds as if I don't want to put it
back in to try and move the data. What's the easiest way to fix this

I still could not get the drives online, even after IBM says they fixed
things, so my solution was to restart the system. Sure maybe I could have
brought down TSM and restarted it alone, but I didn't feel like wasting time
and then discovering I needed to restart the system anyway. This way I'm
covered all the way around, if this didn't work IBM would be getting another
call. The restart workedbut for how long? I'll have to keep an eye on
things today while the drives are busy copying data. In the mean time I need
to figure out how to get the data from this tape(s) moved.

The other burning question is, after IBM fixed things, why couldn't I get
the drives back online through TSM? Why the restart?


Here's a bit of what happened last night in case anyone cares to see
it

07/11/01 19:10:17 ANR8302E I/O error on drive RMT4 (/dev/rmt4) (OP=OFFL,

   CC=0, KEY=04, ASC=15, ASCQ=01,
SENSE=70.00.04.00.00.00.-

00.58.00.00.00.00.15.01.FE.02.31.5D.40.01.00.01.01.20.0-

0.FF.12.40.00.00.1B.08.05.00.00.00.00.00.00.00.00.00.00-

.00.00.00.00.00.00.00.FF.FF.FF.00.00.00.00.00.00.00.00.-

00.00.00.00.00.00.00.00.00.00.00.32.35.44.20.20.20.20.0-
   0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00,

   Description=An undetermined error has occurred).
Refer
   to Appendix B in the 'Messages' manual for
recommended
   action.

07/11/01 19:10:17 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.

07/11/01 19:10:38 ANR8311E An I/O error occurred while accessing drive
RMT4
   (/dev/rmt4) for QRYINQUIRY operation, errno = 9.

07/11/01 19:10:39 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.

07/11/01 19:11:38 ANR8311E An I/O error occurred while accessing drive
RMT4
   (/dev/rmt4) for QRYINQUIRY operation, errno = 9.

07/11/01 19:11:39 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.

07/11/01 19:12:38 ANR8311E An I/O error occurred while accessing drive
RMT4
   (/dev/rmt4) for QRYINQUIRY operation, errno = 9.

07/11/01 19:12:39 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.

07/11/01 19:13:38 ANR8311E An I/O error occurred while accessing drive
RMT4
   (/dev/rmt4) for QRYINQUIRY operation, errno = 9.

07/11/01 19:13:39 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.


A short time later I received an error on rmt1:

07/11/01 19:24:59 ANR8302E I/O error on drive RMT1 (/dev/rmt1)
(OP=WRITE,
   CC=0, KEY=06, ASC=5A, ASCQ=01,
SENSE=71.00.06.00.00.00.-

00.58.00.00.00.00.5A.01.FF.0A.C5.10.40.01.00.02.01.40.0-

0.00.00.00.00.00.0A.00.00.00.00.00.00.00.00.00.00.00.00-

.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.-

00.00.00.00.00.00.00.00.00.00.00.32.35.44.20.20.20.20.0-
   0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00,

   Description=An undetermined error has occurred).
Refer
   to Appendix B in the 'Messages' manual for
recommended
   action.

07/11/01 19:24:59 ANR8311E An I/O error occurred while accessing drive
RMT1
   (/dev/rmt1) for RDBLKID operation, errno = 46.

07/11/01 19:24:59 ANR8302E I/O error on drive RMT1 (/dev/rmt1)
(OP=WRITE,
   CC=0, KEY=02, ASC=3A, ASCQ=00,
SENSE=70.00.02.00.00.00.-

00.58.00.00.00.00.3A.00.FF.0A.C4.08.40.01.00.06.01.40.0-

0.00.00.00.00.00.0A.00.00.00.00.00.00.00.00.00.00.00.00-

.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.-

00.00.00.00.00.00.00.00.00

Re: Tape/Drive problems

2001-07-12 Thread David Longo

I have a IBM 3575 library and have had similar events a couple of times.  My 
understanding of what happens is this.  Some error happens on tape drive and
tape won't dismount, so *SM still thinks tape is mounted - drive in use.  Then we
dismount tape through other than *SM methods.  *SM doesn't know this.  The only 
way I have found to fix is to restart *SM - and I always run a library audit to clear
any tape location issues.

To clear tape, if it's not damaged, I would do a MOVE DATA on the suspect tape.
Could also do an audit volume to check it.

David Longo

>>> [EMAIL PROTECTED] 07/12/01 09:52AM >>>
Hello all and welcome to tape/drive hell.

Last night I just happened to be looking at TSM from home when I discovered
2 tape drives offline. When I tried to change the status I received the
following message:
07/11/01 20:41:26 ANR8413E UPDATE DRIVE: Drive RMT4 is currently in use.

07/11/01 20:54:15 ANR8413E UPDATE DRIVE: Drive RMT1 is currently in use.


I called operations and discovered they had had an alert on rmt1. A tape was
mounted and could not be removed by TSM so they removed it. Seems as though
an almost exact thing happened to rmt4 and the tape would not come out. Did
they call me, no...did they call IBM, noI took care of that, fortunately
I just happened to be online and discovered this.


I still could not get the drives online, even after IBM says they fixed
things, so my solution was to restart the system. Sure maybe I could have
brought down TSM and restarted it alone, but I didn't feel like wasting time
and then discovering I needed to restart the system anyway. This way I'm
covered all the way around, if this didn't work IBM would be getting another
call. The restart workedbut for how long? I'll have to keep an eye on
things today while the drives are busy copying data. In the mean time I need
to figure out how to get the data from this tape(s) moved.

The other burning question is, after IBM fixed things, why couldn't I get
the drives back online through TSM? Why the restart?


Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED] 
Phone:  (858) 826-4062
Pager:   (888) 997-9614



"MMS " made the following
 annotations on 07/12/01 10:05:53
--
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it, and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient.  Health First reserves the right to monitor all e-mail communications 
through its networks.  Any views or opinions expressed in this message are solely 
those of the individual sender, except (1) where the message states such views or 
opinions are on behalf of a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.

==



Re: Tape/Drive problems

2001-07-12 Thread Palmadesso Jack

Same here occasionally when tapes get stuck or drives go offline we have to
restart ADSM.  Even after issueing update drive commands.

Jack Palmadesso

-Original Message-
From: David Longo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 10:02 AM
To: [EMAIL PROTECTED]
Subject: Re: Tape/Drive problems


I have a IBM 3575 library and have had similar events a couple of times.  My

understanding of what happens is this.  Some error happens on tape drive and
tape won't dismount, so *SM still thinks tape is mounted - drive in use.
Then we
dismount tape through other than *SM methods.  *SM doesn't know this.  The
only
way I have found to fix is to restart *SM - and I always run a library audit
to clear
any tape location issues.

To clear tape, if it's not damaged, I would do a MOVE DATA on the suspect
tape.
Could also do an audit volume to check it.

David Longo

>>> [EMAIL PROTECTED] 07/12/01 09:52AM >>>
Hello all and welcome to tape/drive hell.

Last night I just happened to be looking at TSM from home when I discovered
2 tape drives offline. When I tried to change the status I received the
following message:
07/11/01 20:41:26 ANR8413E UPDATE DRIVE: Drive RMT4 is currently in use.

07/11/01 20:54:15 ANR8413E UPDATE DRIVE: Drive RMT1 is currently in use.


I called operations and discovered they had had an alert on rmt1. A tape was
mounted and could not be removed by TSM so they removed it. Seems as though
an almost exact thing happened to rmt4 and the tape would not come out. Did
they call me, no...did they call IBM, noI took care of that, fortunately
I just happened to be online and discovered this.


I still could not get the drives online, even after IBM says they fixed
things, so my solution was to restart the system. Sure maybe I could have
brought down TSM and restarted it alone, but I didn't feel like wasting time
and then discovering I needed to restart the system anyway. This way I'm
covered all the way around, if this didn't work IBM would be getting another
call. The restart workedbut for how long? I'll have to keep an eye on
things today while the drives are busy copying data. In the mean time I need
to figure out how to get the data from this tape(s) moved.

The other burning question is, after IBM fixed things, why couldn't I get
the drives back online through TSM? Why the restart?


Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (888) 997-9614



"MMS " made the following
 annotations on 07/12/01 10:05:53

--
This message is for the named person's use only.  It may contain
confidential, proprietary, or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it, and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient.  Health First reserves the right to monitor all e-mail
communications through its networks.  Any views or opinions expressed in
this message are solely those of the individual sender, except (1) where the
message states such views or opinions are on behalf of a particular entity;
and (2) the sender is authorized by the entity to give such views or
opinions.


==



Re: Audit vol fails

2001-07-12 Thread David Longo

I think recreating (restore volume) is the simplest way.  If the original tape is
not damaged, then I would do a LABEL LIBVOL on it with overwrite=yes
after it is cleared and see if tape can be reused.  My caveat about using 
overwrite=yes applies because you can overwrite good tapes!

David Longo

>>> [EMAIL PROTECTED] 07/12/01 09:43AM >>>
Good mornining all,

One of my DLT IV tapes seems to have gone bad last night.  When I try to run
an audit vol fix=yes on the volume the system complains that there was an
i/o error while trying to read the vol label.  This causes the process to
fail.  I have no way of mounting this vol and there is data on it.  Other
than recreating the vol from the copy pool is there another way to fix this?

Jack Palmadesso



"MMS " made the following
 annotations on 07/12/01 10:11:03
--
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it, and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient.  Health First reserves the right to monitor all e-mail communications 
through its networks.  Any views or opinions expressed in this message are solely 
those of the individual sender, except (1) where the message states such views or 
opinions are on behalf of a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.

==



Re: International characters on WinNT

2001-07-12 Thread Alexander Verkooijen

Thanks Mike, I understand now. We're running
a 4.1 server, so that must be the reason
why the backup fails. We have no intention to
4.2 any time soon (the upgrade to 4.1 took place
just a few hours ago), so I'll ask the customer
to rename his files to file name that don't contain
characters from another code page.

Thanks again,

Alexander

> The TSM 4.2.0 client for Windows NT/2000 is Unicode-enabled and will
> support the client environment where file names from various code pages
> are co-mingled in a file system.  This support co-req's a TSM 4.2 server.

> The message you are seeing indicates that the file in question contains
> characters which are not within the same code page as language of the
> operating system from which the TSM client is being run and that you
> either are not running at TSM 4.2 server or have not migrated the client
> to a Unicode-enabled file space.  The migration is documented in the
> Windows "Using the Backup-Archive Client" manual for v4.2.0.

> Regards,

> Mike Dile
> Tivoli Storage Manager Client Development
> [EMAIL PROTECTED]

---
Alexander Verkooijen([EMAIL PROTECTED])
Senior Systems Programmer
SARA High Performance Computing



Re: Tape/Drive problems

2001-07-12 Thread Richard Sims

...
>IBM says it sounds as if the tape that was in rmt4 sounds as if it's
>dragging so they removed it from the library. ...

Hi, Geoff - "Dragging"?  I've never heard that one before, in all the
years I've been working with IBM 34xx/35xx tapes.  In my
experience, mechanical problems have always been due to drive problems
or irregularities, and not the cartridges.  I'm very suspicious of CEs
who blame cartridges for drive problems.  You didn't say what they did
to fix the problem.  If they didn't work on the drives and fix whatever
their problems were, per diagnostic codes, then you didn't get a fix.
Certainly, if this is not a new tape and has been mounted and used
many times before, then there is little probability of the tape being
the problem.  Remember, there's 1 moving part in the tape, and a helluva
lot more in the drive.

We've had a bunch of problems with the upgraded 3590E drives.  (Why,
when the upgrade involved a whole pallet of boxes and parts, they
didn't simply replace the drives with factory-certified units, is
a big question for IBM, particularly given all the problems that
customers have had with the field-upgraded units.)  Our CEs have
found a lot of problems with the vacuum subsystems, and have
replaced some.  With tapes stuck in drives, I've *always* been able
to eject them either from the drive front panel or a power cycle of
the drive, and once resolved get the drive back into service under
ADSM, without restarting ADSM or otherwise affecting service with
the remaining drives.  The affected tapes went on to be used by ADSM,
as is: no need to move the data.  (It's not a tape problem.)

Per the TSM Messages manual, ASC=15, ASCQ=01 is a mechanical positioning
error; your ASC=5A, ASCQ=01 is operator media removal; ASC=3A, ASCQ=00
is medium not present.  I doubt that the problem drives were properly
reset for TSM to know of a state transition.  Make sure that a Reset is
done from the front panel, and a power cycle if needed, with a clean
state reflected on the front panel afterward.

  Richard Sims, BU



Re: Audit vol fails

2001-07-12 Thread Len Boyle

In article <[EMAIL PROTECTED]>,
Palmadesso Jack <[EMAIL PROTECTED]> says:
>
>Good mornining all,
>
>One of my DLT IV tapes seems to have gone bad last night.  When I try to run
>an audit vol fix=yes on the volume the system complains that there was an
>i/o error while trying to read the vol label.  This causes the process to
>fail.  I have no way of mounting this vol and there is data on it.  Other
>than recreating the vol from the copy pool is there another way to fix this?
>
>Jack Palmadesso

Hello Jack

If you have not already tried this solution, you can try reading the dlt cart
on other dlt drives. If the tape is not a total wreck, you might be able to
read it on another drive.

The other choice is to have a tape recovery company recover the data. But this
is costly and restoring the volume from a copy pool tape would be much better
and cheaper.

len



Re: Tape/Drive problems

2001-07-12 Thread Arnaud Brion

Hi Geoff (and all folks ...)
I just wanted to add a little thing to what my enlightened predecesors said : the 3575 
library is a kind of very sensitive animal : it doesn't like to be manipulated 
manually, that means if any technician has oppened the door and pushed the eject 
button of your drives to get the "stucked" tapes back, it didn't appreciate it at all, 
that's the reason why you had to stop your system.
This library has a kind of internal inventory : if something is done by hand, the 
machine doesn't keep track of it, and when it realises somethin doesn't match with 
what it considers as beeing it's content, it simply hangs !
Rebooting the systems just obliges the library to re-do it's inventory ...
But be aware of the fact that TSM is not informed of those modifications until you 
perform an audit of the library, or you restart the program.

-Original Message-
From: Palmadesso Jack
Sent: Donnerstag, 12. Juli 2001 16:14
To: [EMAIL PROTECTED]
Subject: Re: Tape/Drive problems


Same here occasionally when tapes get stuck or drives go offline we have to
restart ADSM.  Even after issueing update drive commands.

Jack Palmadesso

-Original Message-
From: David Longo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 10:02 AM
To: [EMAIL PROTECTED]
Subject: Re: Tape/Drive problems


I have a IBM 3575 library and have had similar events a couple of times.  My

understanding of what happens is this.  Some error happens on tape drive and
tape won't dismount, so *SM still thinks tape is mounted - drive in use.
Then we
dismount tape through other than *SM methods.  *SM doesn't know this.  The
only
way I have found to fix is to restart *SM - and I always run a library audit
to clear
any tape location issues.

To clear tape, if it's not damaged, I would do a MOVE DATA on the suspect
tape.
Could also do an audit volume to check it.

David Longo

>>> [EMAIL PROTECTED] 07/12/01 09:52AM >>>
Hello all and welcome to tape/drive hell.

Last night I just happened to be looking at TSM from home when I discovered
2 tape drives offline. When I tried to change the status I received the
following message:
07/11/01 20:41:26 ANR8413E UPDATE DRIVE: Drive RMT4 is currently in use.

07/11/01 20:54:15 ANR8413E UPDATE DRIVE: Drive RMT1 is currently in use.


I called operations and discovered they had had an alert on rmt1. A tape was
mounted and could not be removed by TSM so they removed it. Seems as though
an almost exact thing happened to rmt4 and the tape would not come out. Did
they call me, no...did they call IBM, noI took care of that, fortunately
I just happened to be online and discovered this.


I still could not get the drives online, even after IBM says they fixed
things, so my solution was to restart the system. Sure maybe I could have
brought down TSM and restarted it alone, but I didn't feel like wasting time
and then discovering I needed to restart the system anyway. This way I'm
covered all the way around, if this didn't work IBM would be getting another
call. The restart workedbut for how long? I'll have to keep an eye on
things today while the drives are busy copying data. In the mean time I need
to figure out how to get the data from this tape(s) moved.

The other burning question is, after IBM fixed things, why couldn't I get
the drives back online through TSM? Why the restart?


Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (888) 997-9614



"MMS " made the following
 annotations on 07/12/01 10:05:53

--
This message is for the named person's use only.  It may contain
confidential, proprietary, or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it, and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient.  Health First reserves the right to monitor all e-mail
communications through its networks.  Any views or opinions expressed in
this message are solely those of the individual sender, except (1) where the
message states such views or opinions are on behalf of a particular entity;
and (2) the sender is authorized by the entity to give such views or
opinions.


==



Re: Tape/Drive problems

2001-07-12 Thread PINNI, BALANAND (SBCSI)

PL upgrade microcode level of ur drive.
balanand pinni

-Original Message-
From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 8:52 AM
To: [EMAIL PROTECTED]
Subject: Tape/Drive problems


Hello all and welcome to tape/drive hell.

Last night I just happened to be looking at TSM from home when I discovered
2 tape drives offline. When I tried to change the status I received the
following message:
07/11/01 20:41:26 ANR8413E UPDATE DRIVE: Drive RMT4 is currently in use.

07/11/01 20:54:15 ANR8413E UPDATE DRIVE: Drive RMT1 is currently in use.


I called operations and discovered they had had an alert on rmt1. A tape was
mounted and could not be removed by TSM so they removed it. Seems as though
an almost exact thing happened to rmt4 and the tape would not come out. Did
they call me, no...did they call IBM, noI took care of that, fortunately
I just happened to be online and discovered this.

IBM says it sounds as if the tape that was in rmt4 sounds as if it's
dragging so they removed it from the library. That's great, now I have a
tape, possibly 2, with data on it and it sounds as if I don't want to put it
back in to try and move the data. What's the easiest way to fix this

I still could not get the drives online, even after IBM says they fixed
things, so my solution was to restart the system. Sure maybe I could have
brought down TSM and restarted it alone, but I didn't feel like wasting time
and then discovering I needed to restart the system anyway. This way I'm
covered all the way around, if this didn't work IBM would be getting another
call. The restart workedbut for how long? I'll have to keep an eye on
things today while the drives are busy copying data. In the mean time I need
to figure out how to get the data from this tape(s) moved.

The other burning question is, after IBM fixed things, why couldn't I get
the drives back online through TSM? Why the restart?


Here's a bit of what happened last night in case anyone cares to see
it

07/11/01 19:10:17 ANR8302E I/O error on drive RMT4 (/dev/rmt4) (OP=OFFL,

   CC=0, KEY=04, ASC=15, ASCQ=01,
SENSE=70.00.04.00.00.00.-

00.58.00.00.00.00.15.01.FE.02.31.5D.40.01.00.01.01.20.0-

0.FF.12.40.00.00.1B.08.05.00.00.00.00.00.00.00.00.00.00-

.00.00.00.00.00.00.00.FF.FF.FF.00.00.00.00.00.00.00.00.-

00.00.00.00.00.00.00.00.00.00.00.32.35.44.20.20.20.20.0-
   0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00,

   Description=An undetermined error has occurred).
Refer
   to Appendix B in the 'Messages' manual for
recommended
   action.

07/11/01 19:10:17 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.

07/11/01 19:10:38 ANR8311E An I/O error occurred while accessing drive
RMT4
   (/dev/rmt4) for QRYINQUIRY operation, errno = 9.

07/11/01 19:10:39 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.

07/11/01 19:11:38 ANR8311E An I/O error occurred while accessing drive
RMT4
   (/dev/rmt4) for QRYINQUIRY operation, errno = 9.

07/11/01 19:11:39 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.

07/11/01 19:12:38 ANR8311E An I/O error occurred while accessing drive
RMT4
   (/dev/rmt4) for QRYINQUIRY operation, errno = 9.

07/11/01 19:12:39 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.

07/11/01 19:13:38 ANR8311E An I/O error occurred while accessing drive
RMT4
   (/dev/rmt4) for QRYINQUIRY operation, errno = 9.

07/11/01 19:13:39 ANR8469E Dismount of 3590 volume U00361 from drive
RMT4
   (/dev/rmt4) in library 3494LIB failed.


A short time later I received an error on rmt1:

07/11/01 19:24:59 ANR8302E I/O error on drive RMT1 (/dev/rmt1)
(OP=WRITE,
   CC=0, KEY=06, ASC=5A, ASCQ=01,
SENSE=71.00.06.00.00.00.-

00.58.00.00.00.00.5A.01.FF.0A.C5.10.40.01.00.02.01.40.0-

0.00.00.00.00.00.0A.00.00.00.00.00.00.00.00.00.00.00.00-

.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.-

00.00.00.00.00.00.00.00.00.00.00.32.35.44.20.20.20.20.0-
   0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00,

   Description=An undetermined error has occurred).
Refer
   to Appendix B in the 'Messages' manual for
recommended
   action.

07/11/01 19:24:59 ANR8311E An I/O error occurred while accessing drive
RMT1
   (/dev/rmt1) for RDBLKID operation, errno = 46.

07/11/01 19:24:59 ANR8302E I/O error on drive RMT1 (/dev/rmt1)
(OP=WRITE,
   CC=0, KEY=02, ASC=3A, ASC

Re: checkin errors

2001-07-12 Thread Rob Schroeder

Actually, the tape will go into error often after the tape is inserted into
the drive and validated and checked.  The error "seems" to occur while the
tape is being place by the gripper back onto the rack.  I have even had the
same error occur to abend the service yet still check the tape in
correctly.  The drives are defined and on-line in TSM and are available in
the library.

Does anyone have any other ideas?

Thanks

Rob



TDP for SQL 1.1.2

2001-07-12 Thread Bruce Lowrie

I am using TDP for SQL version 1.1.2 on all of my SQL 7 / MS Cluster
installations with no problems. We are testing  out SQL 2000 using the same
version of the TDP and we received this error message:

ACO0302E -- NODENAME cannot be the local machine name when CLUSTERNODE is
set to YES

 when run this string from a command line interface :

sqldsmc  /sqlsecure /sqlserver:dclabvdb80 /adsmoptfile:dsmsql.opt
/backupfull:master

In the diserror.log file is this message:
07/10/2001 16:15:16 ANS1155E CLUSTERNODE option is set to YES but cluster is
not enabled.
Either the machine does not have cluster server installed, or the cluster
server is not running.

Anyone have any ideas?

Bruce E. Lowrie
Sr. Systems Analyst
Information Technology Services
Storage, Output, Legacy
*E-Mail:  [EMAIL PROTECTED]
*Voice: ?(517) 496-6404
*Post:Mail: CO2111, (DC2 1st Floor)




_
This message has been checked for all known viruses by the
MessageLabs Virus Scanning Service. For further information visit
http://www.messagelabs.com/stats.asp



Re: Tape/Drive problems

2001-07-12 Thread

I've been seeing these exact problems for weeks with on og my remote site.
I escalated the problem within IBM. They sent out their 3494 "top Gun" who
did an extended PM on all the drives in this system(8). The problems cleard
up for a week and now we're seeing them again. Ask you CS if you have the
double clip retainer that holds the tape in the drive when its inserted. It
seems like they've flip flopped on the issue of whether or not it should be
removed. Ours are all removed now.  We still have problems wih tapes
sticking in drives where a reset of the drive and a power off do-not
correct the problem.




"Richard Sims" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 07/12/2001 10:49:47 AM

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

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: Tape/Drive problems


...
>IBM says it sounds as if the tape that was in rmt4 sounds as if it's
>dragging so they removed it from the library. ...

Hi, Geoff - "Dragging"?  I've never heard that one before, in all the
years I've been working with IBM 34xx/35xx tapes.  In my
experience, mechanical problems have always been due to drive problems
or irregularities, and not the cartridges.  I'm very suspicious of CEs
who blame cartridges for drive problems.  You didn't say what they did
to fix the problem.  If they didn't work on the drives and fix whatever
their problems were, per diagnostic codes, then you didn't get a fix.
Certainly, if this is not a new tape and has been mounted and used
many times before, then there is little probability of the tape being
the problem.  Remember, there's 1 moving part in the tape, and a helluva
lot more in the drive.

We've had a bunch of problems with the upgraded 3590E drives.  (Why,
when the upgrade involved a whole pallet of boxes and parts, they
didn't simply replace the drives with factory-certified units, is
a big question for IBM, particularly given all the problems that
customers have had with the field-upgraded units.)  Our CEs have
found a lot of problems with the vacuum subsystems, and have
replaced some.  With tapes stuck in drives, I've *always* been able
to eject them either from the drive front panel or a power cycle of
the drive, and once resolved get the drive back into service under
ADSM, without restarting ADSM or otherwise affecting service with
the remaining drives.  The affected tapes went on to be used by ADSM,
as is: no need to move the data.  (It's not a tape problem.)

Per the TSM Messages manual, ASC=15, ASCQ=01 is a mechanical positioning
error; your ASC=5A, ASCQ=01 is operator media removal; ASC=3A, ASCQ=00
is medium not present.  I doubt that the problem drives were properly
reset for TSM to know of a state transition.  Make sure that a Reset is
done from the front panel, and a power cycle if needed, with a clean
state reflected on the front panel afterward.

  Richard Sims, BU



SAS code for accounting records

2001-07-12 Thread Zoltan Forray/AC/VCU

Does anyone have some SAS code (and are willing to share) that reads the
SMF type 42 subtype 14 records that TSM accounting produces?
===
Zoltan Forray
Virginia Commonwealth University
University Computing Center
e-mail: [EMAIL PROTECTED]
voice: 804-828-4807



Re: WIN2k DNS Backup

2001-07-12 Thread Scott Foley

I have not done this, and have only used DNS on Windows NT, but since no one
else was biting.

Windows NT stores DNS information in the registry as well as a directory...
\winnt\system32\dns\.  I think that there is a way to have it store the
information only in file, not the registry and possibly vice versa.  Backing
up this directory is not a problem.  The problem is getting Windows to use
it when you restore it.  If you simply lose the directory or want to go back
to a previous version of DNS information you can probably stop DNS, restore
the file and start DNS again.  Disaster recovery of the NT system is another
matter.  If you don't have a bare-bones restore option for the system, you
may need to reinstall Windows, TSM, and DNS.  When DNS is installed, and the
DNS files (\winnt\system32\dns\) restored Windows will not read them.  You
need to go into DNS and recreate each zone.  When it asks for the name of
the new zone file, use the name of the one that you restored (the DNS files
should be restored at this time).  Windows will then create the zone with
all of the entries that were in the restored file.

There is probably an easier way to do this, but I haven't looked hard enough
to find it.  A lot of this is testing that you can do with NT/2000 without
TSM.

Hope this helped a bit

Scott Foley
NetVoyage Corp
[EMAIL PROTECTED]




-Original Message-
From: Amini, Mehdi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 5:24 AM
To: [EMAIL PROTECTED]
Subject: WIN2k DNS Backup


Can someone please answer this.
We are moving our DNS server from Sun Box to Windows 2000 and was wondering
if anyone has done a backup of DNS on WIN2K and if they had a problem
backing this and if yes what was the workaround?

Thanks

Mehdi Amini
LAN/WAN Engineer
ValueOptions
3110 Fairview Park Drive
Falls Church, VA 22042
Phone: 703-208-8754
Fax: 703-205-6879





**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender by email, delete and destroy this message and its
attachments.


**



SQL on OS390

2001-07-12 Thread Zoltan Forray/AC/VCU

I see lots of SQL floating around here.

Since my server is OS390, I tried a "query" in batch.  However, the
command was too long for a 72-column "card".

What character is used to continue SQL commands onto subsequent lines ?  I
tried the standard "-" which works for almost *ALL* other OS390 utilities,
but it didn't work for TSM.

This is TSM 4.1.3.

===
Zoltan Forray
Virginia Commonwealth University
University Computing Center
e-mail: [EMAIL PROTECTED]
voice: 804-828-4807



All Session init attempts failed

2001-07-12 Thread Stan Vernaillen

Hello All,

first my setup: 3.7.4 server on AIX, 3.7.2 client on AIX with TDP3.1.4 for
SAP/R3
just (re)installed client...

when i try to do an "brbackup -u system/xxx -c -t online" it comes up
with the below error.
normal backup/archives are ok.

...
BR280I Time stamp 2001-07-12 19.41.19
BR229I Calling backup utility...
BR278I Command output of '/usr/sap/AP1/SYS/exe/run/backint -u AP1 -f backup
-i /oracle/AP1/sapbackup/.bdfthfdm.lst -t file -p
/oracle/AP1/dbs/initAP1.utl -c':

Tivoli Data Protection for R/3

 Interface between SAPDBA Utilities and Tivoli Storage Manager
   - Version 3, Release 1, Level 0.4  for AIX LF -
 Build: 119  compiled on Dec 13 2000
(c) Copyright IBM Corporation, 1996, 2000, All Rights Reserved.

BKI0005I: Start of backint program at: Thu Jul 12 19:41:19 2001 .
BKI1214E: TSM Error: 'All Session init attempts failed. (rc=137, cannot get
text for rc).'
BKI1201E: There are no Tivoli Storage Manager-Servers available.
BR233E Backup utility has reported an error while saving file
/oracle/AP1/sapdata2/es46cd_1/es46cd.data1
BR233E Backup utility has reported an error while saving file
/oracle/AP1/sapdata3/stabd_1/stabd.data1
...


In  the server actlog I can see lots of sessions from the client in the
same second, so it seems to find it's way to the server. ok

...
07/12/01 19:41:11 ANR0403I Session 615 ended for node APO (AIX).

07/12/01 19:41:11 ANR0406I Session 616 started for node APO (AIX)
(Tcp/Ip
   167.105.146.175(39129)).

07/12/01 19:41:11 ANR0403I Session 616 ended for node APO (AIX).

07/12/01 19:41:11 ANR0406I Session 617 started for node APO (AIX)
(Tcp/Ip
   167.105.146.175(39130)).

07/12/01 19:41:11 ANR0403I Session 617 ended for node APO (AIX).

...

in all dsm.opt/sys & init.* files i got the servername ok ( as far as
i can see )

Anybody any ideas.??

Stan



Re: TDP for SQL 1.1.2

2001-07-12 Thread Del Hoobler

Bruce,

Are you running this on a NT 4 or 2000 cluster?
Is the cluster service running?
If you run the "dsmc query filespace" program with the
same dsmsql.opt, do you see the same error?

What version of the TSM API are you running with?
("sqldsmc /adsmqueryserver" will tell you the answer.)
If it's a Windows 2000 cluster and an older TSM API,
it may not be working correctly.
You should be running at least 3.7.0 of the TSM API.

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

"It's a beautiful day.  Don't let it get away."  -- Bono




Bruce Lowrie
  cc:
Sent by: "ADSM: Subject: TDP for SQL 1.1.2
Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>


07/12/2001 12:49
PM
Please respond to
"ADSM: Dist Stor
Manager"





I am using TDP for SQL version 1.1.2 on all of my SQL 7 / MS Cluster
installations with no problems. We are testing  out SQL 2000 using the same
version of the TDP and we received this error message:

ACO0302E -- NODENAME cannot be the local machine name when CLUSTERNODE is
set to YES

 when run this string from a command line interface :

sqldsmc  /sqlsecure /sqlserver:dclabvdb80 /adsmoptfile:dsmsql.opt
/backupfull:master

In the diserror.log file is this message:
07/10/2001 16:15:16 ANS1155E CLUSTERNODE option is set to YES but cluster
is
not enabled.
Either the machine does not have cluster server installed, or the cluster
server is not running.

Anyone have any ideas?

Bruce E. Lowrie
Sr. Systems Analyst
Information Technology Services
Storage, Output, Legacy
*E-Mail:  [EMAIL PROTECTED]
*Voice: ?(517) 496-6404
*Post:Mail: CO2111, (DC2 1st Floor)




_
This message has been checked for all known viruses by the
MessageLabs Virus Scanning Service. For further information visit
http://www.messagelabs.com/stats.asp



archives for this list

2001-07-12 Thread Chuck Lam

Hello,

Would someone kindly show me how to look up archives
for this list?

TIA

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/



Re: Peculiar disaster recovery situation

2001-07-12 Thread Jeffrey Renicker

This is not a strange situation at all.  I dealt with the same issue
during our DR test last year.  Here's the steps I took:

1. Before you can restore the TSM database you'll need to update the
   device configuration file (pointed to by the DEVCONFIG statement
   in the dsmserv.opt file).  Look for the "DEFINE LIBRARY" statement
   for the 3494 and change it to read:
 DEFINE LIBRARY libname TYPE=MANUAL

   Save the file and restore the TSM database.

   Manual 3590 drives each have an LCD which displays the volser of the
   tape to mounted on that drive so you'll know which tape to mount on
   which drive.  As I recall, you'll also see a mount message on the TSM
   console.

2. After the TSM database is restored you need to remember that the
   library and drive definitions are kept there and they still reflect
   the 3494 library you have at home.  These need to be changed, too.

   Start the TSM server and bring up an admin session (dsmadmc) and
   issue these commands:

 DEL DRIVE 3494lib drivename   <- do this for all 4 tape drives
 DEF LIBR 3590LIB TYPE=MANUAL
 DEF DRIVE 3590LIB drivename DEVICE=devicename  <- do all 4 drives
 UPD DEVCLASS classname LIBR=3590LIB MOUNTL=4  <- do this for each
  devclass which used
  the 3494 library

After doing these steps I was able to restore files to a NetWare server.

Here's the URL of a page at adsm.org which talks about the same thing
(which
is how I found out about this)
 http://msgs.adsm.org/cgi-bin/get/adsm0002/343.html

Let me know if you need any further info.

Jeff Renicker


- Forwarded by Jeffrey Renicker/Akron/IBM on 07/12/01 03:24 PM -

"Braich,
Raminder"   To: [EMAIL PROTECTED]
  Subject: Peculiar disaster recovery 
situation
Sent by: "ADSM:
Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>


07/11/01 11:29 AM
Please respond to
"ADSM: Dist Stor
Manager"





>Hi,
>   We have a 3494 tape library with 4 3590 tape drives and a robot. We are
>considering an offsite disaster recovery solution. Meaning if the present
>building is destroyed we go to another location and restore everything.
>However at this "other location" we donot have 3494 tape library. We would
>have access to only 3590 tape drives. My question is how would the tapes
be
>loaded to tape drives manually. In other words would the drives recognize
>the tapes(created in 3494 library) or do I need to change something in our
>present configuration.
>
>Thanks
>Raminder Braich



Re: archives for this list

2001-07-12 Thread Martin, Jon R.

You can to go www.adsm.org to review archived postings.



-Original Message-
From: Chuck Lam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 3:50 PM
To: [EMAIL PROTECTED]
Subject: archives for this list


Hello,

Would someone kindly show me how to look up archives
for this list?

TIA

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/



Re: archives for this list

2001-07-12 Thread Kleynerman, Arthur

www.adsm.org

-Original Message-
From: Chuck Lam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 3:50 PM
To: [EMAIL PROTECTED]
Subject: archives for this list


Hello,

Would someone kindly show me how to look up archives
for this list?

TIA

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/


---

The information contained in this e-mail message, and any attachment thereto, is 
confidential and may not be disclosed without our express permission.  If you are not 
the intended recipient or an employee or agent responsible for delivering this message 
to the intended recipient, you are hereby notified that you have received this message 
in error and that any review, dissemination, distribution or copying of this message, 
or any attachment thereto, in whole or in part, is strictly prohibited.  If you have 
received this message in error, please immediately notify us by telephone, fax or 
e-mail and delete the message and all of its attachments.  Thank you.

Every effort is made to keep our network free from viruses.  You should, however, 
review this e-mail message, as well as any attachment thereto, for viruses.  We take 
no responsibility and have no liability for any computer virus which may be 
transferred via this e-mail message.



Re: SQL on OS390

2001-07-12 Thread Bill Colwell

Zoltan,

I use a plus sign, but I don't try to put long selects into the call command,
instead I use a macro.  Here is some jcl and a macro -

//QUERYVOL EXEC PGM=IKJEFT01,DYNAMNBR=100
/SYSPRINT DD  SYSOUT=*
//SYSTSPRT DD  SYSOUT=*
//SYSTSIN  DD *
FREE F(DSCLANG DSCOPT)
DEL   'mytsoid.SELVOLS.OUTPUT'
ALLOC F(DSCLANG) DA('ADSM.V3R1M21.SANSMSG(ANSMENU)') SHR REU
ALLOC F(DSCOPT) DA('ADSM.V3R1.ADMIN.PORT1600.TSOOPT') SHR REU
CALL 'ADSM.V3R1M21.LINKLIB(DSMADMC)' +
 '-ID=mytsmid -PASS=mypass +
 MACRO ''ADSM.V3R1.PROD.MACS(SELVOLS)'' '


/*  */
/* macro file to select all tape volumes*/
/*  */
/*  */
set sqldisplaymode w
select * -
   from adsm.volumes  -
   where stgpool_name ^= 'BACKUPPOOL' -
   > 'mytsoid.SELVOLS.OUTPUT'


Hope this helps,

--
--
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
[EMAIL PROTECTED]
--

In <[EMAIL PROTECTED]>, on 07/12/01
   at 04:06 PM, Zoltan Forray/AC/VCU <[EMAIL PROTECTED]> said:

>I see lots of SQL floating around here.

>Since my server is OS390, I tried a "query" in batch.  However, the
>command was too long for a 72-column "card".

>What character is used to continue SQL commands onto subsequent lines ?  I
>tried the standard "-" which works for almost *ALL* other OS390 utilities,
>but it didn't work for TSM.

>This is TSM 4.1.3.

>===
>Zoltan Forray
>Virginia Commonwealth University
>University Computing Center
>e-mail: [EMAIL PROTECTED]
>voice: 804-828-4807



Restore on a different client machine?

2001-07-12 Thread Yahya Ilyas

Is it possible to restore to a different client machine?I need to do a
restore of a directory to a different client(node), both client machines are
AIX 4.3.3.  Please send me details.

Thanks
Yahya

>   -
>   Yahya Ilyas
>   Systems Programmer Senior
>   Systems Integration & Management
>   Information Technology
>   Arizona State University, Tempe, AZ 85287-0101
>
>   [EMAIL PROTECTED]
>   Phone: (480) 965-4467
>
>



Re: TDP for SQL 1.1.2

2001-07-12 Thread Bruce Lowrie

Del,

This is a 2 node Windows 2000 Cluster and the cluster service is running.
When we run "dsmc query filespace" program with the same dsmsql.opt we do
not get the same error (it actually works since we can use the gui to
backup):
Node Name: DCLABVDB80
Session established with server ADSMSV2: AIX-RS/6000
  Server Version 4, Release 1, Level 2.0
  Server date/time: 07/12/2001 16:35:40  Last access: 07/12/2001 08:54:05

Num Last Incr Date  TypeFile Space Name
--- --  ---
  1   07/10/2001 16:09:29   API:NTSQL  DCLABVDB80.consigment
  2   07/10/2001 16:09:08   API:NTSQL  DCLABVDB80.dbadmin
  3   07/11/2001 20:54:02   NTFS\\dclabcdb80\i$

Results from running "sqldsmc /adsmqueryserver":

Tivoli Storage Manager
Tivoli Data Protection for Microsoft SQL Server
Command Line Interface - Version 1, Release 1, Level 2.01
(C) Copyright IBM Corporation 1997, 1999. All rights reserved.

TSM API Version 4, Release 1, Level 2
TSM Nodename: client

License file exists and contains valid license data.

Server  Options
---
dsmsql  Nodename  dclabvdb80
Cluster Node  Yes
Compression   Off
PasswordAccessGenerate
WaitMount True
CommMethodTCP/IP
TcpServerAddress  adsmsv2eth
TcpPort   1500




Bruce E. Lowrie
Sr. Systems Analyst
Information Technology Services
Storage, Output, Legacy
*E-Mail:  [EMAIL PROTECTED]
*Voice: ?(517) 496-6404
*Post:Mail: CO2111, (DC2 1st Floor)




-Original Message-
From: Del Hoobler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 3:14 PM
To: [EMAIL PROTECTED]
Subject: Re: TDP for SQL 1.1.2


Bruce,

Are you running this on a NT 4 or 2000 cluster?
Is the cluster service running?
If you run the "dsmc query filespace" program with the
same dsmsql.opt, do you see the same error?

What version of the TSM API are you running with?
("sqldsmc /adsmqueryserver" will tell you the answer.)
If it's a Windows 2000 cluster and an older TSM API,
it may not be working correctly.
You should be running at least 3.7.0 of the TSM API.

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

"It's a beautiful day.  Don't let it get away."  -- Bono




Bruce Lowrie
  cc:
Sent by: "ADSM: Subject: TDP for SQL 1.1.2
Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>


07/12/2001 12:49
PM
Please respond to
"ADSM: Dist Stor
Manager"





I am using TDP for SQL version 1.1.2 on all of my SQL 7 / MS Cluster
installations with no problems. We are testing  out SQL 2000 using the same
version of the TDP and we received this error message:

ACO0302E -- NODENAME cannot be the local machine name when CLUSTERNODE is
set to YES

 when run this string from a command line interface :

sqldsmc  /sqlsecure /sqlserver:dclabvdb80 /adsmoptfile:dsmsql.opt
/backupfull:master

In the diserror.log file is this message:
07/10/2001 16:15:16 ANS1155E CLUSTERNODE option is set to YES but cluster
is
not enabled.
Either the machine does not have cluster server installed, or the cluster
server is not running.

Anyone have any ideas?

Bruce E. Lowrie
Sr. Systems Analyst
Information Technology Services
Storage, Output, Legacy
*E-Mail:  [EMAIL PROTECTED]
*Voice: ?(517) 496-6404
*Post:Mail: CO2111, (DC2 1st Floor)




_
This message has been checked for all known viruses by the
MessageLabs Virus Scanning Service. For further information visit
http://www.messagelabs.com/stats.asp

_
This message has been checked for all known viruses by the
MessageLabs Virus Scanning Service. For further information visit
http://www.messagelabs.com/stats.asp

_
This message has been checked for all known viruses by the
MessageLabs Virus Scanning Service. For further information visit
http://www.messagelabs.com/stats.asp



Re: Restore on a different client machine?

2001-07-12 Thread Martin, Jon R.

When you run the dsm session. There is an option to change you
login/connection from the menu bar ( FILE / LOGON ).  On the server you want
to restore to login to dsm as the server you want to restore from.  From
there on it is the same as usual.



-Original Message-
From: Yahya Ilyas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 4:18 PM
To: [EMAIL PROTECTED]
Subject: Restore on a different client machine?


Is it possible to restore to a different client machine?I need to do a
restore of a directory to a different client(node), both client machines are
AIX 4.3.3.  Please send me details.

Thanks
Yahya

>   -
>   Yahya Ilyas
>   Systems Programmer Senior
>   Systems Integration & Management
>   Information Technology
>   Arizona State University, Tempe, AZ 85287-0101
>
>   [EMAIL PROTECTED]
>   Phone: (480) 965-4467
>
>



Re: Restore on a different client machine?

2001-07-12 Thread George Lesho

Take a look at Chapter 3. Backing up and Restoring Files (pg 35 onward) of
the "Using the Backup-Archive Clients" (this is from Ver 3 Release 7) so
since you didn't send any info on Version you are using, the location may
vary. Use the -virtualnodename option as the syntax is tricky with the
-fromnode option. Be sure to read the blurb on "set access".

George Lesho
Storage/System Admin
AFC Enterprises





Yahya Ilyas <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 07/12/2001 03:17:35 PM

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

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:
Fax to:
Subject:  Restore on a different client machine?


Is it possible to restore to a different client machine?I need to do a
restore of a directory to a different client(node), both client machines
are
AIX 4.3.3.  Please send me details.

Thanks
Yahya

>   -
>   Yahya Ilyas
>   Systems Programmer Senior
>   Systems Integration & Management
>   Information Technology
>   Arizona State University, Tempe, AZ 85287-0101
>
>   [EMAIL PROTECTED]
>   Phone: (480) 965-4467
>
>



Re: TDP for SQL 1.1.2

2001-07-12 Thread Del Hoobler

Bruce,

Officially, TDP for SQL 1.1.2 is supported
only on SQL 6.5 and SQL 7. See:

http://www.tivoli.com/support/storage_mgr/tdp_ms.html#SQL

SQL 2000 support was added with TDP for SQL 2.2.0 early this year.
Version 2 added a whole lot of new function.  See:

   http://www.tivoli.com/products/index/data_protect_mssql/index.html

We have tested TDP for SQL 2.2.0 with SQL 2000 active/active in a
Windows 2000 cluster with no problems.


Interestingly, your query filespace output shows that
you have successfully backed up the "consigment" and
the "dbadmin" databases to this node on 7/10/2000.
How were you able to do that?

To get around this problem you could remove the
CLUSTERNODE YES option from the options file
but your generated password may not work properly
in a cluster failover situation.

You could try calling IBM/Tivoli service.
A trace would help not sure how far you'd get since
your not running in a supported environment.

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

"It's a beautiful day.  Don't let it get away."  -- Bono




Bruce Lowrie
  cc:
Sent by: "ADSM: Subject: Re: TDP for SQL 1.1.2
Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>


07/12/2001 04:53
PM
Please respond to
"ADSM: Dist Stor
Manager"





Del,

This is a 2 node Windows 2000 Cluster and the cluster service is running.
When we run "dsmc query filespace" program with the same dsmsql.opt we do
not get the same error (it actually works since we can use the gui to
backup):
Node Name: DCLABVDB80
Session established with server ADSMSV2: AIX-RS/6000
  Server Version 4, Release 1, Level 2.0
  Server date/time: 07/12/2001 16:35:40  Last access: 07/12/2001 08:54:05

Num Last Incr Date  TypeFile Space Name
--- --  ---
  1   07/10/2001 16:09:29   API:NTSQL  DCLABVDB80.consigment
  2   07/10/2001 16:09:08   API:NTSQL  DCLABVDB80.dbadmin
  3   07/11/2001 20:54:02   NTFS\\dclabcdb80\i$

Results from running "sqldsmc /adsmqueryserver":

Tivoli Storage Manager
Tivoli Data Protection for Microsoft SQL Server
Command Line Interface - Version 1, Release 1, Level 2.01
(C) Copyright IBM Corporation 1997, 1999. All rights reserved.

TSM API Version 4, Release 1, Level 2
TSM Nodename: client

License file exists and contains valid license data.

Server  Options
---
dsmsql  Nodename  dclabvdb80
Cluster Node  Yes
Compression   Off
PasswordAccessGenerate
WaitMount True
CommMethodTCP/IP
TcpServerAddress  adsmsv2eth
TcpPort   1500


Bruce E. Lowrie



Reliability of Super DLT drives

2001-07-12 Thread Doug Thorneycroft

Hi
We are thinking of using a couple of Super DLT drives
for special storage purposes, not part of our TSM system.

Is anyone using Super DLT, and if so, are they performing
as expected?

Doug Thorneycroft
County Sanitation Districts of Los Angeles County
(562) 699-7411 Ext. 1058
FAX (562) 699-6756
[EMAIL PROTECTED]



Re: how to free licenses ??

2001-07-12 Thread John Johnson

Run the command AUDIT LICENSES to update this value, and get back into
compliance.

John Johnson




Arnaud Brion
<[EMAIL PROTECTED]   To: [EMAIL PROTECTED]
NMAIL.COM> cc:
Sent by: "ADSM: Dist   Subject: how to free licenses ??
Stor Manager"
<[EMAIL PROTECTED]
U>


07/12/2001 12:28 AM
Please respond to
"ADSM: Dist Stor
Manager"





Hi *SM'ers !

A little embarrassing problem : a few days ago I got a message from  TSM
server, telling me I was not in compliance with license terms : - so far I
agree, I added few new nodes to the system ...
 I then decided to remove some old nodes that where not in use anymore,
with the goal freeing some licenses ... Guess what ? I still have the same
number of managed servers in use !!!
How is it possible to update this value ??
Any help would be greatly appreciated ...
TIA
Arnaud.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78/Fax: +41 61 226 17 01 |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=



Re: Tape/Drive problems

2001-07-12 Thread Steve Harris

>>> Richard Sims <[EMAIL PROTECTED]> 13/07/2001 0:49:47 >>>
...

>We've had a bunch of problems with the upgraded 3590E drives.  (Why,
>when the upgrade involved a whole pallet of boxes and parts, they
>didn't simply replace the drives with factory-certified units, is
>a big question for IBM, particularly given all the problems that
>customers have had with the field-upgraded units.)

...

I've just had a quote to upgrade two B1As to E1As, and its nearly as expensive as 
buying new E1As! 
That doesn't make sense to me.

Steve Harris
AIX and TSM (Finally) Admin
Queensland Health, Brisbane Australia



How to make to inclexcl list to fit my needs???

2001-07-12 Thread David Ruiz

Hi all TSMers,

I am trying to build an include/exclude list for a
HPUX box. I want to backup something sometimes and not
to backup this same thing others, the problem is that
if I put it on an exclude statement, I will never be
able to backup it unless I include it again. I have
this:

/opt/tivoli
/opt/OMImag
/opt/netscape
/opt/MC1
/opt/MC2
.
.
/opt/MC6
/opt/data
/opt/development
.
.
.
/opt/lotsofdirs

I want to backup the whole /opt filesystem but the MC1
and MC2...MC6 in the night and to backup only this MC*
at in the day.

I have already tryied to use two incl/excl lists but
when I use the second one and some file that was
included is now excluded it is automaticly deleted by
an expiration process.

I tryied to do the backup with a dsmc command but it
becomes an never-ending line (too long).

Hope you can give some advice.

David.




__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/



File Permissions on Restore

2001-07-12 Thread rh

As part of my DR activities, I will be restoring files
from many NT servers onto single (consolidated)
servers. If I restore files to a machine of a
different name than the source, how can I assure that
ownership/permissions will work correctly for the
files on the "new" machine?

Thanks,
Rod Hroblak
ADP

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/



missing volumes

2001-07-12 Thread Steve de Souza

Hi All,

I have some volumes which appears in a "q libv" as
follows...(ythis is just one of them)


3575LIB1  11824F Private59


The usual forth field of "Data" is not displayed. Does this mean that this
is a "scratchable" tape???

Also, from the actlog, the last entry for this tape is an atempted checkin,
which has failed as ADSM says that the tape is already in the library.
The next most recent entry for the tape is a "checkout" from the library,
which has failed, because the tape it got was the wrong one(I think the
inventory is stuffed.)

As I am physically holding this tape in my hand, I am very confused
as to what is going on.
Several tapes are like this. It also seems that after doing a
"tapeutil -f /dev/smc0 inventory"
that some of the tapes that are displayed are not the ones that
physically appear in the slot
that it says.

Quite strange. Has anyone got some clues on how to sanity check and
fix this inventory issue please?

cheers
steve

**
Bunnings Legal Disclaimer:

1)  This document is confidential and may contain legally privileged
information. If you are not the intended recipient you must not
read, copy, distribute or act in reliance on it.
If you have received this document in error, please telephone
us immediately on (08) 9365-1555.

2)  All e-mails sent to and sent from Bunnings Building Supplies are
scanned for content. Any material deemed to contain inappropriate
subject matter will be reported to the e-mail administrator of
all parties concerned.

**



James J Healy/NYM/Equitable is out of the office.

2001-07-12 Thread

I will be out of the office from 07/12/2001 until 07/17/2001.

I will respond to your message when I return. If you have an urgent
question regarding Enterprise Data Recovery please contact Joe Marchesani.



Re: SQL on OS390

2001-07-12 Thread Luuk Kleibrink

Zoltan,

This works (NOTE: don't put spaces around the comma's, this might be your
problem):

//TSO1 EXEC PGM=IKJEFT01
//SYSPRINT DD SYSOUT=X
//SYSTSPRT DD SYSOUT=X
//SYSTERM  DD SYSOUT=X
//SYSOUT   DD SYSOUT=X
//SYSTCPD  DD DSN=SYS1.TCPPARMS(TCPDATA),DISP=SHR
//DSCOPT   DD DSN=SYP.TSM.TSOADMIN.OPTIONS,DISP=SHR
//DSCLANG  DD DSN=SYS2.TSM.SANSMSG(ANSMENU),DISP=SHR
//SYSTSIN  DD *
 DSMADMC -ID=id -PA=password -OUT='OS390 data set name' +
 SELECT STGPOOL_NAME,SUM(NUM_FILES) AS FILES, +
 SUM(LOGICAL_MB) AS MB,NODE_NAME FROM OCCUPANCY +
 GROUP BY STGPOOL_NAME,NODE_NAME ORDER BY NODE_NAME,STGPOOL_NAME

Luuk Kleibrink
Delta Lloyd Nuts Ohra



Re: SQL on OS390

2001-07-12 Thread Steve de Souza

speaking of SQL, does anyone know where the SQL reference is for
ADSM because it doesn't appear to be
the same standard that we have on ORacle.
thanks
steve

**
Bunnings Legal Disclaimer:

1)  This document is confidential and may contain legally privileged
information. If you are not the intended recipient you must not
read, copy, distribute or act in reliance on it.
If you have received this document in error, please telephone
us immediately on (08) 9365-1555.

2)  All e-mails sent to and sent from Bunnings Building Supplies are
scanned for content. Any material deemed to contain inappropriate
subject matter will be reported to the e-mail administrator of
all parties concerned.

**