Norita,

It sounds like your management is attempting to impose a standard derived
for a less sophisticated product onto TSM.

What they want, as I read it, is an assurance that they know what is on any
given tape, in case of a disaster recovery - if that is the case, then they
need an offsite database backup, and a recovery plan file: nothing else will
do.  That way they know which offsite tape has the latest database backup
and can perform a restore if need be.

Ask them for the result that they wish to achieve, not the means to provide
it.  I realize that as a technician it is often difficult to resist the
unreasonable and unthinking demands of management, but you are the one who
is charged with running this, not them.  Be firm.

Regards

Steve.

Steve Harris
Brisbane, Australia

----- Original Message -----
From: "Norita binti Hassan" <ita AT POS.COM DOT MY>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Friday, March 11, 2005 1:13 PM
Subject: Re: [ADSM-L] Volume sequence

Thanks.. where can we get documentation or manual on the 'Show" command?

But what my management want is a list of tapes, their nodes and the file
sequence number and the backup date From whisch tables can I retreive all
these info.

e.g
Tape Number Node Name Backup Date Seq. No
----------------------- --------------------- -----------------------
--------------
TEST001 SERVER01 2005-01-01 1
TEST001 SERVER01 2005-01-01 2
TEST002 SERVER03 2005-01-05 1
TEST003 SERVER05 2005-01-05 1

So, from this report, we will know that SERVER01  used 2 tapes and so on.
Can anybody help me??


Thank you



~Norita Hasan~

-----Original Message-----
From: fred johanson [mailto:fred AT UCHICAGO DOT EDU]
Sent: Thursday, March 10, 2005 10:43 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Volume sequence

The undocumented, but well known, "show volumeusage node_name" lists the
volumes in the order they were assigned to the client.


At 10:51 AM 3/10/2005 +0800, you wrote:

I've tried that script, but I need to know the file sequence.
Eg. I have a large database of 170GB.It should occupied more than 1 tape.
How do I know which tape is the first one, and which is next .

~Norita Hasan~

-----Original Message-----
From: goc [mailto:goran.k AT VIP DOT HR]
Sent: Wednesday, March 09, 2005 8:53 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Volume sequence

you can try this ... it givec a lot more and it's useful i think

select
vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.v

o

lume_name
 -
from volumeusage vu,volumes vo -
where vo.volume_name=vu.volume_name -
group by
vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.v

o

lume_name
 -
order by vo.volume_name, -
vu.node_name,vu.copy_type,vo.pct_utilized


----- Original Message -----
From: "Norita binti Hassan" <ita AT POS.COM DOT MY>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Wednesday, March 09, 2005 11:51 AM
Subject: Volume sequence


> Hi,
>
> Is there any select statement that can display the volume sequence

number

> so
> that I can list all the volumes in sequence that has been used by

specific

> node.
>
> NORITA BINTI HASAN
> Senior Programmer
> Enterprise Systems Services
> Information Communication Tech.Div
> 6th Floor, Pos Malaysia Berhad
> 50670 Kuala Lumpur
>
> Tel : 03 - 22756638
>
>
>
> Pos Malaysia Berhad is Malaysia's national postal company
> Visit us online at www.pos.com.my
>
> NOTICE
> This message may contain privileged and/or confidential
> information. If  you are  not the addressee  or authorised
> to  receive this email, you must not use, copy,  disclose
> or take any  action based  on this email. If you  have
> received this  email in  error, please advise  the sender
> immediately by  reply e-mail and delete  this message.
> Pos Malaysia  Berhad takes  no responsibility  for  the
> contents of this email.
>


Pos Malaysia Berhad is Malaysia's national postal company
        Visit us online at www.pos.com.my

NOTICE
This message may contain privileged and/or confidential
information. If  you are  not the addressee  or authorised
to  receive this email, you must not use, copy,  disclose
or take any  action based  on this email. If you  have
received this  email in  error, please advise  the sender
immediately by  reply e-mail and delete  this message.
Pos Malaysia  Berhad takes  no responsibility  for  the
contents of this email.

Fred Johanson
ITSM Administrator
University of Chicago
773-702-8464


Pos Malaysia Berhad is Malaysia's national postal company
Visit us online at www.pos.com.my

NOTICE
This message may contain privileged and/or confidential
information. If  you are  not the addressee  or authorised
to  receive this email, you must not use, copy,  disclose
or take any  action based  on this email. If you  have
received this  email in  error, please advise  the sender
immediately by  reply e-mail and delete  this message.
Pos Malaysia  Berhad takes  no responsibility  for  the
contents of this email.