4.1.1 Shutting Down Query Server

Perform the following procedure to shut down Query Server (QS):

1. Remove QS from topology.
   1. Log in to Active SDS NOAM GUI.
   2. Navigate to Status & Manage from Main Menu, then select HA.
   3. To change HA state of QS to OOS, perform the following steps:
      1. Navigate to Status & Manage from Main Menu, then select HA.
      2. Click Edit and change Max Allowed HA Role of QS to OOS.
   4. To remove the QS from NOAM Server group, perform the following steps:
      1. Navigate to Configuration from Main Menu, then select Server Groups.
      2. Select NOAM (Level A) Server Group and click Edit.
      3. Uncheck QS from Server Group and click OK.
   5. Navigate to Configuration from Main Menu, then select Servers and select QS and click Delete.
2. Shutdown QS by running the following command:

   sudo shutdown -h now

3. Install OL8 and KVM on the shutdown BM server.

   Note:

   For information on installing OL8 and KVM, refer to SDS Installation on OL8 and KVM section in SDS Cloud Installation Guide.
4. Create vSDS 9.0.1 VM.
5. Assign XMI IP to new vSDS 9.0.1.
   • To configure netmask and XMI IP address values, run the following command:

     sudo /usr/TKLC/plat/bin/netAdm set --onboot=yes --netmask=<netmask> --device=eth0 --address=<IP address>

6. Log in to SDS Active vSDS 9.0.1 NOAM using XMI.
7. Navigate to Configuration from Main Menu, then select Servers.
8. Click Insert.
9. Add the following details for QS:
   • Enter QS hostname
   • Update Role as Query Server
   • Hardware Profile as SDS Cloud Guest
   • Select NOAM Network element name
10. Click Ok.
11. Export and run TKLCConfigData.sh on SDS 9.0.X VM.
    1. Navigate to Configuration from Main Menu, then select Servers.
    2. Select newly created vSDS QS.
    3. Click Export, to export server configuration file to the file management folder on the Active NOAM.
    4. SSH to Active SDS 9.0.X NOAM and copy TKLCConfigData.<hostname>.sh to the newly created vSDS 9.0.1 QS. After copying, wait for 5 minutes.

       cd $FILE_MGMT_AREA

       sudo scp TKLCConfigData.<hostname>.sh admusr@<XMI IP of newly created vSDS 9.0.x QS>:/var/tmp/TKLCConfigData.sh

    5. Verify the /var/TKLC/appw/logs/Process/install.log file for successfully running TKLCConfigData.sh file. To verify the logs, run following command:

       sudo tail -f /var/TKLC/appw/logs/Process/install.log

    6. Wait for 10 minutes for server to configure with the IP configuration, then reboot the VM using sudo init 6 command on CLI.
12. Add the QS in the server group again on SDS Active NOAM.
    1. Log in to Active SDS NOAM GUI using VIP.
    2. Navigate to Configuration from Main Menu, then select Server Groups.
    3. Select NOAM server group and click Edit.
    4. Select the QS to add to the NOAM Server group.
    5. Click Ok to save the changes and wait for 5 minutes.
    6. If HA state is not Observer, then navigate to Status & Manage from Main Menu, then select HA, to change HA state of QS to Observer.
    7. SSH to newly created vSDS Query Server.
    8. Run the following commands:

       iset -fvalue=1 IdbParamDef where "param='IdbDisableUpgBarrier'"

       sudo init 6

    9. Log in to Active SDS NOAM GUI using VIP.
    10. Navigate to Status & Manage from Main Menu, then select Query Server and click Restart to restart the application.