Progress数据库的配置和运行.doc

Progress数据库的配置和运行 作者: Wooce 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.