Question on create a database in DB2# Database - 数据库
M*r
1 楼
When I create a database
Command used:
CREATE DATABASE testdb AUTOMATIC STORAGE YES ON 'C:\DB2Data' DBPATH ON 'C:\
db2data' USING CODESET 1252 TERRITORY US COLLATE USING SYSTEM PAGESIZE 8192;
SQL1052N The database path "C:\db2data" does not exist.
I do make sure C:\db2data exists on C drive before I run the command, also,
it is empty.
If I change the path to 'C', it works.
Why?
How can I create a database in folders like C:\db2data?
Command used:
CREATE DATABASE testdb AUTOMATIC STORAGE YES ON 'C:\DB2Data' DBPATH ON 'C:\
db2data' USING CODESET 1252 TERRITORY US COLLATE USING SYSTEM PAGESIZE 8192;
SQL1052N The database path "C:\db2data" does not exist.
I do make sure C:\db2data exists on C drive before I run the command, also,
it is empty.
If I change the path to 'C', it works.
Why?
How can I create a database in folders like C:\db2data?