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
Thank you
Tags: Help
Permalink Reply by kunal on April 23, 2011 at 8:00pm Hello, Mr. Sarbjit
I am Thanking you for your reply and your solution for the simple database.
Thank you Sir
Permalink Reply by Gopi on July 27, 2011 at 2:13am 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.
Best Regards,
Venu
Explore in-memory and columnar technologies through this active approach to exploring emerging technologies.
![]() |
FREE Book: Getting started with DB2 |
© 2013 Created by channeldb2.