Use XML to reconfigure a database instance.
Procedure
-
Download one of the following files, and then save it on the computer from where the command will be executed:
-
Open the XML file and update the parameters as needed using the table below as reference.
-
Parameter
Description
Element
clientName
The name of the client.
instance
instanceName
The long name of the client computer as displayed in the CommCell Console where instance is located. For example, client.domain.company.com.
instance
appName
The agent name associated with the client. Valid values are:
-
DB2
-
DB2 MultiNode
-
DB2 on UNIX
-
Documentum
-
Informix
-
MySQL
-
Notes Database
-
Oracle
-
Oracle RAC
-
PostgreSQL
-
SAP for Oracle
-
SAP for MaxDB
-
SAP HANA
-
SQL
-
Sybase
instance
-
-
Save the changes to the XML file.
-
From the command line, go to software_installation_directory/Base and type the following command:
qlogin -cs commserve_host_name -u user_name
-
From software_installation_directory/Base type the following command:
qoperation execute -af '/tmp/reconfigure_instance_template.xml' -appName 'application_name' -clientName '<client_name>' -instanceName '<instance_name>'
If the XML file is saved in the software_installation_directory/Base directory, the file path (xml_path in the example above) does not need to be included on the command line.
Note
For DB2 Multinode, use the DB2 multinode pseudoclient name for the -clientName parameter.