I spoke with the Developer at Share this week on this subject.  There is a
way to find this out using some internal SHOW commands.  Basically, you find
the OBJECT_ID from the BACKUPS table.  Once you have done that you can issue
a SHOW BFO [high order] [low order] and you will get an answer back.  But
this is all unsupported stuff so do not call Tivoli Support for any help.
The high order is a decimal number of 0 if the OBJECT_ID is less than 2**32
- 1.    If it is larger then you subtract that behemouth number for the
OBJECT_ID number and that becomes the [high-order] and the low order is
2**32 - 1.

By the way 2**32 - 1 = 4293967295

It is not quite as simple as I have stated.  If the object is part of an
aggregate then you have to issue the command again.  Example:


tsm: TSMserver>select object_id from backups where node_name = 'your node'
and
ate(backup_date)='2002-04-20'
ANR2963W This SQL query may produce a very large result table, or may
require a
significant amount of time to compute.

Do you wish to proceed? (Yes (Y)/No (N)) y

           OBJECT_ID
--------------------
            78041166
            78069203
            78069272
            78069511
            78319025
            78323201
            78323812

tsm: TSMserver>show bfo 0 78041166

Bitfile Object: 0.78041166
**Archival Bitfile Entry
  Bitfile Type: PRIMARY  Storage Format: 9
  Bitfile Size: 0.264282163  Number of Segments: 1
  Storage Pool ID: 33  Volume ID: 1688  Volume Name: 422138
**Archival Bitfile Entry
  Bitfile Type: COPY  Storage Format: 9
  Bitfile Size: 0.264282163  Number of Segments: 1
  Storage Pool ID: -14  Volume ID: 1835  Volume Name: 422223
**Archival Bitfile Entry
  Bitfile Type: COPY  Storage Format: 9
  Bitfile Size: 0.264282163  Number of Segments: 1
  Storage Pool ID: -15  Volume ID: 1847  Volume Name: 422258

Hope this helps.  I am trying to see if we can get a query command that
Tivoli will support to help us with this issue.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Braich, Raminder [mailto:raminder.braich AT DAVEY DOT COM]
Sent: Friday, August 23, 2002 9:25 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Which volume contains the backups
Importance: High


Hello,
   We backup our SAP/Oracle system using TDP for R/3. The OS is windows NT.
I am trying to find out the volumes which contain the backups from last
Friday(08/16/2002) for our production server. I have tried querying
volumeusage table but it does not take the date condition. I would also like
to know the copypool tapes that contain that backup and are offsite.  Does
anyone know how to go around this.
  Any and all help is very much appreciated.

Thanks
Raminder Braich
SAP/Oracle DBA