sysmod - Modifying the System Catalogs

To optimize the Accelerator database, you should periodically run the sysmod command. This command modifies the system catalogs of your database to their current storage structure. By doing so, you remove overflow and deleted pages, which accelerates query processing.

To use the sysmod command as demonstrated in the following sections you must be logged on as the actian or root user.

To run sysmod over the Hubble database

Note: The sysmod operation requires exclusive access to the database

To ensure you have exclusive access to the database, you will need to follow the instructions in the following order:

1. Follow the instructions given in Shutdown Replication.

2. Follow the instructions given in Disable new connections to the Accelerator Database.

   Log on to the Accelerator server and run the following command:

   sysmod <database>

   For example, the default database is db:

   sysmod db

   Follow the instructions given in Manual Replication Service Startup

   The replication tasks can be restarted in the following two modes:

   • Resume: will read the source database log and resume reading the changes from where it left off.

   • Reload: will reload the data from the source database and then read the changes from the source database log.