How to recreate all the indexes in the 'mdb' database and remove leftover data from rollback?
NSM 11.2 SP2 CUM1 on AIX running JMO.
- unisrvcntr stop all
- with a tar command, save the PostGres database located in directory /opt/CA/SharedComponents/pgsql
- unisrvcntr start postgres
Then while logged on as 'root', run the following commands:
psql mdb <passwd>
vacuum verbose analyze;
reindex database mdb;
<passwd> is the password of the 'mdbadmin' account created during the NSM installation, default value is mdbadmin.