ADSM-L

Re: [ADSM-L] Restoring (DB2) API data using the BA client

2011-12-13 07:12:54
Subject: Re: [ADSM-L] Restoring (DB2) API data using the BA client
From: Steven Harris <steve AT STEVENHARRIS DOT INFO>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 13 Dec 2011 23:03:54 +1100
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

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

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

"ADSM: Dist Stor Manager"<ADSM-L AT vm.marist DOT edu>  wrote on 2011-12-13
04:55:17:

From: Daniel Sparrman<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