IBM Support

Procedure to remove the DASH HA "tipds" datasource via CLI

Question & Answer


Question

Is there a way to remove the "tipds" WAS datasource from a DASH server?

Cause

In the event of a catastrophic problem with the HA DB2 instance and the WAS Admin Console cannot be accessed, this CLI option can be used for any DASH version 3.1.2 or newer.

Answer

To temporarily remove the "tipds" datasource, the following procedure can be used:

  1. Stop any DASH server in the cluster that may be running.
  2. Create a back up of the "resources.xml" file in each DASH server. There will be a "resources.xml" copy in the "cells", "nodes", and "servers" directories. You must back up the copy of the file in the directory that matches the scope where you created the "tipds" datasource. Search the resources.xml copies under the following directories for one that contains the "tipds" string, and back up that copy:
    [JazzSM Home]/profile/config/cells/JazzSMNode01Cell/
    [JazzSM Home]/profile/config/cells/JazzSMNode01Cell/nodes/JazzSMNode01/
    [JazzSM Home]/profile/config/cells/JazzSMNode01Cell/nodes/JazzSMNode01/servers/server1

    For example, make a backup called resources.xml.bak

  3. Use the following wsadmin commands to remove the "tipds" datasource:
    1. ./wsadmin.sh -lang jython -conntype NONE
    2. wsadmin> AdminTask.listDatasources('-interactive')

      Scope string (scope): <scope> ## specify the cope that matches the directory of the edited resources.xml file. The possible values are "Cell", "Node", "Server". For example:


      Scope string (scope): Node

      When prompted:

      F (Finish)
      C (Cancel)

      Choose "F".

      Command output:

      'tipds(cells/JazzSMNode01Cell/nodes/JazzSMNode01|resources.xml#DataSource_1465485777656)'

      If there are multiple datasources defined at the specified scope, they will all be listed together in one continuous line in the output of the command.
    3. Execute the "deleteDatasource" option passing the portion of the output of the "listDatasources" command that is in parenthesis.

      wsadmin> AdminTask.deleteDatasource('DB2 Universal JDBC Driver Provider (XA) <listDatasources entry for "tipds" in parenthesis>

      Using the listDatasources example in step 2 above the command looks like:

      wsadmin> AdminTask.deleteDatasource('DB2 Universal JDBC Driver Provider (XA) (cells/JazzSMNode01Cell/nodes/JazzSMNode01|resources.xml#DataSource_1465485777656)')

      Command output:
      '"DB2 Universal JDBC Driver Provider (XA) (cells/JazzSMNode01Cell/nodes/JazzSMNode01|resources.xml#DataSource_1465485777656)"\nData source tipds has been successfully deleted.\n'
    4. Save the change:

      wsadmin> AdminConfig.save()


    Once the DB2 issue is addressed, you can restore the backup copy of the resources.xml and restart DASH. On restart DASH will be rejoined to the cluster.


[{"Product":{"code":"SSRLR8","label":"Tivoli Components"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Jazz for Service Management","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.1.2;1.1.2.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2018

UID

swg21985052