Re: Converting I/O station into regular slots

[Dirk Kastens]

Camilo,

> I have a question, I am running out of physical space on my
> 3583 library, and I was wondering if there is a way of making
> the 12 slots on the I/O station (Bulk), part of the regular
> tape slots.

Yes, I've done this with our 3583. I can't tell you from the
top of my head what exactly I did, but you have to configure
the library using the front panel.

Dirk

Re: Problem with Storagetek L20 and 5.1.6.2

[Zlatko Krastev/ACIT]

You seem to do everything correct and if it does not work the best way is 
to open a PMR with IBM. Try to rescreate the problem on another box.

Zlatko Krastev
IT Consultant






GUILLAUMONT Etienne <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
25.02.2003 09:01
Please respond to "ADSM: Dist Stor Manager"

 
To: [EMAIL PROTECTED]
cc: 
Subject:Re: Problem with Storagetek L20 and 5.1.6.2


I upgraded 4.1.6 -> 5.1.5 ->5.1.6.0 ->5.1.6.2 I don't remember the version
for the ITSM device driver as I went back but it was the latest available
on the tivoli server. But there was something peculiar : when I issued an
update all with the 5.1.5 cd, the devices were not updated and I had to
specifically install it.

To answer to you last question : I hope that the fact that the drivers
doesn't function is not normal ! :-))

regards


Etienne GUILLAUMONT
e-mail : [EMAIL PROTECTED]

RGB Technologie
Parc d'Innovation, Bâtiment PYTHAGORE
11 Rue Jean SAPIDUS
67400 ILLKIRCH
Tél :  03 90 40 60 60
Fax : 03 90 40 60 61


  
Zlatko   
Krastev/ACIT To: [EMAIL PROTECTED]  
 
<[EMAIL PROTECTED]cc:
AL.NET>  Subject: Re: Problem with 
Storagetek L20 and 5.1.6.2 
Sent by:   
"ADSM: Dist   
Stor Manager"   
<[EMAIL PROTECTED]   
RIST.EDU>   
  
  
23/02/2003   
22:25   
Please   
respond to   
"ADSM: Dist   
Stor Manager"   
  
  




How you did the upgrade (4.1.6 -> 5.1.6.2 or 4.1.6 -> 5.1.0.0 -> 5.1.6.0
-> 5.1.6.2 or otherwise)?
What is the fileset and version for the ITSM device driver?
You hope wrong or you hope normal :-)

Zlatko Krastev
IT Consultant






GUILLAUMONT Etienne <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
21.02.2003 15:07
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Problem with Storagetek L20 and 5.1.6.2


Hello,

I juste upgraded my TSM server on AIX 4.3.3 to 5.1.6.2 from 4.1.6 and I
had
to reinstall the devices software at 4.1 level to have my Storagetek work.
The library functionned but the DLT1 drives where unable to read tapes. I
got the following message :

20.02.03   14:06:43  ANR8302E I/O error on drive DLT1.2 (/dev/mt1)
(OP=SETMODE,
  Error Number=22, CC=207, KEY=FF, ASC=FF, ASCQ=FF,
  SENSE=**NONE**, Description=Device is not in a state
  capable of performing request).  Refer to Appendix D
in
  the 'Messages' manual for recommended action.

I just updated TSM to 5.1.6.2 and removed the drive and the library before
recreating them.

Did I do anything wrong or is it normal (I hope not)

Regards

Etienne GUILLAUMONT
e-mail : [EMAIL PROTECTED]

RGB Technologie
Parc d'Innovation, Bâtiment PYTHAGORE
11 Rue Jean SAPIDUS
67400 ILLKIRCH
Tél :  03 90 40 60 60
Fax : 03 90 40 60 61

Re: Need ideas for offsite copy of HSM tapes

[Zlatko Krastev/ACIT]

Matt,

- If you want to have the lowest possible number of tapes you should not
do any backups (single copy).
- If you want something quick, cheap and dirty - migration goes to one
primary pool, B/A client backups to another primary. Latter goes offsite
without any copypools (2 copies).
- If you want to do it by the book with higher safety - migration pool,
backup pool and copypool (3 copies).
I cannot (and do not want to) force you, just can make a hint.

Zlatko Krastev
IT Consultant






Matt Simpson <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
24.02.2003 17:21
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: Need ideas for offsite copy of HSM tapes


At 12:08 PM +0200 2/23/03, Zlatko Krastev/ACIT wrote:
>- HSM client sends the data in a storage pool. That storage pool can be
>backed up to a copypool. If this is a storage hierarchy within the server
>(diskpool migration to tapepool), backup the diskpool first then backup
>the tapepool to same copypool. Voila.

OK .. but even if I copy the diskpool and tapepool to a copypool,
isn't there some client data that never gets migrated to the
diskpool? I need a solution that allows me to recover the data if the
client machine gets burned up.  Will the HSM pools contain all the
necessary directory structure information to rebuild the client data?
I need to read the manuals some more, but from what I've been told,
the answer is No.

>- management class for HSM client has parameter migrequiresbkup
>(defaulting to yes). Thus if MIGDESTination of the class and DESTination
>of the backup copygroup point to different pools - you again can have two
>copies. Plus the copypool one can be even more.

Yes, I can have to copies; the migration copy and the backup copy.
But they'll both be in a primary storage pool. True, creating the
copy pool gives me "even more".  But the objective is not to see how
MANY copies of the data I can create; it's to see how FEW I can
create and still have the ability to completely restore the client
from the offsite tapes.

>- usage of HSM client does not prevent filesystem to be backed up using
>B/A client.

True.  But again, we're trying to keep the total number of backups to
a minimum.  We have to pay for tapes.

>How afterwards off-site tape management is to be done is just another
>story solvable in many ways - through DRM, AutoVault, TSMManager, etc.

Well, maybe it's just another story; but the answer to that story has
a major impact on the first story.  EG  DRM requires the use of
copypools to move tapes offsite.  I've been told AutoVault does not,
so that's something I need to look at. But that opens up some more
questions (aside from the cost, how is reclamation of offsite tapes
done, etc)


At 7:58 AM -0500 2/23/03, Richard Sims wrote:
>I would approach it this way:  Via dsmmigfs, defined the stub size to be
>512 to eliminate leading file data from the stub, to force all files to
>be eligible for migration.

OK, but even if I force all files to migrate, does the migration pool
contain enough info about the client directory structure to allow me
to restore the complete client data directory in the event of a
disaster?
--


Matt Simpson --  OS/390 Support
219 McVey Hall  -- (859) 257-2900 x300
University Of Kentucky, Lexington, KY 40506

mainframe --   An obsolete device still used by thousands of obsolete
companies serving billions of obsolete customers and making huge obsolete
profits for their obsolete shareholders.  And this year's run twice as
fast
as last year's.

Re: Problem with Storagetek L20 and 5.1.6.2

[Jan Batteram]

I had a simailar problem with DLT1 drives, There is an readme on the TSM
site how to update the TSM installation with the SHOW FORMATDLT1 admin
command with the UPDATEFORMAT parameter.
and UPDATE DEVCLASS DLT1 or DLT1C.

regards,
Jan Batteram
IT-Specialist
Royal Swets & Zeitlinger

-Original Message-
From: Zlatko Krastev/ACIT [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 9:54 AM
To: [EMAIL PROTECTED]
Subject: Re: Problem with Storagetek L20 and 5.1.6.2


You seem to do everything correct and if it does not work the best way is 
to open a PMR with IBM. Try to rescreate the problem on another box.

Zlatko Krastev
IT Consultant






GUILLAUMONT Etienne <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
25.02.2003 09:01
Please respond to "ADSM: Dist Stor Manager"

 
To: [EMAIL PROTECTED]
cc: 
Subject:Re: Problem with Storagetek L20 and 5.1.6.2


I upgraded 4.1.6 -> 5.1.5 ->5.1.6.0 ->5.1.6.2 I don't remember the version
for the ITSM device driver as I went back but it was the latest available
on the tivoli server. But there was something peculiar : when I issued an
update all with the 5.1.5 cd, the devices were not updated and I had to
specifically install it.

To answer to you last question : I hope that the fact that the drivers
doesn't function is not normal ! :-))

regards


Etienne GUILLAUMONT
e-mail : [EMAIL PROTECTED]

RGB Technologie
Parc d'Innovation, Bâtiment PYTHAGORE
11 Rue Jean SAPIDUS
67400 ILLKIRCH
Tél :  03 90 40 60 60
Fax : 03 90 40 60 61


  
Zlatko   
Krastev/ACIT To: [EMAIL PROTECTED]  
 
<[EMAIL PROTECTED]cc:
AL.NET>  Subject: Re: Problem with 
Storagetek L20 and 5.1.6.2 
Sent by:   
"ADSM: Dist   
Stor Manager"   
<[EMAIL PROTECTED]   
RIST.EDU>   
  
  
23/02/2003   
22:25   
Please   
respond to   
"ADSM: Dist   
Stor Manager"   
  
  




How you did the upgrade (4.1.6 -> 5.1.6.2 or 4.1.6 -> 5.1.0.0 -> 5.1.6.0
-> 5.1.6.2 or otherwise)?
What is the fileset and version for the ITSM device driver?
You hope wrong or you hope normal :-)

Zlatko Krastev
IT Consultant






GUILLAUMONT Etienne <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
21.02.2003 15:07
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Problem with Storagetek L20 and 5.1.6.2


Hello,

I juste upgraded my TSM server on AIX 4.3.3 to 5.1.6.2 from 4.1.6 and I
had
to reinstall the devices software at 4.1 level to have my Storagetek work.
The library functionned but the DLT1 drives where unable to read tapes. I
got the following message :

20.02.03   14:06:43  ANR8302E I/O error on drive DLT1.2 (/dev/mt1)
(OP=SETMODE,
  Error Number=22, CC=207, KEY=FF, ASC=FF, ASCQ=FF,
  SENSE=**NONE**, Description=Device is not in a state
  capable of performing request).  Refer to Appendix D
in
  the 'Messages' manual for recommended action.

I just updated TSM to 5.1.6.2 and removed the drive and the library before
recreating them.

Did I do anything wrong or is it normal (I hope not)

Regards

Etienne GUILLAUMONT
e-mail : [EMAIL PROTECTED]

RGB Technologie
Parc d'Innovation, Bâtiment PYTHAGORE
11 Rue Jean SAPIDUS
67400 ILLKIRCH
Tél :  03 90 40 60 60
Fax : 03 90 40 60 61

Re: Help setting up RMAN w/ TDP 2210

[Jozef Zatko]

Hi Theresa,
I had similar problem. Check your LANG environment variable for user under
which you are running backup scripts (RMAN).
It should be equal to language used in TSM API.
For example:
if you have En_US subdirectory in TSM api client, your LANG variable have
to be LANG=En_US.

Hope this helps


Ing. Jozef Zatko
Login a.s.
Dlha 2, Stupava
tel.: (421) (2) 60252618



Theresa
Sarver   To: [EMAIL PROTECTED]
   Subject: Help setting up RMAN w/ TDP 2210
Sent by:
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>


24.02.2003
23:35
Please
respond to
"ADSM: Dist
Stor Manager"






Hi all;

I'm having all kinds of problems and am hoping someone can assist me with
this setup...as I'm all confused at this point.

Environment:
AIX 51 ML3
TSM Server 5162
TSM (ba) Client 510 (64 bit)
TSM (api) Client 4210 (32 bit)
TDP (oracle) Client 2210 (32 bit)
Oracle Enterprise Server 817

As this server is running AIX5 w/ Oracle 817 databases I had to install TDP
2210 (if I read the documentation right), and TDP 22 installed the 4210 (32
bit) API.

No matter what we try RMAN will not backup, we went from seeing the
following errrors:

RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel dev1
RMAN-10035: exception raised in RPC: ORA-19554: error allocating device,
device type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 2534: System call error number 2534.

to this error:

RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel dev1
RMAN-10035: exception raised in RPC: ORA-19554: error allocating device,
device type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 2518: System call error number 2518.

I tripple checked that the libobk.a file is linked to the correct location:
/c2qnu01/u01/oracle/product/8.1.7/lib>ls -la libobk.a
lrwxrwxrwx   1 oracle   dba  17 Feb 21 11:20 libobk.a ->
/usr/lib/li
bobk.a

Output of tdpo.opt:
DSMI_ORC_CONFIG/usr/tivoli/tsm/client/api/bin/dsm.opt.oracle
DSMI_LOG   /usr/tivoli/tsm/client/api/bin
TDPO_FSadmsorc
TDPO_NODE  c2qnu01_oracle
TDPO_OWNER oracle
TDPO_PSWDPATH  /usr/tivoli/tsm/client/oracle/bin

I have attached the dsm.opt and dsm.sys files for your review.  I have
linked them both from the api directory back to the ba/bin directory:

lrwxrwxrwx   1 root system   44 Feb 21 16:22 dsm.opt.oracle ->
/usr/
tivoli/tsm/client/ba/bin/dsm.opt.oracle
lrwxrwxrwx   1 root system   37 Feb 20 16:05 dsm.sys ->
/usr/tivoli/
tsm/client/ba/bin/dsm.sys

The password file was generated fine and I was able to run the tdpoconf
showenv, the contents of which I included.  I also provided the
tdpoerror.log - though I don't think it'll help any.

I've gone through all relevant archive articles and nothing seems to apply
to my situation.  I also opened a PMR with TSM Support, but I haven't heard
anything back yet.

Any help would be appreciated.

Thank you;
Theresa


(See attached file: dsm.sys)
(See attached file: dsm.opt.oracle)
(See attached file: lslpp.txt)
(See attached file: tdpoconf.outfile)
(See attached file: tdpoerror.log)



dsm.sys
Description: Binary data


dsm.opt.oracle
Description: Binary data


lslpp.txt
Description: Binary data


tdpoconf.outfile
Description: Binary data


tdpoerror.log
Description: Binary data

ANR8302E error on drive

[Sylvia Nergard]

Does this indicate a hardware error?

ANR8302E I/O error on drive MT1.0.0.2 (mt1.0.0.2)
   (OP=READ, Error Number=1117, CC=305, KEY=00, ASC=00,
   ASCQ=00,
SENSE=70.00.00.00.00.00.00.0E.00.00.00.00.00.00-
   .00.00.00.00.00.00.00.00., Description=Drive
failure).
   Refer to Appendix D in the 'Messages' manual for
   recommended action.
ANR8792E Unrecoverable drive failures on drive MT1.0.0.2
   (mt1.0.0.2); drive is now taken offline.

This has happend twice, when I set the drive online again it works.
Is it really a hardware error, or could it be something else that makes TSM
to set this drive offline?


Regards

Sylvia Nergård

Re: Converting I/O station into regular slots

[Richard Sims]

> I have a question, I am running out of physical space on my
> 3583 library, and I was wondering if there is a way of making
> the 12 slots on the I/O station (Bulk), part of the regular
> tape slots.

The manual, of all things, says you can...
via Setup->Utils->Config.

Re: ANR8302E error on drive

[Rick Harderwijk]

Hi,

If Tivoli discovers 'persistent' errors working with a drive, it will take
the drive offline, so it cannot 'accidentally' operate the drive for a
backup action.

I'd check to see if this happens with the same tape - that might indicate
that the tape is bad. I'm no expert on all those errorcodes (there might be
something in one of the manuals), but if the error occurs with another tape,
there's probably something wrong with the drive. If the drive is in a
library, you could check the library's display (if it has one) to seen if
there is something there that might help you determine the exact nature of
the error.

Kind regards,

Rick

-Oorspronkelijk bericht-
Van: Sylvia Nergard [mailto:[EMAIL PROTECTED]
Verzonden: 25 februari 2003 12:03
Aan: [EMAIL PROTECTED]
Onderwerp: ANR8302E error on drive


Does this indicate a hardware error?

ANR8302E I/O error on drive MT1.0.0.2 (mt1.0.0.2)
   (OP=READ, Error Number=1117, CC=305, KEY=00, ASC=00,
   ASCQ=00,
SENSE=70.00.00.00.00.00.00.0E.00.00.00.00.00.00-
   .00.00.00.00.00.00.00.00., Description=Drive
failure).
   Refer to Appendix D in the 'Messages' manual for
   recommended action.
ANR8792E Unrecoverable drive failures on drive MT1.0.0.2
   (mt1.0.0.2); drive is now taken offline.

This has happend twice, when I set the drive online again it works.
Is it really a hardware error, or could it be something else that makes TSM
to set this drive offline?


Regards

Sylvia Nergård

Re: ANR8302E error on drive

[Farren Minns]

We had a similar problem recently with one of our 3590 drives. In the end,
it turned out of the little brush that cleans the heads in the drive was
all but knackered. We had it replaced and it was fine again.

I would say it's most likely a drive problem of some sort rather then TSM
releated. As Rick says, the errors are persistent, TSM will set the drive
off-line just in case.

Farren

John Wiley & Sons Ltd



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

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

To:       [EMAIL PROTECTED]
cc:
Subject:        Re: ANR8302E error on drive


Hi,

If Tivoli discovers 'persistent' errors working with a drive, it will take
the drive offline, so it cannot 'accidentally' operate the drive for a
backup action.

I'd check to see if this happens with the same tape - that might indicate
that the tape is bad. I'm no expert on all those errorcodes (there might be
something in one of the manuals), but if the error occurs with another
tape,
there's probably something wrong with the drive. If the drive is in a
library, you could check the library's display (if it has one) to seen if
there is something there that might help you determine the exact nature of
the error.

Kind regards,

Rick

-Oorspronkelijk bericht-
Van: Sylvia Nergard [mailto:[EMAIL PROTECTED]
Verzonden: 25 februari 2003 12:03
Aan: [EMAIL PROTECTED]
Onderwerp: ANR8302E error on drive


Does this indicate a hardware error?

ANR8302E I/O error on drive MT1.0.0.2 (mt1.0.0.2)
(OP=READ, Error Number=1117, CC=305, KEY=00, ASC=00,
ASCQ=00,
SENSE=70.00.00.00.00.00.00.0E.00.00.00.00.00.00-
.00.00.00.00.00.00.00.00., Description=Drive
failure).
Refer to Appendix D in the 'Messages' manual for
recommended action.
ANR8792E Unrecoverable drive failures on drive MT1.0.0.2
(mt1.0.0.2); drive is now taken offline.

This has happend twice, when I set the drive online again it works.
Is it really a hardware error, or could it be something else that makes TSM
to set this drive offline?


Regards

Sylvia Nergård

Re: ANR8302E error on drive

[Richard Sims]

>Does this indicate a hardware error?
>ANR8302E I/O error on drive MT1.0.0.2 (mt1.0.0.2)
>(OP=READ, Error Number=1117, CC=305, KEY=00, ASC=00, ASCQ=00, ...

On the basis of the ASC and ASCQ values being 0, I would suspect
the problem to be a dirty tape head.  Begin by assuring that the
drive is enjoying regular cleaning, by whatever method is appropriate
to your environment.  If the problems persist, call upon your
customer engineer to service the drive.

  Richard Sims, BU

Re: licensing costs

[Kamp, Bruce]

The next question for me is how do I convert the IBM/Tivoli points to a real
license count that I can put on my server!  I have been trying to get an
answer from my IBM rep for a couple of months!

--
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E: [EMAIL PROTECTED]
P: (954) 987-2020 x4597
F: (954) 985-1404
---


-Original Message-
From: Joshua S. Bassi [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 10:33 PM
To: [EMAIL PROTECTED]
Subject: Re: licensing costs


> Can anyone explain how having more than one processor in a server has
anything to do with how much it costs to back it up?

Sure, it's how IBM can change more for a product that lives on the higher
end of the food chain.  They figure that if you spend money on SMP based
systems, then you can afford more for your software licensing.


--
Joshua S. Bassi
IBM Certified - AIX 4/5L, SAN, Shark
Tivoli Certified Consultant -ADSM/TSM
eServer Systems Expert -pSeries HACMP

AIX, HACMP, Storage, TSM Consultant
Cell (831) 595-3962
[EMAIL PROTECTED]

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Patrick Boutilier
Sent: Monday, February 24, 2003 4:26 PM
To: [EMAIL PROTECTED]
Subject: Re: licensing costs


Coats, Jack wrote:

>
> Reciently I heard from my VAR, that TSM NT/2K and Novell clients are
> all now priced on a per processor basis.  Where previously on these
> the client was for up to 4 processors, and after that you went to a
> different teir of pricing.
>
> Now a single processor client cost more than a non-processor specific
> client did 6 months ago.
>

Can anyone explain how having more than one processor in a server has
anything to do with how much it costs to back it up?



> 
> As much as I like TSM, IMHO, they need to figure out how they want to
> price it, and publish that mechagnism for everyone to understand.
> Also, the current pricing structure is pretty bad.  Everytime I look
> at getting a few more clients, it makes me want to re-evaluate using
> TSM at all from a financial perspective. 
>

Netware Restore Question

[Kamp, Bruce]

Environment:
TSM client 5.1.5.6 on Netware 6
TSM server 5.1.1.6 on AIX 4.3.3

Trying to restore the directory vol1:\asset inventory from the command line
but can not figure out the correct syntax!  I have tried the following
commands:
load dsmc res vol1:\asset inventory\ -subdir=yes -rep=all -tapep=no
load dsmc res "vol1:\asset inventory\" -subdir=yes -rep=all -tapep=no
load dsmc res vol1:\"asset inventory"\ -subdir=yes -rep=all -tapep=no
What am I missing?!

Thanks,
--
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E: [EMAIL PROTECTED] 
P: (954) 987-2020 x4597
F: (954) 985-1404
---

Re: Help setting up RMAN w/ TDP 2210

[Lisa Cabanas]

Theresa--

this should help narrowing down where the problem is.  Try running it to
the dummy disk first, then with the MML.  If you still have problems,
holler-- I've been down this road before.

-lisa




Here is the technical document from the Oracle metalink site that talks
about Oracle 9i and how it works with a 3rd party tape vendor (TDP).






 Backup and Recovery - Recovery Manager (RMAN) Library Index
 Type: Note
Doc ID:
131865.1
 Score: 32%
Modified Date:
18-NOV-2002
 Status: PUBLISHED
   Platform: Generic issue
Product: Oracle
Server - Enterprise Editio




   Bookmark
  Fixed font
Go to End


  Doc ID:
 Note:188619.1
  Subject:
 Dynamic Loading of Libraries Using SBT_LIBRARY for
 RMAN Backups in Oracle 9i
  Type:
 BULLETIN
  Status:
 PUBLISHED

Content Type:

TEXT/PLAIN
Creation Date:

10-MAY-2002
Last Revision Date:

23-OCT-2002



  INTRODUCTION
  -

  In most Recovery Manager backup, restore and recover scripts when a
  channel of type 'SBT' is allocated to perform backups it means that a
  tape storage is being used to store written backup information during a
  Recovery Manager backup operation that can be used to restore and
  recover from.


  SCOPE & APPLICATION
  

  This article is intended for all Recovery Manager Users of Oracle 9i.
  The scope of this bulletin covers aspects of how libraries are linked in
  dynamically in Oracle 9i, the purpose of the SBT_LIBRARY parameter,
  the libobk.so and the Oracle Disk Manager (libodm9.so) library.


  Consider the following backup script

  Example
  ===

  run {
  set command id to '${HOST}_${ORACLE_SID}';
  allocate channel c1 type 'SBT_TAPE'
  parms 'ENV=(NSR_SERVER=SHMT.US.ORACLE.COM,
  ORACLE_HOME=${ORACLE_HOME},
  NSR_CLIENT=${THE_CLIENT},
  NSR_DATA_VOLUME_POOL=Full,
  NSR_COMPRESS=FALSE,
  NSR_DEBUG_FILE=${LOG_FILE}.nsr)'
  ;
  backup full
format '${HOST}_${The_Date}_df_%d_%s_%p'
(database filesperset=3
 );


  When the above backup script is executed, RMAN submits the backup request
to
  the Oracle server session which is actually the session that is
performing
  the backup. This Oracle server session in turn identifies the output
channel
  as a MML (Media Management device) and then makes a request to the
  Media Manager (example Legato, Veritas, Tivoli etc) to write the output
  into a backupset onto the tape media.

  Before you can  use RMAN to perform backups to sequential media such as
tapes,
  the third party vendor API of your choice needs to first be linked or
  integrated with Oracle.

  How is Oracle linked in 9i
  ---

  In Oracle 9i, Oracle loads media management libraries dynamically
  when an SBT channel is allocated and the SBT_LIBRARY option is not used
  in the  PARMS environment variable.

  Oracle will always be linked with two versions of the SBT library of
which one
  is statically linked and this is also known by default as the dummy SBT
library which
  will return a  -1 on sbtinto() or any sbt calls. The second library is
the
  oracle's disk SBT library.

  How does Oracle determine which library to use when SBT channels are
allocated
  using Recovery Manager

  When a channel is allocated using RMAN, the channels are allocated using
  the following algorithm which is used to determine the order of
precedence
  in loading a library

  1.If an SBT_LIBRARY is defined in the Allocate channel or Configure
Channel
command then the predefined library specified is loaded.

  If no SBT_LIBRARY parameter is used in the PARMS parameter , RMAN will
  attempt to load with the following order of precedence which is firstly

  1) Attempt to load the  libobk.so library
  2) If step (1)  above fails, then the statically linked SBT library
 which is the libobk.a library is attempted to be used
  3) If both the step (1) and (2) attempts fail, then a trace file is
 generated in the user_dump_destination directory

  What happened to libobk.so?
  ---

  The existence of this library and the change in its usage is  documented
in the
  Oracle9i Recovery Manager User's Guide  Release 1 (9.0.1) Part Number
A90135-01

  In Oracle 9i, the libobk.so library is no longer a  part of the standard
  Oracle installation as in previous releases. It is recreated by
  installing third-party media management software.

  In addition, the libobk.so library is installed by the third party 

Re: Netware Restore Question

[Wolfgang Bayrhof]

Hi Bruce,

you have to use the short filenames to start the restore operation by the command 
line. The short filenames are saved in the namespace "DOS" under NetWare. You can find 
out the short names by NDIR, MONITOR and NwAdmin. Maybe you can also use your Windows 
Explorer to find out the short names.

The command

  load dsmc res vol1:\assetinv\ -subdir=yes -rep=all -tapep=no

or

  load dsmc res vol1:\assetin1\ -subdir=yes -rep=all -tapep=no

should work.

bye,
Wolfgang Bayrhof


- Original Message -
From: "Kamp, Bruce" <[EMAIL PROTECTED]>
Date: Tue, 25 Feb 2003 08:03:03 -0500
To: [EMAIL PROTECTED]
Subject: Netware Restore Question

> Environment:
> TSM client 5.1.5.6 on Netware 6
> TSM server 5.1.1.6 on AIX 4.3.3
>
> Trying to restore the directory vol1:\asset inventory from the command line
> but can not figure out the correct syntax!  I have tried the following
> commands:
> load dsmc res vol1:\asset inventory\ -subdir=yes -rep=all -tapep=no
> load dsmc res "vol1:\asset inventory\" -subdir=yes -rep=all -tapep=no
> load dsmc res vol1:\"asset inventory"\ -subdir=yes -rep=all -tapep=no
> What am I missing?!
>
> Thanks,
> --
> Bruce Kamp
> Midrange Systems Analyst II
> Memorial Healthcare System
> E: [EMAIL PROTECTED] 
> P: (954) 987-2020 x4597
> F: (954) 985-1404
> ---

Re: Netware Restore Question

[Kamp, Bruce]

I am restoring the whole volume.  It was blown away...  So I can't see the
directory in any of these utils.  I tried both of your suggestions & no go
on both...  I also tried vol1:\asset*\ & that didn't work either.  Any other
suggestions?

--
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E: [EMAIL PROTECTED]
P: (954) 987-2020 x4597
F: (954) 985-1404
---


-Original Message-
From: Wolfgang Bayrhof [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 8:27 AM
To: [EMAIL PROTECTED]
Subject: Re: Netware Restore Question


Hi Bruce,

you have to use the short filenames to start the restore operation by the
command line. The short filenames are saved in the namespace "DOS" under
NetWare. You can find out the short names by NDIR, MONITOR and NwAdmin.
Maybe you can also use your Windows Explorer to find out the short names.

The command

  load dsmc res vol1:\assetinv\ -subdir=yes -rep=all -tapep=no

or

  load dsmc res vol1:\assetin1\ -subdir=yes -rep=all -tapep=no

should work.

bye,
Wolfgang Bayrhof


- Original Message -
From: "Kamp, Bruce" <[EMAIL PROTECTED]>
Date: Tue, 25 Feb 2003 08:03:03 -0500
To: [EMAIL PROTECTED]
Subject: Netware Restore Question

> Environment:
> TSM client 5.1.5.6 on Netware 6
> TSM server 5.1.1.6 on AIX 4.3.3
>
> Trying to restore the directory vol1:\asset inventory from the command
> line but can not figure out the correct syntax!  I have tried the
> following
> commands:
> load dsmc res vol1:\asset inventory\ -subdir=yes -rep=all -tapep=no
> load dsmc res "vol1:\asset inventory\" -subdir=yes -rep=all -tapep=no
> load dsmc res vol1:\"asset inventory"\ -subdir=yes -rep=all -tapep=no
> What am I missing?!
>
> Thanks,
> --
> Bruce Kamp
> Midrange Systems Analyst II
> Memorial Healthcare System
> E: [EMAIL PROTECTED] 
> P: (954) 987-2020 x4597
> F: (954) 985-1404
> ---

Re: 5.1.6.2 Linux tsmscsi broken

[Patrick Boutilier]

Mitch,

Just change line 75 of tsmscsi (it is just a shell script) from :

prefix=`rpm -q --queryformat %'{INSTALLPREFIX}' TIVsm-tsmscsi-5.1.6-0`

to :

prefix=`rpm -q --queryformat %'{INSTALLPREFIX}' TIVsm-tsmscsi-5.1.6-2`



Mitch Sako wrote:
The tsmscsi that is in 5.1.6.2 for Linux32 is not working for us:

We are running Redhat 7.2:
[EMAIL PROTECTED] ~]$ uname -a
Linux tsm2 2.4.9-31 #1 Tue Feb 11 14:43:37 PST 2003 i686 unknown
The 5.1.6.2 tsmscsi executable prints the following strange message:
[EMAIL PROTECTED] bin]$ ./tsmscsi
package TIVsm-tsmscsi-5.1.6-0 is not installed/tivoli/tsm/devices/bin not found
Make sure that the device driver is installed under package TIVsm-tsmscsi-5.1.6-0 is 
not
installed/tivoli/tsm/devices/bin
I was hoping that we would get a chance to try a new tsmscsi because the one we have 
(5.1.6.0) is really unstable
and we have numerous core dumps to prove it.

Re: Netware Restore Question

[Halvorsen Geirr Gulbrand]

Hi Bruce,
I'm not sure, but can you setup the client web-interface, then you could
browse your way to what you would like to restore, instead of using time
figuring out the cl syntax. Better to do that when an important restore
isn't hanging over your head.

Rgds
Geirr G. Halvorsen

-Original Message-
From: Kamp, Bruce [mailto:[EMAIL PROTECTED]
Sent: 25. februar 2003 14:34
To: [EMAIL PROTECTED]
Subject: Re: Netware Restore Question


I am restoring the whole volume.  It was blown away...  So I can't see the
directory in any of these utils.  I tried both of your suggestions & no go
on both...  I also tried vol1:\asset*\ & that didn't work either.  Any other
suggestions?

--
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E: [EMAIL PROTECTED]
P: (954) 987-2020 x4597
F: (954) 985-1404
---


-Original Message-
From: Wolfgang Bayrhof [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 8:27 AM
To: [EMAIL PROTECTED]
Subject: Re: Netware Restore Question


Hi Bruce,

you have to use the short filenames to start the restore operation by the
command line. The short filenames are saved in the namespace "DOS" under
NetWare. You can find out the short names by NDIR, MONITOR and NwAdmin.
Maybe you can also use your Windows Explorer to find out the short names.

The command

  load dsmc res vol1:\assetinv\ -subdir=yes -rep=all -tapep=no

or

  load dsmc res vol1:\assetin1\ -subdir=yes -rep=all -tapep=no

should work.

bye,
Wolfgang Bayrhof


- Original Message -
From: "Kamp, Bruce" <[EMAIL PROTECTED]>
Date: Tue, 25 Feb 2003 08:03:03 -0500
To: [EMAIL PROTECTED]
Subject: Netware Restore Question

> Environment:
> TSM client 5.1.5.6 on Netware 6
> TSM server 5.1.1.6 on AIX 4.3.3
>
> Trying to restore the directory vol1:\asset inventory from the command
> line but can not figure out the correct syntax!  I have tried the
> following
> commands:
> load dsmc res vol1:\asset inventory\ -subdir=yes -rep=all -tapep=no
> load dsmc res "vol1:\asset inventory\" -subdir=yes -rep=all -tapep=no
> load dsmc res vol1:\"asset inventory"\ -subdir=yes -rep=all -tapep=no
> What am I missing?!
>
> Thanks,
> --
> Bruce Kamp
> Midrange Systems Analyst II
> Memorial Healthcare System
> E: [EMAIL PROTECTED] 
> P: (954) 987-2020 x4597
> F: (954) 985-1404
> ---

Re: Netware Restore Question

[Wolfgang Bayrhof]

Hi Bruce,

you can still use the Pick-List with the -pick option.
It's maybe a time-consuming task to scroll the pick list
on the command line, when there a lot of directories in
your volumes root, but it should work.

  load dsmc res vol1:\ -pick -subdir=yes -rep=all -tapep=no

bye,
Wolfgang Bayrhof




- Original Message -
From: "Kamp, Bruce" <[EMAIL PROTECTED]>
Date: Tue, 25 Feb 2003 08:34:05 -0500
To: [EMAIL PROTECTED]
Subject: Re: Netware Restore Question

> I am restoring the whole volume.  It was blown away...  So I can't see the
> directory in any of these utils.  I tried both of your suggestions & no go
> on both...  I also tried vol1:\asset*\ & that didn't work either.  Any other
> suggestions?
>
> --
> Bruce Kamp
> Midrange Systems Analyst II
> Memorial Healthcare System
> E: [EMAIL PROTECTED]
> P: (954) 987-2020 x4597
> F: (954) 985-1404
> ---
>
>
> -Original Message-
> From: Wolfgang Bayrhof [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 25, 2003 8:27 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Netware Restore Question
>
>
> Hi Bruce,
>
> you have to use the short filenames to start the restore operation by the
> command line. The short filenames are saved in the namespace "DOS" under
> NetWare. You can find out the short names by NDIR, MONITOR and NwAdmin.
> Maybe you can also use your Windows Explorer to find out the short names.
>
> The command
>
>   load dsmc res vol1:\assetinv\ -subdir=yes -rep=all -tapep=no
>
> or
>
>   load dsmc res vol1:\assetin1\ -subdir=yes -rep=all -tapep=no
>
> should work.
>
> bye,
> Wolfgang Bayrhof
>
>
> - Original Message -
> From: "Kamp, Bruce" <[EMAIL PROTECTED]>
> Date: Tue, 25 Feb 2003 08:03:03 -0500
> To: [EMAIL PROTECTED]
> Subject: Netware Restore Question
>
> > Environment:
> > TSM client 5.1.5.6 on Netware 6
> > TSM server 5.1.1.6 on AIX 4.3.3
> >
> > Trying to restore the directory vol1:\asset inventory from the command
> > line but can not figure out the correct syntax!  I have tried the
> > following
> > commands:
> > load dsmc res vol1:\asset inventory\ -subdir=yes -rep=all -tapep=no
> > load dsmc res "vol1:\asset inventory\" -subdir=yes -rep=all -tapep=no
> > load dsmc res vol1:\"asset inventory"\ -subdir=yes -rep=all -tapep=no
> > What am I missing?!
> >
> > Thanks,
> > --
> > Bruce Kamp
> > Midrange Systems Analyst II
> > Memorial Healthcare System
> > E: [EMAIL PROTECTED] 
> > P: (954) 987-2020 x4597
> > F: (954) 985-1404
> > ---

Cannot backup Domino version 5.0.11 using tdp

[Frost, Dave]

Hi,

Several of our clients have upgraded their Domino servers to v5.0.11, and
the tdp promptly stopped working.  The tdp worked fine with previous
versions of Domino on these servers.  We have tried using the very latest
tdp version from the ftp site, but no success there.

The symptoms we see are that the first time you open the GUI after
installing it, a   C++ API runtime error appears. After this, the GUI just
hangs. The command line does not appear to work either.

We _have_ found that we can backup the Domino server through the tdp gui
IF, and only if, the Domino server is shut down!

The last client is running  NAI GroupShield V5.2 within the Domino
application, but not at the server level.  We tried shutting this down, but
with no effect.

Has anybody managed to get Domino 5.0.11 to backup through the tdp yet?

tia,

-=Dave=-
+44 (0) 20 7608 7140

Accountants do it with double entry.

Réf. : Cannot backup Domino version 5.0.11 using tdp

[Guillaume Gilbert]

I just got this error. The problem is with version 5.2 of groupshield. Even if 
groupshield is deactivated we were getting this error. We had to completly deinstall 
it to
get TDP working correctly. You can either go back to a previous version or wait for 
5.2.1 which should correct the problem.

Guillaume Gilbert
CGI Canada




"Frost, Dave" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 2003-02-25 09:12:18

Veuillez répondre à "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Envoyé par :  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


Pour : [EMAIL PROTECTED]
cc :
Objet : Cannot backup Domino version 5.0.11 using tdp

Hi,

Several of our clients have upgraded their Domino servers to v5.0.11, and
the tdp promptly stopped working.  The tdp worked fine with previous
versions of Domino on these servers.  We have tried using the very latest
tdp version from the ftp site, but no success there.

The symptoms we see are that the first time you open the GUI after
installing it, a   C++ API runtime error appears. After this, the GUI just
hangs. The command line does not appear to work either.

We _have_ found that we can backup the Domino server through the tdp gui
IF, and only if, the Domino server is shut down!

The last client is running  NAI GroupShield V5.2 within the Domino
application, but not at the server level.  We tried shutting this down, but
with no effect.

Has anybody managed to get Domino 5.0.11 to backup through the tdp yet?

tia,

-=Dave=-
+44 (0) 20 7608 7140

Accountants do it with double entry.

TDP for MS SQL version 5.1.5

[Edgardo Moso]

Anyone knows the link for the TDP for MS SQL version 5.1.5.0?
I've been working with IBm but they just gave the ftp link which anonymous
couldn't access.

Thanks,

Ed Moso

Re: Cannot backup Domino version 5.0.11 using tdp

[Greg Redell]

Just add DOMDSM and DOMDSMC to the excluded applications list under server
settings.  We have been working fine with Domino 5.0.11 TDP 5.1.5.1 and
Groupshield 5.2 for a month and a half.

Greg Redell
Great-West Life & Annuity Insurance Co.
Phone: 314-525-5877
Email: [EMAIL PROTECTED]

Don't try to fix it, unless you understand it.


|-+>
| |   "Frost, Dave"|
| |   <[EMAIL PROTECTED]|
| |   RD.COM>  |
| |   Sent by: "ADSM:  |
| |   Dist Stor|
| |   Manager" |
| |   <[EMAIL PROTECTED]|
| |   .EDU>|
| ||
| ||
| |   02/25/2003 08:12 |
| |   AM   |
| |   Please respond to|
| |   "ADSM: Dist Stor |
| |   Manager" |
|-+>
  
>--|
  |
  |
  |   To:   [EMAIL PROTECTED]  
   |
  |   cc:  
  |
  |   Subject:  Cannot backup Domino version 5.0.11 using tdp  
  |
  
>--|




Hi,

Several of our clients have upgraded their Domino servers to v5.0.11, and
the tdp promptly stopped working.  The tdp worked fine with previous
versions of Domino on these servers.  We have tried using the very latest
tdp version from the ftp site, but no success there.

The symptoms we see are that the first time you open the GUI after
installing it, a   C++ API runtime error appears. After this, the GUI just
hangs. The command line does not appear to work either.

We _have_ found that we can backup the Domino server through the tdp gui
IF, and only if, the Domino server is shut down!

The last client is running  NAI GroupShield V5.2 within the Domino
application, but not at the server level.  We tried shutting this down, but
with no effect.

Has anybody managed to get Domino 5.0.11 to backup through the tdp yet?

tia,

-=Dave=-
+44 (0) 20 7608 7140

Accountants do it with double entry.

Re: Netware Restore Question

[Kamp, Bruce]

I found 1 big mistake!  The directory is Asset Inventory Backup.  But I
found the syntax is load dsmc res "vol1:\asset inventory backup\"
-subdir=yes -rep=all


--
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E: [EMAIL PROTECTED]
P: (954) 987-2020 x4597
F: (954) 985-1404
---


-Original Message-
From: Wolfgang Bayrhof [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 8:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Netware Restore Question


Hi Bruce,

you can still use the Pick-List with the -pick option.
It's maybe a time-consuming task to scroll the pick list
on the command line, when there a lot of directories in
your volumes root, but it should work.

  load dsmc res vol1:\ -pick -subdir=yes -rep=all -tapep=no

bye,
Wolfgang Bayrhof




- Original Message -
From: "Kamp, Bruce" <[EMAIL PROTECTED]>
Date: Tue, 25 Feb 2003 08:34:05 -0500
To: [EMAIL PROTECTED]
Subject: Re: Netware Restore Question

> I am restoring the whole volume.  It was blown away...  So I can't see
> the directory in any of these utils.  I tried both of your suggestions
> & no go on both...  I also tried vol1:\asset*\ & that didn't work
> either.  Any other suggestions?
>
> --
> Bruce Kamp
> Midrange Systems Analyst II
> Memorial Healthcare System
> E: [EMAIL PROTECTED]
> P: (954) 987-2020 x4597
> F: (954) 985-1404
> ---
>
>
> -Original Message-
> From: Wolfgang Bayrhof [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 25, 2003 8:27 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Netware Restore Question
>
>
> Hi Bruce,
>
> you have to use the short filenames to start the restore operation by
> the command line. The short filenames are saved in the namespace "DOS"
> under NetWare. You can find out the short names by NDIR, MONITOR and
> NwAdmin. Maybe you can also use your Windows Explorer to find out the
> short names.
>
> The command
>
>   load dsmc res vol1:\assetinv\ -subdir=yes -rep=all -tapep=no
>
> or
>
>   load dsmc res vol1:\assetin1\ -subdir=yes -rep=all -tapep=no
>
> should work.
>
> bye,
> Wolfgang Bayrhof
>
>
> - Original Message -
> From: "Kamp, Bruce" <[EMAIL PROTECTED]>
> Date: Tue, 25 Feb 2003 08:03:03 -0500
> To: [EMAIL PROTECTED]
> Subject: Netware Restore Question
>
> > Environment:
> > TSM client 5.1.5.6 on Netware 6
> > TSM server 5.1.1.6 on AIX 4.3.3
> >
> > Trying to restore the directory vol1:\asset inventory from the
> > command line but can not figure out the correct syntax!  I have
> > tried the following
> > commands:
> > load dsmc res vol1:\asset inventory\ -subdir=yes -rep=all -tapep=no
> > load dsmc res "vol1:\asset inventory\" -subdir=yes -rep=all
> > -tapep=no load dsmc res vol1:\"asset inventory"\ -subdir=yes
> > -rep=all -tapep=no What am I missing?!
> >
> > Thanks,
> > --
> > Bruce Kamp
> > Midrange Systems Analyst II
> > Memorial Healthcare System
> > E: [EMAIL PROTECTED] 
> > P: (954) 987-2020 x4597
> > F: (954) 985-1404
> > ---

Re: TDP for MS SQL version 5.1.5

[Del Hoobler]

Ed,

I just obtained this with anonymous:

ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/tivoli-data-protection/ntsql/v515/nt/


Thanks,

Del
===
> Anyone knows the link for the TDP for MS SQL version 5.1.5.0?
> I've been working with IBm but they just gave the ftp link which
anonymous
> couldn't access.

AIX Client automatic start for dsmcad

[Anders Ståhlbom]

Where is the best place for starting dsmcad during boot on AIX 4.3.3?

Like /etc/rc.d/rc.local for Linux


//Anders

Re: AIX Client automatic start for dsmcad

[Jin Bae Chi]

I use /etc/inittab file to bring dsmcad with ONCE option.



Jin Bae Chi (Gus)
System Admin/Tivoli
Data Center, CSCC
614-287-5270
614-287-5488 Fax
[EMAIL PROTECTED]


>>> [EMAIL PROTECTED] 02/25/03 09:45AM >>>
Where is the best place for starting dsmcad during boot on AIX 4.3.3?

Like /etc/rc.d/rc.local for Linux


//Anders

Re: Help setting up RMAN w/ TDP 2210

[Neil Rasmussen]

Theresa,

The 2518 return code you are seeing means that the license file that Data
Protection for Oracle is picking up and reading is not a valid license
file for TDP Oracle. It could be that your license file was corrutped
during install?? Unfortunately, troubleshooting is very hard with Rman
when a failure occurs during initialization - It isn't until a later
function call that Rman will actually send a meaningful message to the
Rman output. If you believe that the license file is the correct one for
TDP Oracle, try removing and reinstalling TDP Oracle. Hope this helps.


--

Date:Mon, 24 Feb 2003 17:35:27 -0500
From:Theresa Sarver <[EMAIL PROTECTED]>
Subject: Help setting up RMAN w/ TDP 2210

This is a MIME message. If you are reading this text, you may want to
consider changing to a mail reader or gateway that understands how to
properly handle MIME multipart messages.

--=_623D0BF3.7E1F7317
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi all;

I'm having all kinds of problems and am hoping someone can assist me with
=
this setup...as I'm all confused at this point.


Regards,

Neil Rasmussen
Software Development
TDP for Oracle
[EMAIL PROTECTED]

Copy storage pools - serious data integrity issues

[Neil Schofield]

Dear all

I've been running TSM for four years or so. When we use BACKUP STGPOOL to
copy a primary storage pool to a copy storage pool, I have relied on the
fact that a successful completion means I have two copies of all my data.

I've just discovered that a number of my files don't have a second copy.
For a large number of volumes (more than 10 per server) Q CONTENT xx
COPIED=NO comes back details of the files but BACKUP STGPOOL (with or
without PREVIEW=YES) tells me there is no data to be copied.

Some of these files were backed up from the client months (years?) ago.
Some are active, some are inactive.

I discovered this when testing my DR procedures. I updated the status of
all my primary storage pool volumes to be DESTROYED and ran a RESTORE
STGPOOL PREVIEW=YES. I was shocked at the number of 'ANR1256W Volume XX
contains files that could not be restored' messages that resulted.

I've logged a PMR but wondered if anybody else had experienced similar. It
kind of blows a big hole in my DR plans.

For info, we are running TSM Server 4.2.1.15 on Windows.

Thanks
Neil Schofield
Yorkshire Water Services Ltd.



Visit our web site to find out about our award winning
Cool Schools community campaign at
http://www.yorkshirewater.com/yorkshirewater/schools.html
The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject
to the legal notice available at http://www.keldagroup.com/email.htm
Yorkshire Water Services Limited
Registered Office Western House Halifax Road Bradford BD6 2SZ
Registered in England and Wales No 2366682

Re: Copy storage pools - serious data integrity issues

[William Rosette]

I did experience the same problem at a DR 3 years ago.  What we found out
was our Daily Process was not working properly.  The BACKUP STGPOOL was not
finishing to successful completion.  Also, did a RESTORE STGPOOL COPYPOOL.
I usually run the restore a couple of months b4 DR to help sync things up.
Last year there was no tapes to restore.  As long as our daily process
continues to complete successfully our DR will work good.

Thank You,
Bill Rosette
Data Center/IS/Papa Johns International
WWJD



  Neil Schofield
  <[EMAIL PROTECTED]To:   [EMAIL PROTECTED]
  ATER.CO.UK>   cc:
  Sent by: "ADSM: Dist Stor Subject:  Copy storage pools - 
serious data integrity issues
  Manager"
  <[EMAIL PROTECTED]>


  02/25/2003 10:31 AM
  Please respond to "ADSM:
  Dist Stor Manager"






Dear all

I've been running TSM for four years or so. When we use BACKUP STGPOOL to
copy a primary storage pool to a copy storage pool, I have relied on the
fact that a successful completion means I have two copies of all my data.

I've just discovered that a number of my files don't have a second copy.
For a large number of volumes (more than 10 per server) Q CONTENT xx
COPIED=NO comes back details of the files but BACKUP STGPOOL (with or
without PREVIEW=YES) tells me there is no data to be copied.

Some of these files were backed up from the client months (years?) ago.
Some are active, some are inactive.

I discovered this when testing my DR procedures. I updated the status of
all my primary storage pool volumes to be DESTROYED and ran a RESTORE
STGPOOL PREVIEW=YES. I was shocked at the number of 'ANR1256W Volume XX
contains files that could not be restored' messages that resulted.

I've logged a PMR but wondered if anybody else had experienced similar. It
kind of blows a big hole in my DR plans.

For info, we are running TSM Server 4.2.1.15 on Windows.

Thanks
Neil Schofield
Yorkshire Water Services Ltd.



Visit our web site to find out about our award winning
Cool Schools community campaign at
http://www.yorkshirewater.com/yorkshirewater/schools.html
The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject
to the legal notice available at http://www.keldagroup.com/email.htm
Yorkshire Water Services Limited
Registered Office Western House Halifax Road Bradford BD6 2SZ
Registered in England and Wales No 2366682

Re: ANR8302E error on drive

[TAZ]

Sylvia,

The first question is in regards to  cleaning frequency?

How often do you clean this particular drive?

Sam.
- Original Message -
From: "Sylvia Nergard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 25, 2003 4:02 AM
Subject: ANR8302E error on drive


Does this indicate a hardware error?

ANR8302E I/O error on drive MT1.0.0.2 (mt1.0.0.2)
   (OP=READ, Error Number=1117, CC=305, KEY=00, ASC=00,
   ASCQ=00,
SENSE=70.00.00.00.00.00.00.0E.00.00.00.00.00.00-
   .00.00.00.00.00.00.00.00., Description=Drive
failure).
   Refer to Appendix D in the 'Messages' manual for
   recommended action.
ANR8792E Unrecoverable drive failures on drive MT1.0.0.2
   (mt1.0.0.2); drive is now taken offline.

This has happend twice, when I set the drive online again it works.
Is it really a hardware error, or could it be something else that makes TSM
to set this drive offline?


Regards

Sylvia Nergerd

Re: TDP Domino sporadic/chronic error - "ACD0200E File () could not be opened for reading."

[Del Hoobler]

Kent,

Is there any type of Domino maintenance activity that might be
happening during the entire backup window? We have seen some
similar things when the Domino server was doing some maintenance
tasks during the backup window. DP for Domino scans all of the
databases, and gets the information (like pathnames, etc.)
at the beginning.  It could be that something prevented
getting the path information at the beginning, or something
has changed it by the time DP for Domino opens it for backup.

I would look at that first. If you see this continue and do
not see anything else that could be getting in the way,
please call IBM support. A trace of the problem recreation
may help determine what is going on.

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

- Remember that the best job security is
doing a job well and doing it cheerfully.
=
> We have a TDP-Domino incremental backup schedule on our TSM Server that
> occasionally produces this message in the client log:
>
> >  Tivoli Data Protection for Lotus Domino - Version 1, Release
1,
> Level 1.0
> .
> .
> >  Backing up database mail\WXY12345.nsf, 1 of 1.
> >  Full: 0   Read: 0  Written: 0  Rate: 0.00 Kb/Sec
> >  Backup of mail\WXY12345.nsf failed.
> >  ACD0200E File () could not be opened for reading.
> .
> .
> This has been occurring sporadically on 3 different Domino Servers.  Each
> server has several hundred active mail databases, all in the same
> subdirectory, most of which TDP backs up just fine.  We see this message
> on a very small, random subset - typically just 1-3 databases on 1 of the
> 3 servers on any given night.  Sometimes all 3 server backups succeed
with
> no reported errors.  The subset of affected databases is somewhat random,
> except that they always seem to be near (not at) the end of the mail
> subdirectory.
>
> We perform follow-up incremental backups on any that fail, and the
> follow-up backups always work fine.
>
> We haven't been able to correlate occurrences to any client-side or
> server-side events.  Does anyone know what might be causing this, and
> (hopefully) how to resolve it?

Binding SYSTEM OBJECT

[Fred Johanson]

About half the machines in our central server domain are small and bound to
a small server management class by an option set.  It looks like
0  include ?:* smallserver
1-37 exclude the usual suspects
38  include c:\adsm.sys\...\* smallserver
39  dirmc smallserver.
Sequence #s 0 and 39 do the right thing, but 38 does not, so the SYSTEM
OBJECTs go to the default pool instead.
What have I missed here?  The server is 5.1.1.6 running on AIX.

Client install on a MS Cluster with SQL 2000

[Tyree, David]

We will be setting up a new cluster server running Win2k and MS
SQL 2000. We are at 5.1 on our TSM server.

We are backing up another cluster server running the same OS but
without any SQL on it. And we are backing up SQL 2000 running on a
non-cluster server. Both have the newest clients installed and running fine.


Is there anything that's not in the book on running a SQL client
on a MS cluster that I might need to know?

Thanks...



David Tyree
Microcomputer Specialist
South Georgia Medical Center
229.333.1155

Confidential Notice:  This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information.  Any unauthorized review, use,  disclosure or
distribution is prohibited.  If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.

5.1.6.2 Upgrade

[Gill, Geoffrey L.]

This morning I upgraded to 5.1.6.2 server on AIX 4.3.3. The upgrade was from
V5.1.5.2, which went smooth. Will keep an eye out for any anomolies,
especially tonight being that's it's the first full load for backups.

Has anyone who upgraded recently noticed any issues that cause real
problems?

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

Re: 5.1.6.2 Linux tsmscsi broken

[Mitch Sako]

Thank you.  I will give it a try when I can quiesce the server.

Mitch

Patrick Boutilier wrote:

> Mitch,
>
> Just change line 75 of tsmscsi (it is just a shell script) from :
>
> prefix=`rpm -q --queryformat %'{INSTALLPREFIX}' TIVsm-tsmscsi-5.1.6-0`
>
> to :
>
> prefix=`rpm -q --queryformat %'{INSTALLPREFIX}' TIVsm-tsmscsi-5.1.6-2`
>
> Mitch Sako wrote:
> > The tsmscsi that is in 5.1.6.2 for Linux32 is not working for us:
> >
> > We are running Redhat 7.2:
> > [EMAIL PROTECTED] ~]$ uname -a
> > Linux tsm2 2.4.9-31 #1 Tue Feb 11 14:43:37 PST 2003 i686 unknown
> >
> > The 5.1.6.2 tsmscsi executable prints the following strange message:
> > [EMAIL PROTECTED] bin]$ ./tsmscsi
> > package TIVsm-tsmscsi-5.1.6-0 is not installed/tivoli/tsm/devices/bin not found
> > Make sure that the device driver is installed under package TIVsm-tsmscsi-5.1.6-0 
> > is not
> > installed/tivoli/tsm/devices/bin
> >
> > I was hoping that we would get a chance to try a new tsmscsi because the one we 
> > have (5.1.6.0) is really unstable
> > and we have numerous core dumps to prove it.

Linux Server Restrictions

[Mitch Sako]

The number of possible Linux configurations is extremely limited.  Two of them
involve enterprise Linux distros, including a SuSE one that I could not figure
out a way to buy.  The RH enterprise offering requires a kernel that does not
ship with the product and it's a large task in itself to get registered with RH
and get the appropriate kernel from them.  That left a RH 7.2 with a 2.4.9-31
kernel (I think 2.4.9-34 is "current").

I am wondering what possible factors went into limiting the number of
configurations for the Linux server.  I can guess that it has something to do
with the GPL and LGPL restrictions and C++ code but I would only be guessing.
For those of us who prefer to stay current with kernel.org versions it presents
a severe problem.  For instance, the only stable RH 7.2 configuration I could
get working on an X235/X345 server is a 2.4.19 kernel built with gcc 2.95.3
because of problems with the LSI Logic MPT SCSI drivers.  Retrofitting module
drivers into old kernels just doesn't provide a stable environment in my testing
experience.

Anyway, I would be very curious to know why the configuration choices are so
restrictive.

Re: 5.1.6.2 Upgrade

[Gill, Geoffrey L.]

> I would've logged a call with TSM support but I've already
> got 2 PMR's open that they're not calling me back on.  ;)
>
> How do your help screens look?
> Thanks;
> Theresa

Theresa,

>From my perspective help files look fine via the web interface and the CLI.

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

Checkin multiple tapes to 3494 library

[Tommy Templeton]

Hi *SM'ers

Is there a way to check in multiple new volumes (with barcodes) to a 3494 library as 
scratch? 

Tommy Templeton
Senior System Administrator
DFA-MMRS
601-359-3106
e-mail - [EMAIL PROTECTED]

Re: Checkin multiple tapes to 3494 library

[Bob Booth - UIUC]

checkin libv libname search=yes checkl=yes/no status=scratch

bob

On Tue, Feb 25, 2003 at 01:30:52PM -0600, Tommy Templeton wrote:
> Hi *SM'ers
>
> Is there a way to check in multiple new volumes (with barcodes) to a 3494 library as 
> scratch?
>
> Tommy Templeton
> Senior System Administrator
> DFA-MMRS
> 601-359-3106
> e-mail - [EMAIL PROTECTED]

Re: Checkin multiple tapes to 3494 library

[Fred Johanson]

checki libv libname sea=y devt=whatever stat=scr volr=1stbarcode,lastbarcode

At 01:30 PM 2/25/2003 -0600, you wrote:
Hi *SM'ers

Is there a way to check in multiple new volumes (with barcodes) to a 3494
library as scratch?
Tommy Templeton
Senior System Administrator
DFA-MMRS
601-359-3106
e-mail - [EMAIL PROTECTED]

Re: Checkin multiple tapes to 3494 library

[Lawrence Clark]

load them in the hopper and get them in the library 1st, before entering
the checkin command.

>>> [EMAIL PROTECTED] 02/25/03 02:30PM >>>
Hi *SM'ers

Is there a way to check in multiple new volumes (with barcodes) to a
3494 library as scratch?

Tommy Templeton
Senior System Administrator
DFA-MMRS
601-359-3106
e-mail - [EMAIL PROTECTED]

(Veritas) BMR security issue

[bbullock]

Interesting note about BMR. This might be old news, as the report is almost a 
week old, but I don't recall seeing it sent out to the listserv.

<>

Ben

Re: Checkin multiple tapes to 3494 library

[Trinh, Tony]

Tommy,

Yup, the easiest way that I found to check in multiple new volumes to a 3494
library is creating a text file like below. Then log in to TSM and run a
macro against that file...show below too... Hopefully these tapes have
already been formatted.



$ more checkin
checkin libv ids01atl1 1a1321 devt=3590 status=scratch
checkin libv ids01atl1 1a1323 devt=3590 status=scratch
checkin libv ids01atl1 1a1330 devt=3590 status=scratch
checkin libv ids01atl1 1a1331 devt=3590 status=scratch
checkin libv ids01atl1 1a1334 devt=3590 status=scratch


Session established with server I01SV600: Solaris 7/8
  Server Version 4, Release 2, Level 1.9
  Server date/time: 02/25/03   20:37:55  Last access: 02/25/03   20:22:15


tsm: I01SV600>macro /tmp/checkin




-Original Message-
From: Tommy Templeton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 11:31 AM
To: [EMAIL PROTECTED]
Subject: Checkin multiple tapes to 3494 library

Hi *SM'ers

Is there a way to check in multiple new volumes (with barcodes) to a 3494
library as scratch?

Tommy Templeton
Senior System Administrator
DFA-MMRS
601-359-3106
e-mail - [EMAIL PROTECTED]

Re: 5.1.6.2 Upgrade

[Theresa Sarver]

I just noticed late last night that the formatting of the TSM Server's "help" menus 
are all messed up.  

Doesn't matter if I go through the GUI or the CLI, I get the following:

tsm: C2TSMSERV>help upd stg 
UPDATE STGPOOL|  -- 
---||UPDATE STGPOOL (Update a Storage Pool)||Use this command to change 
a storage pool.||The UPDATE STGPOOL command takes three forms, depending on 
whether the|update is for a primary storage pool assigned to random access  
devices, a|primary storage pool assigned to sequential access devices, or a 
copy|storage pool. The syntax and parameters for each form are  
defined|separately.||UPDATE STGPOOL -- Primary Random Access||Use this command  
to update a random access storage pool.||Privilege Class||To issue this 
command, you must have system privilege, unrestricted storage|privilege, or 
restricted storage privilege for the storage pool to
be|updated.||Syntax||>>-UPDate STGpool---pool_name- 
--->||>-+--+-->|
  '-DESCription--=--description--'||>-+-+-- 
-->|  '-ACCess--=--+-READWrite---+--'|  
 +-READOnly+|   '-UNAVailable-'||>-+--- 
--+>|   

I would've logged a call with TSM support but I've already got 2 PMR's open that 
they're not calling me back on.  ;)

How do your help screens look?

Thanks;
Theresa

>>> [EMAIL PROTECTED] 02/25/03 11:38AM >>>
This morning I upgraded to 5.1.6.2 server on AIX 4.3.3. The upgrade was from
V5.1.5.2, which went smooth. Will keep an eye out for any anomolies,
especially tonight being that's it's the first full load for backups.

Has anyone who upgraded recently noticed any issues that cause real
problems?

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

Re: Help setting up RMAN w/ TDP 2210

[Theresa Sarver]

My LANG variable was set to "en_US" in both the ...api/bin directory as well as for 
user:oracle.  

We were able to backup RMAN to disk successfully.  

As this is a new (replacement server) for one of our SP nodes, I copied the license 
file from this SP node onto the new server and then downloaded/installed TDP2210.  I 
have ordered the TDP 22 installation media and will try a clean install of that when I 
get it.

I'll keep you posted.

Thanks to everyone for the help thus far;
Theresa

Extended device support

[Guillaume Gilbert]

Ok guys don't laugh

I tried migrate my old adsm 3.1.2.42 server today. It's a small server with only 7 
clients. On AIX 4.3.3. I installed 5.1.6.2 and everything was going fine until I tried
using the tape drives. Now these are very peculiar. They are 2 ESCON attached 3490 
drives. (only 800 megs per tape...) TSM 51 di not like this. I got io errors galor and
was unable to read any tapes. Well looks like they are not supported anymore. Let's go 
back to adsm 3.1.2.42. I did but I still can't read my tapes. Seems I have lost the
extended device support module and I can't find the install pack anywhere.

So my question is : does anybody out there have a copy of this thing lying around 
somewhere or can point to a place I can download it???

If anyone does, please reach me at this email adress

Thank You


Guillaume Gilbert
Conseiller - Gestion du stockage
CGI - Gestion intégré des technologies
TEL. : (514) 281-7000 ext 3642
Pager : (514) 957-2615
Email : [EMAIL PROTECTED]

Client side Multi HBA Configuration

[Cermak, Frank S]

Hi - can anyone provide insight on the configuration of client side multiple
fibre HBAs using fibre over IP?

Thanks,

Frank C.

Library Configuration Question

[Kelly J. Lipp]

Folks,

Does anyone know the how the following works for sure:

During library definition a read element status command is sent to the
library to help the definition process.  Is a read element status then
issued during each subsequent library initialization (at startup) or is this
information stored statically in the database?

The specific case I'm curious about is when slots are added to a library.
Will TSM detect these new slots as part of the initialization or will a
library re-definition be required?

I have seen a case where a simple restart detected the new slots and I have
also seen the case where a re-definition was required.

What is really happening?  Clearly this is for the engineers.

Thanks,

Kelly J. Lipp
STORServer, Inc.
485-B Elkton Drive
Colorado Springs, CO 80907
[EMAIL PROTECTED] or [EMAIL PROTECTED]
www.storsol.com or www.storserver.com
(719)531-5926
Fax: (240)539-7175

Re: Checkin multiple tapes to 3494 library

[Allen Barth]

You got  several answers, but I got questions for you.

1. Is the 3494 shared?
2. Do you know if the tapes are initialized?

If the 3494 is shared, you can't just do a search=yes because you may very
well get tapes that *shouldn't* belong to ITSM
If the tapes aren't initialized then you can't just do a checkin.  You'll
need to do a DSMLABEL or LABEL LIBV





Tommy Templeton <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
02/25/03 01:30 PM
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Checkin multiple tapes to 3494 library


Hi *SM'ers

Is there a way to check in multiple new volumes (with barcodes) to a 3494
library as scratch?

Tommy Templeton
Senior System Administrator
DFA-MMRS
601-359-3106
e-mail - [EMAIL PROTECTED]

is centralized backup of 7 DMZ feasible?

[Molly YM Pui]

Dear TSMers,

We've encountered an environment which have 7 DMZ, with a total of 25 SUN
Servers (total with 250GB data) required backup. So in average, each DMZ
will require backup of 40GB data.
I'm thinking of building a dedicated backup network, say 100M Ethernet for
handling this traffic.

Solution i can think of is to build a TSM Server with 7 NIC cards, all SUN
Servers also install additional NIC card.
Also include a firewall between the TSM Server and TSM clients for security
purpose. So this will require 7 firewalls in place.

Questions
- Does anyone ever have production environment with backup of DMZ clients
that can share with me? Is it a feasible solution? I can see this will have
really big backup traffic pass through the firewall.
- Or what's the best practice in backing up servers in DMZ?
- I've heard people saying that firewall will significatly lower the
network throughput and the backup process may be unstable. Is this true?

If anyone has better solution on this, please advise. Thanks.


Best Regards,
 Molly Pui

Re: Checkin multiple tapes to 3494 library

[Lawrence Clark]

lookat the checkin libvolume command

checkin libv  volr= stat=scr dev=3590

>>> [EMAIL PROTECTED] 02/25/03 02:30PM >>>
Hi *SM'ers

Is there a way to check in multiple new volumes (with barcodes) to a
3494 library as scratch?

Tommy Templeton
Senior System Administrator
DFA-MMRS
601-359-3106
e-mail - [EMAIL PROTECTED]

Select statement question...

[Coats, Jack]

The first of these queries works.  What is wrong with the second one?  I've
been scratching my balding head and getting nothing but an itching scalp.
Thanks for you help! ... Jack

select platform_name as OS, -
client_os_level as OS_VER, -
node_name as Node, -
cast(cast(client_version as char(2)) || '.' -
|| cast(client_release as char(2)) || '.' -
|| cast(client_level as char(2)) || '.' -
|| cast(client_sublevel as char(2)) -
as char(15)) as "Client" -
from nodes -
order by platform_name, "Client", Node


select platform_name as OS, -
  client_os_level as OS_VER, -
  cast(cast(client_version as char(2)) || '.' -
  || cast(client_release as char(2)) || '.' -
  || cast(client_level as char(2)) || '.' -
  || cast(client_sublevel as char(2)) -
as char(15)) as "Client", -
  count(*) -
 from nodes -
  group by platform_name, -
client_os_level -
  order by OS, OS_VER, "Client"

support for Qualstar RLS-4221 library????

[Bill Boyer]

According to the supported devices web page, this library isn't supported,
but you never know when the last time the page was updated. Does anyone know
if and what level of TSM supports this library with AIT-2 drives?

TIA,
Bill Boyer
"Some days you are the bug, some days you are the windshield." - ??

Re: 5.1.6.2 Upgrade

[Ruddy STOUDER]

Theresa,

Is your TSM Server an AIX machine ?

This is probably due to the fact you "unzipped" the file on a Windows
machine iso :

- ftp the package from your win machine to the AIX server (in bin format)
- gunzip the file on the AIX machine
- tar the file on th AIX machine

This should solve your problem.

Ruddy

Ruddy Stouder
Senior Technical Consultant
TSM Certified Consultant
I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de
Louvain-La-Neuve
B-1348 Mont-Saint-Guibert
[EMAIL PROTECTED]

Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40




-Original Message-
From: Theresa Sarver [mailto:[EMAIL PROTECTED] 
Sent: mardi 25 février 2003 18:46
To: [EMAIL PROTECTED]
Subject: Re: 5.1.6.2 Upgrade


I just noticed late last night that the formatting of the TSM Server's
"help" menus are all messed up.  

Doesn't matter if I go through the GUI or the CLI, I get the following:

tsm: C2TSMSERV>help upd stg

UPDATE STGPOOL|
-- 
---||UPDATE STGPOOL (Update a Storage Pool)||Use this command to 
---||change
a storage pool.||The UPDATE STGPOOL command takes three forms, depending on

whether the|update is for a primary storage pool assigned to random access

devices, a|primary storage pool assigned to sequential access devices, or a

copy|storage pool. The syntax and parameters for each form are

defined|separately.||UPDATE STGPOOL -- Primary Random Access||Use this 
defined|command
to update a random access storage pool.||Privilege Class||To issue this

command, you must have system privilege, unrestricted storage|privilege, or

restricted storage privilege for the storage pool to

be|updated.||Syntax||>>-UPDate 
be|STGpool---pool_name-
--->||>-+--+-->|

 
'-DESCription--=--description--'||>-+-+-
- 
-->|  '-ACCess--=--+-READWrite---+--'|

 +-READOnly+|
'-UNAVailable-'||>-+--- 
--+>|


I would've logged a call with TSM support but I've already got 2 PMR's open
that they're not calling me back on.  ;)

How do your help screens look?

Thanks;
Theresa

>>> [EMAIL PROTECTED] 02/25/03 11:38AM >>>
This morning I upgraded to 5.1.6.2 server on AIX 4.3.3. The upgrade was from
V5.1.5.2, which went smooth. Will keep an eye out for any anomolies,
especially tonight being that's it's the first full load for backups.

Has anyone who upgraded recently noticed any issues that cause real
problems?

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

Re: Select statement question...

[Paul Ripke]

On Wednesday, Feb 26, 2003, at 10:03 Australia/Sydney, Coats, Jack
wrote:
The first of these queries works.  What is wrong with the second one?
I've
been scratching my balding head and getting nothing but an itching
scalp.
Thanks for you help! ... Jack
select platform_name as OS, -
client_os_level as OS_VER, -
node_name as Node, -
cast(cast(client_version as char(2)) || '.' -
|| cast(client_release as char(2)) || '.' -
|| cast(client_level as char(2)) || '.' -
|| cast(client_sublevel as char(2)) -
as char(15)) as "Client" -
from nodes -
order by platform_name, "Client", Node
select platform_name as OS, -
  client_os_level as OS_VER, -
  cast(cast(client_version as char(2)) || '.' -
  || cast(client_release as char(2)) || '.' -
  || cast(client_level as char(2)) || '.' -
  || cast(client_sublevel as char(2)) -
as char(15)) as "Client", -
  count(*) -
 from nodes -
  group by platform_name, -
client_os_level -
  order by OS, OS_VER, "Client"
All non-summary columns selected have to be in the group by clause. In
your
case, this means the "Client" column. BTW, I haven't tried this, and
I'm not
sure TSM SQL-like interface will accept it.
BTW: Hope this helps your scalp stop itching...

Cheers,
--
Paul Ripke
Unix/OpenVMS/TSM/DBA
101 reasons why you can't find your Sysadmin:
68: It's 9AM. He/She is not working that late.
-- Koos van den Hout