离线备份sample的脚本

sample_backup.sh

=============

#！/bin/bash

db2 connect to sample

db2 quiesce database immediate force connections

db2 connect reset

db2 backup db sample to /tmp

db2 connect to sample

db2 unquiesce database

db2 connect reset

QUIESCE DATABASE results in all objects in the database being in the quiesced mode. Only the allowed user or group and SYSADM, SYSMAINT, DBADM, or SYSCTRL will be able to access the database or its objects.