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

clientside backup of partioned database

P: n/a

I have DB2 9.1 running on a Linux-server.
The database is partioned into two nodes on this server.

On another Linux-server, acting as application server, I want to initiate
the backup.

When I issue the backup command from the client server, I get a backup of
the controlling node, NODE0000.

How can I take a backup of the NODE0001? On the client side the env-var
DB2NODE=1 is obviously ignored.
db2_all is not available on the client side.

Should NODE0001 somehow be CATALOGed on the client side and then ATTACHed?

Could Call SYSPROC.ADMIN_CMD(Backup...) be used? If so, how do I set the

IBM ought to enhance the backup command to something like
BACKUP databasename ...
ON ALL NODES EXCEPT (node,....,node)

Dan van Ginhoven
Jul 31 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.