BACKUP DATABASE命令就像一把瑞士军刀，简单却锋利。打开终端，输入：db2 backup db 你的数据库名 to /你的/备份/路径 db2 backup db 你的数据库名 online to /你的/备份/路径 include logs把日志也一起打包，相当于把赛车的“行车记录仪”也带走，回放时不怕漏掉任何精彩瞬间。命令长成这样：db2 backup db 你的数据库名 online to /你的/备份/路径 include logs db2ckbkp命令给它做“健康体检”：db2ckbkp /你的/备份/路径/那个文件 df -h /你的/备份/路径。mkdir -p /db2backup/$(date +%F)。db2 connect to sample db2 force applications all db2 backup db sample to /db2backup/2025-09-02 db2 backup db sample online to /db2backup/2025-09-02 include logs db2 update db cfg for sample using trackmod on db2 backup db sample incremental to /db2backup/inc db2ckbkp /db2backup/2025-09-02/SAMPLE.0.DB2.NODE0000.CATN0000.20250902080001.001 0 2 * * * /home/db2inst1/scripts/backup.sh ] /home/db2inst1/logs/backup.log 2>&1 #!/bin/bash
. /home/db2inst1/sqllib/db2profile
BACKUP_DIR="/db2backup/$(date +%F)"
mkdir -p $BACKUP_DIR
db2 backup db sample online to $BACKUP_DIR include logsdb2 restore db sample from /db2backup/2025-09-02 taken at 20250902080001
db2 rollforward db sample to end of logs and stop