DB2修改日志模式報SQLSTATE=57019的問題 總結一下 DB2 默認為循環歸檔，根據應用要求調整為日志歸檔模式 www.2cto.com ============================================= 修改之後啟動時報錯 SQL1116N A connection to or activation of database "XXX" cannot be made because of BACKUP PENDING. SQLSTATE=57019 ============================================= 解決步驟： db2 connect to XXX db2 force application all www.2cto.com db2 "UPDATE DB CFG FOR XXX USING LOGARCHMETH1 'Disk:/db2log/db2logar'" db2 "backup db XXX to /db2log/backup/dpf_1,/db2log/backup/dpf_2,/db2log/backup/dpf_3,/db2log/backup/dpf_4" db2stop db2start
