Post-Installation Tasks › Maintaining the MDB › Uninstallation of DSM Manager and MDB › data_uninstall Command—Delete Data from the Database

data_uninstall Command—Delete Data from the Database

Use the data_uninstall command to delete data from the database or check the database for products and domains registered. The data_uninstall command supports Microsoft SQL Server and Oracle.

This command has different formats:

data_uninstall -server server_name

-instance instance_name:port_number
-database database_name
-asset {k | d }
-pdata {k | d }
-cdata {k | d }
-user
-pwd

Deletes data from the database depending on the k or d flags (k = keep the data, d = delete the data) given as arguments. (You will get this usage if you run the command without any arguments.)

data_uninstall -server server_name

-instance instance_name:port_number
-database database_name
-check

Prints the number of products registered in the MDB as well as the number of domains registered in the database.

data_uninstall -server server_name

-instance instance_name:port_number
-database database_name
-sdonly

Deletes only software delivery data depending on the object in the file system. This command also deletes all MDB references to OSIM and boot images.

‑server server_name

Specifies the name of the local RDBMS system.

Important! The name of the database server plus the name of the database instance must have a maximum overall length of 29 characters.

‑instance instance_name:port_number

Identifies the database instance, for example, a Microsoft SQL Server instance name. The specification of the port number is mandatory, except in case of the Microsoft SQL Server default instance. In case of the Microsoft SQL Server default instance, you must use double quotes to define an empty name like ‑instance "".

‑database database_name

In the case of SQL Server, specifies the name of the database, for example, mdb.

In the case of Oracle, specifies the SID.

‑asset {k|d}

Specifies if asset data should be unregistered. Use ‑asset k to keep assets and ‑asset d to unregister assets.

-pdata {k|d}

Specifies if product-specific data should be deleted. Use ‑pdata k to keep the data and ‑pdata d to delete the data.

-cdata {k|d}

Specifies if CA ITCM common data should be deleted. Use ‑cdata k to keep the data and ‑cdata d to delete common data.

‑user user_name

Specifies the user name to connect to the database, for example, ca_itrm.

‑pwd password

Specifies the password of the user specified through ‑user.

‑check

Checks if CA Technologies products are still registered in the database and which domains are registered.

‑sdonly

Deletes only software delivery data that relates to objects in the file system, including OSIM and boot data.

Example: Check products and domains

This example only checks if CA Technologies products are still registered in the MDB database and lists all domains registered.

data_uninstall -server myMachine

-instance ""
-database mdb
-check

Example: Delete data except assets

This example deletes all CA ITCM data from the MDB database but does not deregister the assets.

data_uninstall -server myMachine

-instance ""
-database mdb
-check
-asset k 
-pdata d 
-cdata d 
-user ca_itrm
-pwd myPassword