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 

Views: 6787

Reply to This

Replies to This Discussion

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.


Best Regards,



Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service