By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,018 Members | 930 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,018 IT Pros & Developers. It's quick & easy.

how can I use db2adutl to view TSM info of another physical server

P: n/a
I have DB2 backed up to TSM from the production system.
How can I use db2adutl to view the backup info from other server
instead of production.

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
For details on recovering a database backup from TSM or your log files from
TSM to a different server than the original, I refer you to the online DB2
Information Center:

http://publib.boulder.ibm.com/infoce...help/index.jsp

and search on keyword fromnode. You will find the first entry gives you the
details for what you need I believe.

Bob

<sh*******@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
I have DB2 backed up to TSM from the production system.
How can I use db2adutl to view the backup info from other server
instead of production.

Nov 12 '05 #2

P: n/a
What exactly are you looking for.
DB2 has a db2ckbkp command that allows you to investigate the image contents
but this has to be run from the path where the image is at.
You'd have to bring the image from TSM to disk to use that.

Have you tried db2adutl -h to see what parms you can use to get your info??

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<sh*******@gmail.com> a écrit dans le message de news:
11**********************@g44g2000cwa.googlegroups. com...
I have DB2 backed up to TSM from the production system.
How can I use db2adutl to view the backup info from other server
instead of production.


Nov 12 '05 #3

P: n/a
I need to bring the backup image from the TSM to server B, Server B is
not a production.
But it can not see the database image of production.
no lucky from
db2adutl -h

Nov 12 '05 #4

P: n/a
I need to restore db or bring the backup image from the TSM to server
B, Server B is
not a production.
But it can not see the database image of production using db2adutl at
all.
no lucky from
db2adutl -h

Nov 12 '05 #5

P: n/a
sh*******@gmail.com wrote:
I need to bring the backup image from the TSM to server B, Server B is
not a production.
But it can not see the database image of production.
no lucky from
db2adutl -h


Hi there,

Restoring a backup taken on one TSM server to another is something we now do
all the time.

The server is in the OPTIONS keyword on the RESTORE command. You need to
create a file containing details of the "TSM node" you want to access (or
specify these options in the restore command as a string, but creating the
file is a good idea for ongoing use). So, for example, lets say you want
you restore a backup you took on FRED onto BARNEY (these names are the
server names in the dsm.sys / dsm.opt files on the servers).

Then the restore commands will be -

db2 restore db sample use TSM options "-fromnode FRED -fromowner db2inst1"

or

db2 restore db sample use TSM options @/home/db2inst1/sqllib/fredtsm.opts

However there is one "gotcha" : by default the backup images aren't
available to anyone apart from the server which created them. So you have
to "grant" access to them from other servers. You can do this in two
ways : either using raw TSM commands or using the the "access control"
options of db2adutl.

You run this on the server your backup was taken from -

db2adutl grant all on all for all

or

db2adutl grant user db2inst1 on nodename barney for database sample

This whole process is documented in the manuals / Information Center in a
section entitled -

"Cross-node recovery with the db2adutl command and the logarchopt and
vendoropt database configuration parameters"

HTH

Phil Nelson
ScotDB Limited
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.