When uninstalling the DSM manager, the MDB is not uninstalled and remains on the system.
The MDB is used by different CA Technologies products that may be installed locally together with the MDB or that may be using it remotely. Uninstalling one of these CA Technologies products does not necessarily mean that the MDB is no longer used.
We recommend that uninstalling the MDB and the selected MDB provider should only be done by an authorized administrator after having carefully considered all implications of local or remote usage by other CA Technologies products.
A Microsoft SQL Server MDB can be removed using the Microsoft SQL Enterprise Manager, where you can select the MDB database and delete it. Another tool that can be used to delete an MS SQL Server MDB is SQL Server Management Studio.
To remove an Oracle MDB, use the setup program and select "uninstall" to remove the PIF product part of the MDB schema. Then logging in as 'oracle', you can use the Oracle dbca administration tool to delete the database tables. Finally, any remaining files in the ../opt/CA/SharedComponents/oracle/mdb folder can be removed manually by logging in as 'root'.
Note: For more information about removing an Oracle MDB, see the MDB Overview (which is part of the CA ITCM documentation set (Bookshelf)) or the appropriate Oracle documentation.
If you uninstall a DSM manager, you must manually remove the ca_itrm user from the Microsoft SQL Server, as well as the ca_itrm_ams account if present. If the ca_itrm user remains in the Microsoft SQL Server, a new installation of CA ITCM using this SQL Server may not be possible. If CCS has been used and is also uninstalled, the nsmadmin and hostname\TNDUsers accounts will also need to be deleted from SQL Server.
If you uninstall a DSM manager, the corresponding data contained in the MDB is not removed by default.
The CA ITCM installation wizard provides the feature to remove data from the MDB.
If, for any reason, you do not choose this way to remove data from the MDB, you must run the script data_uninstall to clean up the MDB. This script supports Microsoft SQL Server and Oracle. The appropriate versions of the script, data_uninstall.bat (for SQL Server) and data_uninstall.sh (for Oracle), are available at the following locations on the CA ITCM installation DVD:
Copy all files from the respective subdirectory to your local manager system and run the data_uninstall script with appropriate parameters from the command prompt.
Following is a list of scenarios and business cases that explain the use of the data_uninstall script:
If CA ITCM was the only application, you may remove the MDB manually.
Otherwise, run the data_uninstall script and set the flags for ‑pdata d and ‑data d.
If CA ITCM was the only application, you may remove the MDB manually.
Otherwise, run the data_uninstall script and set the flags ‑pdata d and ‑cdata d.
If you want to remove the registered assets as well, you should set the argument ‑asset d.
In this case, at least some data must be removed referring to file system objects. Therefore, run the data_uninstall script and set the ‑sdonly flag. This will remove the references to related software delivery file system objects, including Operating System Installation Management (OSIM) and boot information.
|
Copyright © 2013 CA.
All rights reserved.
|
|