Re: TDP for Exchange 6.1.3 - need help finding out how to find out what I need to find out....

[Del Hoobler]

Hi Wanda,

I recommend that you enable tracing, open a PMR,
and send the trace to IBM Support.

You can do that by adding the following to
the TDPEXCC BACKUP command:

 /TRACEFLAG=SERVICE /TRACEFILE=TRACE.TXT

The trace will tell the IBM Support team
exactly where the code is crashing.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 08/07/2012
10:35:31 PM:

 From: Prather, Wanda wanda.prat...@icfi.com
 To: ADSM-L@vm.marist.edu
 Date: 08/07/2012 10:38 PM
 Subject: TDP for Exchange 6.1.3 - need help finding out how to find
 out what I need to find out
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Well, I'm stumped.
 My customer has a 2-node Exchange 2003 active/passive cluster on
 Win2K3 R2 SP2.
 TDP for Exchange is 6.1.3.3, Legacy backups.


 Node 1 is usually the active node, and TSM works fine.

 The TDPEX GUI on Node 1 works as expected.  The client scheduler
 service for Exchange is installed on node 1, is defined as a cluster
 resource, and works fine.



 Node 2 is usually the passive node, and TSM doesn't work at all.



 The dsm.opt file, the information store,  the logs are on a
clusterdrive, I:.



 When we fail Exchange over from Node 1 to Node 2, the I: drive
 becomes available to Node 2, as it should, so the exchange dsm.opt
 file is used on both nodes.  CLUSTERNODE is set to YES,
 PASSWORDACCESS to GENERATE..



 When we then start the TDP for Exchange GUI on Node 2, it creates a
 session with the TSM server and authenticates OK (verified by
 checking the server actlog).  When you click restore, you can see
 the available backups to restore as you would expect.

 But when you click backup, you get the usual message updating
 mailbox history, then the GUI dies without a whimper.  No message,
 the GUI just vanishes.



 If you invoke a backup via the command line from the \TDPEXCh
directory::



 tdpexcc backup * \tsmoptfile=dsm.opt   \excserver=exch-foo
\logfile=foo.log



 EXACTLY the same thing happens.  You see the session established
 with the server, no password errors.  You see the updating mailbox
 history message.  Then the cmd line exits.  The exchange log
 foo.log shows the updating mailbox history message, nothing else.
 No messages in dsierror.log, nothing in the Windows event log. The
 server actlog shows only ANR0480W, indicating the session was
 terminated by the client end.  It's a mystery how it dies.

 The box has been rebooted, and we've tried uninstalling and
 reinstalling the TDP.

 I'm not having any luck Googling for an error message I don't see -
 anybody seen behavior before that makes the TDPEXch session vanish
 without a tra - um, error?  Suggestions for search words?

 What am I missing here?
 Thanks for any ideas!

 Wanda

Re: TDP for Exchange 6.1.3 - need help finding out how to find out what I need to find out....

[Prather, Wanda]

Thanks Del, will do...

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del 
Hoobler
Sent: Wednesday, August 08, 2012 7:51 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for Exchange 6.1.3 - need help finding out how to 
find out what I need to find out

Hi Wanda,

I recommend that you enable tracing, open a PMR, and send the trace to IBM 
Support.

You can do that by adding the following to the TDPEXCC BACKUP command:

 /TRACEFLAG=SERVICE /TRACEFILE=TRACE.TXT

The trace will tell the IBM Support team exactly where the code is crashing.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 08/07/2012
10:35:31 PM:

 From: Prather, Wanda wanda.prat...@icfi.com
 To: ADSM-L@vm.marist.edu
 Date: 08/07/2012 10:38 PM
 Subject: TDP for Exchange 6.1.3 - need help finding out how to find 
 out what I need to find out
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Well, I'm stumped.
 My customer has a 2-node Exchange 2003 active/passive cluster on
 Win2K3 R2 SP2.
 TDP for Exchange is 6.1.3.3, Legacy backups.


 Node 1 is usually the active node, and TSM works fine.

 The TDPEX GUI on Node 1 works as expected.  The client scheduler 
 service for Exchange is installed on node 1, is defined as a cluster 
 resource, and works fine.



 Node 2 is usually the passive node, and TSM doesn't work at all.



 The dsm.opt file, the information store,  the logs are on a
clusterdrive, I:.



 When we fail Exchange over from Node 1 to Node 2, the I: drive becomes 
 available to Node 2, as it should, so the exchange dsm.opt file is 
 used on both nodes.  CLUSTERNODE is set to YES, PASSWORDACCESS to 
 GENERATE..



 When we then start the TDP for Exchange GUI on Node 2, it creates a 
 session with the TSM server and authenticates OK (verified by checking 
 the server actlog).  When you click restore, you can see the available 
 backups to restore as you would expect.

 But when you click backup, you get the usual message updating mailbox 
 history, then the GUI dies without a whimper.  No message, the GUI 
 just vanishes.



 If you invoke a backup via the command line from the \TDPEXCh
directory::



 tdpexcc backup * \tsmoptfile=dsm.opt   \excserver=exch-foo
\logfile=foo.log



 EXACTLY the same thing happens.  You see the session established with 
 the server, no password errors.  You see the updating mailbox 
 history message.  Then the cmd line exits.  The exchange log foo.log 
 shows the updating mailbox history message, nothing else.
 No messages in dsierror.log, nothing in the Windows event log. The 
 server actlog shows only ANR0480W, indicating the session was 
 terminated by the client end.  It's a mystery how it dies.

 The box has been rebooted, and we've tried uninstalling and 
 reinstalling the TDP.

 I'm not having any luck Googling for an error message I don't see - 
 anybody seen behavior before that makes the TDPEXch session vanish 
 without a tra - um, error?  Suggestions for search words?

 What am I missing here?
 Thanks for any ideas!

 Wanda

TDP for Exchange 6.1.3 - need help finding out how to find out what I need to find out....

[Prather, Wanda]

Well, I'm stumped.
My customer has a 2-node Exchange 2003 active/passive cluster on Win2K3 R2 SP2.
TDP for Exchange is 6.1.3.3, Legacy backups.


Node 1 is usually the active node, and TSM works fine.

The TDPEX GUI on Node 1 works as expected.  The client scheduler service for 
Exchange is installed on node 1, is defined as a cluster resource, and works 
fine.



Node 2 is usually the passive node, and TSM doesn't work at all.



The dsm.opt file, the information store,  the logs are on a cluster drive, I:.



When we fail Exchange over from Node 1 to Node 2, the I: drive becomes 
available to Node 2, as it should, so the exchange dsm.opt file is used on both 
nodes.  CLUSTERNODE is set to YES, PASSWORDACCESS to GENERATE..



When we then start the TDP for Exchange GUI on Node 2, it creates a session 
with the TSM server and authenticates OK (verified by checking the server 
actlog).  When you click restore, you can see the available backups to restore 
as you would expect.

But when you click backup, you get the usual message updating mailbox 
history, then the GUI dies without a whimper.  No message, the GUI just 
vanishes.



If you invoke a backup via the command line from the \TDPEXCh directory::



tdpexcc backup * \tsmoptfile=dsm.opt   \excserver=exch-foo \logfile=foo.log



EXACTLY the same thing happens.  You see the session established with the 
server, no password errors.  You see the updating mailbox history message.  
Then the cmd line exits.  The exchange log foo.log shows the updating mailbox 
history message, nothing else.  No messages in dsierror.log, nothing in the 
Windows event log. The server actlog shows only ANR0480W, indicating the 
session was terminated by the client end.  It's a mystery how it dies.

The box has been rebooted, and we've tried uninstalling and reinstalling the 
TDP.

I'm not having any luck Googling for an error message I don't see - anybody 
seen behavior before that makes the TDPEXch session vanish without a tra - um, 
error?  Suggestions for search words?

What am I missing here?
Thanks for any ideas!

Wanda

Re: TDP for Exchange 6.1.3 - need help finding out how to find out what I need to find out....

[Rick Harderwijk]

Wanda,

Have you tried tracing the activity of the process with Sysinternals'
Process Monitor? It might help in pinpointing at what stage exactly the
client exits. Maybe it is trying to read a registry key and crashes on that
or something. I've found Process Monitor very helpful in a number of
different cases in the past.

Cheers,

Rick

On Wed, Aug 8, 2012 at 4:35 AM, Prather, Wanda wanda.prat...@icfi.comwrote:

 Well, I'm stumped.
 My customer has a 2-node Exchange 2003 active/passive cluster on Win2K3 R2
 SP2.
 TDP for Exchange is 6.1.3.3, Legacy backups.


 Node 1 is usually the active node, and TSM works fine.

 The TDPEX GUI on Node 1 works as expected.  The client scheduler service
 for Exchange is installed on node 1, is defined as a cluster resource, and
 works fine.



 Node 2 is usually the passive node, and TSM doesn't work at all.



 The dsm.opt file, the information store,  the logs are on a cluster
 drive, I:.



 When we fail Exchange over from Node 1 to Node 2, the I: drive becomes
 available to Node 2, as it should, so the exchange dsm.opt file is used on
 both nodes.  CLUSTERNODE is set to YES, PASSWORDACCESS to GENERATE..



 When we then start the TDP for Exchange GUI on Node 2, it creates a
 session with the TSM server and authenticates OK (verified by checking the
 server actlog).  When you click restore, you can see the available backups
 to restore as you would expect.

 But when you click backup, you get the usual message updating mailbox
 history, then the GUI dies without a whimper.  No message, the GUI just
 vanishes.



 If you invoke a backup via the command line from the \TDPEXCh directory::



 tdpexcc backup * \tsmoptfile=dsm.opt   \excserver=exch-foo \logfile=foo.log



 EXACTLY the same thing happens.  You see the session established with the
 server, no password errors.  You see the updating mailbox history
 message.  Then the cmd line exits.  The exchange log foo.log shows the
 updating mailbox history message, nothing else.  No messages in
 dsierror.log, nothing in the Windows event log. The server actlog shows
 only ANR0480W, indicating the session was terminated by the client end.
  It's a mystery how it dies.

 The box has been rebooted, and we've tried uninstalling and reinstalling
 the TDP.

 I'm not having any luck Googling for an error message I don't see -
 anybody seen behavior before that makes the TDPEXch session vanish without
 a tra - um, error?  Suggestions for search words?

 What am I missing here?
 Thanks for any ideas!

 Wanda

Re: how to find a particular node retention period?

[Theo Brettschneider]

Your backup wil allways follow the default management class unless you
specify another managementclass behind an include statement

Met vriendelijke groet, 
Theo Brettschneider
+31 (0) 6 29 02 13 53

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Arul
Sent: Tuesday, May 03, 2011 5:38 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] how to find a particular node retention period?

hi Guys,

kindly assit me how to find a particular node retention period?

Example:

i am having two mgmt class such as MGMT1  MGMT 2 both are in same
domain DOM1

while taking backup, at what retention period the backup will be done?

tsm: ADMIN_SERVER1q co dom1

PolicyPolicyMgmt  Copy  Versions Versions   Retain
Retain
DomainSet Name  Class Group Data DataExtra
Only
NameName  NameExists  Deleted Versions
Version
- - - -   
---
DOM1  ACTIVEMGMT1 STANDARD 21   30
60
DOM1  ACTIVEMGMT2 STANDARD 21  180
60
DOM1  POLI1 MGMT1 STANDARD 21   30
60
DOM1  POLI1 MGMT2 STANDARD 21  180
60


sm: ADMIN_SERVER1q mgmt f=d

   Policy Domain Name: DOM1
  Policy Set Name: ACTIVE
  Mgmt Class Name: MGMT1
 Default Mgmt Class ?: No
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 04/27/2011 21:19:15
 Managing profile:
  Changes Pending: No

   Policy Domain Name: DOM1
  Policy Set Name: ACTIVE
  Mgmt Class Name: MGMT2
 Default Mgmt Class ?: Yes
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 05/03/2011 20:41:48
 Managing profile:
  Changes Pending: No

   Policy Domain Name: DOM1
  Policy Set Name: POLI1
  Mgmt Class Name: MGMT1
 Default Mgmt Class ?: No
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 04/27/2011 21:19:15
 Managing profile:
  Changes Pending: No

   Policy Domain Name: DOM1
  Policy Set Name: POLI1
  Mgmt Class Name: MGMT2
 Default Mgmt Class ?: Yes
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 05/03/2011 20:41:48
 Managing profile:
  Changes Pending: No


Thanks
Arul

+--
|This was sent by arulkumar9...@gmail.com via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+--

how to find a particular node retention period?

[Arul]

hi Guys,

kindly assit me how to find a particular node retention period?

Example:

i am having two mgmt class such as MGMT1  MGMT 2 both are in same domain DOM1

while taking backup, at what retention period the backup will be done?

tsm: ADMIN_SERVER1q co dom1

PolicyPolicyMgmt  Copy  Versions Versions   Retain  Retain
DomainSet Name  Class Group Data DataExtraOnly
NameName  NameExists  Deleted Versions Version
- - - -    ---
DOM1  ACTIVEMGMT1 STANDARD 21   30  60
DOM1  ACTIVEMGMT2 STANDARD 21  180  60
DOM1  POLI1 MGMT1 STANDARD 21   30  60
DOM1  POLI1 MGMT2 STANDARD 21  180  60


sm: ADMIN_SERVER1q mgmt f=d

   Policy Domain Name: DOM1
  Policy Set Name: ACTIVE
  Mgmt Class Name: MGMT1
 Default Mgmt Class ?: No
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 04/27/2011 21:19:15
 Managing profile:
  Changes Pending: No

   Policy Domain Name: DOM1
  Policy Set Name: ACTIVE
  Mgmt Class Name: MGMT2
 Default Mgmt Class ?: Yes
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 05/03/2011 20:41:48
 Managing profile:
  Changes Pending: No

   Policy Domain Name: DOM1
  Policy Set Name: POLI1
  Mgmt Class Name: MGMT1
 Default Mgmt Class ?: No
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 04/27/2011 21:19:15
 Managing profile:
  Changes Pending: No

   Policy Domain Name: DOM1
  Policy Set Name: POLI1
  Mgmt Class Name: MGMT2
 Default Mgmt Class ?: Yes
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 05/03/2011 20:41:48
 Managing profile:
  Changes Pending: No


Thanks
Arul

+--
|This was sent by arulkumar9...@gmail.com via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+--

Re: how to find a particular node retention period?

[Grigori Solonovitch]

For any node in domain DOM1 default management class MGMT2 will be used (see- 
Default Mgmt Class ?: Yes), if any other is not specified in OPT file.

From: ADSM: Dist Stor Manager [ADSM-L@VM.MARIST.EDU] On Behalf Of Arul 
[tsm-fo...@backupcentral.com]
Sent: Tuesday, May 03, 2011 6:37 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] how to find a particular node retention period?

hi Guys,

kindly assit me how to find a particular node retention period?

Example:

i am having two mgmt class such as MGMT1  MGMT 2 both are in same domain DOM1

while taking backup, at what retention period the backup will be done?

tsm: ADMIN_SERVER1q co dom1

PolicyPolicyMgmt  Copy  Versions Versions   Retain  Retain
DomainSet Name  Class Group Data DataExtraOnly
NameName  NameExists  Deleted Versions Version
- - - -    ---
DOM1  ACTIVEMGMT1 STANDARD 21   30  60
DOM1  ACTIVEMGMT2 STANDARD 21  180  60
DOM1  POLI1 MGMT1 STANDARD 21   30  60
DOM1  POLI1 MGMT2 STANDARD 21  180  60


sm: ADMIN_SERVER1q mgmt f=d

   Policy Domain Name: DOM1
  Policy Set Name: ACTIVE
  Mgmt Class Name: MGMT1
 Default Mgmt Class ?: No
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 04/27/2011 21:19:15
 Managing profile:
  Changes Pending: No

   Policy Domain Name: DOM1
  Policy Set Name: ACTIVE
  Mgmt Class Name: MGMT2
 Default Mgmt Class ?: Yes
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 05/03/2011 20:41:48
 Managing profile:
  Changes Pending: No

   Policy Domain Name: DOM1
  Policy Set Name: POLI1
  Mgmt Class Name: MGMT1
 Default Mgmt Class ?: No
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 04/27/2011 21:19:15
 Managing profile:
  Changes Pending: No

   Policy Domain Name: DOM1
  Policy Set Name: POLI1
  Mgmt Class Name: MGMT2
 Default Mgmt Class ?: Yes
  Description:
   Space Management Technique: None
  Auto-Migrate on Non-Use: 0
   Migration Requires Backup?: Yes
Migration Destination: SPACEMGPOOL
ast Update by (administrator): ADMIN
Last Update Date/Time: 05/03/2011 20:41:48
 Managing profile:
  Changes Pending: No


Thanks
Arul

+--
|This was sent by arulkumar9...@gmail.com via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+--


Please consider the environment before printing this Email.

CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.

Re: How to find what management class is used per node

[Grigori Solonovitch]

Hello Dwight,
I have found your queries very good and developed some shell scripts, based on 
your queries, to produce reports for:

1) Domain - Node - File Space - Destination - Management Class - Copy Group 
Parameters (verexists, verdeleted,retextra, reatonly) for file backups;
2) Domain - Node - File Space - Destination - Management Class - Copy Group 
Parameters (verexists, verdeleted,retextra, reatonly) for directories (to 
control DIRMC);
3) Domain - Node - File Space - Destination - Management Class - Retain 
Versions for file archives;
4) Domain - Node - File Space - Destination - Management Class - Retain 
Versions for directory archives (to control DIRMC).

Shell scripts are quite good:
1) produce exact information about used MC, polls and copy group parameters for 
all nodes;
2) running for acceptable time;
3) running without total overloading TSM Server.

Scripts provide information like this:

--
| AIX | Node1 | FS1 | SP1 | MC1 | NOLIMIT | NOLIMIT |  31 |31 |
| | | FS2 | SP1 | MC1 | NOLIMIT | NOLIMIT |  31 |31 
|
| | | FS3 | SP1 | MC2 | NOLIMIT | NOLIMIT |  15 |15 
|
| | | FS3 | SP1 | MC3 | NOLIMIT | NOLIMIT |  62 |62 
|
|--+-+-+-+---+-+-+---+---|
| NT  | Node2  | FS4 | SP2 | MC4 | NOLIMIT | NOLIMIT |8 |  8 |
.

Scripts were developed under AIX, but I think they can be used under any UNIX 
with small modifications (see support for commands tr and od only).
I can provide scripts to anybody, who is interesting in this kind of reports, 
by direct E-mail.
Kindest regards,

Grigori G. Solonovitch

Senior Technical Architect

Information Technology  Bank of Kuwait and Middle East  http://www.bkme.com

Phone: (+965) 2231-2274  Mobile: (+965) 99798073  E-Mail: g.solonovi...@bkme.com

Please consider the environment before printing this Email


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Dwight 
Cook
Sent: Wednesday, March 03, 2010 12:23 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] How to find what management class is used per node

Try these:

select distinct node_name as Node Name   ,filespace_name as Filespace
Name,class_name as Management Class Name from backups
where TYPE='FILE' group by node_name,filespace_name,class_name

Node Name  Filespace Name Management
Class Name
-- --
-
TSMCLI01   /  DEFAULT
TSMCLI01   /home  DEFAULT
TSMCLI01   /opt   DEFAULT
TSMCLI01   /tmp   DEFAULT
TSMCLI01   /tsm   DEFAULT
TSMCLI01   /usr   DEFAULT
TSMCLI01   /var   DEFAULT
TSMCLI01   /wn001 DEFAULT

and the same for the archives table

you could always use the ~where node_name='HMPG1018'~ to limit the output to
just that node


select distinct node_name,filespace_name,class_name from backups group by
node_name,filespace_name,class_name

will show you everything, including directory information...

NODE_NAME  FILESPACE_NAME CLASS_NAME
-- -- --
TSMCLI01   /  B7.3_R35.95_A370_-
   DIRMC
TSMCLI01   /  DEFAULT
TSMCLI01   /home  B7.3_R35.95_A370_-
   DIRMC
TSMCLI01   /home  DEFAULT
...
TSMCLI01   /wn001 B7.3_R35.95_A370_-
   DIRMC
TSMCLI01   /wn001 DEFAULT


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Moyer, Joni M
Sent: Tuesday, March 02, 2010 2:21 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] How to find what management class is used per node

Hi,

I was just wondering if anyone knows a script that I can run to find out
what management class is utilized by node hmpg1018?  Would I need to run:
select * from backups where node_name='HMPG1018'?

Thanks in advance for any help

Joni Moyer
Storage Administrator III
(717)302-9966
joni.mo...@highmark.com



This e-mail and any attachments to it are confidential and are intended
solely for use of the individual or entity to whom they are addressed. If
you have received this e-mail in error, please notify

Re: How to find what management class is used per node

[Moyer, Joni M]

That is perfect!

Thanks Dwight!  That is exactly the output I was looking for!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Dwight 
Cook
Sent: Tuesday, March 02, 2010 4:23 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: How to find what management class is used per node

Try these:

select distinct node_name as Node Name   ,filespace_name as Filespace
Name,class_name as Management Class Name from backups
where TYPE='FILE' group by node_name,filespace_name,class_name

Node Name  Filespace Name Management
Class Name
-- --
-
TSMCLI01   /  DEFAULT
TSMCLI01   /home  DEFAULT
TSMCLI01   /opt   DEFAULT
TSMCLI01   /tmp   DEFAULT
TSMCLI01   /tsm   DEFAULT
TSMCLI01   /usr   DEFAULT
TSMCLI01   /var   DEFAULT
TSMCLI01   /wn001 DEFAULT

and the same for the archives table

you could always use the ~where node_name='HMPG1018'~ to limit the output to
just that node


select distinct node_name,filespace_name,class_name from backups group by
node_name,filespace_name,class_name

will show you everything, including directory information...

NODE_NAME  FILESPACE_NAME CLASS_NAME
-- -- --
TSMCLI01   /  B7.3_R35.95_A370_-
   DIRMC
TSMCLI01   /  DEFAULT
TSMCLI01   /home  B7.3_R35.95_A370_-
   DIRMC
TSMCLI01   /home  DEFAULT
...
TSMCLI01   /wn001 B7.3_R35.95_A370_-
   DIRMC
TSMCLI01   /wn001 DEFAULT


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Moyer, Joni M
Sent: Tuesday, March 02, 2010 2:21 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] How to find what management class is used per node

Hi,

I was just wondering if anyone knows a script that I can run to find out
what management class is utilized by node hmpg1018?  Would I need to run:
select * from backups where node_name='HMPG1018'?

Thanks in advance for any help

Joni Moyer
Storage Administrator III
(717)302-9966
joni.mo...@highmark.com



This e-mail and any attachments to it are confidential and are intended
solely for use of the individual or entity to whom they are addressed. If
you have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
keep, use, disclose, copy or distribute this e-mail without the author's
prior permission. The views expressed in this e-mail message do not
necessarily represent the views of Highmark Inc., its subsidiaries, or
affiliates.

How to find what management class is used per node

[Moyer, Joni M]

Hi,

I was just wondering if anyone knows a script that I can run to find out what 
management class is utilized by node hmpg1018?  Would I need to run: select * 
from backups where node_name='HMPG1018'?

Thanks in advance for any help

Joni Moyer
Storage Administrator III
(717)302-9966
joni.mo...@highmark.com



This e-mail and any attachments to it are confidential and are intended solely 
for use of the individual or entity to whom they are addressed. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this e-mail without the author's prior permission. 
The views expressed in this e-mail message do not necessarily represent the 
views of Highmark Inc., its subsidiaries, or affiliates.

Re: How to find what management class is used per node

[Remco Post]

On 2 mrt 2010, at 21:21, Moyer, Joni M wrote:

 Hi,
 
 I was just wondering if anyone knows a script that I can run to find out what 
 management class is utilized by node hmpg1018?  Would I need to run: select * 
 from backups where node_name='HMPG1018'?
 

on the node itself run 'dsmc q backup / -ina -subdir=y' 

(assuming unix, but you get the drift)

since each file can be bound to a different mgmt class, there is no such 
concept of a mgmt class used by a node, and the client is the proper place to 
run this query, not the server.


 Thanks in advance for any help
 
 Joni Moyer
 Storage Administrator III
 (717)302-9966
 joni.mo...@highmark.com

-- 
Met vriendelijke groeten/Kind Regards,

Remco Post
r.p...@plcs.nl
+31 6 248 21 622

Re: How to find what management class is used per node

[Huebschman, George J.]

Avoid that if you can.
You probably can.  If you can not, someone else will be able to.

* Normally the node uses the default management class for the domain;
then any MC specified by INCLUDE statements.

* Log onto the client and run q inclexcl.   The q inclexcl command
will show you all includes and excludes in the dsm.opt, inclexcl file,
or client option set.  Check the listing, looking for includes, then for
mgmt class names next to the includes.

* Also, directories will automatically use the management class with the
longest retention in the domain (unless the client is using a dirmc
option.)

You certainly can run a select against the largest of the tables, but it
should be done carefully.  Smart folks advise against it.  It is a very
intensive query.  If there are many objects for this client, try to
limit the query as much as possible by using index keys.  Try running
the select against one filespace at a time for example.  If you have
many filespaces and that seems to tedious, it is an indicator that you
need to do it!

I was just wondering if anyone knows a script that I can run to find out
what management class is utilized by node hmpg1018?  Would I need to
run: select * from backups where node_name='HMPG1018'?

George H

IMPORTANT:  E-mail sent through the Internet is not secure. Legg Mason 
therefore recommends that you do not send any confidential or sensitive 
information to us via electronic mail, including social security numbers, 
account numbers, or personal identification numbers. Delivery, and or timely 
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends 
that you do not send time sensitive 
or action-oriented messages to us via electronic mail.

This message is intended for the addressee only and may contain privileged or 
confidential information. Unless you are the intended recipient, you may not 
use, copy or disclose to anyone any information contained in this message. If 
you have received this message in error, please notify the author by replying 
to this message and then kindly delete the message. Thank you.

Re: How to find what management class is used per node

[Dwight Cook]

Try these:

select distinct node_name as Node Name   ,filespace_name as Filespace
Name,class_name as Management Class Name from backups
where TYPE='FILE' group by node_name,filespace_name,class_name

Node Name  Filespace Name Management
Class Name
-- --
-
TSMCLI01   /  DEFAULT
TSMCLI01   /home  DEFAULT
TSMCLI01   /opt   DEFAULT
TSMCLI01   /tmp   DEFAULT
TSMCLI01   /tsm   DEFAULT
TSMCLI01   /usr   DEFAULT
TSMCLI01   /var   DEFAULT
TSMCLI01   /wn001 DEFAULT

and the same for the archives table

you could always use the ~where node_name='HMPG1018'~ to limit the output to
just that node


select distinct node_name,filespace_name,class_name from backups group by
node_name,filespace_name,class_name

will show you everything, including directory information...

NODE_NAME  FILESPACE_NAME CLASS_NAME
-- -- --
TSMCLI01   /  B7.3_R35.95_A370_-
   DIRMC
TSMCLI01   /  DEFAULT
TSMCLI01   /home  B7.3_R35.95_A370_-
   DIRMC
TSMCLI01   /home  DEFAULT
...
TSMCLI01   /wn001 B7.3_R35.95_A370_-
   DIRMC
TSMCLI01   /wn001 DEFAULT


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Moyer, Joni M
Sent: Tuesday, March 02, 2010 2:21 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] How to find what management class is used per node

Hi,

I was just wondering if anyone knows a script that I can run to find out
what management class is utilized by node hmpg1018?  Would I need to run:
select * from backups where node_name='HMPG1018'?

Thanks in advance for any help

Joni Moyer
Storage Administrator III
(717)302-9966
joni.mo...@highmark.com



This e-mail and any attachments to it are confidential and are intended
solely for use of the individual or entity to whom they are addressed. If
you have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
keep, use, disclose, copy or distribute this e-mail without the author's
prior permission. The views expressed in this e-mail message do not
necessarily represent the views of Highmark Inc., its subsidiaries, or
affiliates.

How I find out how often and how has accessed a storagepool with restore requests

[Erwin Zavala]

How I find out how often and how has accessed a storagepool with
restore requests

How to find total size of certain file space

[Jiangxi Wazi]

Hi, Group,

Is there a script to get total size of certain file space.
e.g. Windows server, given server name and drive name, find out how much
backup/archive space is used on TSM?

Thank you,
J.

Re: How to find total size of certain file space

[Mark Stapleton]

query occupancy node_name stg=primary_stg_pool
 
--
Mark Stapleton ([EMAIL PROTECTED])
CDW Berbee
System engineer
7145 Boone Avenue North, Suite 140
Brooklyn Park MN 55428-1511
763-592-5963
www.berbee.com
 
 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
 Of Jiangxi Wazi
 Sent: Friday, November 21, 2008 9:41 AM
 To: ADSM-L@VM.MARIST.EDU
 Subject: [ADSM-L] How to find total size of certain file space
 
 Hi, Group,
 
 Is there a script to get total size of certain file space.
 e.g. Windows server, given server name and drive name, find out how
 much
 backup/archive space is used on TSM?
 
 Thank you,
 J.

How to find what tapes were created for a full backup to tape

[Joni Moyer]

Hello everyone,

Every weekend we run backups of our NAS environment with NDMP protocol.  We
create all of the onsite full backups and then the offsite backups run
following the completion of the full/onsites.  What I would like to know
is, how can I tell which tapes were created for our offsite full backups?
I have a separate node defined for the offsite backups:
NAS_SERVER_2_OFFSITE and it uses a storage pool of tape_ndmp_offsite.  Any
suggestions would be appreciated!


Joni Moyer
Highmark
Storage Systems, Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
[EMAIL PROTECTED]

How to find out backupversions for datasets with special extensio n

[VOJTA Othmar]

Hi to all,
has anybody a sql-query for datasets with extension for example JPG or MP3.
Output ideally with filesize?!

thanks

Re: How to find out if LAN-Free doesn't work

[David E Ehresman]

ANS9201W Lanfree path failed.
in the dsmerror.log

or wait for the phone call from the dba to say backups aren't working
because they took 4 times longer than normal.

 [EMAIL PROTECTED] 01/10/06 2:57 AM 
Hi,

we use LAN-Free backup for large DBs. Sometimes it happens that the
LAN-Free backup doesn't work and the backup goes the way over the LAN.
I'm
looking for an easy and quick possibility (message?) to find out, when
a
backup doesn't go over the preferred (LAN-free) way?

Regards winfried

Re: How to find out if LAN-Free doesn't work

[Miller, Daniel]

HmmMaybe this should be sent from you as you are PM?

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
David E Ehresman
Sent: Tuesday, January 10, 2006 9:14 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: How to find out if LAN-Free doesn't work

ANS9201W Lanfree path failed.
in the dsmerror.log

or wait for the phone call from the dba to say backups aren't working
because they took 4 times longer than normal.

 [EMAIL PROTECTED] 01/10/06 2:57 AM 
Hi,

we use LAN-Free backup for large DBs. Sometimes it happens that the
LAN-Free backup doesn't work and the backup goes the way over the LAN.
I'm
looking for an easy and quick possibility (message?) to find out, when
a
backup doesn't go over the preferred (LAN-free) way?

Regards winfried

__

The information contained in this message is intended only for the personal and 
confidential use of the recipient(s) named above. If the reader of this message 
is not the intended recipient or an agent responsible for delivering it to the 
intended recipient, you are hereby notified that you have received this 
document in error and that any review, dissemination, distribution, or copying 
of this message is strictly prohibited. If you have received this communication 
in error, please notify us immediately, and delete the original message.

Re: How to find out if LAN-Free doesn't work

[Sung Y Lee]

I think the easiest way is to query actlog for lanfree -- q actlog
begind=-2 s=lanfree. If the data was sent via lanfree, you should get
lanfree completion message.

Sung Y. Lee


ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/10/2006
09:14:14 AM:

 ANS9201W Lanfree path failed.
 in the dsmerror.log

 or wait for the phone call from the dba to say backups aren't working
 because they took 4 times longer than normal.

  [EMAIL PROTECTED] 01/10/06 2:57 AM 
 Hi,

 we use LAN-Free backup for large DBs. Sometimes it happens that the
 LAN-Free backup doesn't work and the backup goes the way over the LAN.
 I'm
 looking for an easy and quick possibility (message?) to find out, when
 a
 backup doesn't go over the preferred (LAN-free) way?

 Regards winfried

How to find out if LAN-Free doesn't work

[Winfried Heilmann]

Hi,

we use LAN-Free backup for large DBs. Sometimes it happens that the
LAN-Free backup doesn't work and the backup goes the way over the LAN. I'm
looking for an easy and quick possibility (message?) to find out, when a
backup doesn't go over the preferred (LAN-free) way?

Regards winfried

How to find the 3583 LTO FSC1/FSC2 error code explanations

[Zoltan Forray/AC/VCU]

I am looking for a document that deciphers/explains the FSC1/FSC2 error
codes I get for the LTO2 drive in the 3583 library.

I checked all local physical docs but could only find SAC codes (as well
as media type errors).

Google searchs found nothing.

Re: How to find the 3583 LTO FSC1/FSC2 error code explanations

[William Boyer]

SAC codes are in the 3583 setup and operator guide.


Bill Boyer
Some days you're the bug, some days you're the windshield - ??

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan 
Forray/AC/VCU
Sent: Tuesday, December 13, 2005 9:46 AM
To: ADSM-L@VM.MARIST.EDU
Subject: How to find the 3583 LTO FSC1/FSC2 error code explanations

I am looking for a document that deciphers/explains the FSC1/FSC2 error codes I 
get for the LTO2 drive in the 3583 library.

I checked all local physical docs but could only find SAC codes (as well as 
media type errors).

Google searchs found nothing.

Re: How to find the 3583 LTO FSC1/FSC2 error code explanations

[Zoltan Forray/AC/VCU]

Please reread my message.

I FOUND the SAC codes.I want the FSC1/FSC2 codes displayed when you
view the DRIVE LOGS !




William Boyer [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
12/13/2005 09:54 AM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU


To
ADSM-L@VM.MARIST.EDU
cc

Subject
Re: [ADSM-L] How to find the 3583 LTO FSC1/FSC2 error code explanations






SAC codes are in the 3583 setup and operator guide.


Bill Boyer
Some days you're the bug, some days you're the windshield - ??

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Tuesday, December 13, 2005 9:46 AM
To: ADSM-L@VM.MARIST.EDU
Subject: How to find the 3583 LTO FSC1/FSC2 error code explanations

I am looking for a document that deciphers/explains the FSC1/FSC2 error
codes I get for the LTO2 drive in the 3583 library.

I checked all local physical docs but could only find SAC codes (as well
as media type errors).

Google searchs found nothing.

Re: How to find out all drives in NT2000 using command line? Thanks

[Frank Tsao, email is [EMAIL PROTECTED]]

I had talked to several people and found that dumpcfg utility would
generate the data I am looking for.

Thanks for all your help and effort.

Frank Tsao
[EMAIL PROTECTED]
PAX 25803, 626-302-5803
FAX 626-302-7131



 Andrew Raibeck
 [EMAIL PROTECTED]
 OMTo
 Sent by: ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor  cc
 Manager
 [EMAIL PROTECTED] Subject
 .EDU Re: How to find out all drives in
   NT2000 using command line? Thanks

 04/25/2005 09:16
 AM


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







Hi Frank,

There is no command that I can think of that does this; you'd have to write
a program or script to do it. Here are sample script and C++ program (they
both do the same thing). If these are useful, tailor as you wish.

Regards,

Andy


WMI SCRIPT

' ListDrives.vbs
' Invoke by running
'
'cscript ListDrives.vbs
'
' from an OS command prompt.
strComputer = .

set objWMIService = GetObject(winmgmts: _
 {impersonationLevel=impersonate}!\\ _
 strComputer  \root\cimv2)

set disks = objWMIService.ExecQuery (select * from Win32_LogicalDisk)

for each objDisk in disks
   select case objDisk.DriveType
  case 0
 ' I would not normally expect to see this.
 Wscript.Echo objDisk.DeviceID   Unknown
  case 1
 Wscript.Echo objDisk.DeviceID   Invalid root path
  case 2
 Wscript.Echo objDisk.DeviceID   Removable
  case 3
 Wscript.Echo objDisk.DeviceID   Fixed
  case 4
 Wscript.Echo objDisk.DeviceID   Remote
  case 5
 Wscript.Echo objDisk.DeviceID   CD-ROM
  case 6
 Wscript.Echo objDisk.DeviceID   RAM disk
  case Else
 ' I would not normally expect to see this.
 Wscript.Echo objDisk.DeviceID   ??
   end select
next




C++ PROGRAM

/*
 ListDrive.cpp

 Compiled with Visual Studio .Net 2003 from an OS prompt as follows:

   cl /GX /Zi /O1 ListDrives.cpp /link /debug
*/
#include windows.h
#include cstdio
#include cmath
#include iostream

using namespace std;

int main()
{
   char  driveLetter[] = *:\\;
   DWORD drives= GetLogicalDrives();
   DWORD bit   = 0;

   if (!drives)
   {
  cout  ERROR: GetLogicalDrives() failed with rc 
GetLastError()  endl;
  return -1;
   }

   for (int i = 0, bit = 1; i != 26; i++, bit *= 2)
   {
  if (drives  bit)
  {
 cout  char('A' + i)  : ;
 driveLetter[0] = 'A' + i;

 switch (GetDriveType(driveLetter))
 {
case DRIVE_UNKNOWN:
   // I would not normally expect to see this.
   cout  Unknown;
   break;
case DRIVE_NO_ROOT_DIR:
   cout  Invalid root path;
   break;
case DRIVE_REMOVABLE:
   cout  Removable;
   break;
case DRIVE_FIXED:
   cout  Fixed;
   break;
case DRIVE_REMOTE:
   cout  Remote;
   break;
case DRIVE_CDROM:
   cout  CD-ROM;
   break;
case DRIVE_RAMDISK:
   cout  RAM disk;
   break;
default:
   // I would not normally expect to see this.
   cout  ??;
   break;
 }   // switch (...)

 cout  endl;
  }   // if (drives  bit)
   }   // for (...)

   cout  endl;

   return 0;
}


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-04-22
14:05:23:

 Frank Tsao
 [EMAIL PROTECTED]
 PAX 25803, 626-302-5803
 FAX 626-302-7131[attachment ListDrives.cpp deleted by Frank
Tsao/SCE/EIX]

Attachment ListDrives.vbs contains a potentially harmful file type
extension and was removed in accordance with IBM IT content security
practices.

Re: How to find out all drives in NT2000 using command line? Thanks

[Frank Tsao, email is [EMAIL PROTECTED]]

Thanks, Richards.

It is close but that is not what I am looking for.

I want to find drive letter installed on a NT2000 system.

For example, issue find_drive_of_all_systems will return results as

C:
E:
F:
J:
K:


Frank Tsao
[EMAIL PROTECTED]
PAX 25803, 626-302-5803
FAX 626-302-7131



 Richard Sims
 [EMAIL PROTECTED]
 Sent by: ADSM:To
 Dist Stor ADSM-L@VM.MARIST.EDU
 Manager   cc
 [EMAIL PROTECTED]
 .EDU Subject
   Re: How to find out all drives in
   NT2000 using command line? Thanks
 04/24/2005 04:27
 AM


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






Frank -

You may find the DevCon utility useful for Windows command line work:

http://support.microsoft.com/kb/q311272/

and  www.robvanderwoude.com/devcon.html

  Richard Sims

Re: How to find out all drives in NT2000 using command line? Thanks

[Andrew Raibeck]

Hi Frank,

There is no command that I can think
of that does this; you'd have to write a program or script to do it. Here
are sample script and C++ program (they both do the same thing). If these
are useful, tailor as you wish.

Regards,

Andy


WMI SCRIPT

' ListDrives.vbs
' Invoke by running
'
'  cscript ListDrives.vbs
'
' from an OS command prompt.
strComputer = .

set objWMIService = GetObject(winmgmts:
_
   {impersonationLevel=impersonate}!\\
_
   strComputer 
\root\cimv2)

set disks = objWMIService.ExecQuery
(select * from Win32_LogicalDisk)

for each objDisk in disks
 select case objDisk.DriveType
   case 0
'
I would not normally expect to see this.
Wscript.Echo
objDisk.DeviceID   Unknown
   case 1
Wscript.Echo
objDisk.DeviceID   Invalid root path
   case 2
Wscript.Echo
objDisk.DeviceID   Removable
   case 3
Wscript.Echo
objDisk.DeviceID   Fixed
   case 4
Wscript.Echo
objDisk.DeviceID   Remote
   case 5
Wscript.Echo
objDisk.DeviceID   CD-ROM
   case 6
Wscript.Echo
objDisk.DeviceID   RAM disk
   case Else
'
I would not normally expect to see this.
Wscript.Echo
objDisk.DeviceID   ??
 end select
next




C++ PROGRAM

/*
ListDrive.cpp

Compiled with Visual Studio .Net
2003 from an OS prompt as follows:

 cl /GX /Zi /O1 ListDrives.cpp
/link /debug
*/
#include windows.h
#include cstdio
#include cmath
#include iostream

using namespace std;

int main()
{
 char driveLetter[]
= *:\\;
 DWORD drives  
 = GetLogicalDrives();
 DWORD bit  
   = 0;

 if (!drives)
 {
   cout  ERROR:
GetLogicalDrives() failed with rc 
 
GetLastError()  endl;
   return -1;
 }

 for (int i = 0, bit = 1;
i != 26; i++, bit *= 2)
 {
   if (drives 
bit)
   {
cout
 char('A' + i)  : ;
driveLetter[0]
= 'A' + i;

switch
(GetDriveType(driveLetter))
{
 
case DRIVE_UNKNOWN:
 
 // I would not normally expect to see this.
 
 cout  Unknown;
 
 break;
 
case DRIVE_NO_ROOT_DIR:
 
 cout  Invalid root path;
 
 break;
 
case DRIVE_REMOVABLE:
 
 cout  Removable;
 
 break;
 
case DRIVE_FIXED:
 
 cout  Fixed;
 
 break;
 
case DRIVE_REMOTE:
 
 cout  Remote;
 
 break;
 
case DRIVE_CDROM:
 
 cout  CD-ROM;
 
 break;
 
case DRIVE_RAMDISK:
 
 cout  RAM disk;
 
 break;
 
default:
 
 // I would not normally expect to see this.
 
 cout  ??;
 
 break;
}
 // switch (...)

cout
 endl;
   }  // if
(drives  bit)
 }  // for (...)

 cout  endl;

 return 0;
}


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-04-22 14:05:23:

 Frank Tsao
 [EMAIL PROTECTED]
 PAX 25803, 626-302-5803
 FAX 626-302-7131


ListDrives.cpp
Description: Binary data


Attachment ListDrives.vbs contains a potentially harmful file type extension 
and was removed in accordance with IBM IT content security practices.

Re: How to find out all drives in NT2000 using command line? Thanks

[Richard Sims]

Frank -
You may find the DevCon utility useful for Windows command line work:
   http://support.microsoft.com/kb/q311272/
and  www.robvanderwoude.com/devcon.html
 Richard Sims

Re: How to find out all drives in NT2000 using command line? Thanks

[David E Ehresman]

q drive

 [EMAIL PROTECTED] 04/22/05 5:05 PM 
Frank Tsao
[EMAIL PROTECTED]
PAX 25803, 626-302-5803
FAX 626-302-7131

How to find out all drives in NT2000 using command line? Thanks

[Frank Tsao, email is [EMAIL PROTECTED]]

Frank Tsao
[EMAIL PROTECTED]
PAX 25803, 626-302-5803
FAX 626-302-7131

how to find out the date when a file became inactive??

[Lisa Laughlin]

Good morning *SMers!

Can anyone one help me out on this one?

I am severely brain impaired right now  I have a request from mgmt to see
if I can find out when a file became inactive (i.e., when it was deleted).
I am pretty sure I have a recollection of finding out this information
before, but am at an utter loss right now to remember how.

tia,

lisa

Re: how to find out the date when a file became inactive??

[Richard Sims]

Can anyone one help me out on this one?

I am severely brain impaired right now  I have a request from mgmt to see
if I can find out when a file became inactive (i.e., when it was deleted).
I am pretty sure I have a recollection of finding out this information
before, but am at an utter loss right now to remember how.

Lisa - Do a Select on the Backups table, where the DEACTIVATE_DATE
   tells the story.
(See  DEACTIVATE_DATE  in http://people.bu.edu/rbs/ADSM.QuickFacts)

  Richard Sims

Re: how to find out the date when a file became inactive??

[Lisa Laughlin]

Thanks Richard-- I was hoping it wasn't one of THOSE select statements-- I
started

tsm: TSM_HQ_2select deactivate_date, filespace_name, type, ll_name,
hl_name,dea
ctivate_date, class_name, state, backup_date,node_name from backups where
NODE_N
AME='GHDATA01DISKGROUP2' order by BACKUP_DATE

before I asked the list the question.  This is on a clustered, SAN, Windows
2000 server with way more than a million objects  about 800G of data on
it.  I am just hoping I don't crash the TSM server before the select
finishes!!


Perhaps I should have only include the HL_name for the filespace I was
interested in..



 Richard Sims
 [EMAIL PROTECTED]
 Sent by: ADSM:To
 Dist Stor [EMAIL PROTECTED]
 Manager   cc
 [EMAIL PROTECTED]
 .EDU Subject
   Re: how to find out the date when a
   file became inactive??
 06/08/2004 10:59
 AM


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






Can anyone one help me out on this one?

I am severely brain impaired right now  I have a request from mgmt to see
if I can find out when a file became inactive (i.e., when it was deleted).
I am pretty sure I have a recollection of finding out this information
before, but am at an utter loss right now to remember how.

Lisa - Do a Select on the Backups table, where the DEACTIVATE_DATE
   tells the story.
(See  DEACTIVATE_DATE  in http://people.bu.edu/rbs/ADSM.QuickFacts)

  Richard Sims

Re: how to find out the date when a file became inactive??

[Stapleton, Mark]

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of Lisa Laughlin
Thanks Richard-- I was hoping it wasn't one of THOSE select 
statements-- I started

tsm: TSM_HQ_2select deactivate_date, filespace_name, type, ll_name,
hl_name,dea
ctivate_date, class_name, state, backup_date,node_name from 
backups where
NODE_N
AME='GHDATA01DISKGROUP2' order by BACKUP_DATE

Also, try to limit the select by setting delimiters on the
filespace_name, type, and backup_date.

--
Mark Stapleton 

Re: how to find out the date when a file became inactive??

[Ben Bullock]

As far as I know. There is no easy way to get this other than
the nightly backup logs, which typically are not kept too long.

I think you would need to run a select on the DB to pull that
one out. It looks like it is in the backups table. Here is a look at the
fields and how they are formatted:

  NODE_NAME: ADMIN-SRVX
 FILESPACE_NAME: /var/run
   FILESPACE_ID: 5
  STATE: INACTIVE_VERSION
   TYPE: FILE
HL_NAME: /
LL_NAME: syslog-ng.pid
  OBJECT_ID: 637355388
BACKUP_DATE: 2004-01-02 17:11:56.00
DEACTIVATE_DATE: 2004-01-11 17:10:49.00
  OWNER: root
 CLASS_NAME: DEFAULT



Perhaps something like this would get it:

select FILESPACE_NAME, HL_NAME, LL_NAME, DEACTIVATE_DATE from backups
where node_name like 'CLIENT-NAME' and filespace_name like
'/file/space/name' and LL_NAME like file.name

Or... Perhaps I'm smoking crack and there is a much easier way
to get this information...

Ben


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Lisa Laughlin
Sent: Tuesday, June 08, 2004 9:53 AM
To: [EMAIL PROTECTED]
Subject: how to find out the date when a file became inactive??


Good morning *SMers!

Can anyone one help me out on this one?

I am severely brain impaired right now  I have a request from mgmt to
see if I can find out when a file became inactive (i.e., when it was
deleted). I am pretty sure I have a recollection of finding out this
information before, but am at an utter loss right now to remember how.

tia,

lisa

how to find out the managemnt class a file is bound to?

[Christian Wadl]

Hello,

Is there a (easy) way to check to which management class a file is bound..?
A kind of DB queryy maybe? (select * from ??? where mgmtclass=??? ..
something this way..)

Thanks for help

Chris

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.664 / Virus Database: 427 - Release Date: 21.04.2004

Re: how to find out the managemnt class a file is bound to?

[Adams, Matt (US - Hermitage)]

Quickest way is to open up the TSM Restore GUI and go to the file and
from there you can tell what mgmt class it is bound to.

 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Christian Wadl
Sent: Wednesday, April 21, 2004 3:47 PM
To: [EMAIL PROTECTED]
Subject: how to find out the managemnt class a file is bound to?

Hello,

Is there a (easy) way to check to which management class a file is
bound..?
A kind of DB queryy maybe? (select * from ??? where mgmtclass=??? ..
something this way..)

Thanks for help

Chris

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.664 / Virus Database: 427 - Release Date: 21.04.2004



This message (including any attachments) contains confidential information intended 
for a specific individual and purpose, and is protected by law.  If you are not the 
intended recipient, you should delete this message.  Any disclosure, copying, or 
distribution of this message, or the taking of any action based on it, is strictly 
prohibited.

Re: how to find out the managemnt class a file is bound to?

[Prather, Wanda]

Quickest way, if the client is handy, is to start the b/a client and open
the RESTORE window.

Navigate through the file tree until you can display the file.
Scroll to the far right of the window, and you will see the management
class.

Or:

select * from backups where node_name='NNN' and ll_name like
'%partialfilename%'
NN must be upper case
the % in the filename is a generic match.
The letters you put in to match are mixed-case for UNIX clients, must be ALL
UPPER CASE for Windows.

-Original Message-
From: Christian Wadl [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 4:47 PM
To: [EMAIL PROTECTED]
Subject: how to find out the managemnt class a file is bound to?


Hello,

Is there a (easy) way to check to which management class a file is bound..?
A kind of DB queryy maybe? (select * from ??? where mgmtclass=??? ..
something this way..)

Thanks for help

Chris

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.664 / Virus Database: 427 - Release Date: 21.04.2004

Re: how to find out the managemnt class a file is bound to?

[Bill Boyer]

I guess you could query the BACKUPS table, but that takes a long time.

The way I normally do it, I start the TSM client GUI (or web interface) and
go to restore. Find where the file(s) is/are and the management class is
displayed in one of the columns. You might have to scroll to the right to
see it. If you can't access that node, then from any node with TSM just run
the client with the -VIRTUALNODE= parameter to see the files for that node.

Bill Boyer
DSS, Inc.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Christian Wadl
Sent: Wednesday, April 21, 2004 4:47 PM
To: [EMAIL PROTECTED]
Subject: how to find out the managemnt class a file is bound to?


Hello,

Is there a (easy) way to check to which management class a file is bound..?
A kind of DB queryy maybe? (select * from ??? where mgmtclass=??? ..
something this way..)

Thanks for help

Chris

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.664 / Virus Database: 427 - Release Date: 21.04.2004

AW: how to find out the managemnt class a file is bound to? Done, Thanks!

[Christian Wadl]

No Client GUI here, so the select will do it...

Thanks!

---Disclaimer---

The information in this email is for the confidential use of the
individual(s) named above.
Review, dissemination or copying of this communication by anyone other than
the named
recipient(s) is not permitted.
If you have received this in error please notify us immediately. We have
taken all reasonable
precautions to ensure that any attachment has been swept for viruses.
However it is your
responsibility to ensure that it has been swept and checked by your own
anti-virus software
and we cannot accept liability.



-Urspr|ngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Auftrag von
Prather, Wanda
Gesendet: Mittwoch, 21. April 2004 22:54
An: [EMAIL PROTECTED]
Betreff: Re: how to find out the managemnt class a file is bound to?


Quickest way, if the client is handy, is to start the b/a client and open
the RESTORE window.

Navigate through the file tree until you can display the file.
Scroll to the far right of the window, and you will see the management
class.

Or:

select * from backups where node_name='NNN' and ll_name like
'%partialfilename%'
NN must be upper case
the % in the filename is a generic match.
The letters you put in to match are mixed-case for UNIX clients, must be ALL
UPPER CASE for Windows.

-Original Message-
From: Christian Wadl [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 4:47 PM
To: [EMAIL PROTECTED]
Subject: how to find out the managemnt class a file is bound to?


Hello,

Is there a (easy) way to check to which management class a file is bound..?
A kind of DB queryy maybe? (select * from ??? where mgmtclass=??? ..
something this way..)

Thanks for help

Chris

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.664 / Virus Database: 427 - Release Date: 21.04.2004
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.664 / Virus Database: 427 - Release Date: 21.04.2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.664 / Virus Database: 427 - Release Date: 21.04.2004

Re: AW: how to find out the managemnt class a file is bound to? Done, Thanks!

[Richard Sims]

No Client GUI here, so the select will do it...

Not needed...  Just do 'dsmc q backup ...'

   Richard Sims

How to find zero byte files that are backed up ?

[Cook, Dwight E]

OK, I've had a question put to me and so far I just don't know...
With such viruses, as the ones that zero out files under windows, is there
an easy way to see if TSM is holding any zero-byte files ? ? ?  (ie. check
from the TSM server for potentially infected client nodes...)

I tried testing under Unix (AIX) with a zero byte file and...
I thought that I might be able to look in the adsm.contents table for
file_size=0
but what I found is (two things)...
1) due to aggregates, the file size listed for most files is the
size of the aggregate
2) if you have a zero byte file, you won't even have an entry for it
in the adsm.contents table
The output of a show version doesn't list anything about filesize...

Anyone have any tricks to do such a discovery ? (of zero byte backed up
files)

Dwight

Re: How to find zero byte files that are backed up ?

[Del Hoobler]

Dwight,

I wanted to let you know that zero byte files on the TSM
Server are OK for some things. For example, DP for Domino and
DP for Exchange use zero byte files that contain meta data
necessary for their restores.

So, once you find a way to query for this, you should be aware
that you might find some legitimate zero byte files.

Then again... you probably already knew this!  :-)
But.. just in case people started querying their TSM Servers,
and seeing some of these zero byte files, I didn't want them
assuming they had a virus.

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

- Never cut what can be untied.
- Commit yourself to constant improvement.
===
 OK, I've had a question put to me and so far I just don't know...
 With such viruses, as the ones that zero out files under windows, is
there
 an easy way to see if TSM is holding any zero-byte files ? ? ?  (ie.
check
 from the TSM server for potentially infected client nodes...)

 I tried testing under Unix (AIX) with a zero byte file and...
 I thought that I might be able to look in the adsm.contents table for
 file_size=0
 but what I found is (two things)...
 1) due to aggregates, the file size listed for most files is the
 size of the aggregate
 2) if you have a zero byte file, you won't even have an entry for
it
 in the adsm.contents table
 The output of a show version doesn't list anything about filesize...

 Anyone have any tricks to do such a discovery ? (of zero byte backed up
 files)

Re: How to find zero byte files that are backed up ?

[Richard Sims]

OK, I've had a question put to me and so far I just don't know...
With such viruses, as the ones that zero out files under windows, is there
an easy way to see if TSM is holding any zero-byte files ? ? ?  (ie. check
from the TSM server for potentially infected client nodes...)

Sounds like one of those Dilbert manager assigned tasks...
TSM does not support the server administrator meddling with individual files,
not even to inspect their attributes: that can only be done from a client
compatible with the one which stored the files.
In any case, someone in your shop is flailing.  The real solution is for
the PCs there to rigorously employ and automatically run virus scanning
software.  Only in situ can viruses be properly detected and handled.

  Richard Sims, BU

How to find obsolete filespaces?

[Gerhard Rentschler]

Hi,
filespaces which no longer exist on the node will stay on the server
forever. As they may consume considerable resources on tape and in the
database, we regularly try to find such filespaces and ask the owner whether
they can be deleted or not. We use the field Last Backup Start date/time
of q filespace f=d or the corresponding field in the filespaces table.
Unfortunately, I learned from responses to a mail earlier this week that
this field is not always updated (for example not by selective backups).
Is there another way to find out obsolete filespaces?
Best regards
Gerhard

---
Gerhard Rentschleremail:[EMAIL PROTECTED]
Regional Computing Center tel.   ++49/711/685 5806
University of Stuttgart   fax:   ++49/711/682357
Allmandring 30a
D 70550
Stuttgart
Germany

how to find

[Thomas Denier]

 Is there a way to find  quickly which storagepool each client belongs to .?

The 'query occupancy' command will provide information on which storage
pools a client is currently using. If you use migration to shift backup
files from an initial destination pool to a long term pool, the query
command won't necessarily report the initial destination pool. The query
command won't warn of cases where a client could start using a new pool
any time because of changes in the include/exclude statements or because
of new files that match an include that did not apply to any previously
existing files.

Re: How to find out what data is on tape

[David Longo]

You probably had reclamations running that freed up these tapes.
They would be in a DRM state of vaultr unless someone had moved
them past that.  If they are truly scratch, there is no way to see what
they were.  If you do both a q vol and a q drm for each of
these tapes and get nothing, then there are scratch.

It'a always a good idea to do an inventory comparison between
what *Sm says is in vault and what offsite vendor says.  Tapes can
get misplaced for various reasons.  For all the automation of *SM,
this part (offsite excahnge) involves many manual steps.

I do an inventory about every two months and only find about 1 tape
out of place.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 08/01/01 10:23AM 
Yesterday I found 95 tapes in our offsite-location,
which don't belong to any storage-pools.

Normally the only two ways that a tape gets to the
offsite-location is, that it's a copy-storage pool
from our tape-pool, or it's a dbbackup-tape.

In our DRM-Environment there is a setting, which takes
care about the dbbackup tapes, so that they will stay
7 days in the offsite location before the ADSM-Server
wants them to be put back into the system.

Is there a possibility to find out what content is on
this tapes, which don't belong to any storage pools?
Further problem is that our volume-history and
activity-log only covers 2 weeks so in my opinion
there is no easy way to check for tapes to be reused
or for tapes with storage data.

Best regards
Martin Radel

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/ 



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

==

Re: How to find out what data is on tape

[Richard Sims]

Further problem is that our volume-history and
activity-log only covers 2 weeks so in my opinion
there is no easy way to check for tapes to be reused
or for tapes with storage data.

Perhaps you have a backup of the volhist backup file as
specified on your VOLUMEHistory server option, which
you could restore and examine?

Your plight is why I stress that Activity Log data *must*
be kept as long as the oldest-written tapes.  Keeping it
all in the TSM db is too much bloat: we use Q Actlog
to extract old data and save it in opsys disk files,
which we store in HSM.  We have 5 years worth, which
makes it easy to find out where a tape has been.

  Richard Sims, BU

how to find filename or node name

[Wu, Jie]

Hi all,
 I did a backup stg *** *** preview=yes and noticed that there is a
25G file in the primary storage pool, I am wondering if there is any way to
find out from which node the file is and what is its name. Thanks.

Jie

Re: how to find filename or node name

[Poland, Neil]

try "q cont stgpoolvolumename"

IE: "q vol /usr/lpp/adsmserv/pools/stgpool.pool"

-Original Message-
From: Wu, Jie [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 9:55 AM
To: [EMAIL PROTECTED]
Subject: how to find filename or node name


Hi all,
 I did a backup stg *** *** preview=yes and noticed that there is a
25G file in the primary storage pool, I am wondering if there is any way to
find out from which node the file is and what is its name. Thanks.

Jie

Re: How to find out what tape's a client data are on ?

[Bernhard Unold]

q occu
  or
select * from occupancy

Steve Hicks schrieb:
 
 What would the command be to show utilization of the tape vs. the client's
 data. With collocation turned off, this command doesn't help too much by
 itself. How would I query how much space is taken in my pool overall by one
 client?
 
 
 "Sharp, Neil
 (London)"  To: [EMAIL PROTECTED]
 SharpNei@EXCHANGE.cc:
 UK.ML.COM Subject:     Re: How to find out what 
tape's a client data are on ?
 Sent by: "ADSM:
 Dist Stor Manager"
 [EMAIL PROTECTED]
 DU
 
 
 03/02/01 07:31 AM
 Please respond to
 "ADSM: Dist Stor
 Manager"
 
 
 
 Thanks for the suggestion
 
  -Original Message-
  From: Bernhard Unold [SMTP:[EMAIL PROTECTED]]
  Sent: Friday, March 02, 2001 1:21 PM
  To:   [EMAIL PROTECTED]
  Subject:  Re: How to find out what tape's a client data are on ?
 
  I can't help with Sql, but i wonder, why do you need tapes from offsite
  for a client restore? Perhaps this will not help you now, but my
  suggestion is, to backup your storage pool(s) and put the backups
  offsite. So for the next restore you will not have to recall a tape at
  all from offsite. Ask me, if you want to know more.
 
  Allen Barth schrieb:
  
   While your statement is technically true Andy,  *SM does take the
  liberty
   of folding various fields to UPPER CASE which IMHO is just plain dumb.
   OOPS, forgot that mainframe heritage.
  
   Al Barth
   Zurich Scudder Investments
  
   Andy Raibeck
   Andrew_Raibeck@TTo:
  [EMAIL PROTECTED]
   IVOLI.COM   cc:
   Sent by: "ADSM:  Subject: Re: How to
  find out what tape's a client data are on ?
   Dist Stor
   Manager"
   [EMAIL PROTECTED]
   .EDU
  
   03/01/01 11:47 AM
   Please respond to
   "ADSM: Dist Stor
   Manager"
  
   This is not a case (no pun intended) of TSM being case-sensitive.
  Rather,
   it is the standard SQL "is equal to" operator, '=', that is case
  sensitive
   when comparing strings. This is per the SQL standard, and is not
  specific
   to TSM's SQL implementation.
  
   Regards,
  
   Andy
  
   Andy Raibeck
   IBM/Tivoli
   Tivoli Storage Manager Client Development
   e-mail: [EMAIL PROTECTED]
   "The only dumb question is the one that goes unasked."
  
   Shekhar Dhotre [EMAIL PROTECTED]@VM.MARIST.EDU on
 03/01/2001
   10:41:16 AM
  
   Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
   Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
   To:   [EMAIL PROTECTED]
   cc:
   Subject:  Re: How to find out what tape's a client data are on ?
  
   Thanks .Worked .. .. i was thinking that TSM is not case sensitive
   application
   .. hmm..
  
   Glen Churchfield [EMAIL PROTECTED]@VM.MARIST.EDU on
 03/01/2001
   11:57:38 AM
  
   Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
   Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
   To:   [EMAIL PROTECTED]
   cc:
  
   Subject:  Re: How to find out what tape's a client data are on ?
  
   Shekhar,
   Remember that the node name is case sensitive and is all caps.
  
   -Original Message-
   From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, March 01, 2001 11:40 AM
   To: [EMAIL PROTECTED]
   Subject: Re: How to find out what tape's a client data are on ?
  
   I am trying same command for the One of my AIX Box , that is getting
  backed
   up
   regularly .
   I am not getting any output .. IS anything wrong here ..
  
   tsm: TSMselect volume_name,node_name from volumeusage where
   node_name='medrs2'
group by volume_name,node_name
   ANR2034E SELECT: No match found using this criteria.
   ANS8001I Return code 11.
  
   "Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
   03/01/2001 11:02:07 AM
  
   Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
   Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
   To:   [EMAIL PROTECTED]
   cc:
  
   Subject:  Re: How to find out what tape's a client data are on ?
  
   Thanks for your help. It has answered my question.
  
   Neil
  
-Original Message-
    From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 12:47 PM
To:   [EMAIL PROTECTED]
Subject:  Re: How to find out what tape's a client data are on ?
   
Here is the SQL script :
   
select volum

Re: How to find out what tape's a client data are on ?

[Walker, Lesley R]

Andy Raibeck:
 Either way, I'm pretty sure that DISTINCT is supposed to
 account for distinct rows in their entirety, and not just certain columns.
 I'll have to look into this.

That's what I thought too.  My guess would be something to do with the SQL
interface not being direct to the database - something going missing in the
translation.

Anyway, it's good to know I'm not going mad.  :-)

In case you need to know, the system that produces these results is 3.7.4 on
Solaris, recently upgraded from an earlier 3.7 release.

Re: How to find out what tape's a client data are on ?

[Bernhard Unold]

I can't help with Sql, but i wonder, why do you need tapes from offsite
for a client restore? Perhaps this will not help you now, but my
suggestion is, to backup your storage pool(s) and put the backups
offsite. So for the next restore you will not have to recall a tape at
all from offsite. Ask me, if you want to know more.

Allen Barth schrieb:
 
 While your statement is technically true Andy,  *SM does take the liberty
 of folding various fields to UPPER CASE which IMHO is just plain dumb.
 OOPS, forgot that mainframe heritage.
 
 Al Barth
 Zurich Scudder Investments
 
 Andy Raibeck
 Andrew_Raibeck@TTo: [EMAIL PROTECTED]
 IVOLI.COM   cc:
 Sent by: "ADSM:  Subject: Re: How to find out what 
tape's a client data are on ?
 Dist Stor
 Manager"
 [EMAIL PROTECTED]
 .EDU
 
 03/01/01 11:47 AM
 Please respond to
 "ADSM: Dist Stor
 Manager"
 
 This is not a case (no pun intended) of TSM being case-sensitive. Rather,
 it is the standard SQL "is equal to" operator, '=', that is case sensitive
 when comparing strings. This is per the SQL standard, and is not specific
 to TSM's SQL implementation.
 
 Regards,
 
 Andy
 
 Andy Raibeck
 IBM/Tivoli
 Tivoli Storage Manager Client Development
 e-mail: [EMAIL PROTECTED]
 "The only dumb question is the one that goes unasked."
 
 Shekhar Dhotre [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001
 10:41:16 AM
 
 Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
 Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
 To:   [EMAIL PROTECTED]
 cc:
 Subject:  Re: How to find out what tape's a client data are on ?
 
 Thanks .Worked .. .. i was thinking that TSM is not case sensitive
 application
 .. hmm..
 
 Glen Churchfield [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001
 11:57:38 AM
 
 Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
 Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
 To:   [EMAIL PROTECTED]
 cc:
 
 Subject:  Re: How to find out what tape's a client data are on ?
 
 Shekhar,
 Remember that the node name is case sensitive and is all caps.
 
 -Original Message-
 From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 01, 2001 11:40 AM
 To: [EMAIL PROTECTED]
 Subject: Re: How to find out what tape's a client data are on ?
 
 I am trying same command for the One of my AIX Box , that is getting backed
 up
 regularly .
 I am not getting any output .. IS anything wrong here ..
 
 tsm: TSMselect volume_name,node_name from volumeusage where
 node_name='medrs2'
  group by volume_name,node_name
 ANR2034E SELECT: No match found using this criteria.
 ANS8001I Return code 11.
 
 "Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
 03/01/2001 11:02:07 AM
 
 Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
 Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
 To:   [EMAIL PROTECTED]
 cc:
 
 Subject:  Re: How to find out what tape's a client data are on ?
 
 Thanks for your help. It has answered my question.
 
 Neil
 
  -Original Message-
  From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
  Sent: Thursday, March 01, 2001 12:47 PM
  To:   [EMAIL PROTECTED]
  Subject:  Re: How to find out what tape's a client data are on ?
 
  Here is the SQL script :
 
  select volume_name,node_name from volumeusage where node_name='$1' group
  by volume_name,node_name
 
  Just give the server name as parameter 1
 
   Ruddy Stouder
  System Engineer
  I.R.I.S.
  Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
  B- 1435 Mont-Saint-Guibert
  [EMAIL PROTECTED]
  http://www.irislink.com
  Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40
 
 
  -Original Message-
  From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
  Sent: jeudi 1 mars 2001 13:44
  To: [EMAIL PROTECTED]
  Subject: How to find out what tape's a client data are on ?
 
 
  I have a frustrating situation whereby if I perform a client restore it
  may
  call a tape from off-site. This tape is then recalled (usually 4 hours)
  and
  then placed in the library. The restore then continues but then stalls
  again
  requesting another tape. What I need to find out up front are all the
  tapes
  that could possibly be requested for the client and recall all tapes. I
  can
  find this out by running 'q vol client=X' but I have 2000 tapes to
  search
  and this will take a long time even if scripted . I think that what I
  need
  is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
  shortly)
 
  Thanks for your time.
 
  Neil Sharp
  Merrill Lynch ADSM/TSM Administrator
  Work : 020-7573-0469
  Mobile : 07769-741612
  Pager : 

Re: How to find out what tape's a client data are on ?

[Sharp, Neil (London)]

Thanks for the suggestion

 -Original Message-
 From: Bernhard Unold [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, March 02, 2001 1:21 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?
 
 I can't help with Sql, but i wonder, why do you need tapes from offsite
 for a client restore? Perhaps this will not help you now, but my
 suggestion is, to backup your storage pool(s) and put the backups
 offsite. So for the next restore you will not have to recall a tape at
 all from offsite. Ask me, if you want to know more.
 
 Allen Barth schrieb:
  
  While your statement is technically true Andy,  *SM does take the
 liberty
  of folding various fields to UPPER CASE which IMHO is just plain dumb.
  OOPS, forgot that mainframe heritage.
  
  Al Barth
  Zurich Scudder Investments
  
  Andy Raibeck
  Andrew_Raibeck@TTo:
 [EMAIL PROTECTED]
  IVOLI.COM   cc:
  Sent by: "ADSM:  Subject: Re: How to
 find out what tape's a client data are on ?
  Dist Stor
  Manager"
  [EMAIL PROTECTED]
  .EDU
  
  03/01/01 11:47 AM
  Please respond to
  "ADSM: Dist Stor
  Manager"
  
  This is not a case (no pun intended) of TSM being case-sensitive.
 Rather,
  it is the standard SQL "is equal to" operator, '=', that is case
 sensitive
  when comparing strings. This is per the SQL standard, and is not
 specific
  to TSM's SQL implementation.
  
  Regards,
  
  Andy
  
  Andy Raibeck
  IBM/Tivoli
  Tivoli Storage Manager Client Development
  e-mail: [EMAIL PROTECTED]
  "The only dumb question is the one that goes unasked."
  
  Shekhar Dhotre [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001
  10:41:16 AM
  
  Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
  Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
  To:   [EMAIL PROTECTED]
  cc:
  Subject:  Re: How to find out what tape's a client data are on ?
  
  Thanks .Worked .. .. i was thinking that TSM is not case sensitive
  application
  .. hmm..
  
  Glen Churchfield [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001
  11:57:38 AM
  
  Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
  Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
  To:   [EMAIL PROTECTED]
  cc:
  
  Subject:  Re: How to find out what tape's a client data are on ?
  
  Shekhar,
  Remember that the node name is case sensitive and is all caps.
  
  -Original Message-
  From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, March 01, 2001 11:40 AM
  To: [EMAIL PROTECTED]
  Subject: Re: How to find out what tape's a client data are on ?
  
  I am trying same command for the One of my AIX Box , that is getting
 backed
  up
  regularly .
  I am not getting any output .. IS anything wrong here ..
  
  tsm: TSMselect volume_name,node_name from volumeusage where
  node_name='medrs2'
   group by volume_name,node_name
  ANR2034E SELECT: No match found using this criteria.
  ANS8001I Return code 11.
  
  "Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
  03/01/2001 11:02:07 AM
  
  Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
  Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
  
  To:   [EMAIL PROTECTED]
  cc:
  
  Subject:  Re: How to find out what tape's a client data are on ?
  
  Thanks for your help. It has answered my question.
  
  Neil
  
   -Original Message-
   From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
   Sent: Thursday, March 01, 2001 12:47 PM
   To:   [EMAIL PROTECTED]
   Subject:  Re: How to find out what tape's a client data are on ?
  
   Here is the SQL script :
  
   select volume_name,node_name from volumeusage where node_name='$1'
 group
   by volume_name,node_name
  
   Just give the server name as parameter 1
  
Ruddy Stouder
   System Engineer
   I.R.I.S.
   Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
   B- 1435 Mont-Saint-Guibert
   [EMAIL PROTECTED]
   http://www.irislink.com
   Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40
  
  
   -Original Message-
   From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
   Sent: jeudi 1 mars 2001 13:44
   To: [EMAIL PROTECTED]
   Subject: How to find out what tape's a client data are on ?
  
  
   I have a frustrating situation whereby if I perform a client restore
 it
   may
   call a tape from off-site. This tape is then recalled (usually 4
 hours)
   and
   then placed in the library. The restore then continues but then stalls
   again
   requesting another tape. What I need to find out up front are all the
   tapes
   that could possibly be requested for the client and recall all tapes.
 I
   ca

Re: How to find out what tape's a client data are on ?

[Steve Hicks]

What would the command be to show utilization of the tape vs. the client's
data. With collocation turned off, this command doesn't help too much by
itself. How would I query how much space is taken in my pool overall by one
client?


   
  
"Sharp, Neil   
  
(London)"  To: [EMAIL PROTECTED]
  
SharpNei@EXCHANGE.cc: 
  
UK.ML.COM Subject:     Re: How to find out what 
tape's a client data are on ?   
Sent by: "ADSM:
  
Dist Stor Manager" 
  
[EMAIL PROTECTED]
  
DU
  
   
  
   
  
03/02/01 07:31 AM  
  
Please respond to  
  
"ADSM: Dist Stor   
  
Manager"   
  
   
  
   
  




Thanks for the suggestion

 -Original Message-
 From: Bernhard Unold [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, March 02, 2001 1:21 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 I can't help with Sql, but i wonder, why do you need tapes from offsite
 for a client restore? Perhaps this will not help you now, but my
 suggestion is, to backup your storage pool(s) and put the backups
 offsite. So for the next restore you will not have to recall a tape at
 all from offsite. Ask me, if you want to know more.

 Allen Barth schrieb:
 
  While your statement is technically true Andy,  *SM does take the
 liberty
  of folding various fields to UPPER CASE which IMHO is just plain dumb.
  OOPS, forgot that mainframe heritage.
 
  Al Barth
  Zurich Scudder Investments
 
  Andy Raibeck
  Andrew_Raibeck@TTo:
 [EMAIL PROTECTED]
  IVOLI.COM   cc:
  Sent by: "ADSM:  Subject: Re: How to
 find out what tape's a client data are on ?
  Dist Stor
  Manager"
  [EMAIL PROTECTED]
  .EDU
 
  03/01/01 11:47 AM
  Please respond to
  "ADSM: Dist Stor
  Manager"
 
  This is not a case (no pun intended) of TSM being case-sensitive.
 Rather,
  it is the standard SQL "is equal to" operator, '=', that is case
 sensitive
  when comparing strings. This is per the SQL standard, and is not
 specific
  to TSM's SQL implementation.
 
  Regards,
 
  Andy
 
  Andy Raibeck
  IBM/Tivoli
  Tivoli Storage Manager Client Development
  e-mail: [EMAIL PROTECTED]
  "The only dumb question is the one that goes unasked."
 
  Shekhar Dhotre [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001
  10:41:16 AM
 
  Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  To:   [EMAIL PROTECTED]
  cc:
  Subject:  Re: How to find out what tape's a client data are on ?
 
  Thanks .Worked .. .. i was thinking that TSM is not case sensitive
  application
  .. hmm..
 
  Glen Churchfield [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001
  11:57:38 AM
 
  Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  To:   [EMAIL PROTECTED]
  cc:
 
  Subject:  Re: How to find out what tape's a client data are on ?
 
  Shekhar,
  Remember that 

Re: How to find out what tape's a client data are on ?

[Andy Raibeck]

H that doesn't look right to me, either. Just from observation, it
looks as if the DISTINCT keyword is operating on either the first column in
the result set, or maybe the sorting key, since you are now sorting by
storage pool name. Either way, I'm pretty sure that DISTINCT is supposed to
account for distinct rows in their entirety, and not just certain columns.
I'll have to look into this.

Regards,

Andy

Andy Raibeck
IBM Tivoli Systems
Tivoli Storage Manager Client Development
e-mail: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."


"Walker, Lesley R" [EMAIL PROTECTED]@VM.MARIST.EDU on 03/02/2001
11:16:27 AM

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

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


To:   [EMAIL PROTECTED]
cc:
Subject:  Re: How to find out what tape's a client data are on ?



 Just out of curiosity, since I've only casually been following
 this thread, was there a specific reason for the "group by"
 clause?

 I think what is desired is simplly an "order by" clause, e.g.

Well, I'm really confused now.

I came up with my own version of the query:

select distinct volume_name,stgpool_name
from volumeusage
where node_name='FOO'

and that produces an answer:

VOLUME_NAMESTGPOOL_NAME
-- --
ITF010 CPITFPOOL
ITF013 CPITFPOOL
ITF018 CPITFPOOL
ITF026 CPITFPOOL
ITF001 ITFPOOL
ITF003 ITFPOOL
ITF004 ITFPOOL
ITF014 ITFPOOL
ITF025 ITFPOOL
ITF027 ITFPOOL
ITF028 CPITFPOOL
ITF006 ITFPOOL
ITF002 CPITFPOOL

BUT if I add "order by stgpool_name" it doesn't show all the tapes - eg:

VOLUME_NAMESTGPOOL_NAME
-- --
ITF010 CPITFPOOL
ITF001 ITFPOOL

So what's going on here?

Re: How to find out what tape's a client data are on ?

[Prather, Wanda]

I use this:
select stgpool_name, sum(physical_mb)  from occupancy where
node_name='XX' group by stgpool_name

-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 8:58 AM
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?


What would the command be to show utilization of the tape vs. the client's
data. With collocation turned off, this command doesn't help too much by
itself. How would I query how much space is taken in my pool overall by one
client?




"Sharp, Neil

(London)"  To: [EMAIL PROTECTED]

SharpNei@EXCHANGE.cc:

UK.ML.COM Subject:     Re: How to find
out what tape's a client data are on ?
Sent by: "ADSM:

Dist Stor Manager"

[EMAIL PROTECTED]

DU





03/02/01 07:31 AM

Please respond to

"ADSM: Dist Stor

Manager"









Thanks for the suggestion

 -Original Message-
 From: Bernhard Unold [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, March 02, 2001 1:21 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 I can't help with Sql, but i wonder, why do you need tapes from offsite
 for a client restore? Perhaps this will not help you now, but my
 suggestion is, to backup your storage pool(s) and put the backups
 offsite. So for the next restore you will not have to recall a tape at
 all from offsite. Ask me, if you want to know more.

 Allen Barth schrieb:
 
  While your statement is technically true Andy,  *SM does take the
 liberty
  of folding various fields to UPPER CASE which IMHO is just plain dumb.
  OOPS, forgot that mainframe heritage.
 
  Al Barth
  Zurich Scudder Investments
 
  Andy Raibeck
  Andrew_Raibeck@TTo:
 [EMAIL PROTECTED]
  IVOLI.COM   cc:
  Sent by: "ADSM:  Subject: Re: How to
 find out what tape's a client data are on ?
  Dist Stor
  Manager"
  [EMAIL PROTECTED]
  .EDU
 
  03/01/01 11:47 AM
  Please respond to
  "ADSM: Dist Stor
  Manager"
 
  This is not a case (no pun intended) of TSM being case-sensitive.
 Rather,
  it is the standard SQL "is equal to" operator, '=', that is case
 sensitive
  when comparing strings. This is per the SQL standard, and is not
 specific
  to TSM's SQL implementation.
 
  Regards,
 
  Andy
 
  Andy Raibeck
  IBM/Tivoli
  Tivoli Storage Manager Client Development
  e-mail: [EMAIL PROTECTED]
  "The only dumb question is the one that goes unasked."
 
  Shekhar Dhotre [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001
  10:41:16 AM
 
  Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  To:   [EMAIL PROTECTED]
  cc:
  Subject:  Re: How to find out what tape's a client data are on ?
 
  Thanks .Worked .. .. i was thinking that TSM is not case sensitive
  application
  .. hmm..
 
  Glen Churchfield [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001
  11:57:38 AM
 
  Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  To:   [EMAIL PROTECTED]
  cc:
 
  Subject:  Re: How to find out what tape's a client data are on ?
 
  Shekhar,
  Remember that the node name is case sensitive and is all caps.
 
  -Original Message-
  From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, March 01, 2001 11:40 AM
  To: [EMAIL PROTECTED]
  Subject: Re: How to find out what tape's a client data are on ?
 
  I am trying same command for the One of my AIX Box , that is getting
 backed
  up
  regularly .
  I am not getting any output .. IS anything wrong here ..
 
  tsm: TSMselect volume_name,node_name from volumeusage where
  node_name='medrs2'
   group by volume_name,node_name
  ANR2034E SELECT: No match found using this criteria.
  ANS8001I Return code 11.
 
  "Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
  03/01/2001 11:02:07 AM
 
  Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  Sent by:  "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
 
  To:   [EMAIL PROTECTED]
  cc:
 
  Subject:  Re: How to find out what tape's a client data are on ?
 
  Thanks for your help. It has answered my question.
 
  Neil
 
   -Original Message-
   From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
   Sent: Thursday, March 01, 2001 12:47 PM
   To:   [EMAIL PROTECTED]
   Subject:  Re:

How to find out what tape's a client data are on ?

[Sharp, Neil (London)]

I have a frustrating situation whereby if I perform a client restore it may
call a tape from off-site. This tape is then recalled (usually 4 hours) and
then placed in the library. The restore then continues but then stalls again
requesting another tape. What I need to find out up front are all the tapes
that could possibly be requested for the client and recall all tapes. I can
find this out by running 'q vol client=X' but I have 2000 tapes to search
and this will take a long time even if scripted . I think that what I need
is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading shortly)

Thanks for your time.

Neil Sharp
Merrill Lynch ADSM/TSM Administrator
Work : 020-7573-0469
Mobile : 07769-741612
Pager : 01893-038277
e-mail : [EMAIL PROTECTED]

Re: How to find out what tape's a client data are on ?

[Thierry ITTY]

you can try :

dsmadmc -id=YOURNAME -pass=YOURPASS -outfile \
"select distinct(volume_name) \
from volumeusage \
where node_name='YOURNODE'"

hth


A 12:43 01/03/2001 -, vous avez crit :
I have a frustrating situation whereby if I perform a client restore it may
call a tape from off-site. This tape is then recalled (usually 4 hours) and
then placed in the library. The restore then continues but then stalls again
requesting another tape. What I need to find out up front are all the tapes
that could possibly be requested for the client and recall all tapes. I can
find this out by running 'q vol client=X' but I have 2000 tapes to search
and this will take a long time even if scripted . I think that what I need
is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading shortly)

Thanks for your time.

Neil Sharp
Merrill Lynch ADSM/TSM Administrator
Work : 020-7573-0469
Mobile : 07769-741612
Pager : 01893-038277
e-mail : [EMAIL PROTECTED]


- * - * - * - * - * - * -
Mes idees n'engagent que moi (vieux proverbe du Net)

Thierry ITTY
eMail : [EMAIL PROTECTED]   FRANCE

Re: How to find out what tape's a client data are on ?

[Ruddy STOUDER]

Here is the SQL script :

select volume_name,node_name from volumeusage where node_name='$1' group
by volume_name,node_name

Just give the server name as parameter 1

 Ruddy Stouder
System Engineer
I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
B- 1435 Mont-Saint-Guibert
[EMAIL PROTECTED]
http://www.irislink.com
Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


-Original Message-
From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
Sent: jeudi 1 mars 2001 13:44
To: [EMAIL PROTECTED]
Subject: How to find out what tape's a client data are on ?


I have a frustrating situation whereby if I perform a client restore it
may
call a tape from off-site. This tape is then recalled (usually 4 hours)
and
then placed in the library. The restore then continues but then stalls
again
requesting another tape. What I need to find out up front are all the
tapes
that could possibly be requested for the client and recall all tapes. I
can
find this out by running 'q vol client=X' but I have 2000 tapes to
search
and this will take a long time even if scripted . I think that what I
need
is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
shortly)

Thanks for your time.

Neil Sharp
Merrill Lynch ADSM/TSM Administrator
Work : 020-7573-0469
Mobile : 07769-741612
Pager : 01893-038277
e-mail : [EMAIL PROTECTED]

Re: How to find out what tape's a client data are on ?

[Sharp, Neil (London)]

Thanks for your help. It has answered my question.

Neil

 -Original Message-
 From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 01, 2001 12:47 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 Here is the SQL script :

 select volume_name,node_name from volumeusage where node_name='$1' group
 by volume_name,node_name

 Just give the server name as parameter 1

  Ruddy Stouder
 System Engineer
 I.R.I.S.
 Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
 B- 1435 Mont-Saint-Guibert
 [EMAIL PROTECTED]
 http://www.irislink.com
 Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


 -Original Message-
 From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
 Sent: jeudi 1 mars 2001 13:44
 To: [EMAIL PROTECTED]
 Subject: How to find out what tape's a client data are on ?


 I have a frustrating situation whereby if I perform a client restore it
 may
 call a tape from off-site. This tape is then recalled (usually 4 hours)
 and
 then placed in the library. The restore then continues but then stalls
 again
 requesting another tape. What I need to find out up front are all the
 tapes
 that could possibly be requested for the client and recall all tapes. I
 can
 find this out by running 'q vol client=X' but I have 2000 tapes to
 search
 and this will take a long time even if scripted . I think that what I
 need
 is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
 shortly)

 Thanks for your time.

 Neil Sharp
 Merrill Lynch ADSM/TSM Administrator
 Work : 020-7573-0469
 Mobile : 07769-741612
 Pager : 01893-038277
 e-mail : [EMAIL PROTECTED]

Re: How to find out what tape's a client data are on ?

[Shekhar Dhotre]

I am trying same command for the One of my AIX Box , that is getting backed up
regularly .
I am not getting any output .. IS anything wrong here ..

tsm: TSMselect volume_name,node_name from volumeusage where node_name='medrs2'
 group by volume_name,node_name
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.





"Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001 11:02:07 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Thanks for your help. It has answered my question.

Neil

 -Original Message-
 From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 01, 2001 12:47 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 Here is the SQL script :

 select volume_name,node_name from volumeusage where node_name='$1' group
 by volume_name,node_name

 Just give the server name as parameter 1

  Ruddy Stouder
 System Engineer
 I.R.I.S.
 Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
 B- 1435 Mont-Saint-Guibert
 [EMAIL PROTECTED]
 http://www.irislink.com
 Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


 -Original Message-
 From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
 Sent: jeudi 1 mars 2001 13:44
 To: [EMAIL PROTECTED]
 Subject: How to find out what tape's a client data are on ?


 I have a frustrating situation whereby if I perform a client restore it
 may
 call a tape from off-site. This tape is then recalled (usually 4 hours)
 and
 then placed in the library. The restore then continues but then stalls
 again
 requesting another tape. What I need to find out up front are all the
 tapes
 that could possibly be requested for the client and recall all tapes. I
 can
 find this out by running 'q vol client=X' but I have 2000 tapes to
 search
 and this will take a long time even if scripted . I think that what I
 need
 is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
 shortly)

 Thanks for your time.

 Neil Sharp
 Merrill Lynch ADSM/TSM Administrator
 Work : 020-7573-0469
 Mobile : 07769-741612
 Pager : 01893-038277
 e-mail : [EMAIL PROTECTED]


 $RFC822.eml

Re: How to find out what tape's a client data are on ?

[MORGAN TONY]

Try the nodename in UPPERCASE... It cut/pasted fine on my box. (4.1.1.2)

-Original Message-
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2001 16:40
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?



I am trying same command for the One of my AIX Box , that is getting backed
up
regularly .
I am not getting any output .. IS anything wrong here ..

tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
 group by volume_name,node_name
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.





"Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001 11:02:07 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Thanks for your help. It has answered my question.

Neil

 -Original Message-
 From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 01, 2001 12:47 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 Here is the SQL script :

 select volume_name,node_name from volumeusage where node_name='$1' group
 by volume_name,node_name

 Just give the server name as parameter 1

  Ruddy Stouder
 System Engineer
 I.R.I.S.
 Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
 B- 1435 Mont-Saint-Guibert
 [EMAIL PROTECTED]
 http://www.irislink.com
 Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


 -Original Message-
 From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
 Sent: jeudi 1 mars 2001 13:44
 To: [EMAIL PROTECTED]
 Subject: How to find out what tape's a client data are on ?


 I have a frustrating situation whereby if I perform a client restore it
 may
 call a tape from off-site. This tape is then recalled (usually 4 hours)
 and
 then placed in the library. The restore then continues but then stalls
 again
 requesting another tape. What I need to find out up front are all the
 tapes
 that could possibly be requested for the client and recall all tapes. I
 can
 find this out by running 'q vol client=X' but I have 2000 tapes to
 search
 and this will take a long time even if scripted . I think that what I
 need
 is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
 shortly)

 Thanks for your time.

 Neil Sharp
 Merrill Lynch ADSM/TSM Administrator
 Work : 020-7573-0469
 Mobile : 07769-741612
 Pager : 01893-038277
 e-mail : [EMAIL PROTECTED]

Re: How to find out what tape's a client data are on ?

[David Longo]

This is case sensitive.  Your node name is probably MEDRS2.  Node names (and some 
other fields) are translated to ALL UPPER CASE when stored regardless of case when 
entered.

Query commands don't care about case, select statements do.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 11:39AM 

I am trying same command for the One of my AIX Box , that is getting backed up
regularly .
I am not getting any output .. IS anything wrong here ..

tsm: TSMselect volume_name,node_name from volumeusage where node_name='medrs2'
 group by volume_name,node_name
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.





"Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001 11:02:07 AM

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

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


To:   [EMAIL PROTECTED] 
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Thanks for your help. It has answered my question.

Neil

 -Original Message-
 From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]] 
 Sent: Thursday, March 01, 2001 12:47 PM
 To:   [EMAIL PROTECTED] 
 Subject:  Re: How to find out what tape's a client data are on ?

 Here is the SQL script :

 select volume_name,node_name from volumeusage where node_name='$1' group
 by volume_name,node_name

 Just give the server name as parameter 1

  Ruddy Stouder
 System Engineer
 I.R.I.S.
 Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
 B- 1435 Mont-Saint-Guibert
 [EMAIL PROTECTED] 
 http://www.irislink.com 
 Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


 -Original Message-
 From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]] 
 Sent: jeudi 1 mars 2001 13:44
 To: [EMAIL PROTECTED] 
 Subject: How to find out what tape's a client data are on ?


 I have a frustrating situation whereby if I perform a client restore it
 may
 call a tape from off-site. This tape is then recalled (usually 4 hours)
 and
 then placed in the library. The restore then continues but then stalls
 again
 requesting another tape. What I need to find out up front are all the
 tapes
 that could possibly be requested for the client and recall all tapes. I
 can
 find this out by running 'q vol client=X' but I have 2000 tapes to
 search
 and this will take a long time even if scripted . I think that what I
 need
 is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
 shortly)

 Thanks for your time.

 Neil Sharp
 Merrill Lynch ADSM/TSM Administrator
 Work : 020-7573-0469
 Mobile : 07769-741612
 Pager : 01893-038277
 e-mail : [EMAIL PROTECTED] 



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

Ý==

Re: How to find out what tape's a client data are on ?

[Kent J. Monthei]

Use upper-case within the single quotes for the node_name.





[EMAIL PROTECTED] on 01-Mar-2001 11:39



Please respond to [EMAIL PROTECTED]

To:   ADSM-L
cc:(bcc: Kent J Monthei/CIS/PHRD/SB_PLC)
Subject:  Re: How to find out what tape's a client data are on ?





I am trying same command for the One of my AIX Box , that is getting backed up
regularly .
I am not getting any output .. IS anything wrong here ..

tsm: TSMselect volume_name,node_name from volumeusage where node_name='medrs2'
 group by volume_name,node_name
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.





"Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001 11:02:07 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Thanks for your help. It has answered my question.

Neil

 -Original Message-
 From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 01, 2001 12:47 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 Here is the SQL script :

 select volume_name,node_name from volumeusage where node_name='$1' group
 by volume_name,node_name

 Just give the server name as parameter 1

  Ruddy Stouder
 System Engineer
 I.R.I.S.
 Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
 B- 1435 Mont-Saint-Guibert
 [EMAIL PROTECTED]
 http://www.irislink.com
 Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


 -Original Message-
 From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
 Sent: jeudi 1 mars 2001 13:44
 To: [EMAIL PROTECTED]
 Subject: How to find out what tape's a client data are on ?


 I have a frustrating situation whereby if I perform a client restore it
 may
 call a tape from off-site. This tape is then recalled (usually 4 hours)
 and
 then placed in the library. The restore then continues but then stalls
 again
 requesting another tape. What I need to find out up front are all the
 tapes
 that could possibly be requested for the client and recall all tapes. I
 can
 find this out by running 'q vol client=X' but I have 2000 tapes to
 search
 and this will take a long time even if scripted . I think that what I
 need
 is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
 shortly)

 Thanks for your time.

 Neil Sharp
 Merrill Lynch ADSM/TSM Administrator
 Work : 020-7573-0469
 Mobile : 07769-741612
 Pager : 01893-038277
 e-mail : [EMAIL PROTECTED]



 $RFC822.eml

Re: How to find out what tape's a client data are on ?

[Glen Churchfield]

Shekhar,
Remember that the node name is case sensitive and is all caps.

-Original Message-
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:40 AM
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?



I am trying same command for the One of my AIX Box , that is getting backed
up
regularly .
I am not getting any output .. IS anything wrong here ..

tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
 group by volume_name,node_name
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.





"Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001 11:02:07 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Thanks for your help. It has answered my question.

Neil

 -Original Message-
 From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 01, 2001 12:47 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 Here is the SQL script :

 select volume_name,node_name from volumeusage where node_name='$1' group
 by volume_name,node_name

 Just give the server name as parameter 1

  Ruddy Stouder
 System Engineer
 I.R.I.S.
 Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
 B- 1435 Mont-Saint-Guibert
 [EMAIL PROTECTED]
 http://www.irislink.com
 Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


 -Original Message-
 From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
 Sent: jeudi 1 mars 2001 13:44
 To: [EMAIL PROTECTED]
 Subject: How to find out what tape's a client data are on ?


 I have a frustrating situation whereby if I perform a client restore it
 may
 call a tape from off-site. This tape is then recalled (usually 4 hours)
 and
 then placed in the library. The restore then continues but then stalls
 again
 requesting another tape. What I need to find out up front are all the
 tapes
 that could possibly be requested for the client and recall all tapes. I
 can
 find this out by running 'q vol client=X' but I have 2000 tapes to
 search
 and this will take a long time even if scripted . I think that what I
 need
 is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
 shortly)

 Thanks for your time.

 Neil Sharp
 Merrill Lynch ADSM/TSM Administrator
 Work : 020-7573-0469
 Mobile : 07769-741612
 Pager : 01893-038277
 e-mail : [EMAIL PROTECTED]

Re: How to find out what tape's a client data are on ?

[Maria Paz Gimeno]

The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
Subject: Re: How to find out what tape's a client data are on ?



 I am trying same command for the One of my AIX Box , that is getting
backed up
 regularly .
 I am not getting any output .. IS anything wrong here ..

 tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
  group by volume_name,node_name
 ANR2034E SELECT: No match found using this criteria.
 ANS8001I Return code 11.

Re: How to find out what tape's a client data are on ?

[Shekhar Dhotre]

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

:-)  :-)thanks ...  Is it showing me offsite (Copypool) tapes in this query ?




Maria Paz Gimeno [EMAIL PROTECTED]@VM.MARIST.EDU on 02/28/2001 12:14:39 PM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
Subject: Re: How to find out what tape's a client data are on ?



 I am trying same command for the One of my AIX Box , that is getting
backed up
 regularly .
 I am not getting any output .. IS anything wrong here ..

 tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
  group by volume_name,node_name
 ANR2034E SELECT: No match found using this criteria.
 ANS8001I Return code 11.


 $RFC822.eml

Re: How to find out what tape's a client data are on ?

[Shekhar Dhotre]

Thanks .Worked .. .. i was thinking that TSM is not case sensitive application
.. hmm..




Glen Churchfield [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001
11:57:38 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Shekhar,
Remember that the node name is case sensitive and is all caps.

-Original Message-
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:40 AM
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?



I am trying same command for the One of my AIX Box , that is getting backed
up
regularly .
I am not getting any output .. IS anything wrong here ..

tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
 group by volume_name,node_name
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.





"Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001 11:02:07 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Thanks for your help. It has answered my question.

Neil

 -Original Message-
 From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 01, 2001 12:47 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 Here is the SQL script :

 select volume_name,node_name from volumeusage where node_name='$1' group
 by volume_name,node_name

 Just give the server name as parameter 1

  Ruddy Stouder
 System Engineer
 I.R.I.S.
 Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
 B- 1435 Mont-Saint-Guibert
 [EMAIL PROTECTED]
 http://www.irislink.com
 Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


 -Original Message-
 From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
 Sent: jeudi 1 mars 2001 13:44
 To: [EMAIL PROTECTED]
 Subject: How to find out what tape's a client data are on ?


 I have a frustrating situation whereby if I perform a client restore it
 may
 call a tape from off-site. This tape is then recalled (usually 4 hours)
 and
 then placed in the library. The restore then continues but then stalls
 again
 requesting another tape. What I need to find out up front are all the
 tapes
 that could possibly be requested for the client and recall all tapes. I
 can
 find this out by running 'q vol client=X' but I have 2000 tapes to
 search
 and this will take a long time even if scripted . I think that what I
 need
 is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
 shortly)

 Thanks for your time.

 Neil Sharp
 Merrill Lynch ADSM/TSM Administrator
 Work : 020-7573-0469
 Mobile : 07769-741612
 Pager : 01893-038277
 e-mail : [EMAIL PROTECTED]


 $RFC822.eml

Re: How to find out what tape's a client data are on ?

[Andy Raibeck]

This is not a case (no pun intended) of TSM being case-sensitive. Rather,
it is the standard SQL "is equal to" operator, '=', that is case sensitive
when comparing strings. This is per the SQL standard, and is not specific
to TSM's SQL implementation.

Regards,

Andy

Andy Raibeck
IBM/Tivoli
Tivoli Storage Manager Client Development
e-mail: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."


Shekhar Dhotre [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001
10:41:16 AM

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

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


To:   [EMAIL PROTECTED]
cc:
Subject:  Re: How to find out what tape's a client data are on ?




Thanks .Worked .. .. i was thinking that TSM is not case sensitive
application
.. hmm..




Glen Churchfield [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001
11:57:38 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Shekhar,
Remember that the node name is case sensitive and is all caps.

-Original Message-
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:40 AM
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?



I am trying same command for the One of my AIX Box , that is getting backed
up
regularly .
I am not getting any output .. IS anything wrong here ..

tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
 group by volume_name,node_name
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.





"Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001 11:02:07 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Thanks for your help. It has answered my question.

Neil

 -Original Message-
 From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 01, 2001 12:47 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 Here is the SQL script :

 select volume_name,node_name from volumeusage where node_name='$1' group
 by volume_name,node_name

 Just give the server name as parameter 1

  Ruddy Stouder
 System Engineer
 I.R.I.S.
 Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
 B- 1435 Mont-Saint-Guibert
 [EMAIL PROTECTED]
 http://www.irislink.com
 Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


 -Original Message-
 From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
 Sent: jeudi 1 mars 2001 13:44
 To: [EMAIL PROTECTED]
 Subject: How to find out what tape's a client data are on ?


 I have a frustrating situation whereby if I perform a client restore it
 may
 call a tape from off-site. This tape is then recalled (usually 4 hours)
 and
 then placed in the library. The restore then continues but then stalls
 again
 requesting another tape. What I need to find out up front are all the
 tapes
 that could possibly be requested for the client and recall all tapes. I
 can
 find this out by running 'q vol client=X' but I have 2000 tapes to
 search
 and this will take a long time even if scripted . I think that what I
 need
 is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
 shortly)

 Thanks for your time.

 Neil Sharp
 Merrill Lynch ADSM/TSM Administrator
 Work : 020-7573-0469
 Mobile : 07769-741612
 Pager : 01893-038277
 e-mail : [EMAIL PROTECTED]


(See attached file: $RFC822.eml)

 $RFC822.eml

Re: How to find out what tape's a client data are on ?

[Allen Barth]

While your statement is technically true Andy,  *SM does take the liberty
of folding various fields to UPPER CASE which IMHO is just plain dumb.
OOPS, forgot that mainframe heritage.

Al Barth
Zurich Scudder Investments




Andy Raibeck
Andrew_Raibeck@TTo: [EMAIL PROTECTED]
IVOLI.COM   cc:
Sent by: "ADSM:  Subject: Re: How to find out what 
tape's a client data are on ?
Dist Stor
Manager"
[EMAIL PROTECTED]
.EDU


03/01/01 11:47 AM
Please respond to
"ADSM: Dist Stor
Manager"






This is not a case (no pun intended) of TSM being case-sensitive. Rather,
it is the standard SQL "is equal to" operator, '=', that is case sensitive
when comparing strings. This is per the SQL standard, and is not specific
to TSM's SQL implementation.

Regards,

Andy

Andy Raibeck
IBM/Tivoli
Tivoli Storage Manager Client Development
e-mail: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."


Shekhar Dhotre [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001
10:41:16 AM

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

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


To:   [EMAIL PROTECTED]
cc:
Subject:  Re: How to find out what tape's a client data are on ?




Thanks .Worked .. .. i was thinking that TSM is not case sensitive
application
.. hmm..




Glen Churchfield [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001
11:57:38 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Shekhar,
Remember that the node name is case sensitive and is all caps.

-Original Message-
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:40 AM
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?



I am trying same command for the One of my AIX Box , that is getting backed
up
regularly .
I am not getting any output .. IS anything wrong here ..

tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
 group by volume_name,node_name
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.





"Sharp, Neil (London)" [EMAIL PROTECTED]@VM.MARIST.EDU on
03/01/2001 11:02:07 AM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Thanks for your help. It has answered my question.

Neil

 -Original Message-
 From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, March 01, 2001 12:47 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: How to find out what tape's a client data are on ?

 Here is the SQL script :

 select volume_name,node_name from volumeusage where node_name='$1' group
 by volume_name,node_name

 Just give the server name as parameter 1

  Ruddy Stouder
 System Engineer
 I.R.I.S.
 Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
 B- 1435 Mont-Saint-Guibert
 [EMAIL PROTECTED]
 http://www.irislink.com
 Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75 40


 -Original Message-
 From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
 Sent: jeudi 1 mars 2001 13:44
 To: [EMAIL PROTECTED]
 Subject: How to find out what tape's a client data are on ?


 I have a frustrating situation whereby if I perform a client restore it
 may
 call a tape from off-site. This tape is then recalled (usually 4 hours)
 and
 then placed in the library. The restore then continues but then stalls
 again
 requesting another tape. What I need to find out up front are all the
 tapes
 that could possibly be requested for the client and recall all tapes. I
 can
 find this out by running 'q vol client=X' but I have 2000 tapes to
 search
 and this will take a long time even if scripted . I think that what I
 need
 is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
 shortly)

 Thanks for your time.

 Neil Sharp
 Merrill Lynch ADSM/TSM Administrator
 Work : 020-7573-0469
 Mobile : 07769-741612
 Pager : 01893-038277
 e-mail : [EMAIL PROTECTED]


(See attached file: $RFC822.eml)
(See attached file: $RFC822.eml)


 $RFC822.eml

Re: How to find out what tape's a client data are on ?

[David Longo]

Yes, all tapes are in this query.  To further define list add in the "where" clause 
the stgpool_name you want or don't want.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 12:38PM 

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

:-)  :-)thanks ...  Is it showing me offsite (Copypool) tapes in this query ?




Maria Paz Gimeno [EMAIL PROTECTED]@VM.MARIST.EDU on 02/28/2001 12:14:39 PM

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

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


To:   [EMAIL PROTECTED] 
cc:

Subject:  Re: How to find out what tape's a client data are on ?


The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
Subject: Re: How to find out what tape's a client data are on ?



 I am trying same command for the One of my AIX Box , that is getting
backed up
 regularly .
 I am not getting any output .. IS anything wrong here ..

 tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
  group by volume_name,node_name
 ANR2034E SELECT: No match found using this criteria.
 ANS8001I Return code 11.



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

Ý==

Re: How to find out what tape's a client data are on ?

[Shekhar Dhotre]

  87,072.9   47.3Full
MED260COPYPOOL STK9710  44,541.5   77.6Full
MED261COPYPOOL STK9710  94,341.1   30.2Full
MED262TAPEPOOL STK9710  71,680.0   81.5  Filling
MED264TAPEPOOL STK9710  71,680.0   17.3  Filling
MED268TAPEPOOL STK9710 106,456.6   44.6Full
MED271COPYPOOL STK9710   0.00.0  Pending
MED304TAPEPOOL STK9710  71,680.04.5  Filling
MED311COPYPOOL STK9710   0.00.0  Pending
MED316TAPEPOOL STK9710  71,680.05.1  Filling
MED317TAPEPOOL STK9710  71,680.00.6  Filling
MED375COPYPOOL STK9710   0.00.0  Pending
MED401TAPEPOOL STK9710   0.00.0  Pending
MED403TAPEPOOL STK9710  90,793.9   38.0Full
MED404TAPEPOOL STK9710   0.00.0  Pending
MED411TAPEPOOL STK9710   0.00.0  Pending
MED414COPYPOOL STK9710   0.00.0  Pending
more...   (ENTER to continue, 'C' to cancel)

MED416TAPEPOOL STK9710  71,680.02.7  Filling
MED501COPYPOOL STK9710  81,604.0  100.0Full
MED503COPYPOOL STK9710   0.00.0  Pending
MED506TAPEPOOL STK9710  71,680.0   61.1  Filling
MED507COPYPOOL STK9710  71,680.0   12.6  Filling
MED511COPYPOOL STK9710  71,680.0   49.4  Filling
MED513COPYPOOL STK9710  71,680.0   61.3  Filling
MED514COPYPOOL STK9710  71,680.07.3  Filling
MED560TAPEPOOL STK9710   0.00.0  Pending





David Longo [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001 01:06:56
PM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Yes, all tapes are in this query.  To further define list add in the "where"
clause the stgpool_name you want or don't want.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 12:38PM 

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

:-)  :-)thanks ...  Is it showing me offsite (Copypool) tapes in this query
?




Maria Paz Gimeno [EMAIL PROTECTED]@VM.MARIST.EDU on 02/28/2001 12:14:39 PM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
Subject: Re: How to find out what tape's a client data are on ?



 I am trying same command for the One of my AIX Box , that is getting
backed up
 regularly .
 I am not getting any output .. IS anything wrong here ..

 tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
  group by volume_name,node_name
 ANR2034E SELECT: No match found using this criteria.
 ANS8001I Return code 11.



"MMS health-first.org" made the following
 annotations on 03/01/01 13:12:48
--
This message is for the named person's use only.  It may contain confidential,
proprietary, or legally privileged information.  No confidentiality or privilege
is waived or lost by any mistransmission.  If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it, and notify the sender.  You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are
not the intended 

Re: How to find out what tape's a client data are on ?

[David Longo]

 STK9710  71,680.06.6  Filling
MED250TAPEPOOL STK9710  71,680.05.6  Filling
MED251COPYPOOL STK9710  55,945.3   64.9Full
MED252COPYPOOL STK9710   0.00.0  Pending
MED254COPYPOOL STK9710 121,199.61.0Full
MED255TAPEPOOL STK9710  87,072.9   47.3Full
MED260COPYPOOL STK9710  44,541.5   77.6Full
MED261COPYPOOL STK9710  94,341.1   30.2Full
MED262TAPEPOOL STK9710  71,680.0   81.5  Filling
MED264TAPEPOOL STK9710  71,680.0   17.3  Filling
MED268TAPEPOOL STK9710 106,456.6   44.6Full
MED271COPYPOOL STK9710   0.00.0  Pending
MED304TAPEPOOL STK9710  71,680.04.5  Filling
MED311COPYPOOL STK9710   0.00.0  Pending
MED316TAPEPOOL STK9710  71,680.05.1  Filling
MED317TAPEPOOL STK9710  71,680.00.6  Filling
MED375COPYPOOL STK9710   0.00.0  Pending
MED401TAPEPOOL STK9710   0.00.0  Pending
MED403TAPEPOOL STK9710  90,793.9   38.0Full
MED404TAPEPOOL STK9710   0.00.0  Pending
MED411TAPEPOOL STK9710   0.00.0  Pending
MED414COPYPOOL STK9710   0.00.0  Pending
more...   (ENTER to continue, 'C' to cancel)

MED416TAPEPOOL STK9710  71,680.02.7  Filling
MED501COPYPOOL STK9710  81,604.0  100.0Full
MED503COPYPOOL STK9710   0.00.0  Pending
MED506TAPEPOOL STK9710  71,680.0   61.1  Filling
MED507COPYPOOL STK9710  71,680.0   12.6  Filling
MED511COPYPOOL STK9710  71,680.0   49.4  Filling
MED513COPYPOOL STK9710  71,680.0   61.3  Filling
MED514COPYPOOL STK9710  71,680.07.3  Filling
MED560TAPEPOOL STK9710   0.00.0  Pending





David Longo [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001 01:06:56
PM

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

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


To:   [EMAIL PROTECTED] 
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Yes, all tapes are in this query.  To further define list add in the "where"
clause the stgpool_name you want or don't want.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED] 


 [EMAIL PROTECTED] 03/01/01 12:38PM 

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

:-)  :-)thanks ...  Is it showing me offsite (Copypool) tapes in this query
?




Maria Paz Gimeno [EMAIL PROTECTED]@VM.MARIST.EDU on 02/28/2001 12:14:39 PM

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

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


To:   [EMAIL PROTECTED] 
cc:

Subject:  Re: How to find out what tape's a client data are on ?


The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
- Original Message -
From: Shekhar Dhotre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
Subject: Re: How to find out what tape's a client data are on ?



 I am trying same command for the One of my AIX Box , that is getting
backed up
 regularly .
 I am not getting any output .. IS anything wrong here ..

 tsm: TSMselect volume_name,node_name from volumeusage where
node_name='medrs2'
  group by volume_name,node_name
 ANR2034E SELECT: No match found using this criteria.
 ANS8001I Return code 11.



"MMS health-first.org" made the following
 annotations on 03/01/01 13:12:48
--
This message is for the named person's use only.  It may contain confidential,
proprie

Re: How to find out what tape's a client data are on ?

[Shekhar Dhotre]

Thanks David ...

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'
 and stgpool_name='COPYPOOL' group by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED202 MEDRS1
MED251 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'
 and stgpool_name='TAPEPOOL' group by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED201 MEDRS1
MED255 MEDRS1
MED506 MEDRS1





David Longo [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001 04:28:55
PM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Your select statement is incorrect.  It should be:

select volume_name,node_name from volumeusage where node_name='MEDRS1' and
stgpool_name='COPYTAPE' group by volume_name,node_name


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 02:48PM 

 The following query shows  same tapes  for  node 'MEDRS1' in tapepool and
copypool ?

  tsm: TSMselect volume_name,node_name from volumeusage where node_name
='MEDRS1'g
 roup by volume_name,node_name where stgpool_name='TAPEPOOL'

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name where stgpool_name='COPYPOOL'

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMQ DRM

Volume NameState   Last Update   Automated
   Date/Time LibName
   -   ---   
64 Vault   02/22/01   12:08:00
MED200 Vault   02/16/01   15:38:21
MED251 Vault   02/16/01   15:38:22
MED252 Vault   02/23/01   13:38:02
MED254 Vault   02/26/01   10:43:13
MED260 Vault   02/19/01   10:36:43
MED261 Vault   02/19/01   10:36:43
MED271 Vault   02/26/01   10:43:13
MED311 Vault   02/19/01   10:36:43
MED375 Vault   02/27/01   10:48:18
MED414 Vault   02/20/01   11:42:36
MED501 Vault   03/01/01   12:47:40
MED503 Vault   02/21/01   10:47:50
MED511 Vault   02/27/01   10:48:18
MED513 Vault   03/01/01   12:47:40
MED514 Vault   03/01/01   12:47:40
MED515 Vault   03/01/01   12:49:00
MED512 Vault   03/01/01   12:49:00
more...   (ENTER to continue, 'C' to cancel)

MED413 Vault   02/27/01   10:49:43
MED510 Vault   02/26/01   10:44:30
MED374 Vault   02/26/01   10:44:30
MED269 Vault   02/26/01   10:44:30
MED253 Vault   02/23/01   13:39:13


tsm: TSMQ VOL

Volume Name   Storage  Device  EstimatedPct   Volume
  Pool NameClass Name   Capacity   Util   Status
(MB)
  ---  --  -  -  
/tsmpool/data01.dsm   DISKPOOL DISK  5,000.00.0  On-Line
/tsmpool/data02.dsm   DISKPOOL DISK  5,000.00.0  On-Line
/tsmpool/data03.dsm   DISKPOOL DISK  5,000.00.0  On-Line
/tsmpool/data0

Re: How to find out what tape's a client data are on ?

[Thomas A. La Porte]

Just out of curiosity, since I've only casually been following
this thread, was there a specific reason for the "group by"
clause?

I think what is desired is simplly an "order by" clause, e.g.

select volume_name, node_name -
  from volumeusage -
 where node_name = 'MEDRS1' -
   and stgpool_name = 'COPYPOOL' -
 order by volume_name, node_name

The group by function is necessary when there is a group function
in the "select" statement, e.g. when you are summing a value:

select node_name, sum(backup_copy_mb) -
  from auditocc -
 where node_name = 'MEDRS1' -
 group by node_name


 -- Tom

Thomas A. La Porte
DreamWorks SKG
[EMAIL PROTECTED]

On Thu, 1 Mar 2001, Shekhar Dhotre wrote:


Thanks David ...

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'
 and stgpool_name='COPYPOOL' group by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED202 MEDRS1
MED251 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'
 and stgpool_name='TAPEPOOL' group by volume_name,node_name

VOLUME_NAMENODE_NAME
-- --
MED201 MEDRS1
MED255 MEDRS1
MED506 MEDRS1





David Longo [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001 04:28:55
PM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: How to find out what tape's a client data are on ?


Your select statement is incorrect.  It should be:

select volume_name,node_name from volumeusage where node_name='MEDRS1' and
stgpool_name='COPYTAPE' group by volume_name,node_name


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 03/01/01 02:48PM 

 The following query shows  same tapes  for  node 'MEDRS1' in tapepool and
copypool ?

  tsm: TSMselect volume_name,node_name from volumeusage where node_name
='MEDRS1'g
 roup by volume_name,node_name where stgpool_name='TAPEPOOL'

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMselect volume_name,node_name from volumeusage where node_name='MEDRS1'g
 roup by volume_name,node_name where stgpool_name='COPYPOOL'

VOLUME_NAMENODE_NAME
-- --
MED200 MEDRS1
MED201 MEDRS1
MED251 MEDRS1
MED254 MEDRS1
MED255 MEDRS1
MED260 MEDRS1
MED261 MEDRS1
MED501 MEDRS1
MED506 MEDRS1
MED507 MEDRS1
MED511 MEDRS1
MED513 MEDRS1

tsm: TSMQ DRM

Volume NameState   Last Update   Automated
   Date/Time LibName
   -   ---   
64 Vault   02/22/01   12:08:00
MED200 Vault   02/16/01   15:38:21
MED251 Vault   02/16/01   15:38:22
MED252 Vault   02/23/01   13:38:02
MED254 Vault   02/26/01   10:43:13
MED260 Vault   02/19/01   10:36:43
MED261 Vault   02/19/01   10:36:43
MED271 Vault   02/26/01   10:43:13
MED311 Vault   02/19/01   10:36:43
MED375 Vault   02/27/01   10:48:18
MED414 Vault   02/20/01   11:42:36
MED501 Vault   03/01/01   12:47:40
MED503 Vault   02/21/01   10:47:50
MED511 Vault   02/27/01   10:48:18
MED513 Vault   03/01/01   12:47:40
MED514 Vault   03/01/01   12:47:40
MED515 Vault   03/01/01   12:49:00
MED512 Vault   03/01/01   12:49:00
more...   (ENTER to continue, 'C' to cancel)

MED413 Vault   02/27/01   10:49:43
MED510 Vault   02/26/01   10:44:30
MED374 

Re: How to find out what tape's a client data are on ?

[Walker, Lesley R]

 Just out of curiosity, since I've only casually been following
 this thread, was there a specific reason for the "group by"
 clause?

 I think what is desired is simplly an "order by" clause, e.g.

Well, I'm really confused now.

I came up with my own version of the query:

select distinct volume_name,stgpool_name
from volumeusage
where node_name='FOO'

and that produces an answer:

VOLUME_NAMESTGPOOL_NAME
-- --
ITF010 CPITFPOOL
ITF013 CPITFPOOL
ITF018 CPITFPOOL
ITF026 CPITFPOOL
ITF001 ITFPOOL
ITF003 ITFPOOL
ITF004 ITFPOOL
ITF014 ITFPOOL
ITF025 ITFPOOL
ITF027 ITFPOOL
ITF028 CPITFPOOL
ITF006 ITFPOOL
ITF002 CPITFPOOL

BUT if I add "order by stgpool_name" it doesn't show all the tapes - eg:

VOLUME_NAMESTGPOOL_NAME
-- --
ITF010 CPITFPOOL
ITF001 ITFPOOL

So what's going on here?