hcilmclear

This command cleans up after a crashed engine that has not properly disconnected from the Lock Manager.

hcilmclear {-s | -p process -m | { -A | -a tablename }} [-v]
  • -s prints a status report for all database users of the Lock Manager.
  • -p process specifies the name of the engine process to clean up.
  • -m cleans up the database user for hcimonitord.
  • -A cleans up all database users for hcimsgarchive.
  • -a tablename cleans up the database user that is specified by tablename for hcimsgarchive.
  • -v specifies verbose mode.

This command clears up database problems, such as db_vista -921, which indicates the user is already in the database from a failure to previously log out. This can happen when a process panics or is otherwise stopped during running.

This command also eliminates the requirement to shut down the entire site to cycle the Lock Manager. This happened when a process crashed or did not shut down properly.

In most cases, this command should run automatically, but the command can also be run manually.

This is valid for Windows and UNIX users.