Cannot delete CMSynergy database

(Last modified: 15Apr2004)

This document (10080280) is provided subject to the disclaimer at the end of this document.

symptom

Cannot delete CMSynergy database

Can't delete database

ERROR: Database is not inactive, can't continue.

425: Database is currently opened by another user.

INFORMIX: -425, ISAM: -107

fact

Telelogic CMSynergy

note

The normal procedure for deleting a database is as follows:

ccmdb shutdown <dbpath>
ccmdb delete <dbpath> -y

Sometimes, however, the ccmdb delete fails: "ERROR: Database is not inactive, can't continue." If you try ccmdb drop at this point, you get "425: Database is currently opened by another user."

cause

This problem is caused by a session in the database that is invisible to the /usr/local/bin/sessions command and is not killed by ccmdb delete. The reason for the existence of this "invisible" session is not known.

fix

To find and kill this "invisible" session, log into the appropriate engine host as the informix user and do the following. These instructions assume you are using bash or ksh. We also assume that you have already run ccmdb shutdown and tried to run ccmdb delete on the database.

  1. export CCM_HOME=<ccm path>
  2. export INFORMIXDIR=$CCM_HOME/informix
  3. export ONCONFIG=<name of informix database server>
  4. export INFORMIXSERVER=<name of informix database server>
  5. export PATH=$CCM_HOME/bin:$INFORMIXDIR/bin:$PATH
  6. onstat -g sql

This onstat command produces a list of entries that look like this:

24    -              train              CR  Not Wait   0    0    9.03

The first field is the session id and the third field is the database associated with that session. You should see at least one session in the database you're trying to delete. Using that session id, run this command:

onmode -z <session_id>

For example,

onmode -z 24

You should now be able to log in as ccm_root and delete the database using ccmdb delete.

document

Document Title: Cannot delete CMSynergy database
Document ID: 10080280
Solution ID: NOVL87158
Creation Date: 14Feb2003
Modified Date: 15Apr2004
Novell Product Class:Third Party

disclaimer

The Origin of this information may be internal or external to Novell. Novell makes all reasonable efforts to verify this information. However, the information provided in this document is for your information only. Novell makes no explicit or implied claims to the validity of this information.
Any trademarks referenced in this document are the property of their respective owners. Consult your product manuals for complete trademark information.