DB2 Alternate Restore option DB2_MEDIA_SERVER
Hello Forum,
we do DB2 alternate restores frequently and we need to swap the media server for that restore.
I'm aware that I can force to take a new media server, but it would be nice if that media server is only for that one alternate restore.
So the Netbackup DB2 Admin Guide mentions the Option:
DB2_MEDIA_SERVER:
"Allows the user to explicitly specify the media server to be used to perform the restore."
Does anyone use this keyword?
My proble is: Where do I define DB2_MEDIA_SERVER? Does it belon in the db2.conf file? Can I specify it in the db2 restore command and how? Does it belong in the OPTIONS part of the Db2 restore command?
Iy anyone uses this keyword it would be nice if I can get some help how to use it. :)
Thanks
Volker
Ok, that was simple. The manual was misleading, the DB2_MEDIA_SERVER belongs to the option part of the command:
db2 "restore db XXX load /usr/openv/netbackup/bin/nbdb2.sl64 open 4 sessions OPTIONS "DB2_MEDIA_SERVER=XXX" logtarget /db2/XXX/log_dir/NODE0000 parallelism 30"
Volker