Removing leftover files from the repository tier (Windows)

When you remove suite software, the software removal program removes only the files that were created as part of the installation of InfoSphere® Information Server. You must manually remove other files from the repository tier computer if you plan to reinstall the suite.

Before you begin

Run the software removal program and ensure that it completed successfully.


  1. Remove unused databases.
    1. If you created the metadata repository database before you installed InfoSphere Information Server, manually drop the metadata repository database.
      The default database name is xmeta.
    2. If you created the IBM® InfoSphere Information Analyzer analysis database before you installed InfoSphere Information Server, manually drop the database.
      The default database name is iadb.
  2. Delete the application server directory.
    The default directory for the folder is C:\IBM\WebSphere\AppServer.
  3. Remove users if they are no longer needed.
    1. Run the following command to delete the users.
      net user username /delete 
    2. If you used the Db2® database system as the metadata repository, delete the following accounts:
      • The Db2 administration server user. Delete this user only if you are also removing Db2. The default user is db2admin.
      • The owner of the metadata repository. The default user is xmeta.
      • The owner of the IBM InfoSphere Information Analyzer analysis database. The default user is iauser.
    3. If you used an Oracle database system or a Microsoft SQL Server database system for the metadata repository, use an Oracle database system command or a Microsoft SQL Server database system command to drop the metadata repository user and schema.
  4. If you used the InfoSphere Information Server installation program to install the IBMDb2 database system, remove the following directories:
    Db2 installation directory
    The default directory is C:\IBM\sqllib.
    Db2 installation drive
    The directory is x:\DB2, where x is the drive where you installed the Db2 database system.
    Db2 users directory
    The default directories are %ALLUSERSPROFILE%\Application Data\IBM\DB2 and %ALLUSERSPROFILE%\Application Data\IBM\DB2History.
  5. If you previously installed older versions of IBM InfoSphere DataStage® or InfoSphere Information Server clients, Windows registry keys might remain on the system after you uninstall the clients. If you have uninstalled all InfoSphere DataStage or InfoSphere Information Server software, delete the following registry keys.
    Depending on the version of software you have installed, only some of the following keys might exist.
    HKEY_CURRENT_USER\Software\Wow6432Node\Ascential Software
    HKLM\SOFTWARE\Ascential Software\ASBNode
    HKLM\SOFTWARE\Ascential Software\DataStage Client
    HKLM\SOFTWARE\Ascential Software\DataStage Multi-Client Manager
    HKLM\SOFTWARE\Ascential Software\Documentation Tool
  6. Delete the groups that contained the deleted users, if you no longer need the groups.
  7. Remove any remaining InfoSphere Information Server users and groups if you are not using them for other purposes.
  8. Restart the computer.