Start by running the 'db2 list database directory'
command, this should give you information on
existing databases. If ypur database is not on the list
and you're attached to the right instance - the db
doesn't exist and you dont need to drop it.
If it exists and you cannat access it, simply run the
'db2 drop database databasename' command.
Originally posted by bollin99
Database server = DB2/LINUX 8.1.3
SQL1013N The database alias name or database name "DXDMIS01" could not be found. SQLSTATE=42705
Encountered this problem after RESTARTING THE INSTANCE.
Can somebody please tell me how I can get back the database.
Obviously Cannot connect to the database. If not connect atleast Drop the Database.
If 'db2 list db directory' doesn't show it you first need to check if it's still on disk. If nothing special was specified when creating the database it should be in the default db directory which is specified in the instance variable DFTDBPATH.
If so, you can catalog the db again using the command
'db2 catalog db DXDMIS01 on <DFTDBPATH>'.
If you specified another location for your database when creating it you need to check that location and use it in the 'catalog db' command.