@Mauro, We have an option to pass the MediaAgent name with the command line backups/restores.
Please check the below documentation link.
https://documentation.commvault.com/commvault/v11_sp20/article?p=14906.htm
Hi Mahender
Thanks so much for this. It’s definitely going to be a huge help.
I assume I’ll need to get this completed by the DBA, as I don’t have access to his systems?
Hi Mauro.
Before submitting the restore, your DBA should update VENDOROPT and LOGARCHOPT1 parameters as following:-
db2 update db cfg for <database name> using VENDOROPT "'CvClientName=<client_name_on_CommCell>,CvInstanceName=Instance001,CVDB2USEMEDIAPARAMS=1'"
db2 update db cfg for <database name> using LOGARCHOPT1 "'CvClientName=<client_name_on_CommCell>,CvInstanceName=Instance001,CVDB2USEMEDIAPARAMS=1'"
Where <database name> is the name of the database
<client_name_on_CommCell> is the name of the client in commcell console.
After updating the parameter, you or your DBA should create a parameter file in any location on the client with the following entries:-
The name of the file can be any(for example: parameter.txt)
You can add only MediaAgent entry and also any other media related info((like storage policy, Library)
In your case, you only need MediaAgent entry, so the file should have the following info:
>mediaagent]
<name of the MediaAgent>
Where replace the mediaagent name in the <name of the MediaAgent>.
After creating the parameter.txt file, you need to add the following registry key to the client properties, under additional settings.
Registry Key name: sDB2MEDIAPARAMS_<instanacename>_<DATABASENAME>
Category: Db2Agent
Type: String
Value: <complete path of the parameter file>
Replace the parameter.txt path in <complete path of the parameter file>.
Ref:- https://documentation.commvault.com/commvault/v11_sp20/article?p=14904.htm
Please let me know in case of any questions.
--
Mahender
Hi Mauro.
Before submitting the restore, your DBA should update VENDOROPT and LOGARCHOPT1 parameters as following:-
db2 update db cfg for <database name> using VENDOROPT "'CvClientName=<client_name_on_CommCell>,CvInstanceName=Instance001,CVDB2USEMEDIAPARAMS=1'"
db2 update db cfg for <database name> using LOGARCHOPT1 "'CvClientName=<client_name_on_CommCell>,CvInstanceName=Instance001,CVDB2USEMEDIAPARAMS=1'"
Where <database name> is the name of the database
<client_name_on_CommCell> is the name of the client in commcell console.
After updating the parameter, you or your DBA should create a parameter file in any location on the client with the following entries:-
The name of the file can be any(for example: parameter.txt)
You can add only MediaAgent entry and also any other media related info((like storage policy, Library)
In your case, you only need MediaAgent entry, so the file should have the following info:
>mediaagent]
<name of the MediaAgent>
Where replace the mediaagent name in the <name of the MediaAgent>.
After creating the parameter.txt file, you need to add the following registry key to the client properties, under additional settings.
Registry Key name: sDB2MEDIAPARAMS_<instanacename>_<DATABASENAME>
Category: Db2Agent
Type: String
Value: <complete path of the parameter file>
Replace the parameter.txt path in <complete path of the parameter file>.
Ref:- https://documentation.commvault.com/commvault/v11_sp20/article?p=14904.htm
Please let me know in case of any questions.
--
Mahender
Hi Mahender
Thank you so much for this information. We managed to complete this successfully and the POC was signed off as successful.
I appreciate your help.