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 <st...@stevenharris.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: stor...@us.ibm.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@vm.marist.edu> wrote on 2011-12-13 >> 04:55:17: >> >> From: Daniel Sparrman<daniel.sparrman@**EXIST.SE<daniel.sparr...@exist.se> >>> > >>> To: ADSM-L@vm.marist.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@vm.marist.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.sparr...@exist.se >>> http://www.existgruppen.se >>> Posthusgatan 1 761 30 NORRTÄLJE >>> >>> -----"ADSM: Dist Stor Manager"<ADSM-L@VM.MARIST.EDU> skrev: ----- >>> Till: ADSM-L@VM.MARIST.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.folke...@gmail.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 >>>> >>>>