DB2的日志相关参数

最新推荐文章于 2024-06-26 19:57:00 发布

水墨胭脂

最新推荐文章于 2024-06-26 19:57:00 发布

阅读量2.9k

点赞数

本文链接：https://blog.csdn.net/nayanminxing/article/details/78226799

版权

本文介绍了DB2数据库中日志管理的关键概念，如LOGARCHMETH1和Path to log files的区别。LOGARCHMETH1用于归档活动日志，而Path to log files存储当前活动日志。LOGFILSIZ定义每个日志文件大小，NEWLOGPATH更改日志路径，MIRRORLOGPATH涉及日志镜像。重点讨论了日志空间管理和事务处理中这些参数的作用。

摘要由CSDN通过智能技术生成

重要观点明晰

1.LOGARCHMETH1和Path to log files的区别

1.创建一个新数据库


[db2inst1@db22 ~]$ db2 create database yynewlog
DB20000I  The CREATE DATABASE command completed successfully.

####2.此时查看数据库目录

[db2inst1@db22 YYNEWLOG]$ pwd
/home/db2inst1/db2inst1/NODE0000/YYNEWLOG
[db2inst1@db22 YYNEWLOG]$ ls 
T0000000  T0000001  T0000002
[db2inst1@db22 YYNEWLOG]$ ls T0000000/
C0000000.CAT

####3.先看一下此时的配置


[db2inst1@db22 YYNEWLOG]$ db2 get db cfg for yynewlog | grep -i log
       Database Configuration for Database yynewlog
 Log retain for recovery status                          = NO
 User exit for logging status                            = NO
 Changed path to log files                  (NEWLOGPATH) = 
 Path to log files                                       = /home/db2inst1/db2inst1/NODE0000/SQL00005/LOGSTREAM0000/
 Overflow log path                     (OVERFLOWLOGPATH) = 
 Mirror log path                         (MIRRORLOGPATH) = 
 Second log archive method                (LOGARCHMETH2) = OFF
 Archive compression for logarchmeth2    (LOGARCHCOMPR2) = OFF

####5.开启