Thanks all,

It turns out the backup was done with an B/A archive action of a dump to
file of the database so the retrieve was as easy as can be.
Anyway, thanks for all the responses.


On Tue, Dec 13, 2011 at 1:03 PM, Steven Harris <steve AT stevenharris DOT 
info>wrote:

> I haven't used it, but the db2adutl utility has an extract operand which
> is supposed to put the backup objects on the local filesystem.  I think it
> will be a DB2 dump format though, you'll still need to load it into DB2 to
> access it.
>
> http://publib.boulder.ibm.com/**infocenter/db2luw/v8/topic/**
> com.ibm.db2.udb.doc/core/**r0002077.htm<http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/core/r0002077.htm>
>
> Regards
>
> Steve.
>
> Steven Harris
> TSM Admin,
> Canberra Australia
>
>
> On 13/12/2011 10:03 PM, Andrew Raibeck wrote:
>
>> Actually there is limited ability for the backup-archive client to operate
>> on data backed up or archived by the API. See the chapter on
>> "Backup-archive client interoperability" in the API manual:
>>
>> http://publib.boulder.ibm.com/**infocenter/tsminfo/v6r3/topic/**
>> com.ibm.itsm.client.develop.**doc/c_interop.html<http://publib.boulder.ibm.com/infocenter/tsminfo/v6r3/topic/com.ibm.itsm.client.develop.doc/c_interop.html>
>>
>> Best regards,
>>
>> Andy Raibeck
>> IBM Software Group
>> Tivoli Storage Manager Client Product Development
>> Level 3 Team Lead
>> Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS
>> Internet e-mail: storman AT us.ibm DOT com
>>
>> IBM Tivoli Storage Manager support web page:
>> http://www.ibm.com/support/**entry/portal/Overview/**
>> Software/Tivoli/Tivoli_**Storage_Manager<http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager>
>>
>> "ADSM: Dist Stor Manager"<ADSM-L AT vm.marist DOT edu>  wrote on 2011-12-13
>> 04:55:17:
>>
>>  From: Daniel Sparrman<daniel.sparrman@**EXIST.SE<daniel.sparrman AT EXIST 
>> DOT SE>
>>> >
>>> To: ADSM-L AT vm.marist DOT edu
>>> Date: 2011-12-13 05:00
>>> Subject: Re: Restoring (DB2) API data using the BA client
>>> Sent by: "ADSM: Dist Stor Manager"<ADSM-L AT vm.marist DOT edu>
>>>
>>> Since the DB2 API only act as a media manager for DB2, the B/A
>>> client wont be able to read what has actually been backed up.
>>>
>>> So the answer to your question is no, the B/A client cant restore
>>> data that has been backed up using DB2 (through the TSM API).
>>>
>>> What you can do to restore the data is
>>>
>>> a) Install a DB2 server and then restore the data using that instance
>>>
>>> b) Start writing your own software to retrieve the stored objects on
>>> the TSM server through the TSM API.
>>>
>>> Out of the alternatives, I'd say A is alot easier.
>>>
>>> Best Regards
>>>
>>> Daniel Sparrman
>>>
>>>
>>> Daniel Sparrman
>>> Exist i Stockholm AB
>>> Växel: 08-754 98 00
>>> Fax: 08-754 97 30
>>> daniel.sparrman AT exist DOT se
>>> http://www.existgruppen.se
>>> Posthusgatan 1 761 30 NORRTÄLJE
>>>
>>> -----"ADSM: Dist Stor Manager"<ADSM-L AT VM.MARIST DOT EDU>  skrev: -----
>>> Till: ADSM-L AT VM.MARIST DOT EDU
>>> Från: Steven Langdale
>>> Sänt av: "ADSM: Dist Stor Manager"
>>> Datum: 12/13/2011 10:50
>>> Ärende: Re: Restoring (DB2) API data using the BA client
>>>
>>> Stefan
>>>
>>> Anyone feel free to correct me, but I don't think you can.  Have you
>>>
>> tried
>>
>>> running up a BA client to see what is actually there?
>>>
>>> Steven
>>>
>>> On 13 December 2011 08:29, Stefan Folkerts
>>>
>> <stefan.folkerts AT gmail DOT com>**wrote:
>>
>>> Hi all,
>>>>
>>>> I am looking into restoring DB2 (version 7) data of a node that has
>>>>
>>> since
>>
>>> been physically removed but still has data in TSM.
>>>> Has anybody ever restored API data using a BA client to disk, it
>>>>
>>> doesn't
>>
>>> have to be restored to DB2, no logs tricks..just the plain data to disk
>>>> restore using the same platform BA client.
>>>>
>>>> Please advise.
>>>>
>>>> Regards,
>>>>  Stefan
>>>>
>>>>