互联网服务portal 8.0
Portal每次备份数据库以后都很慢，什么原因
大家好！
我的环境Linux6.3+Portal8.0+DB2 9.7都是在同一台服务器上，写了个定时作业备份，但是每次备份以后，Portal都很慢，备份前打开页面2~3秒，备份后则要8秒左右，有谁知道是什么原因吗？我登陆多次（20次以上）以后，又变快了
数据库备份脚本如下：
echo -------------备份数据库-----------
datedir=`date +%Y-%m-%d`
delete_date=`date +%Y-%m-%d --date='7 days ago'`
backupdir=/home/backup
db2 CONNECT TO COMMUNI
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db COMMUNI to $backupdir/$datedir/
db2 CONNECT TO COMMUNI
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO CUSTOMIZ
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db CUSTOMIZ to $backupdir/$datedir/
db2 CONNECT TO CUSTOMIZ
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO FBKDB
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db FBKDB to $backupdir/$datedir/
db2 CONNECT TO FBKDB
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO JCRDB
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db JCRDB to $backupdir/$datedir/
db2 CONNECT TO JCRDB
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO LMDB
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db LMDB to $backupdir/$datedir/
db2 CONNECT TO LMDB
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO RELEASE
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db RELEASE to $backupdir/$datedir/
db2 CONNECT TO RELEASE
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
echo 备份数据库成功！！！
我的环境Linux6.3+Portal8.0+DB2 9.7都是在同一台服务器上，写了个定时作业备份，但是每次备份以后，Portal都很慢，备份前打开页面2~3秒，备份后则要8秒左右，有谁知道是什么原因吗？我登陆多次（20次以上）以后，又变快了
数据库备份脚本如下：
echo -------------备份数据库-----------
datedir=`date +%Y-%m-%d`
delete_date=`date +%Y-%m-%d --date='7 days ago'`
backupdir=/home/backup
db2 CONNECT TO COMMUNI
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db COMMUNI to $backupdir/$datedir/
db2 CONNECT TO COMMUNI
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO CUSTOMIZ
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db CUSTOMIZ to $backupdir/$datedir/
db2 CONNECT TO CUSTOMIZ
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO FBKDB
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db FBKDB to $backupdir/$datedir/
db2 CONNECT TO FBKDB
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO JCRDB
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db JCRDB to $backupdir/$datedir/
db2 CONNECT TO JCRDB
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO LMDB
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db LMDB to $backupdir/$datedir/
db2 CONNECT TO LMDB
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
db2 CONNECT TO RELEASE
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 CONNECT RESET
db2 backup db RELEASE to $backupdir/$datedir/
db2 CONNECT TO RELEASE
db2 UNQUIESCE DATABASE
db2 CONNECT RESET
echo 备份数据库成功！！！
4同行回答
另：做好dbtransfer，有专门针对DB2的优化，以提高性能：
DB2 only. After the database-transfer script completes, connect to each database and perform
a reorg check to improve performance. You can do that following these steps:
a. From the DB2 server, connect to the release database and execute the following command:
db2 reorgchk update statistics on table all > reorgchk.txt
b. Review the reorgchk.txt file and note any table names that have an * set in the REORG
column.
c. Execute the following command for each table name:
db2 reorg table
d. After you have completed running reorg against all the marked tables for this database,
execute the following DB2 commands to rebind the database:
db2 terminate
db2rbind -l db2rbind.out -u -p
e. Repeat a-d for community, customization, jcr, likeminds and feedback.收起
DB2 only. After the database-transfer script completes, connect to each database and perform
a reorg check to improve performance. You can do that following these steps:
a. From the DB2 server, connect to the release database and execute the following command:
db2 reorgchk update statistics on table all > reorgchk.txt
b. Review the reorgchk.txt file and note any table names that have an * set in the REORG
column.
c. Execute the following command for each table name:
db2 reorg table
d. After you have completed running reorg against all the marked tables for this database,
execute the following DB2 commands to rebind the database:
db2 terminate
db2rbind
e. Repeat a-d for community, customization, jcr, likeminds and feedback.收起
浏览779