User Tools

Site Tools


database:db2

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
database:db2 [2024/05/28 17:56]
manu [connect to DB2]
database:db2 [2025/07/09 13:54] (current)
manu [Suppress Archogs]
Line 343: Line 343:
 </​cli>​ </​cli>​
  
 +==== Suppress Archlogs ====
 +
 +When doing online backup, you have to manually purge and suppress archlogs:
 +
 +Example suppress archlogs older than 100 days, before 2024/12:
 +<cli prompt='​$'>​
 +$ db2 connect to TSMDB1
 +
 +$ db2 list history TSMDB1 | grep X |grep D
 +$ db2 prune history 202412 with force option and delete
 +
 +$ find /​db2archlog/​db2inst1/​TSMDB1 -type f -name "​*.LOG"​ -ctime +100 -exec rm {} \;
 +</​cli>​
 ===== Backup/​restore DB2 database ===== ===== Backup/​restore DB2 database =====
  
database/db2.1716911807.txt.gz ยท Last modified: 2024/05/28 17:56 by manu