Checking the consistency of the SESA Database on SSIM

Products

• Security Information Manager

Issue/Introduction

You want to check if the SESA database is corrupted

Resolution

You can use the db2dart command to check the architectural structure of a database in DB2
The SESA database shouldn't be in use when running the db2dart tool.

Follow the steps below to run db2dart:

1. Login as db2admin via ssh and su to root:
su -

2. Change the directory and run the stopall.sh command
cd /opt/Symantec/simserver/simdbmu/bin/
sh stopall.sh

3. Stop the simdbmu and rxregistry service
/etc/init.d/simdbmu stop
/etc/init.d/rxregistry stop

4. Logout as root

5. As db2admin force all applications to be disconnected from the database
db2 force application all

6. Run the db2dart command
db2dart SESA /DB

This will create a report file SESA.RPT in the home directory (/dbsesa/db2admin) of the db2admin user.
You can copy this file offbox and review it with any text editor.

After that you can either restart the services or reboot the appliance.

To restart the services:

1. Login as db2admin via ssh and su to root:
su -

2. Start the rxregistry and simdbmu service
/etc/init.d/rxregistry start
/etc/init.d/simdbmu start

3. Start all other services
cd /opt/Symantec/simserver/simdbmu/bin
sh startall.sh



References
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0003477.htm