Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic SYNERGY (steve huntington)
Decrease font size
Increase font size
Topic Title: removing database from the system
Topic Summary: trouble deleting database
Created On: 6-Dec-2005 15:49
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Toni Arte, on Wednesday, December 7, 2005 4:11 PM

Answer:
It seems that you have relocated the database directory somewhere, try to find it from your system. What does 'ccmsrv status -s caev880' say (that should display the database paths of all databases on that Informix instance)? That should give you a database path you can use with the 'ccmdb' command, and if the directory does not exist at all, you can get rid of the Informix part by using 'ccmdb drop' command ('ccmdb delete' is the same as doing 'rm -rf' on the database path + 'ccmdb drop').
 6-Dec-2005 15:49
User is offline View Users Profile Print this message


Alicia Ade-Kuhn

Posts: 6
Joined: 14-Nov-2005

While trying to rename a database using the ccmdb info command an arguement in string was left off. Not knowing whether the command took place the original database was deleted. Now trying to add back the database the system says that it already exists and will not allow to add database with name desired but if I try to delete it it says that it does not exist. It would seem that I need to remove something from informix database. Question is how to do it? Any help would be appreciated thanks

caev880:ccm_root % ccmdb info /apps/ccm_synergy/db63/PAM_SCRS

ERROR: Directory '/apps/ccm_synergy/db63/PAM_SCRS' does not exist!

caev880:ccm_root % ccmdb info /apps/ccm_synergy/db63/pam_scrs

ERROR: Directory '/apps/ccm_synergy/db63/pam_scrs' does not exist!

caev880:ccm_root % ccmdb info /apps/ccm_synergy/db63/PAM_SCRS/db -k dbpath -v /apps/ccm_synergy/db63/pam_scrs/db

ERROR: Directory '/apps/ccm_synergy/db63/PAM_SCRS/db' does not exist!

caev880:ccm_root % cd /software/ccm63/packfiles
caev880:ccm_root % pwd
/software/ccm63/packfiles
caev880:ccm_root % ccmdb unpack base.cpk -t /apps/ccm_synergy/db63/pam_scrs

WARNING: database name '//caev880/pam_scrs' already exists in database server 'caev880'.
         Please use a different database name to retry the operation.

caev880:ccm_root % ccmdb delete /apps/ccm_synergy/db63/pam_scrs

ATTENTION:  This command will delete database /apps/ccm_synergy/db63/pam_scrs
            It cannot be recovered after being deleted.

Do you want to continue (Y/N)? [N] y
ERROR: database path does not exist: /apps/ccm_synergy/db63/pam_scrs
caev880:ccm_root %

Report this to a Moderator Report this to a Moderator
 7-Dec-2005 07:47
User is offline View Users Profile Print this message


Toni Arte

Posts: 30
Joined: 16-Aug-2004

Answer Answer
It seems that you have relocated the database directory somewhere, try to find it from your system. What does 'ccmsrv status -s caev880' say (that should display the database paths of all databases on that Informix instance)? That should give you a database path you can use with the 'ccmdb' command, and if the directory does not exist at all, you can get rid of the Informix part by using 'ccmdb drop' command ('ccmdb delete' is the same as doing 'rm -rf' on the database path + 'ccmdb drop').
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic SYNERGY forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 15:34.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.