Very Computer

i had two databases which got hosed.  all traces are gone,
except that the file SQLDBDIR still contains entries, which
show up in Control Center db tree.  tired of looking at
them.

is there a way to tell DB2 to rebuild SQLDBDIR?  alternatively,
i've looked at the file in my trusty hex editor, and can
identify the entries; to a degree.  can see the db names as
pairs.  can't tell where the entries start and stop, nor
whether there is a db count that has to be changed.

any way?

DB -> 7.1 fp 3
OS -> NT4/SP6

toodles,
robert

Quote:>i had two databases which got hosed.  all traces are gone,
>except that the file SQLDBDIR still contains entries, which
>show up in Control Center db tree.  tired of looking at
>them.

>is there a way to tell DB2 to rebuild SQLDBDIR?  alternatively,
>i've looked at the file in my trusty hex editor, and can
>identify the entries; to a degree.  can see the db names as
>pairs.  can't tell where the entries start and stop, nor
>whether there is a db count that has to be changed.

>any way?

>DB -> 7.1 fp 3
>OS -> NT4/SP6

>toodles,
>robert

Try using "db2 uncatalog database MYDB"... that should remove them
from the SQLDBDIR

after hitting the send button, thought i should have mentioned
that i tried that.  got back message that DB didn't exist.  went
so far as to create a new database with same number of characters
in name; copy the data directory in C:\DB2; change names and
directory numbers in the files.  still won't get rid of it.

tried UNCATALOG with ODBC option:  said that was successful,
but the little blighters won't go away.

toodles
robert