This section provides helps you execute database uninstallation SQL scripts.
The directory context for DB2 is install-dir\DirXMLUtilities\jdbc\sql\db2_udbl\install.
Drop the idm, indirect, and direct operating system user accounts.
If you haven’t already done so, change the name of the administrator account name and password in the installation scripts.
Using the Command Line Processor (CLP), execute the uninstall.sql script.
For example: db2 -f uninstall.sql
This script won’t execute in the Command Center interface beyond version 7 because the script uses the \ line continuation character. Later versions of the Command Center don’t recognize this character.
Delete the idm_db2.jar file.
The directory context for Informix SQL scripts is install-dir\jdbc\sql\informix_ids\install.
Drop the idm operating system user account.
Start a client such as SQL Editor.
Log on to your server as user informix or another user with DBA (database administrator) privileges.
By default, the password for informix is informix.
If you execute scripts as a user other than informix, change all references to informix in the install scripts prior to execution.
If you aren’t using the informix account with the default password, change the name of the DBA account name and password in the installation scripts.
Open and execute uninstall.sql from the ansi (transactional, ANSI-compliant), log (transactional, non-ANSI-compliant), or no_log (non-transactional, non-ANSI-compliant) subdirectory, depending upon which type of database you installed.
The directory context for Microsoft SQL Server scripts is install-dir\jdbc\sql\mssql\install.
Start a client such as Query Analyzer.
Log on to your database server as user sa.
By default, the sa user has no password.
Open and execute the first installation script, uninstall.sql.
The execute hotkey in Query Analyzer is F5.
The directory context for MySQL SQL scripts is install-dir\jdbc\sql\mysql\install.
From a MySQL client, such as mysql, log on as user root or another user with administrative privileges.
For example, from the command line execute mysql -u root -p
By default, the root user has no password.
Execute the uninstall.sql uninstallation script.
For example: mysql> \. c:\uninstall.sql
Don’t use a semicolon to terminate this statement.
The directory context for Oracle SQL scripts is install-dir\jdbc\sql\oracle\install.
From an Oracle client, such as SQL Plus, log on as user SYSTEM.
By default, the password for SYSTEM is MANAGER.
If you execute scripts as a user other than SYSTEM with password MANAGER, change all references to SYSTEM in the scripts prior to execution.
Execute the uninstallation script uninstall.sql.
For example: SQL> @c:\uninstall.sql
The directory context for PostgreSQL scripts is install-dir\jdbc\sql\postgres\install. The directory context for executing Postgres commands is postgres-install-dir/pgsql/bin.
From a Postgres client such as psql, log on as user postgres to the idm database.
For example, from the UNIXC command line, execute ./psql -d idm postgres
By default, the Postgres user has no password.
From inside psql, execute the script uninstall.sql.
For example: idm=# \i uninstall.sql
Drop the database idm.
For example, from the UNIX command line, execute ./dropdb idm
Remove or comment out entries for the idm user in the pg_hba.conf file.
For example:
#host idm idm 255.255.255.255 255.255.255.0
Restart the Postgres server to effect changes made to the pg_hba.conf file.
The directory context for Sybase SQL scripts is install-dir\jdbc\sql\sybase_ase\install.
From a Sybase client, such as isql, log on as user sa.
Execute the installation script uninstall.sql.
For example, from the command line, execute isql -U sa -P -i uninstall.sql
By default, the sa account has no password.