1. [db2inst1@server1 ~]$ db2 update db cfg for sample using logretain recovery 2. DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. 3. SQL1363W One or more of the parameters submitted for immediate modification 4. were not changed dynamically. For these configuration parameters, all 5. applications must disconnect from this database before the changes become 6. effective 7. 8. --这时候,需要手动备份数据库,否是会出现backup pending的状态: 9. 10. [db2inst1@server1 ~]$ con sample 11. SQL1116N A connection to or activation of database "SAMPLE" cannot be made 12. because of BACKUP PENDING. SQLSTATE=57019 13. 14. [db2inst1@server1 ~]$ db2 backup db sample to /tmp 15. 16. Backup successful. The timestamp for this backup image is : 20101117125927 17. 18. 19. --检查相关设置: 20. 21. [db2inst1@server1 ~]$ con sample 22. 23. Database Connection Information 24. 25. Database server = DB2/LINUX 9.5.2 26. SQL authorization ID = DB2INST1 27. Local database alias = SAMPLE 28. 29. [db2inst1@server1 ~]$ db2 get db cfg |grep -i log 30. Log retain for recovery status = RECOVERY 31. Log retain for recovery enabled (LOGRETAIN) = RECOVERY 32. First log archive method (LOGARCHMETH1) = LOGRETAIN 33. Options for logarchmeth1 (LOGARCHOPT1) = 34. Second log archive method (LOGARCHMETH2) = OFF 35. 36. 37. --再设置归档的路径: 38. 39. [db2inst1@server1 ~]$ db2 update db cfg for sample using LOGARCHMETH1 "DISK:/arch/" 40. 41. DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. 42. 43. [db2inst1@server1 ~]$ db2 get db cfg |grep LOGARCHMETH1 44. First log archive method (LOGARCHMETH1) = DISK:/arch/ 45. 46. 47. --手动归档一下: 48. 49. [db2inst1@server1 ~]$ db2 ARCHIVE LOG FOR DATABASE sample 50. DB20000I The ARCHIVE LOG command completed successfully. 51. 52. --看看归档情况 53. [root@server1 /arch/db2inst1/SAMPLE/NODE0000/C0000000]# ll 54. total 16 55. -rw-r----- 1 db2inst1 db2iadm1 12288 Nov 17 13:09 S0000000.LOG 56. [db2inst1@server1 ~]$ db2 LIST HISTORY ARCHIVE LOG all for sample 57. 58. List History File for sample 59. 60. Number of matching file entries = 2 61. 62. 63. Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 64. -- --- ------------------ ---- --- ------------ ------------ -------------- 65. X D 20101117130935 1 D S0000000.LOG C0000000 66. ---------------------------------------------------------------------------- 67. 68. ---------------------------------------------------------------------------- 69. Comment: 70. Start Time: 20101117130935 71. End Time: 20101117130935 72. Status: A 73. ---------------------------------------------------------------------------- 74. EID: 23 Location: /arch/db2inst1/SAMPLE/NODE0000/C0000000/S0000000.LOG 75. 76. 77. Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 78. -- --- ------------------ ---- --- ------------ ------------ -------------- 79. X D 20101117130935 N S0000000.LOG 80. ---------------------------------------------------------------------------- 81. 82. ---------------------------------------------------------------------------- 83. Comment: ARCHIVE LOG 84. Start Time: 20101117130935 85. End Time: 20101117130935 86. Status: A 87. ---------------------------------------------------------------------------- 88. EID: 24