db2
db2在出现dead lock的时候 会用到force application all
force application all,断开所有连接到这个库的连接, 然后那些连接再继续连这个库,还是可以连的
force完了后 照样可以连接
不需要重启
直接连接 只要数据库没有被停止
list application show detail 你可以看到当前所有连接的信息
db2 list applications
查看连接数
恢复数据库:
db2 restore database etl from /home/odsuser/backup/ taken at 20140319095439 to /home/odsuser/ERDDDATA/DATABASE into test01
db2 create database test01 automatic storage yes using codeset UTF-8 territory cn pagesize 32768
db2 restore database etl from /home/odsuser/backup/ taken at 20140319095439 into test01
重定向恢复
db2 restore db etl from /home/odsuser/backup/ taken at 20140319095439 into test01 redirect generate script redirect_etl.sql