修改数据库为归档之后，感觉可以不做备份也行

开启归档之后，如果不备份的话，那么开归档是没有任何意义的。。开归档的目的就是能够做Rollforward操作，如果不备份的话，rollforward的起点在哪儿？

题主所说的trace mode跟归不归档没关系，归不归档由logarchmeth1决定的收起

学习收起

回复 6# pingssg


   上db2diag.log看看，改ARHCIVE的时候没理由不用做备份。收起

回复 5# zsj2002


     db2 update db cfg for pa using trackmod YES
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W  Database must be deactivated and reactivated before the changes to
one or more of the configuration parameters will be effective.
You have new mail in /var/spool/mail/db2inst1
[db2inst1@db210 backup]$ db2 terminate
DB20000I  The TERMINATE command completed successfully.
You have new mail in /var/spool/mail/db2inst1
[db2inst1@db210 backup]$ db2 activate db testa
DB20000I  The ACTIVATE DATABASE command completed successfully.
[db2inst1@db210 backup]$ db2 connect to pa
   Database Connection Information
Database server        = DB2/LINUXX8664 10.1.0
SQL authorization ID   = DB2INST1
Local database alias   = PA
[db2inst1@db210 backup]$ db2 get db cfg for pa | grep -i trac
Track modified pages                         (TRACKMOD) = YES



系统本来就在归档下，然后修改成TRACKMOD之后，也不需要做备份收起

回复 1# pingssg



还是上DB2DIAG.LOG 看看收起

我猜楼主的数据库原来就是归档的收起

但是不能online备份的吧  应该收起

怎么发现，如何做的，把步骤和日志贴出来看看收起