dm 320

〇〇

复制了dm.key还是不行
linux-r49z:~ # cd /tmp/dm7_neoky5_64
linux-r49z:/tmp/dm7_neoky5_64 # cp dm.key /opt/dmdbms/bin
linux-r49z:/tmp/dm7_neoky5_64 # su - dmdba
dmdba@linux-r49z:~> cd /opt/dmdbms/
dmdba@linux-r49z:/opt/dmdbms> bin/dminit PATH=/dm7data PAGE_SIZE=16
initdb V7.1.3.53-Build(2014.03.20-40793trunc)
db version: 0X70008
file dm.key not found, use default license!
create directory '/dm7data/DAMENG' failed
dmdba@linux-r49z:/opt/dmdbms> cd bin
dmdba@linux-r49z:/opt/dmdbms/bin> ./dminit PATH=/dm7data PAGE_SIZE=16
initdb V7.1.3.53-Build(2014.03.20-40793trunc)
db version: 0X70008
create directory '/dm7data/DAMENG' failed
dmdba@linux-r49z:/opt/dmdbms/bin> ll dm.key
-rw-r--r-- 1 root root 648  3鏈?26 13:09 dm.key

〇〇

〇〇 发表于 2014-3-26 13:09
复制了dm.key还是不行
linux-r49z:~ # cd /tmp/dm7_neoky5_64
linux-r49z:/tmp/dm7_neoky5_64 # cp dm.ke ...

原来是dmdba没有权限，用root
dmdba@linux-r49z:/opt/dmdbms/bin> exit
logout
linux-r49z:/tmp/dm7_neoky5_64 # cd /opt/dmdbms/bin
linux-r49z:/opt/dmdbms/bin # ./dminit PATH=/dm7data PAGE_SIZE=16
initdb V7.1.3.53-Build(2014.03.20-40793trunc)
db version: 0X70008
create dm database success. 2014-03-26 13:11:38

〇〇

都是root权限，太不方便了
linux-r49z:/opt/dmdbms/bin # cd /dm7data
linux-r49z:/dm7data # ll
total 4
drwxr-xr-x 3 root root 4096 Mar 26 13:11 DAMENG
linux-r49z:/dm7data # cd DA*
linux-r49z:/dm7data/DAMENG # ll
total 131924
-rw-r--r-- 1 root root  67108864 Mar 26 13:11 DAMENG01.log
-rw-r--r-- 1 root root  67108864 Mar 26 13:11 DAMENG02.log
drwxr-xr-x 2 root root      4096 Mar 26 13:11 HMAIN
-rw-r--r-- 1 root root 134217728 Mar 26 13:11 MAIN.DBF
-rw-r--r-- 1 root root 134217728 Mar 26 13:11 ROLL.DBF
-rw-r--r-- 1 root root  10485760 Mar 26 13:11 SYSTEM.DBF
-rw-r--r-- 1 root root      5120 Mar 26 13:11 dm.ctl
-rw-r--r-- 1 root root     18429 Mar 26 13:11 dm.ini
-rw-r--r-- 1 root root       633 Mar 26 13:11 dm_service.prikey
-rw-r--r-- 1 root root       697 Mar 26 13:11 dminit20140326131134.log

〇〇

./dmserver /dm7data/DAMENG/dm.ini

trx: 1209 purged 1 pages
trx: 1210 purged 1 pages
trx: 1211 purged 1 pages
trx: 1212 purged 1 pages
trx: 1213 purged 1 pages
trx: 1214 purged 1 pages
trx: 1216 purged 1 pages
trx: 1217 purged 1 pages
SYSTEM IS READY.

Invalidate command.

〇〇

〇〇 发表于 2014-3-26 13:25
./dmserver /dm7data/DAMENG/dm.ini

trx: 1209 purged 1 pages

在另一个窗口
linux-r49z:/opt/dmdbms/bin # ./disql
disql V7.1.3.53-Build(2014.03.20-40793trunc)
username:sysdba
password:
[-2501]:Invalid username or password.
username:SYSDBA
password:

Server[LOCALHOST:5236]:mode is normal, state is open
normal user login

login used time: 2.750(ms)
Connected to: DM 7.1.3.53
SQL>select count(*) from user_segments;

LINEID     COUNT(*)            
---------- --------------------
1          0                  

used time: 79.880(ms). Execute id is 528.
SQL>c/user/dba
2   /
c/user/dba

c/user/dba
*         
line 1, column 1, nearby [/] has error[-2007]:
Syntax error.
SQL>select count(*) from dba_segments;

LINEID     COUNT(*)            
---------- --------------------
1          36                  

used time: 757.346(ms). Execute id is 529.
SQL>

情殇无恒

版主有没有点性能上的测试啊，只纠结功能兼容性，那不如直接用oracle，mysql，mssql，毕竟别人的成熟度还高些呢。

〇〇

情殇无恒 发表于 2014-3-27 11:58
版主有没有点性能上的测试啊，只纠结功能兼容性，那不如直接用oracle，mysql，mssql，毕竟别人的成熟度还高 ...

举个例子，最好有create 、insert、 select语句