467,198 Members | 1,201 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

clientside backup of partioned database


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
  • viewed: 1272

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Thiko | last post: by
2 posts views Thread by nt | last post: by
6 posts views Thread by Eric Herber | last post: by
1 post views Thread by alex | last post: by
4 posts views Thread by uthuras@hotmail.com | last post: by
10 posts views Thread by Sumanth | last post: by
5 posts views Thread by jag | last post: by
10 posts views Thread by Konstantin Andreev | last post: by
reply views Thread by Massimiliano Campagnoli | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.