IBM Security Identity Governance and Intelligence, Version 5.2.3.1

Clear the service integration bus

If you encounter any configuration or login problems when you work with IBM® Security Identity Governance and Intelligence, you must clear the Service Integration Bus (SIB) data from the database.

Ensure that you have the needed administrative authority. On Windows systems, the login user ID must be in the Administrators Group. On UNIX or Linux systems, the login user ID must be root.

To clear theService Integration Bus, complete these steps.

Ensure that the database is running (IGIDB).
Start the DB2® command line.
Windows
1. Start the Windows command prompt.
2. Run the following command:
  set DB2INSTANCE=db2admin where db2admin is the database administrator.
3. Run db2cmd to start the DB2 command line.
Linux

Run the command su - db2admin where db2admin is the database administrator.
In the DB2 command line, enter the DELETE SQL statements that you require to delete all data from the tables in the Service Integration Bus schemas.
Enter the following commands for each of the Service Integration Bus schema in your environment:
```
db2 delete from schema_name.SIB000
db2 delete from schema_name.SIB001
db2 delete from schema_name.SIB002
db2 delete from schema_name.SIBCLASSMAP
db2 delete from schema_name.SIBKEYS
db2 delete from schema_name.SIBLISTING
db2 delete from schema_name.SIBXACTS
db2 delete from schema_name.SIBOWNER
db2 delete from schema_name.SIBOWNERO
```
Where the Service Integration Bus schema schema_name is ITIML000 for a single server, and ITIML000, ITIML0001, ITIML002, ITIML003, and ITIMS000 are for a cluster environment. For a cluster, the number of schemas such as ITIML0001, ITIML0002, or other schemas vary depending on the number of nodes in the cluster. ITIMS000 is also one of the schema names for the cluster.

Note: The SIBOWNER0 might not exist in all Identity data store environments. If it does not exist and the delete statement fails, you can ignore the failure.