Re: Create TSM service

2005-01-19 Thread Gokhan YILDIRIM
dsmcutil inst /name:TSM Client Scheduler /node:  /password:xxx 
/autostart:yes /clientdir:c:\Tivoli\TSM\baclient 
/optfile:c:\Tivoli\TSM\baclient\dsm.opt /startnow:no

Best Regards,
Gökhan YILDIRIM

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of nghiatd
Sent: Wednesday, January 19, 2005 4:04 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Create TSM service

Does anyone know to create TSMserver service in Win2K by command ?

This message and attachments are confidential and intended solely for the 
individual(s) stated in this
message.If you received this message although you are not the addressee you are 
responsible to keep the
message confidential .The sender has no responsibility for the accuracy or 
correctness of the
information in the message and its attachments.Our company shall have no 
liability for any changes
or late receiving,loss of integrity and confidentiality,viruses and any damages 
caused in
anyway to your computer system.

Bu mesaj ve ekleri mesajda gonderildigi belirtilen kisi/kisilere ozeldir ve 
gizlidir.Bu mesajin muhatabi
olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj iceriginin gizliligi 
ve bu gizlilik yukumlulugune
uyulmasi zorunlulugu tarafiniz icin de soz konusudur.Mesaj ve eklerinde yer 
alan bilgilerin dogrulugu ve
guncelligi konusunda gonderenin ya da sirketimizin herhangi bir sorumlulugu 
bulunmamaktadir.Sirketimiz
mesajin ve bilgilerinin size degisiklige ugrayarak veya gec ulasmasindan, 
butunlugunun ve gizliliginin
korunamamasindan, virus icermesinden ve bilgisayar sisteminize verebilecegi 
herhangi bir zarardan
sorumlu tutulamaz.


Re: Create TSM service

2005-01-19 Thread nghiatd
Thank for your help,
But I want to create service for TSM server, not scheduler.
Because I can't create service for TSM server starting when I try to recover
TSM server

- Original Message -
From: Gokhan YILDIRIM [EMAIL PROTECTED]
To: ADSM-L@VM.MARIST.EDU
Sent: Wednesday, January 19, 2005 3:42 PM
Subject: Re: Create TSM service


dsmcutil inst /name:TSM Client Scheduler /node:  /password:xxx
/autostart:yes /clientdir:c:\Tivoli\TSM\baclient
/optfile:c:\Tivoli\TSM\baclient\dsm.opt /startnow:no

Best Regards,
Gvkhan YILDIRIM

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
nghiatd
Sent: Wednesday, January 19, 2005 4:04 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Create TSM service

Does anyone know to create TSMserver service in Win2K by command ?

This message and attachments are confidential and intended solely for the
individual(s) stated in this
message.If you received this message although you are not the addressee you
are responsible to keep the
message confidential .The sender has no responsibility for the accuracy or
correctness of the
information in the message and its attachments.Our company shall have no
liability for any changes
or late receiving,loss of integrity and confidentiality,viruses and any
damages caused in
anyway to your computer system.

Bu mesaj ve ekleri mesajda gonderildigi belirtilen kisi/kisilere ozeldir ve
gizlidir.Bu mesajin muhatabi
olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj iceriginin
gizliligi ve bu gizlilik yukumlulugune
uyulmasi zorunlulugu tarafiniz icin de soz konusudur.Mesaj ve eklerinde yer
alan bilgilerin dogrulugu ve
guncelligi konusunda gonderenin ya da sirketimizin herhangi bir sorumlulugu
bulunmamaktadir.Sirketimiz
mesajin ve bilgilerinin size degisiklige ugrayarak veya gec ulasmasindan,
butunlugunun ve gizliliginin
korunamamasindan, virus icermesinden ve bilgisayar sisteminize verebilecegi
herhangi bir zarardan
sorumlu tutulamaz.


Client return codes 4 and 8 - Can I safely ignore them?

2005-01-19 Thread Davis Adrian
We are currently implementing Tivoli Sotage Manager and I want the simplest
method to check for client errors for scripting purposes...

We've had a number of return code 4 (File not found) and return code 8
(Session lost - Session reestablished) errors. These don't seem to be
important, and I feel I can consider them to be warnings.

Are there any reasons that I may get a return code of 4 or 8 that really is
an error which has effected the usefulness of the backup?

Many Thanks,
   =Adrian=


Re: Client return codes 4 and 8 - Can I safely ignore them?

2005-01-19 Thread Warren, Matthew (Retail)
'Session lost - reestablished' errors are important, especially if
occuring repeatedly. They can extend the backup times greatly also.

We have seen session lost errors where the MAXSESSIONS values were to
low on either the TSM server or the Storage Agent.


Matt.


_-'-_
  -|-


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Davis Adrian
Sent: Wednesday, January 19, 2005 9:29 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Client return codes 4 and 8 - Can I safely ignore them?

We are currently implementing Tivoli Sotage Manager and I want the
simplest
method to check for client errors for scripting purposes...

We've had a number of return code 4 (File not found) and return code 8
(Session lost - Session reestablished) errors. These don't seem to
be
important, and I feel I can consider them to be warnings.

Are there any reasons that I may get a return code of 4 or 8 that really
is
an error which has effected the usefulness of the backup?

Many Thanks,
   =Adrian=


___ Disclaimer Notice __
This message and any attachments are confidential and should only be read by 
those to whom they are addressed. If you are not the intended recipient, please 
contact us, delete the message from your computer and destroy any copies. Any 
distribution or copying without our prior permission is prohibited.

Internet communications are not always secure and therefore Powergen Retail 
Limited does not accept legal responsibility for this message. The recipient is 
responsible for verifying its authenticity before acting on the contents. Any 
views or opinions presented are solely those of the author and do not 
necessarily represent those of Powergen Retail Limited. 

Registered addresses:

Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 
8LG.
Registered in England and Wales No: 3407430

Telephone +44 (0) 2476 42 4000
Fax +44 (0) 2476 42 5432


Re: 3584 Tape Library issue (maybe)

2005-01-19 Thread Lepre, James
How do you have the drives setup inside of TSM... Do you autodetect or
do you put he serial numbers in.  If you use serial numbers then check
to see if the drives are in the right order

Lsdev -Cc tape

Then do a lscfg -v rmtX to get the serial number and then match it up
with the correct order of drives 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Nathan Reiss
Sent: Tuesday, January 18, 2005 5:17 PM
To: ADSM-L@VM.MARIST.EDU
Subject: 3584 Tape Library issue (maybe)

I got a weird problem.  This is a shot in the dark, but I'm going to ask
all the kind-folks on the Adsm mailing list a weird question.  Maybe
someone out there will have some ideas.

Please bare in mind that we do have a PMR open with TSM support, a
service
call with IBM Hardware CE's, and with Brocade.

It appears that we've tracked the problem to the 3584's. but not
positive
about that yet.

About every 2-4 days we have to power cycle all the drives, or at least
a
good subset of them, in our 3584 libraries.  Both of the 3584's are four
frames each, and each has 27 LTO2 drives.   The tape SAN consists of two
Brocade M14's. Each drive is plugged into the M14 directly.  (Not into
another edge switch).  We thought that there might be a bad connection
between the two M14's, but we disabled the system boards that were
giving
us some issues in both last week.  Then today the issue happened again.

The TSM Server (library managers) that run the two libraries are both at
v5.2.4, on AIX 5.2 ML4.   There are about 15 TSM library clients that
talk
the respective library managers, as well as somewhere around 50 storage
agents as well.  All are current TSM levels.  We are at the latest
firmware
on all the drives and the libraries as well now.We are at Atape
8.4.9.0
.

Today, when the problem was happening we also (using the 3584's web
interface, so TSM was not involved) wouldn't eject tapes from the
libraries
to empty slots from the tape drives in frame four on one of them.  It
told
me that there weren't any empty slots to put the tape into.  But I could
move the tape from that drive, to drive 1 in frame 1, and then it would
eject it to an empty slot like normal.  It did this with five tapes.

The two things we have done to temp. fix the issue has been:

1. Restarting the TSM library Managers.
2A. Power cycling the drives.  Sometimes just the two drives that are
the
control paths into the library,
2B.  and sometimes it appears to need every drive power cycled.

Since I was having trouble with ejecting tapes earlier and TSM was not
involved in that scenario, I am inclined to think that TSM really isn't
part of the root problem, but that it some how gets confused and needs
to
be restarted at times in order to, shall we say,  clear its head.
Because
it seems to affect the library even when not talking to TSM or AIX, I
don't
think upgrading the Atape driver to whatever 9.X.X.X version is out
there
would fix the problem. But I'm open to arguments that say I'm full of it
there.

Does anybody out there have any ideas?

Thank you,

David N. Reiss
Unix/TSM System Engineer
Caterpillar, Inc.
(309)/494-3749


Re: Emergency! Server will not start

2005-01-19 Thread Steve Schaub
Joni,

In case of emergency:

1. Step back
2. Take a deep breath
3. Reach for the chocolate-covered strawberries!

-Original Message-
From: Joni Moyer [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 18, 2005 3:54 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Emergency! Server will not start


I thank you all for your quick response to my own stupid mistake.  I am
just setting up this new TSM server and I did not extend the recovery
log past the initial use of 4MB.  Thank you again!  Your help is always
appreciated

: )


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 Curtis Stewart
 [EMAIL PROTECTED]
 AWSON.COM
To
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor
cc
 Manager
 [EMAIL PROTECTED]
Subject
 .EDU Re: Emergency!  Server will not
   start

 01/18/2005 03:46
 PM


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






Can you see the file system and directory where you put the logs from
the OS? I think the 4MB is the default amount of log the TSM install
creates in the server/bin directory.

[EMAIL PROTECTED]


ANR2032E messages on 'DEF CLIENTACTION'

2005-01-19 Thread Paul Van De Vijver
Hi,

The last weeks I got several ANR2032E messages on 'DEF CLIENTACTION'
commands
This happens sometimes 1 time a night, sometimes up to 5 times a night
always for different clients.
See extraction server log below :

15.01.2005 07:15:19 ANR2017I Administrator BATCH issued command: DEFINE
CLIENTACTION nodexxx ACTION=INCREMENTAL (SESSION: 28508)
15.01.2005 07:15:24 ANR2032E DEFINE CLIENTACTION: Command failed -
internal
server error detected. (SESSION: 28508)
15.01.2005 07:15:24 ANR2505I 0 schedules were defined for DEFINE
CLIENTACTION.
(SESSION: 28508)

TSM Server version 5.2.3.3 running on Z/OS 1.4

Thanks for any info

Paul Van de Vijver
Honda Europe NV
Belgium




The information contained in this communication is confidential and may be 
legally privileged. It is intended solely for the use of the individual or the 
entity to whom it is addressed and others authorised to receive it. If you have 
received it by mistake, please let the sender know by e-mail reply and delete 
it from your system.
If you are not the intended recipient you are hereby notified that any 
disclosure, copying, distribution or taking any action in reliance of the 
contents of this information is strictly prohibited and may be unlawful.
Honda Europe NV is neither liable for the proper and complete transmission of 
the information contained in this communication nor for any delay in its 
receipt.


Re: select statement: help!

2005-01-19 Thread Joni Moyer
Hey!

I have one other simple question.  Is there a way that the output of this
select statement will be able to go on one line so that it isn't so hard to
read?  The output currently looks like this, but I would rather have it all
fit on one line.  Thanks!

NODE_NAME: VMSNW05
  DATE: 2005-01-18
  ACTIVITY: BACKUP
 START: 10:31:15
   END: 12:05:51
 MEGABYTES: 12
 FILES: 140
SUCCESSFUL: NO


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 Andrew Raibeck
 [EMAIL PROTECTED]
 OMTo
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor  cc
 Manager
 [EMAIL PROTECTED] Subject
 .EDU Re: select statement: help!


 01/18/2005 12:42
 PM


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






Maybe something like:

select entity as node_name, date(start_time) as date, cast(activity as -
varchar(10)) as activity, time(start_time) as start, time(end_time) as
end, -
cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as -
decimal(7,0)) as files, successful -
from summary -
  where date(start_time) date(current_timestamp - 1 day) -
  and (entity like 'HM%' or entity like 'GEO%') -
  order by successful

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.

ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/18/2005
10:33:11:

 Hello All!

 I have been trying, what seems like forever, to get this select
statement
 to work and I am just not sure what I am doing wrong... Any suggestions?
 I
 am trying to get a list of the backups of all of the servers that begin
 with hm* and geo* within the past 24 hours and if they were successful,
 missed or failed.  Thank you in advance!  Here is what I have so far,
but
 it doesn't seem to work:

 select entity as node_name, date(start_time) as date, cast(activity as
 varchar(10)) as activity, time(start_time) as start, time(end_time) as
end,
 cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as
 decimal(7,0)) as files, successful
 from summary
   where date(start_time)  current_timestamp - 1 day
   and entity like 'hm*,geo*'
group by entity
   order by successful

 
 Joni Moyer
 Highmark
 Storage Systems
 Work:(717)302-6603
 Fax:(717)302-5974
 [EMAIL PROTECTED]
 


Re: select statement: help!

2005-01-19 Thread PAC Brion Arnaud
Joni,

Maybe this http://msgs.adsm.org/cgi-bin/get/adsm0109/730.html will help
you !
Cheers. 


Arnaud 


**
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]

**

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Wednesday, 19 January, 2005 14:00
To: ADSM-L@VM.MARIST.EDU
Subject: Re: select statement: help!

Hey!

I have one other simple question.  Is there a way that the output of
this select statement will be able to go on one line so that it isn't so
hard to read?  The output currently looks like this, but I would rather
have it all fit on one line.  Thanks!

NODE_NAME: VMSNW05
  DATE: 2005-01-18
  ACTIVITY: BACKUP
 START: 10:31:15
   END: 12:05:51
 MEGABYTES: 12
 FILES: 140
SUCCESSFUL: NO


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 Andrew Raibeck
 [EMAIL PROTECTED]
 OM
To
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor
cc
 Manager
 [EMAIL PROTECTED]
Subject
 .EDU Re: select statement: help!


 01/18/2005 12:42
 PM


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






Maybe something like:

select entity as node_name, date(start_time) as date, cast(activity as -
varchar(10)) as activity, time(start_time) as start, time(end_time) as
end, -
cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as -
decimal(7,0)) as files, successful -
from summary -
  where date(start_time) date(current_timestamp - 1 day) -
  and (entity like 'HM%' or entity like 'GEO%') -
  order by successful

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew
Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.

ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/18/2005
10:33:11:

 Hello All!

 I have been trying, what seems like forever, to get this select
statement
 to work and I am just not sure what I am doing wrong... Any
suggestions?
 I
 am trying to get a list of the backups of all of the servers that 
 begin with hm* and geo* within the past 24 hours and if they were 
 successful, missed or failed.  Thank you in advance!  Here is what I 
 have so far,
but
 it doesn't seem to work:

 select entity as node_name, date(start_time) as date, cast(activity as
 varchar(10)) as activity, time(start_time) as start, time(end_time) as
end,
 cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as
 decimal(7,0)) as files, successful
 from summary
   where date(start_time)  current_timestamp - 1 day
   and entity like 'hm*,geo*'
group by entity
   order by successful

 
 Joni Moyer
 Highmark
 Storage Systems
 Work:(717)302-6603
 Fax:(717)302-5974
 [EMAIL PROTECTED]
 


Re: select statement: help!

2005-01-19 Thread Richard Sims
On Jan 19, 2005, at 8:00 AM, Joni Moyer wrote:
I have one other simple question.  Is there a way that the output of
this
select statement will be able to go on one line ...
See my notes in http://people.bu.edu/rbs/ADSM.QuickFacts topic SELECT
output, columnar instead of keyword list.
   Richard Sims


Re: select statement: help!

2005-01-19 Thread Joni Moyer
Hello,

I went out and tried the following:

dsmadmc -servername=server -displaymode=table select statement and it
didn't work.  Do you have to put the statement within single quotes?
Thanks!


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 PAC Brion
 Arnaud
 [EMAIL PROTECTED]  To
 ALPINA.COM   ADSM-L@VM.MARIST.EDU
 Sent by: ADSM:cc
 Dist Stor
 Manager  Subject
 [EMAIL PROTECTED] Re: select statement: help!
 .EDU


 01/19/2005 08:16
 AM


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






Joni,

Maybe this http://msgs.adsm.org/cgi-bin/get/adsm0109/730.html will help
you !
Cheers.


Arnaud


**
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]

**

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Wednesday, 19 January, 2005 14:00
To: ADSM-L@VM.MARIST.EDU
Subject: Re: select statement: help!

Hey!

I have one other simple question.  Is there a way that the output of
this select statement will be able to go on one line so that it isn't so
hard to read?  The output currently looks like this, but I would rather
have it all fit on one line.  Thanks!

NODE_NAME: VMSNW05
  DATE: 2005-01-18
  ACTIVITY: BACKUP
 START: 10:31:15
   END: 12:05:51
 MEGABYTES: 12
 FILES: 140
SUCCESSFUL: NO


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 Andrew Raibeck
 [EMAIL PROTECTED]
 OM
To
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor
cc
 Manager
 [EMAIL PROTECTED]
Subject
 .EDU Re: select statement: help!


 01/18/2005 12:42
 PM


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






Maybe something like:

select entity as node_name, date(start_time) as date, cast(activity as -
varchar(10)) as activity, time(start_time) as start, time(end_time) as
end, -
cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as -
decimal(7,0)) as files, successful -
from summary -
  where date(start_time) date(current_timestamp - 1 day) -
  and (entity like 'HM%' or entity like 'GEO%') -
  order by successful

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew
Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.

ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/18/2005
10:33:11:

 Hello All!

 I have been trying, what seems like forever, to get this select
statement
 to work and I am just not sure what I am doing wrong... Any
suggestions?
 I
 am trying to get a list of the backups of all of the servers that
 begin with hm* and geo* within the past 24 hours and if they were
 successful, missed or failed.  Thank you in advance!  Here is what I
 have so far,
but
 it doesn't seem to work:

 select entity as node_name, date(start_time) as date, cast(activity as
 varchar(10)) as activity, time(start_time) as start, time(end_time) as
end,
 cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as
 decimal(7,0)) as files, successful
 from summary
   where date(start_time)  current_timestamp - 1 day
   and entity like 'hm*,geo*'
group by entity
   order by successful

 
 Joni Moyer
 Highmark
 Storage Systems
 Work:(717)302-6603
 Fax:(717)302-5974
 [EMAIL PROTECTED]
 


Re: select statement: help!

2005-01-19 Thread Eivind Birkeland
Hi.
Use -tabdelimited to get selectresult on one line with TAB between each
column.
See this example:

[EMAIL PROTECTED] tmp]# dsmadmc -server=  -id=  -password=
-tabdelimited andycap:select '*' from libraries
IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 2, Level 3.0
(c) Copyright by IBM Corporation and other(s) 1990, 2004. All Rights
Reserved.

Session established with server DSM0B: AIX-RS/6000
  Server Version 5, Release 1, Level 9.3
  Server date/time: 19-01-2005 14:58:45  Last access: 19-01-2005 14:50:01

ANS8000I Server command: ':select * from libraries'
ANR1699I Resolved  to 1 server(s) - issuing command SELECT  against
server(s).
ANR1687I Output for command 'SELECT ' issued against server  follows:
ACS_9940B   ACSLS   0   NO
OOF  2004-07-19 13:11:08.00
ANR1688I Output for command 'SELECT ' issued against server  completed.
ANR1694I Server  processed command 'SELECT ' and completed
successfully.
ANR1697I Command 'SELECT ' processed by 1 server(s):  1 successful, 0 with
warnings, and 0 with errors.

ANS8002I Highest return code was 0.
|-+-|
| | |
|  Eivind Birkeland   |  E-mail: [EMAIL PROTECTED]   |
|  Unix/DBA Manager   |  Phone: +47 55 14 00 00 / 22 51 |
|  Statoil Norway |  Mobile: +47 907 76 942 |
| | |
|-+-|






Joni Moyer
[EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU
HMARK.COM cc: (bcc: Eivind Birkeland)
Sent by: ADSM:Subject: Re: select statement: 
help!
Dist Stor
Manager
[EMAIL PROTECTED]
ST.EDU


19.01.2005
14:54
Please respond
to ADSM: Dist
Stor Manager






Hello,

I went out and tried the following:

dsmadmc -servername=server -displaymode=table select statement and it
didn't work.  Do you have to put the statement within single quotes?
Thanks!


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 PAC Brion
 Arnaud
 [EMAIL PROTECTED]  To
 ALPINA.COM   ADSM-L@VM.MARIST.EDU
 Sent by: ADSM:cc
 Dist Stor
 Manager  Subject
 [EMAIL PROTECTED] Re: select statement: help!
 .EDU


 01/19/2005 08:16
 AM


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






Joni,

Maybe this http://msgs.adsm.org/cgi-bin/get/adsm0109/730.html will help
you !
Cheers.


Arnaud


**
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]

**

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Wednesday, 19 January, 2005 14:00
To: ADSM-L@VM.MARIST.EDU
Subject: Re: select statement: help!

Hey!

I have one other simple question.  Is there a way that the output of
this select statement will be able to go on one line so that it isn't so
hard to read?  The output currently looks like this, but I would rather
have it all fit on one line.  Thanks!

NODE_NAME: VMSNW05
  DATE: 2005-01-18
  ACTIVITY: BACKUP
 START: 10:31:15
   END: 12:05:51
 MEGABYTES: 12
 FILES: 140
SUCCESSFUL: NO


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 Andrew Raibeck
 [EMAIL PROTECTED]
 OM
To
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor
cc
 Manager
 [EMAIL PROTECTED]
Subject
 .EDU Re: select statement: help!


 01/18/2005 12:42
 PM


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






Maybe something like:

select entity 

Re: yasq (yet another sql question . . . . )

2005-01-19 Thread Rejean Larivee
Hello,
add the -noconfirm option and that should take care of it, i.e,

# dsmadmc -server=andy -id=X -password=X -noconfirm EOD
 ...etc

Bye

Rejean Larivee
IBM Tivoli Storage Manager support




 Eivind Birkeland
 [EMAIL PROTECTED]
   To
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor  cc
 Manager
 [EMAIL PROTECTED] Subject
 .EDU Re: yasq (yet another sql question
   . . . . )

 01/19/2005 03:19
 AM


 Please respond to
 ADSM: Dist Stor
 Manager






Hi.
Think the problem is in TSM!
Se my examples:
FIRST I run the command against a smal TSM-server (andy), with OK result:
--

# dsmadmc -server=andy -id=X -password=X  EOD
 select A.node_name, B.domain_name, -
 sum(A.num_files), -
 sum(A.physical_mb), -
 sum(A.logical_mb) -
  from occupancy A, nodes B where A.node_name = B.node_name group by
A.node_name, B.domain_name
 EOD
IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 2, Level 2.0
(c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights
Reserved.

Session established with server ANDY: AIX-RS/6000
  Server Version 5, Release 1, Level 9.3
  Server date/time: 19-01-2005 08:02:20  Last access: 19-01-2005 07:53:02

ANDYUNIX-BE 7609490 876766.53   872574.98
BELNDIMSS01 NT-BE   32582   8675.70 8250.80
:
:
TRAMPE  UNIX-BE 147704  10894.7210574.58

ANS8002I Highest return code was 0.

#
--


THEN I try the same command on a large TSM-server (andycap), with the same
error as you got.
BUT I sendt the output to a file (outfile) and the it is clear what is
happening.
The contents of the outfile is:
--

IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 2, Level 2.0
(c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights
Reserved.

Session established with server ANDYCAP: AIX-RS/6000
  Server Version 5, Release 1, Level 9.3
  Server date/time: 19-01-2005 08:09:38  Last access: 19-01-2005 08:03:36

ANR2963W This SQL query may produce a very large result table, or may
require a significant amount of time to compute.

Do you wish to proceed? (Yes (Y)/No (N)) The only valid responses are
characters from this set: [Y, N]
The character '#' stands for any decimal integer.The only valid responses
are characters from this set: [Y, N]
The character '#' stands for any decimal integer.The only valid responses
are characters from this set: [Y, N]
The character '#' stands for any decimal integer.The only valid responses
are characters from this set: [Y, N]
:
:
: (this goes on forever.)
--

TSM think it is in an interactiv session and is asking you if you want to
execute this large select.
And due to no or wrong respons it gives the error-message and try once
more!!! Forever!
Try to give an other answer to the question in an interactiv session and
you get the same respons from TSM.

So, as I sad, the problem is TSM and bad handling of the EOD type of
input.
Put the sql-command on a file and use the macro filename instead.





Prather, Wanda
[EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU
HUAPL.EDU  cc: (bcc: Eivind Birkeland)
Sent by: ADSM: Subject: Re: yasq (yet
another sql question . . . . )
Dist Stor
Manager
[EMAIL PROTECTED]
T.EDU


18.01.2005 17:47
Please respond
to ADSM: Dist
Stor Manager






I don't think it is an SQL question.  The SELECT works just fine as is
when I run it as a TSM script.

I think your problem is something to do with extraneous characters,
character set, or with stdin on the host, not with TSM SQL.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Rhodes
Sent: Tuesday, January 18, 2005 11:35 AM
To: ADSM-L@VM.MARIST.EDU
Subject: yasq (yet another sql question . . . . )


Hi Everyone . . .

I'm trying to do a couple things . . . .

1)  Trying to get a listing as follows, where the occupancy filespace
stats are sum'ed for each node, with the 

IBM 3595 tape library on Linux

2005-01-19 Thread Verhelst, Luc
Hi,

We are asked to install a IBM 3590 tapedrive on a linux system with TSM.
SuSE Linux Enterprise Server 8.
TSM version 5.2.3

Has anyone of you ever done this?

Regards,

Luc

Managed Services Unix
Minervastraat 7
B-1930 Zaventem
Phone: +32 (0)2 712 27 66
GSM: +32 (0)474 98 24 25
e-mail: [EMAIL PROTECTED]

Disclaimer: 
This electronic transmission and any files attached to it are strictly 
confidential and intended solely for the addressee. If you are not 
the intended addressee, you must not disclose, copy or take any
action in reliance of this transmission. If you have received this 
transmission in error, please notify the sender by return and delete
the transmission.  Although the sender endeavors to maintain a
computer virus free network, the sender does not warrant that this
transmission is virus-free and will not be liable for any damages 
resulting from any virus transmitted. 
Thank You.



Re: select statement: help!

2005-01-19 Thread PAC Brion Arnaud
Joni,

I usually use single quotes, but have some scrits where double quotes
are used, all without problem !
This an example of the scripts we're using :

CMD=dsmadmc -id=xxx -password=xxx -datao=yes
$CMD select process_num from processes where process='Backup Storage
Pool'

Note the -datao=yes parameter, which avoids having TSM header in your
output (works with TSM version  5.2)

Hope this helped !  


Arnaud 


**
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]

**

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Wednesday, 19 January, 2005 14:55
To: ADSM-L@VM.MARIST.EDU
Subject: Re: select statement: help!

Hello,

I went out and tried the following:

dsmadmc -servername=server -displaymode=table select statement and it
didn't work.  Do you have to put the statement within single quotes?
Thanks!


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 PAC Brion
 Arnaud
 [EMAIL PROTECTED]
To
 ALPINA.COM   ADSM-L@VM.MARIST.EDU
 Sent by: ADSM:
cc
 Dist Stor
 Manager
Subject
 [EMAIL PROTECTED] Re: select statement: help!
 .EDU


 01/19/2005 08:16
 AM


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






Joni,

Maybe this http://msgs.adsm.org/cgi-bin/get/adsm0109/730.html will help
you !
Cheers.


Arnaud


**
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]

**

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Wednesday, 19 January, 2005 14:00
To: ADSM-L@VM.MARIST.EDU
Subject: Re: select statement: help!

Hey!

I have one other simple question.  Is there a way that the output of
this select statement will be able to go on one line so that it isn't so
hard to read?  The output currently looks like this, but I would rather
have it all fit on one line.  Thanks!

NODE_NAME: VMSNW05
  DATE: 2005-01-18
  ACTIVITY: BACKUP
 START: 10:31:15
   END: 12:05:51
 MEGABYTES: 12
 FILES: 140
SUCCESSFUL: NO


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 Andrew Raibeck
 [EMAIL PROTECTED]
 OM
To
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor
cc
 Manager
 [EMAIL PROTECTED]
Subject
 .EDU Re: select statement: help!


 01/18/2005 12:42
 PM


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






Maybe something like:

select entity as node_name, date(start_time) as date, cast(activity as -
varchar(10)) as activity, time(start_time) as start, time(end_time) as
end, -
cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as -
decimal(7,0)) as files, successful -
from summary -
  where date(start_time) date(current_timestamp - 1 day) -
  and (entity like 'HM%' or entity like 'GEO%') -
  order by successful

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew
Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.

ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/18/2005
10:33:11:

 Hello All!

 I have been trying, what seems like forever, to get this select
statement
 to work and I am just not sure what I am doing wrong... Any
suggestions?
 I
 am trying to get a list of the backups of all of the servers that 
 begin with hm* and geo* within the past 24 hours and if they were 
 successful, missed or failed.  Thank you in advance!  Here is what I 
 have so far,
but
 it doesn't seem to work:

 select entity as node_name, date(start_time) as date, cast(activity as
 varchar(10)) as activity, time(start_time) as start, time(end_time) as
end,
 cast(bytes/1024/1024 

Re: Create TSM service

2005-01-19 Thread Stapleton, Mark
Installing the TSM server application will create the service. If you're
installing the software properly, you shouldn't have to create the
server service.

--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627  

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of nghiatd
Sent: Wednesday, January 19, 2005 3:32 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Create TSM service

Thank for your help,
But I want to create service for TSM server, not scheduler.
Because I can't create service for TSM server starting when I 
try to recover TSM server

- Original Message -
From: Gokhan YILDIRIM [EMAIL PROTECTED]
To: ADSM-L@VM.MARIST.EDU
Sent: Wednesday, January 19, 2005 3:42 PM
Subject: Re: Create TSM service


dsmcutil inst /name:TSM Client Scheduler /node:  
/password:xxx /autostart:yes /clientdir:c:\Tivoli\TSM\baclient
/optfile:c:\Tivoli\TSM\baclient\dsm.opt /startnow:no

Best Regards,
Gvkhan YILDIRIM

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of nghiatd
Sent: Wednesday, January 19, 2005 4:04 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Create TSM service

Does anyone know to create TSMserver service in Win2K by command ?

This message and attachments are confidential and intended 
solely for the
individual(s) stated in this
message.If you received this message although you are not the 
addressee you are responsible to keep the message confidential 
.The sender has no responsibility for the accuracy or 
correctness of the information in the message and its 
attachments.Our company shall have no liability for any 
changes or late receiving,loss of integrity and 
confidentiality,viruses and any damages caused in anyway to 
your computer system.

Bu mesaj ve ekleri mesajda gonderildigi belirtilen 
kisi/kisilere ozeldir ve gizlidir.Bu mesajin muhatabi 
olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj 
iceriginin gizliligi ve bu gizlilik yukumlulugune uyulmasi 
zorunlulugu tarafiniz icin de soz konusudur.Mesaj ve eklerinde 
yer alan bilgilerin dogrulugu ve guncelligi konusunda 
gonderenin ya da sirketimizin herhangi bir sorumlulugu 
bulunmamaktadir.Sirketimiz mesajin ve bilgilerinin size 
degisiklige ugrayarak veya gec ulasmasindan, butunlugunun ve 
gizliliginin korunamamasindan, virus icermesinden ve 
bilgisayar sisteminize verebilecegi herhangi bir zarardan 
sorumlu tutulamaz.



Re: Create TSM service

2005-01-19 Thread Prather, Wanda
Start the TSM management console, expand the tree in the left pane.
At the bottom of the list, start WIZARDS.
The SERVICE CONFIGURATION wizard installs the TSM server service.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
nghiatd
Sent: Wednesday, January 19, 2005 4:32 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Create TSM service


Thank for your help,
But I want to create service for TSM server, not scheduler.
Because I can't create service for TSM server starting when I try to
recover
TSM server

- Original Message -
From: Gokhan YILDIRIM [EMAIL PROTECTED]
To: ADSM-L@VM.MARIST.EDU
Sent: Wednesday, January 19, 2005 3:42 PM
Subject: Re: Create TSM service


dsmcutil inst /name:TSM Client Scheduler /node:  /password:xxx
/autostart:yes /clientdir:c:\Tivoli\TSM\baclient
/optfile:c:\Tivoli\TSM\baclient\dsm.opt /startnow:no

Best Regards,
Gvkhan YILDIRIM

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
nghiatd
Sent: Wednesday, January 19, 2005 4:04 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Create TSM service

Does anyone know to create TSMserver service in Win2K by command ?

This message and attachments are confidential and intended solely for
the
individual(s) stated in this
message.If you received this message although you are not the addressee
you
are responsible to keep the
message confidential .The sender has no responsibility for the accuracy
or
correctness of the
information in the message and its attachments.Our company shall have no
liability for any changes
or late receiving,loss of integrity and confidentiality,viruses and any
damages caused in
anyway to your computer system.

Bu mesaj ve ekleri mesajda gonderildigi belirtilen kisi/kisilere ozeldir
ve
gizlidir.Bu mesajin muhatabi
olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj iceriginin
gizliligi ve bu gizlilik yukumlulugune
uyulmasi zorunlulugu tarafiniz icin de soz konusudur.Mesaj ve eklerinde
yer
alan bilgilerin dogrulugu ve
guncelligi konusunda gonderenin ya da sirketimizin herhangi bir
sorumlulugu
bulunmamaktadir.Sirketimiz
mesajin ve bilgilerinin size degisiklige ugrayarak veya gec
ulasmasindan,
butunlugunun ve gizliliginin
korunamamasindan, virus icermesinden ve bilgisayar sisteminize
verebilecegi
herhangi bir zarardan
sorumlu tutulamaz.


Few questions about TSM and Solaris

2005-01-19 Thread Chernyaev Sergey
Hello!

Environment: TSM 5.2.2.0 on SunOS 5.9 

Questions:
1. How I can start or restart TSM? On Linux I'm use service dsmserv
restart for example. On Solaris was runned script named addtoinit
from TSM directory.
2. Periodically I can't connect to TSM through web-interface or admin
command-line. But dsmserv is runned on server. No errors in dsmserv.err
or in actlog. Any ideas?

Thanks


Something wierd

2005-01-19 Thread Mike
Executing dsmadmc 'q files image_db2 /ARCHIVE f=d' I get this:

ANS8000I Server command: 'q files image_db2 /ARCHIVE f=d'

  Node Name: IMAGE_DB2
 Filespace Name: /ARCHIVE
 Hexadecimal Filespace Name:
   FSID: 1
   Platform: DB2/6000
 Filespace Type: API:DB2/6000
  Is Filespace Unicode?: No
  Capacity (MB): 1,892,039,070,937.9
   Pct Util: 100.0
Last Backup Start Date/Time:
 Days Since Last Backup Started:
   Last Backup Completion Date/Time:
   Days Since Last Backup Completed:
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:


ANS8002I Highest return code was 0.

This server hosts OnDemand that has it's own TSM, DB/2, etc.,
and talks to an optical jukebox. I realize this filespace is
(it looks like anyway) a TDP since it says API:DB2. I know my
tape library is no where this large and there are no backup
dates.

Is there some way to really see what is stored in this filespace?

This looks like a 'bad thing'.

Mike


Re: Move media for backupsets?

2005-01-19 Thread Prather, Wanda
I think you are correct.

If this is a frequent problem for you, Autovault from coderelief.com
supports ejection/vaulting of Backupsets.

Wanda Prather
I/O, I/O, It's all about I/O  -(me)


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Tab Trepagnier
Sent: Tuesday, January 18, 2005 5:48 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Move media for backupsets?


TSM 5.1.9.0

Is there some command(s) that would allow sequential, one-step
processing
of backupset volumes similar to the operation of the Move Media command
for storage pools?

For example, Move Media will check out the library volume, alter its
access to read-only, set its location to the Overflow Location, and
eject
the volume from the library with just one command.  And it will process
all relevant volumes if * is given as the volume name.  So if you have
a
dozen storage pool volumes to eject, one command processes all 12 tapes
in
order.  You just collect them from the library and Reply when each is
removed from the library's I/O slot.  Simple.

If those same 12 tapes are part of a Backupset, as far as I can tell,
you
must check out each tape individually, update its Location field
individually, etc.  That's 24 commands for a Backupset where just one is
needed for a storage pool.

Or am I missing something?

Thanks in advance.

Tab Trepagnier
TSM Administrator
Laitram, L.L.C.


Re: Something wierd

2005-01-19 Thread Prather, Wanda
It's a non-issue.
Capacity is the reported capacity of the drive/filesystem; I don't
even know if it is reported accurately for a TDP filespace.
Could be the total TB capacity of your optical jukebox, dunno.
You can't tell whether there is actually that much data on the
filesystem, or not - it's just what the OS reports as the drive size.
 
(And backup dates may or may not be reported to TSM by a TDP.)

To see the total that is BACKED UP to your TSM server for this
filesystem, enter:  q occ IMAGE_DB2 


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Mike
Sent: Wednesday, January 19, 2005 11:06 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Something wierd


Executing dsmadmc 'q files image_db2 /ARCHIVE f=d' I get this:

ANS8000I Server command: 'q files image_db2 /ARCHIVE f=d'

  Node Name: IMAGE_DB2
 Filespace Name: /ARCHIVE
 Hexadecimal Filespace Name:
   FSID: 1
   Platform: DB2/6000
 Filespace Type: API:DB2/6000
  Is Filespace Unicode?: No
  Capacity (MB): 1,892,039,070,937.9
   Pct Util: 100.0
Last Backup Start Date/Time:
 Days Since Last Backup Started:
   Last Backup Completion Date/Time:
   Days Since Last Backup Completed:
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:


ANS8002I Highest return code was 0.

This server hosts OnDemand that has it's own TSM, DB/2, etc.,
and talks to an optical jukebox. I realize this filespace is
(it looks like anyway) a TDP since it says API:DB2. I know my
tape library is no where this large and there are no backup
dates.

Is there some way to really see what is stored in this filespace?

This looks like a 'bad thing'.

Mike


Re: Backing up SYSTEMOBJECT on Win2K machines

2005-01-19 Thread Prather, Wanda
Thanks for the info.
At least that is a bit of progress...

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
TSM_User
Sent: Tuesday, January 18, 2005 7:31 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Backing up SYSTEMOBJECT on Win2K machines


With Windows 2003 it will backup the entire system32 folder during the
system state backup of any file in it changes.  However, if no files
change under system32 then it will not back it up.  So it is somewhat
incremental but not a true incremental where only the files that changed
are backed up.

Prather, Wanda [EMAIL PROTECTED] wrote:..seems like the DB is
growing faster than it use to and I'd like to
prevent rapid growth once the others are included.
It's my understanding that all of the SYSTEMOBJECT files are backed up
with every backup(incremental).

 Yes, that is true. Until you get to Win2003, then I believe
it is supposed to be a true incremental of those files, but I haven't
verified that.

Is it more efficient/better to have ntbackup backup the SYSTEMOBJECT to
a file before the TSM backup, then have TSM backup this file nightly
with the regular TSM backup?

 Many people do that. It means only 1 file gets backed up by
TSM, therefore the impact on your DB is less.

Is there any problem with recovery of the machine using this
method(ntbackup then TSM)?

No.

Is there any advantages/disadvantages to using this method?

Advantages:
Less impact on your TSM DB
I have never run into this, but if your restore fails, you only
have Microsoft to deal with, no finger pointing since only Microsoft
tolls are involved.
Disadvantages:
How are you going to verify that it is working? You have
to visit each machine and set up a scheduled task to do the ntbackup.
If the ntbackup piece fails, TSM isn't going to be able to tell you.
Also, you have to train OTHER people in your shop on how to do
the 2-step restore if you aren't around; restore the flat file
from TSM, then do the ntrestore

Generally how many files does the SYSTEMOBJECT backup contain?
 Depending on the machine, 1800-2000

FWIW:
Here's what I would suggest as the easiest solution. You are
keeping your client backups for 90 days, but I persionally would never
want to restore a Windows registry that is 90 days old!

You can assign the SYSTEMOBJECT to a different management
class than the other files. (Look in the TSM for Windows client manual
for INCLUDE SYSTEMOBJECT ALL). So create a management class that only
keeps 14, or even 30 days worth of your SYSTEMOBJECT backups, while
retaining other stuff for 90 days. That requires changes nowhere but in
the TSM Server, and greatly limits the growth of the SYSTEMOBJECT files
in your TSM DB.

Wanda Prather
I/O, I/O, It's all about I/O -(me)




-
Do you Yahoo!?
 All your favorites on one personal page  Try My Yahoo!


Re: Move media for backupsets?

2005-01-19 Thread Tab Trepagnier
Wanda,

Thanks for the info.  I'll look into adding that to our system.  Managing
backupset volumes is a pain without some extra help.

Tab


ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/19/2005
10:09:49 AM:

 I think you are correct.

 If this is a frequent problem for you, Autovault from coderelief.com
 supports ejection/vaulting of Backupsets.

 Wanda Prather
 I/O, I/O, It's all about I/O  -(me)


 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
 Tab Trepagnier
 Sent: Tuesday, January 18, 2005 5:48 PM
 To: ADSM-L@VM.MARIST.EDU
 Subject: Move media for backupsets?


 TSM 5.1.9.0

 Is there some command(s) that would allow sequential, one-step
 processing
 of backupset volumes similar to the operation of the Move Media command
 for storage pools?

 For example, Move Media will check out the library volume, alter its
 access to read-only, set its location to the Overflow Location, and
 eject
 the volume from the library with just one command.  And it will process
 all relevant volumes if * is given as the volume name.  So if you have
 a
 dozen storage pool volumes to eject, one command processes all 12 tapes
 in
 order.  You just collect them from the library and Reply when each is
 removed from the library's I/O slot.  Simple.

 If those same 12 tapes are part of a Backupset, as far as I can tell,
 you
 must check out each tape individually, update its Location field
 individually, etc.  That's 24 commands for a Backupset where just one is
 needed for a storage pool.

 Or am I missing something?

 Thanks in advance.

 Tab Trepagnier
 TSM Administrator
 Laitram, L.L.C.


Steps in backups

2005-01-19 Thread Luc Beaudoin
Hi all

I'm a bit confuse 

I'm working on my disaster plan ... for my TSM server (on a win2K)

I know that I need to backup ... volhistory, devconfig and TSM DB
Is there an order to do it to make sure the restore on a TSM server work
good ..

Is there a procedure or a best way to make those backups
Is there a best practice for that ...

Thanks

Luc


Re: select statement: help!

2005-01-19 Thread Andrew Raibeck
Joni,

The -displaymode=table option should give you the desired format (that is
the specific purpose of this option).

Your note suggests you omitted the -ID and -PASSWORD options.

It would help if you would post (via copy  paste) the actual command you
issued along with the results, so we can see what you are seeing.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.

ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-01-19
06:54:49:

 Hello,

 I went out and tried the following:

 dsmadmc -servername=server -displaymode=table select statement and it
 didn't work.  Do you have to put the statement within single quotes?
 Thanks!

 
 Joni Moyer
 Highmark
 Storage Systems
 Work:(717)302-6603
 Fax:(717)302-5974
 [EMAIL PROTECTED]
 



  PAC Brion
  Arnaud
  [EMAIL PROTECTED] To
  ALPINA.COM   ADSM-L@VM.MARIST.EDU
  Sent by: ADSM: cc
  Dist Stor
  Manager Subject
  [EMAIL PROTECTED] Re: select statement: help!
  .EDU


  01/19/2005 08:16
  AM


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






 Joni,

 Maybe this http://msgs.adsm.org/cgi-bin/get/adsm0109/730.html will help
 you !
 Cheers.


 Arnaud

 
 **
 Panalpina Management Ltd., Basle, Switzerland, CIT Department
 Viadukstrasse 42, P.O. Box 4002 Basel/CH
 Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
 Direct: +41 (61) 226 19 78
 e-mail: [EMAIL PROTECTED]
 
 **

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
 Joni Moyer
 Sent: Wednesday, 19 January, 2005 14:00
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: select statement: help!

 Hey!

 I have one other simple question.  Is there a way that the output of
 this select statement will be able to go on one line so that it isn't so
 hard to read?  The output currently looks like this, but I would rather
 have it all fit on one line.  Thanks!

 NODE_NAME: VMSNW05
   DATE: 2005-01-18
   ACTIVITY: BACKUP
  START: 10:31:15
END: 12:05:51
  MEGABYTES: 12
  FILES: 140
 SUCCESSFUL: NO

 
 Joni Moyer
 Highmark
 Storage Systems
 Work:(717)302-6603
 Fax:(717)302-5974
 [EMAIL PROTECTED]
 



  Andrew Raibeck
  [EMAIL PROTECTED]
  OM
 To
  Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
  Dist Stor
 cc
  Manager
  [EMAIL PROTECTED]
 Subject
  .EDU Re: select statement: help!


  01/18/2005 12:42
  PM


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






 Maybe something like:

 select entity as node_name, date(start_time) as date, cast(activity as -
 varchar(10)) as activity, time(start_time) as start, time(end_time) as
 end, -
 cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as -
 decimal(7,0)) as files, successful -
 from summary -
   where date(start_time) date(current_timestamp - 1 day) -
   and (entity like 'HM%' or entity like 'GEO%') -
   order by successful

 Andy Raibeck
 IBM Software Group
 Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew
 Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED]

 The only dumb question is the one that goes unasked.
 The command line is your friend.
 Good enough is the enemy of excellence.

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/18/2005
 10:33:11:

  Hello All!
 
  I have been trying, what seems like forever, to get this select
 statement
  to work and I am just not sure what I am doing wrong... Any
 suggestions?
  I
  am trying to get a list of the backups of all of the servers that
  begin with hm* and geo* within the past 24 hours and if they were
  successful, missed or failed.  Thank you in advance!  Here is what I
  have so far,
 but
  it doesn't seem to work:
 
  select entity as node_name, date(start_time) as date, cast(activity as
  varchar(10)) as activity, time(start_time) as start, time(end_time) as
 end,
  cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as
  decimal(7,0)) as files, successful
  from summary
where date(start_time)  current_timestamp - 

Deleting AFS backups on TSM when using afsbutc

2005-01-19 Thread Jones, Eric J
Good morning.
This is all kind of new to me.
We use to backup our AFS volumes with afsbuta(had client node called afsbuta) 
and the backups ran a full every 12 weeks and incremental in between.  In TSM I 
would see a dump ID for each of the backups(in filespace) and when it came time 
to delete them I could just go into the node in TSM, click on File Space 
Name, see all the backup(dump ID's) and delete the ones I wanted to delete.  
With afsbutc which they started to use for our AFS backups I do not see the 
dump ID's for each of the backups, I only see 1 filespace which contains all 
the backups done so far.
My question is how does the data get removed from the TSM server when the dump 
id is deleted in AFS.
Is there some way to do it in AFS with deleted dumpid  so it deletes 
it from AFS and TSM.
I want to make sure we don't just delete the dump id's from AFS.
We are running on AIX 5.2 TSM 5.2.2 and we now running at AFS 3.6 patch 9

Thanks for all the help,
Have a Great Day,
Eric


Controlling the nic/IP selection of multi-homed AIX TSM server

2005-01-19 Thread Zoltan Forray/AC/VCU
TSM AIX server - 5.2.3.5

I think I know the answer to this question, but I figured maybe  good
discussion might evoke some thought on the subject.

Our primary TSM AIX server has 2-nic/addresses.an internal 192.168.x
for GIG-E speed on local boxes, and an external 128.172.x for outside the
data center access.

We have some TSM clients that are tightly locked down, complete with
static routes, etc.

The problem (as I understand it) is with the TSM server and how it selects
which IP address to talk to the clients.

On this problematic client (and more to come), when it contacts the TSM
server for the schedule, it uses its internal 192.168.x connection.
However, when the TSM server tries to tap the client to perform the
backup, it uses its 128.172.x nic/address, which the client then refuses
to recognize/accept/connect to.

Is there any way to get the TSM server to contact a client on the same
nic/IP the client used to contact it, from the server perspective.

Any other suggestions would be appreciated.  So far, the only thing we
came up with is to change the client SCHEDMODE to PROMPTED.


Re: Few questions about TSM and Solaris

2005-01-19 Thread Andreas Almroth
Hi,
Chernyaev Sergey wrote:
Hello!
Environment: TSM 5.2.2.0 on SunOS 5.9
Questions:
1. How I can start or restart TSM? On Linux I'm use service dsmserv
restart for example. On Solaris was runned script named addtoinit
from TSM directory.
I removed the entry from inittab and created a rc script in /etc/rc3.d
instead. Use something like;
#!/bin/sh
case $1 in
start)
nohup /usr/bin/dsmserv /dev/null 21  
;;
stop)
pkill dsmserv
;;
*)
echo Usage: $0 {start|stop|restart}
exit 1
;;
esac
pkill is bad, perhaps you should create a batch job and run dsmadmc to
halt the server...
I don't know why the installation bothers with inittab. From SunOS 5.3
to 5.9 the use of rc scripts is the preferred method. In SunOS 5.10 this
changes drastically though.
2. Periodically I can't connect to TSM through web-interface or admin
command-line. But dsmserv is runned on server. No errors in dsmserv.err
or in actlog. Any ideas?
Never seen this though. Proxy browser problems?
Thanks
/Andreas


Re: LTO device class - Can a format type of drive affect media operations ?

2005-01-19 Thread Steven Masters
Hunny; Excellent!! Thanks!

Steve Masters
Manager TSM Device Driver Development
408-256-8936  tieline  8-276-8936
FAX 408-256-9006
[EMAIL PROTECTED]

Quality Policy = Commit to Quality, Customer Satisfaction, Continual
Improvement




Hunny Kershaw/San Jose/[EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
01/18/2005 02:21 PM
Please respond to
ADSM: Dist Stor Manager


To
ADSM-L@VM.MARIST.EDU
cc

Subject
Re: [ADSM-L] LTO device class - Can a format type of drive affect media
operations ?






Martin,

You can use either one -- format=drive or format=ultrium2c. However, if
you
do not want the drive to write with compression, you will need to set
format=ultrium2.

Regards,

Hunny..

ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/13/2005
12:33:48 PM:

 Hi all,
 can a format type of drive in LTO device classs definitionaffect media
 operation, such as label, r/w, etc in a way, that these operations are
 never performed ?

 I mean, is it necessary set LTO-2 drives as ultrium2[c] format in
 devclass definition ?

 --

 S pozdravem / Best Regards,

 Martin Trcka, IT Consultant
 Tech. Support Department
 GC System a.s., Spitalka 41, 60200 Brno, Czech Rep.
 mob: +420 602 452 361
 fax: +420 543 537 333
 email: [EMAIL PROTECTED]


Re: select statement: help!

2005-01-19 Thread Joni Moyer
Hi Andy!

You have a very good point of showing my command.  Without it is kind of
difficult.  Here is the exact command that I am entering (I'm just going to
use admin admin as id and password and x as the servername):

dsmadmc -server=x -id=admin -password=admin -displaymode=table 'select
entity as node_name, date(start_time) as date, -
cast(activity as varchar(10)) as activity, time(start_time) as
start, time(end_time)as end, cast(bytes/1024/1024 as decimal(6,0)) as
megabytes, -
cast(affected as decimal(7,0)) as files, successful -
   from summary
where date(start_time) date(current_timestamp - 1 day) -
and (entity like 'HM%' or entity like 'PAB%' or entity like 'VMS%'
or entity like 'GEOHMKLG%') -
and activity='BACKUP' order by successful'

I've just been entering this on the command-line, so I don't have any -
within the command.  That's when I receive the following:

ksh: 0403-057 Syntax error: `(' is not expected.
/home/lidzr8v (chrs144:lidzr8v)

Do I not need the quotes around the select statement?  Thank you in
advance!


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 Andrew Raibeck
 [EMAIL PROTECTED]
 OMTo
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor  cc
 Manager
 [EMAIL PROTECTED] Subject
 .EDU Re: select statement: help!


 01/19/2005 11:34
 AM


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






Joni,

The -displaymode=table option should give you the desired format (that is
the specific purpose of this option).

Your note suggests you omitted the -ID and -PASSWORD options.

It would help if you would post (via copy  paste) the actual command you
issued along with the results, so we can see what you are seeing.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.

ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-01-19
06:54:49:

 Hello,

 I went out and tried the following:

 dsmadmc -servername=server -displaymode=table select statement and it
 didn't work.  Do you have to put the statement within single quotes?
 Thanks!

 
 Joni Moyer
 Highmark
 Storage Systems
 Work:(717)302-6603
 Fax:(717)302-5974
 [EMAIL PROTECTED]
 



  PAC Brion
  Arnaud
  [EMAIL PROTECTED] To
  ALPINA.COM   ADSM-L@VM.MARIST.EDU
  Sent by: ADSM: cc
  Dist Stor
  Manager Subject
  [EMAIL PROTECTED] Re: select statement: help!
  .EDU


  01/19/2005 08:16
  AM


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






 Joni,

 Maybe this http://msgs.adsm.org/cgi-bin/get/adsm0109/730.html will help
 you !
 Cheers.


 Arnaud

 
 **
 Panalpina Management Ltd., Basle, Switzerland, CIT Department
 Viadukstrasse 42, P.O. Box 4002 Basel/CH
 Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
 Direct: +41 (61) 226 19 78
 e-mail: [EMAIL PROTECTED]
 
 **

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
 Joni Moyer
 Sent: Wednesday, 19 January, 2005 14:00
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: select statement: help!

 Hey!

 I have one other simple question.  Is there a way that the output of
 this select statement will be able to go on one line so that it isn't so
 hard to read?  The output currently looks like this, but I would rather
 have it all fit on one line.  Thanks!

 NODE_NAME: VMSNW05
   DATE: 2005-01-18
   ACTIVITY: BACKUP
  START: 10:31:15
END: 12:05:51
  MEGABYTES: 12
  FILES: 140
 SUCCESSFUL: NO

 
 Joni Moyer
 Highmark
 Storage Systems
 Work:(717)302-6603
 Fax:(717)302-5974
 [EMAIL PROTECTED]
 



  Andrew Raibeck
  [EMAIL PROTECTED]
  OM
 To
  Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
  Dist Stor
 cc
  Manager
  [EMAIL 

Re: Emergency! Server will not start

2005-01-19 Thread Stapleton, Mark
Chocolate-covered strawberries, heck! Reach for the bottle of Tullamore
Dew!

--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627  

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of Steve Schaub
Sent: Wednesday, January 19, 2005 6:07 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Emergency! Server will not start

Joni,

In case of emergency:

1. Step back
2. Take a deep breath
3. Reach for the chocolate-covered strawberries!

-Original Message-
From: Joni Moyer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 18, 2005 3:54 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Emergency! Server will not start


I thank you all for your quick response to my own stupid mistake.  I am
just setting up this new TSM server and I did not extend the recovery
log past the initial use of 4MB.  Thank you again!  Your help is always
appreciated

: )


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]




 Curtis Stewart
 [EMAIL PROTECTED]
 AWSON.COM
To
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor
cc
 Manager
 [EMAIL PROTECTED]
Subject
 .EDU Re: Emergency!  Server will not
   start

 01/18/2005 03:46
 PM


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






Can you see the file system and directory where you put the logs from
the OS? I think the 4MB is the default amount of log the TSM install
creates in the server/bin directory.

[EMAIL PROTECTED]



Re: select statement: help!

2005-01-19 Thread Richard Sims
Joni - Match your quotes and you'll quickly see what's wrong.
   Richard Sims
On Jan 19, 2005, at 12:31 PM, Joni Moyer wrote:
Hi Andy!
You have a very good point of showing my command.  Without it is kind
of
difficult.  Here is the exact command that I am entering (I'm just
going to
use admin admin as id and password and x as the servername):
dsmadmc -server=x -id=admin -password=admin -displaymode=table
'select
entity as node_name, date(start_time) as date, -
cast(activity as varchar(10)) as activity, time(start_time) as
start, time(end_time)as end, cast(bytes/1024/1024 as decimal(6,0)) as
megabytes, -
cast(affected as decimal(7,0)) as files, successful -
   from summary
where date(start_time) date(current_timestamp - 1 day) -
and (entity like 'HM%' or entity like 'PAB%' or entity like
'VMS%'
or entity like 'GEOHMKLG%') -
and activity='BACKUP' order by successful'
I've just been entering this on the command-line, so I don't have any -
within the command.  That's when I receive the following:
ksh: 0403-057 Syntax error: `(' is not expected.
/home/lidzr8v (chrs144:lidzr8v)
Do I not need the quotes around the select statement?  Thank you in
advance!


Re: select statement: help!

2005-01-19 Thread Andrew Raibeck
Hi Joni,

You don't need the quotes around the SELECT statement. Also, when
specifying the complete command in batch mode, I don't think using the
hyphen (-) for command continuation will work, since it is the OS command
line processor that sees the hyphen, not the admin client.

Try putting your SELECT statement into a separate text file called, for
example, select.macro:

select entity as node_name, date(start_time) as date, -
   cast(activity as varchar(10)) as activity, -
   time(start_time) as start, time(end_time)as end, -
   cast(bytes/1024/1024 as decimal(6,0)) as megabytes, -
   cast(affected as decimal(7,0)) as files, successful -
  from summary -
  where date(start_time) date(current_timestamp - 1 day) and -
(entity like 'HM%' or entity like 'PAB%' or -
 entity like 'VMS%' or entity like 'GEOHMKLG%') and -
activity='BACKUP' order by successful

Then invoke the macro like this:

   dsmadmc -se=blah -id=admin -pa=xxx -displaymode=table macro
select.macro

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.

ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-01-19
10:31:17:

 Hi Andy!

 You have a very good point of showing my command.  Without it is kind of
 difficult.  Here is the exact command that I am entering (I'm just going
to
 use admin admin as id and password and x as the servername):

 dsmadmc -server=x -id=admin -password=admin -displaymode=table
'select
 entity as node_name, date(start_time) as date, -
 cast(activity as varchar(10)) as activity, time(start_time) as
 start, time(end_time)as end, cast(bytes/1024/1024 as decimal(6,0)) as
 megabytes, -
 cast(affected as decimal(7,0)) as files, successful -
from summary
 where date(start_time) date(current_timestamp - 1 day) -
 and (entity like 'HM%' or entity like 'PAB%' or entity like
'VMS%'
 or entity like 'GEOHMKLG%') -
 and activity='BACKUP' order by successful'

 I've just been entering this on the command-line, so I don't have any -
 within the command.  That's when I receive the following:

 ksh: 0403-057 Syntax error: `(' is not expected.
 /home/lidzr8v (chrs144:lidzr8v)

 Do I not need the quotes around the select statement?  Thank you in
 advance!

 
 Joni Moyer
 Highmark
 Storage Systems
 Work:(717)302-6603
 Fax:(717)302-5974
 [EMAIL PROTECTED]
 



  Andrew Raibeck
  [EMAIL PROTECTED]
  OM To
  Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
  Dist Stor cc
  Manager
  [EMAIL PROTECTED] Subject
  .EDU Re: select statement: help!


  01/19/2005 11:34
  AM


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






 Joni,

 The -displaymode=table option should give you the desired format (that
is
 the specific purpose of this option).

 Your note suggests you omitted the -ID and -PASSWORD options.

 It would help if you would post (via copy  paste) the actual command
you
 issued along with the results, so we can see what you are seeing.

 Regards,

 Andy

 Andy Raibeck
 IBM Software Group
 Tivoli Storage Manager Client Development
 Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
 Internet e-mail: [EMAIL PROTECTED]

 The only dumb question is the one that goes unasked.
 The command line is your friend.
 Good enough is the enemy of excellence.

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-01-19
 06:54:49:

  Hello,
 
  I went out and tried the following:
 
  dsmadmc -servername=server -displaymode=table select statement and it
  didn't work.  Do you have to put the statement within single quotes?
  Thanks!
 
  
  Joni Moyer
  Highmark
  Storage Systems
  Work:(717)302-6603
  Fax:(717)302-5974
  [EMAIL PROTECTED]
  
 
 
 
   PAC Brion
   Arnaud
   [EMAIL PROTECTED] To
   ALPINA.COM   ADSM-L@VM.MARIST.EDU
   Sent by: ADSM: cc
   Dist Stor
   Manager Subject
   [EMAIL PROTECTED] Re: select statement: help!
   .EDU
 
 
   01/19/2005 08:16
   AM
 
 
   Please respond to
   ADSM: Dist Stor
   Manager
   [EMAIL PROTECTED]
 .EDU
 
 
 
 
 
 
  Joni,
 
  Maybe this http://msgs.adsm.org/cgi-bin/get/adsm0109/730.html will
help
  you !
  Cheers.
 
 
  Arnaud
 
 

How to delete archive descriptions?

2005-01-19 Thread Robert Knutsen
I have found the command to delete all the files of an archive but I am
unable to delete the archive description that was associated with the
files I deleted.

I used dsmc delete archive *to delete all the archive files

When I use the GUI to view archive restore, all the descriptions still
show up.  I would like to delete them since they hold no files.


Thanks for all the help

Regards
Robert Knutsen


Re: How to delete archive descriptions?

2005-01-19 Thread Robert Ouzen
Hi

Ithink is Cleanup archdir nodename  resetdescr

Regards
Robert Ouzen
Haifa University
Israel
 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert 
Knutsen
Sent: Wednesday, January 19, 2005 8:22 PM
To: ADSM-L@VM.MARIST.EDU
Subject: How to delete archive descriptions?

I have found the command to delete all the files of an archive but I am unable 
to delete the archive description that was associated with the files I deleted.

I used dsmc delete archive *to delete all the archive files

When I use the GUI to view archive restore, all the descriptions still show up. 
 I would like to delete them since they hold no files.


Thanks for all the help

Regards
Robert Knutsen


TSM Client on HMC

2005-01-19 Thread Miles Purdy
Does any one out there have a p5 system with a HMC? Have you tried to hack the 
HMC and put the TSM client on it?

I'd be interested in anyone's experiences.

Miles


--
Miles Purdy 
System Manager
Information Systems Team (IST),
Farm Income Programs Directorate (FIPD),
Agriculture and Agri-Food Canada (AAFC) 
6th Floor 200 Graham Ave.   Mailing: PO box 6100
Winnipeg, MB, CA R3C 4N3
R3C 4L5
Office contact:Mobile contact:
 [EMAIL PROTECTED]  [EMAIL PROTECTED]   
  
 ph: (204) 984-1602 fax: (204) 983-7557Cell: (204) 291-8758

If you hold a UNIX shell up to your ear, can you hear the C?
-


Re: TSM Client on HMC

2005-01-19 Thread Stef Coene
On Wednesday 19 January 2005 20:31, Miles Purdy wrote:
 Does any one out there have a p5 system with a HMC? Have you tried to hack
 the HMC and put the TSM client on it?
I have hacked the hmc but I never tried to install a tsm client on it.
It's basically a linux box, so why should this not go ??


Stef


Re: TSM Client on HMC

2005-01-19 Thread Miles Purdy
That is basically my thoughts. I not sure yet how useful it will be (we only 
got the HW two weeks ago), but it can't hurt to back it up, I'm thinking.



 [EMAIL PROTECTED] 19-Jan-05 1:48:05 PM 
On Wednesday 19 January 2005 20:31, Miles Purdy wrote:
 Does any one out there have a p5 system with a HMC? Have you tried to hack
 the HMC and put the TSM client on it?
I have hacked the hmc but I never tried to install a tsm client on it.
It's basically a linux box, so why should this not go ??


Stef


TSM server on p5 micro partition

2005-01-19 Thread Miles Purdy
Has anyone out there migrated or installed a TSM server in a p5 micro partition 
(not an LPAR)?

I'd be interested in your settings for:
Number of processors: dedicated or virtual. 
And: desired / min / max.
Are you using SMT?

As well as,
Processing power: desired / minimum / maximum 
and: capped or uncapped

My initial thoughts are:
virtual CPUs (since I'm using micro partitions)
des/min/max = 2/1/2

Processing power (des/min/max) = .2/.1/1.5 uncapped
I think I will use SMT on it.

I don't think my TSM server needs a lot of CPU power. I recall that expiration 
used the most CPU power, but that it is a single threaded processes. So more 
than CPU probably won't make it run much faster.

Anyone have any thoughts?

Thanks Miles





--
Miles Purdy 
System Manager
Information Systems Team (IST),
Farm Income Programs Directorate (FIPD),
Agriculture and Agri-Food Canada (AAFC) 
6th Floor 200 Graham Ave.   Mailing: PO box 6100
Winnipeg, MB, CA R3C 4N3
R3C 4L5
Office contact:Mobile contact:
 [EMAIL PROTECTED]  [EMAIL PROTECTED]   
  
 ph: (204) 984-1602 fax: (204) 983-7557Cell: (204) 291-8758

If you hold a UNIX shell up to your ear, can you hear the C?
-


TSM automation problem

2005-01-19 Thread Thomas Denier
We have a TSM 5.2.2.0 server running under mainframe Linux. We have
a locally written Perl script that reads messages from a console mode
administrative session and manages server operations. The server uses
a 3494 tape library.

When we started out, part of the code in the script detected the end
of a database snapshot and executed a 'move drmedia' for the output
volume or volumes. The 'move drmedia' command also causes the volume
or volumes to be ejected from the 3494. The 'move drmedia' sometimes
failed because a volume was still dismounting when TSM tried to eject
it.

When we discovered this problem we added logic to wait for dismounts
to finish. This code looks for ANR8468I messages reporting dismounts.
Each time such a message occurs the script executes a 'query mount'
command. When the query reports no tapes mounted the script proceeds
with the 'move drmedia' command. The new code occasionally hangs up.
The last time this happened we discovered the following sequence of
messages in the activity log:

01/19/2005 07:20:32  ANR8468I 3590 volume 630257 dismounted from drive
  IBMTAPE3 (/dev/IBMtape3) in library TJULIB01. (PROCESS:
 5222)
01/19/2005 07:20:32  ANR2017I Administrator AUTOMATION issued command: QUERY
  MOUNT 63*
01/19/2005 07:20:32  ANR8331I 3590 volume 630257 is mounted R/W in drive
  IBMTAPE3 (/dev/IBMtape3), status: DISMOUNTING.
01/19/2005 07:20:32  ANR8334I 1 matches found.

The server reports that a tape is dismounted, and then responds to a
'query mount' command with a claim that the very same tape is still in
the process of being dismounted. Does anyone know of a good work-around
for this sloppy status reporting?


SAN Booting

2005-01-19 Thread Rushforth, Tim
Hi all:

 

We are looking at booting servers from a SAN instead of local disks.

 

We are planning to use either TSM image or file backups of the OS drives
(Windows 2003) to make server deployment and bare metal restores
quicker:

 

Install Windows (and apps) on hardware

Run SYSPREP

Backup SAN disk from another system (either TSM image backup or TSM file
system backup)

 

To roll out new hardware or perform BMR:

Recover TSM image or file system backup (from another system)

Plug in new hardware to this system and run SYSPREP

 

My questions on this:

 

Is anyone booting from SAN?

What applications?

Is anyone booting a TSM server from a SAN?

Are there any issues (TSM and others) to look out for?

 

Is anyone using TSM as above for System Deployments?

Any issues?

 

I apologize that some of these questions may not be TSM related so
please reply directly to me rather than the list.

 

Thanks,

 

Tim Rushforth

City of Winnipeg

[EMAIL PROTECTED]

 

 


Re: TSM Client on HMC

2005-01-19 Thread Paul Fielding
Hey Miles,
I know of one customer who tried without much success.  My understanding is
that the HMC was too far locked down to be able to install and run the TSM
client on it.
Given that the HMC is supposed to be a closed system, there shouldn't be
anything stored on there that you need to keep, other than some basic
settings that can be backed up by the HMC's own processes on the odd
ocassion that you make such changes.   If the HMC blows up I'd probably just
restore it from CD or DVD...
regards,
Paul
- Original Message -
From: Miles Purdy [EMAIL PROTECTED]
To: ADSM-L@VM.MARIST.EDU
Sent: Wednesday, January 19, 2005 12:31 PM
Subject: [ADSM-L] TSM Client on HMC
Does any one out there have a p5 system with a HMC? Have you tried to hack
the HMC and put the TSM client on it?
I'd be interested in anyone's experiences.
Miles
--
Miles Purdy
System Manager
Information Systems Team (IST),
Farm Income Programs Directorate (FIPD),
Agriculture and Agri-Food Canada (AAFC)
6th Floor 200 Graham Ave.   Mailing: PO box 6100
Winnipeg, MB, CA R3C 4N3
R3C 4L5
Office contact:Mobile contact:
[EMAIL PROTECTED]
[EMAIL PROTECTED]
ph: (204) 984-1602 fax: (204) 983-7557Cell: (204) 291-8758
If you hold a UNIX shell up to your ear, can you hear the C?
-


Re: Backing up SYSTEMOBJECT on Win2K machines

2005-01-19 Thread Robertson, Louis
Eric,

In the event of a disaster you will probably be restoring to dissimilar 
equipment.  If that is the case and you are running W2K with SP3 and you are 
using the ntbackup of the systemstate you definitely want to read Microsoft's 
knowledge base article 249694, ( http://support.microsoft.com/kb/249694 
)specifically the section on changing the registry key - KeysNotToRestore.  
Prior to installing SP4 our test restores to dissimilar equipment was not very 
successful until we made the KeysNotToRestore registry change referenced in 
this article.

Louis

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Jones, Eric J
Sent: Tuesday, January 18, 2005 1:52 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Backing up SYSTEMOBJECT on Win2K machines


Good Afternoon.
I've seen a few post on the backup of the SYSTEMOBJECT for win2k and I'm 
looking for the best way to backup our win2K systems.
I have 4 systems that I currently backup with another 10+ to go.
Most of my machines are UNIX so I've never had a problem with this.
It seems like the DB is growing faster than it use to and I'd like to prevent 
rapid growth once the others are included.
It's my understanding that all of the SYSTEMOBJECT files are backed up with 
every backup(incremental).
We keep all data for 90 days and the systems are backed up Monday-Friday .
Is it more efficient/better to have ntbackup backup the SYSTEMOBJECT to a file 
before the TSM backup, then have TSM backup this file nightly with the regular 
TSM backup?
Is there any problem with recovery of the machine using this method(ntbackup 
then TSM)?
Is there any advantages/disadvantages to using this method?
Generally how many files does the SYSTEMOBJECT backup contain?
We are currently on AIX 5.2/TSM 5.2.2 server and win2K SP3 clients.

Have a Great Day,
Eric

***
The information in this email is confidential and may be legally privileged.  
Access to this email by anyone other than the intended addressee is 
unauthorized.  If you are not the intended recipient of this message, any 
review, disclosure, copying, distribution, retention, or any action taken or 
omitted to be taken in reliance on it is prohibited and may be unlawful.  If 
you are not the intended recipient, please reply to or forward a copy of this 
message to the sender and delete the message, any attachments, and any copies 
thereof from your system.
***


Re: How to delete archive descriptions?

2005-01-19 Thread Robert Knutsen
I am unable to find 'Cleanup' command.  Is it in the client manual?

Thanks
Robert Knutsen



Robert Ouzen [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
01/19/2005 11:26 AM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU


To
ADSM-L@VM.MARIST.EDU
cc

Subject
Re: How to delete archive descriptions?






Hi

Ithink is Cleanup archdir nodename  resetdescr

Regards
Robert Ouzen
Haifa University
Israel


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Robert Knutsen
Sent: Wednesday, January 19, 2005 8:22 PM
To: ADSM-L@VM.MARIST.EDU
Subject: How to delete archive descriptions?

I have found the command to delete all the files of an archive but I am
unable to delete the archive description that was associated with the
files I deleted.

I used dsmc delete archive *to delete all the archive files

When I use the GUI to view archive restore, all the descriptions still
show up.  I would like to delete them since they hold no files.


Thanks for all the help

Regards
Robert Knutsen


Re: Server to server with different managementclasses

2005-01-19 Thread Joerg Pohlmann
Steve, set up two policy domains on the target server, with a node
type=server in each to be used by the source server. In one PD, create a
default management class where the archive copygroup destination is disk.
In the other PD create a default MC where the archive copy group
destination is a disk/tape hierarchy or just tape. On the source server,
define the two servers with the IP of the target server and the two
respective virtual volumes node names. Then define two device classes, one
to use the server that uses the node in the target server PD to only send
data to disk. The other device class on the source server uses the second
server definition where the node is the one that sends data to the
disk/tape hierarchy. Then use the first devclass for the data base backups
and the second devclass for your virtual volume copy pool.

I have used this approach for backupsets and copy pool differentiation
such that I could the tapes at the target server that contained the
archive objects for the backupset at the source server out of the tape
library, whereas the archive objects for the copy storage pool virtual
volumes stayed inside the library to be ready for reclamation. In this
shop, the backupsets were used as a means of doing annual archives for a
given set of server where the likelihood of anyone wanting access to this
data was nil.

Hope I mumbled clearly.

Joerg Pohlmann
604-535-0452




Steve Harris [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
2005-01-19 01:12
Please respond to
ADSM: Dist Stor Manager


To
ADSM-L@VM.MARIST.EDU
cc

Subject
Server to server with different managementclasses






Hi All,

TSM for windows 5.3

I'm trying to set up server to server to allow electronic vaulting and
remote database backups.  I'd like the database and the copypool data to
go to different management classes on the remote server - Why? - because
the remote site will likely not be manned when a database restore is
performed and so I'd like the DB backups to remain on disk/in the tape
library whereas the copypool data is essentially write-only and can afford
to be taken out of the library  much earlier, as it is unlikely ever to be
read.

In the usual case on the receiving end, the sending server is allocated to
a domain and its data all goes into the default archive management class
for that domain.

Is there any way to differentiate this data? I note that there is a
facility to provide a node name  when defining server to server for
virtual volumes, but I can't get my head around how to use it.

Regards

Steve.

Steve Harris
TSM Admin
Queensland Health, Brisbane Australia








***
This email, including any attachments sent with it, is confidential and
for the sole use of the intended recipient(s).  This confidentiality is
not waived or lost, if you receive it and you are not the intended
recipient(s), or if it is transmitted/received in error.

Any unauthorised use, alteration, disclosure, distribution or review of
this email is prohibited.  It may be subject to a statutory duty of
confidentiality if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this
email in error, you are asked to immediately notify the sender by
telephone or by return email.  You should also delete this email and
destroy any hard copies produced.
***


FW: Backing up SYSTEMOBJECT on Win2K machines

2005-01-19 Thread Stapleton, Mark
[from the TSM mailing list--points to a link detailing Windows registry
gotchas for bare-metal restores]

--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627  

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of Robertson, Louis
Sent: Wednesday, January 19, 2005 4:01 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Backing up SYSTEMOBJECT on Win2K machines

Eric,

In the event of a disaster you will probably be restoring to 
dissimilar equipment.  If that is the case and you are running 
W2K with SP3 and you are using the ntbackup of the systemstate 
you definitely want to read Microsoft's knowledge base article 
249694, ( http://support.microsoft.com/kb/249694 )specifically 
the section on changing the registry key - KeysNotToRestore.  
Prior to installing SP4 our test restores to dissimilar 
equipment was not very successful until we made the 
KeysNotToRestore registry change referenced in this article.

Louis

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] 
Behalf Of Jones, Eric J
Sent: Tuesday, January 18, 2005 1:52 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Backing up SYSTEMOBJECT on Win2K machines


Good Afternoon.
I've seen a few post on the backup of the SYSTEMOBJECT for 
win2k and I'm looking for the best way to backup our win2K systems.
I have 4 systems that I currently backup with another 10+ to go.
Most of my machines are UNIX so I've never had a problem with this.
It seems like the DB is growing faster than it use to and I'd 
like to prevent rapid growth once the others are included.
It's my understanding that all of the SYSTEMOBJECT files are 
backed up with every backup(incremental).
We keep all data for 90 days and the systems are backed up 
Monday-Friday .
Is it more efficient/better to have ntbackup backup the 
SYSTEMOBJECT to a file before the TSM backup, then have TSM 
backup this file nightly with the regular TSM backup?
Is there any problem with recovery of the machine using this 
method(ntbackup then TSM)?
Is there any advantages/disadvantages to using this method?
Generally how many files does the SYSTEMOBJECT backup contain?
We are currently on AIX 5.2/TSM 5.2.2 server and win2K SP3 clients.