今天安装db29.1在机器上,然后需要建立数据库,在c盘建立pratice目录,然后在建立库时候有提示错误
SQL1052N The database path "C:/pratice" does not exist.
Explanation:
The path specified in the path parameter of the command is not
valid. There is no path with that name.
这个错误报的实在不准确,汗
这个错误在前面解决了,但是解决办法忘记了,今天在review下
db2set -i db2 DB2_CREATE_DB_ON_PATH=YES
其实只要用的命令设置一下DB2的注册表变量并重新启动实例 就可以了。
C:/Program Files/IBM/SQLLIB/BIN>db2set -all
[e] DB2PATH=C:/Program Files/IBM/SQLLIB
[i] DB2PROCESSORS=0,1,2,3
[i] DB2INSTPROF=C:/Documents and Settings/All Users/Application Data/IBM/DB2/testdb2
[i] DB2COMM=TCPIP
[g] DB2_EXTSECURITY=YES
[g] DB2SYSTEM=SENDS-TV
[g] DB2PATH=C:/Program Files/IBM/SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00