DB2 Rookie
The road to becoming a DB2 DBA
Installing DB2 Express-C on Windows 7 64bit – The registry key problem
Posted by on June 12, 2011
Last time I had this problem with the installation on Windows 7. The solution was not easy to find, especially for a rookie like me. It was very straight forward after all. I tried to find the problematic key, but I couldn’t find it. Once I realized it was never created, I couldn’t figure out how to create it. Regedit was no help either. So long story short, here’s what to do if you run into this error message:
The path specified in the "" parameter of the command is not
valid. Either there is no path with that name, or a path has been
specified when the DB2_CREATE_DB_ON_PATH registry variable is disabled
(Windows only).
And the solution is:
- Stop the server
- Open a command line as Admin (right click- > Run as Admin)
- Issue the command:
db2set DB2_CREATE_DB_ON_PATH=YESin the command line. - Start the server
Now you are able to create your DB in a custom location, but you probably do not want to, unless you have a good reason, like running low on disk space.
So next time you try to create your DB, it should work, but at this point, it’s not yet created.
In the next post I’ll show you how to create it after the installation is done.
Pingback: Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial « multidimensionalmayhem