Progress数据库的配置和运行

1.  环境变量设置:

   在shell为tcsh的情况, 修改.tcshrc , 加入:

setenv DLC /home/progress/dlc

setenv WRKDIR /home/progress/wrk

setenv PROEXE $DLC/bin/_progres

setenv PROMSGS $DLC/promsgs

setenv PATH "……: $DLC/bin"

2. Progress 数据库的启动:

    progress安装后就已经有demo, sports,isports,sports2000,empty几个初始的数据库.

[root@xfs dlc]# pwd

/home/progress/dlc

[root@xfs dlc]# proserve sports

PROGRESS PATCH Version 9.1C09 as of February 26, 2002

13:54:25 BROKER   : You are not allowed to connect to a database in $DLC. (1379)

13:54:25 BROKER   : ** This process terminated with exit code 2. (8619)

     以上信息表明我们不能在环境变量$DLC指定的路径下直接执行proserve命令初始化和sports数据库的连接.

[root@xfs dlc]# pwd

/root/sports

[root@xfs ~/sports]# ls /home/progress/dlc/sports.*

/home/progress/dlc/sports.b1 /home/progress/dlc/sports.db

/home/progress/dlc/sports.d1 /home/progress/dlc/sports.pl

[root@xfs ~/sports]# ls /home/progress/dlc/sports_*

/home/progress/dlc/sports_7.d1 /home/progress/dlc/sports_8.d1

[root@xfs ~/sports]# cp /home/progress/dlc/sports.* ./

[root@xfs ~/sports]# cp /home/progress/dlc/sports_* ./

[root@xfs ~/sports]# ls

sports_7.d1 sports_8.d1 sports.b1 sports.d1 sports.db sports.pl

      sports.*和sports_*等文件是sports数据库存储在磁盘上的所有必须的文件, 我们把它们一起copy到/root/sports/下面,   就等于将sports数据库复制一份到/root/sports下面了.

 

[root@xfs ~/sports]# proserve sports -S 2000 -N tcp

PROGRESS PATCH Version 9.1C09 as of February 26, 2002

18:00:01 BROKER 0: Multi-user session begin. (333)

18:00:01 BROKER 0: Begin Physical Redo Phase at 0 . (5326)

18:00:01 BROKER 0: Physical Redo Phase Completed at blk 0 off 167 upd 0. (7161)

18:00:01 BROKER 0: Started for 2000 using tcp, pid 26815. (5644)

 

-S 2000 表示在端口 2000 上提供 sports 数据库的连接服务 , -N tcp 表示以 tcp socket 提供连接 ( 或者选择 udp),  如果不加上 -S 2000, 则 proserve sports 虽然没有出错信息 , 但并未能初始化 sports 数据库的连接服务 .

启动 sports 数据库的连接服务后 ,

[root@xfs ~/sports]# netstat -a|grep 2000

tcp        0      0 *:2000                  *:*                     LISTEN

[root@xfs ~/sports]# ls

sports_7.d1 sports.b1 sports.db sports.lic sports.pl

sports_8.d1 sports.d1 sports.lg sports.lk

可以看到多了sports.lg , sports.lic, sports.lk   3个文件.

[root@xfs ~/sports]# ps -ef | grep progress

root     25601     1 0 13:32 pts/0    00:00:00 /home/progress/dlc/bin/_mprosrv

_mprosrv为监控和提供数据库连接服务的进程.

 

3. SQLExplorer:   类似Oracle sql plus