I am trying to open up sample database but i cannot go through and it pop up with these message : Existing "SAMPLE" database found... The "-force" option was not specified... Attempt to create the database "SAMPLE" failed. SQL1005N The database alias "SAMPLE" already exists in either the localdatabase directory or system database directory.
Is there anyone who can help me on it
Hello, Mr. Sarbjit
I am Thanking you for your reply and your solution for the simple database.
Thank you Sir
did you tried with the following option, This will drop the existing sample db and then create new sample db.
$ db2sampl -force
If this doesn't help then you need to delete db directory manually and the create SAMPLE db using db2sampl.