互联网服务 portal 8.0
Portal每次备份数据库以后都很慢，什么原因
大家好！我的环境Linux6.3+Portal8.0+DB2 9.7都是在同一台服务器上，写了个定时作业备份，但是每次备份以后，Portal都很慢，备份前打开页面2~3秒，备份后则要8秒左右，有谁知道是什么原因吗？我登陆多次（20次以上）以后，又变快了数据库备份脚本如下：echo -------------备份数据库-... 显示全部
查看其它 3 个回答hbhe0316 的回答
另：做好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.