Dropping an orphaned database
Hello,
I have a test-box that had a problem with a chunk. That's been resolved, but I
have a couple of orphaned test-databases on my IDS 10.00.FC5 system. I am
unable to "DROP DATABASE TEST-1" due to an error of missing SYSUSERS table in
the DB space. The DB is orphaned, and I just need to drop it from
sysmaster:sysdatabases.
How is the best way to do that without doing an "oninit -ivy" ?
Thanks.
Jonathan B. Smaby
Pomona College
phone: (909) 621-8506
email: jonathan.smaby@pomona.edu
-------------------------------------------------------------
This message has been scanned by Postini anti-virus software.
If the database catalog is damaged you may not be able to do anything about
it yourself. IBM tech support can probably clear up the problem, but it's
safer to unload the surviving databases and init the server with oninit -i
and load everything into a clean instance.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Tue, Aug 25, 2009 at 6:20 PM, Jonathan Smaby
<Jonathan.Smaby@pomona.edu>wrote:
> Hello,
>
> I have a test-box that had a problem with a chunk. That's been resolved,
> but I
> have a couple of orphaned test-databases on my IDS 10.00.FC5 system. I am
> unable to "DROP DATABASE TEST-1" due to an error of missing SYSUSERS table
> in
> the DB space. The DB is orphaned, and I just need to drop it from
> sysmaster:sysdatabases.
>
> How is the best way to do that without doing an "oninit -ivy" ?
>
> Thanks.
>
> Jonathan B. Smaby
> Pomona College
> phone: (909) 621-8506
> email: jonathan.smaby@pomona.edu
>
> -------------------------------------------------------------
> This message has been scanned by Postini anti-virus software.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001517478644e893160471ff10b0