You need to make the other aliases "disappear". To do this, issue a command db2 uncatalog db <aliasname>
The aliasname is whatever of the two names that are left after your issuing the drop with the third name. You can then recreate the db with whatever name and alias you want. Restoring, if you have a backup could also do it. HTH, Pierre. [EMAIL PROTECTED] wrote: >Hi, > Looks like I made a booboo! > >I had a database (say DBX) and three aliases to it (Say DBA DBB DBC). > >In attempting to write a script to perform some maintenance I >issued a DROP DB command against one of the aliases, this appeared >to drop the underlying database whilst leaving the other aliases lying >around. > >Now I am getting lots of problems with being unable to >drop databases because they don't exist but then I can't create them >because they apparently do exist. > > >Is there an easy way to tidy up > > >TIA > >Steve T > >- >::: When replying to the list, please use 'Reply-All' and make sure >::: a copy goes to the list ([EMAIL PROTECTED]). >*** You are subscribed to [EMAIL PROTECTED] >*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > -- Pierre Saint-Jacques 514-737-4515 Off. IBM Certified Solutions Expert - Administration President 514-737-1268 Fax. 233 Simcoe Cr. SES Consultants Inc. [EMAIL PROTECTED] Mount-Royal, QC Canada H3P 1X1 - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
