小机db2 日志修改归档模式

这篇博客详细记录了在AIX Version 6环境下,使用DB2数据库进行日志路径修改和设置归档模式的过程。首先,通过更新数据库配置将LOGPRIMARY设置为6,并创建了redolog和archivelog目录。接着,尝试更改NEWLOGPATH到指定目录,遇到错误并解决。然后,成功设置LOGARCHMETH1为磁盘归档方式,并指定了归档路径。最后,确认配置更改并检查日志文件状态,确保所有操作已生效。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

 

 

 

 

 


AIX Version 6
Copyright IBM Corporation, 1982, 2010.
login: db2inst1
db2inst1's Password:
*******************************************************************************
*                                                                             *
*                                                                             *
*  Welcome to AIX Version 6.1!                                                *
*                                                                             *
*                                                                             *
*  Please see the README file in /usr/lpp/bos for information pertinent to    *
*  this release of the AIX Operating System.                                  *
*                                                                             *
*                                                                             *
*******************************************************************************

$ db2 update db cfg for testdb using LOGPRIMARY 6
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.
$ mkdir -p testdb/redolog
$ mkdir -p testdb/archivelog
logb2 update db cfg for tacing using NEWLOGPATH disk:/home/db2inst1/testdb/redo
SQL1013N  The database alias name or database name "TACING" could not be
found.  SQLSTATE=42705
$ db2 get db cfg for testdb|grep -i log
 Log retain for recovery status                          = NO
 User exit for logging status                            = NO
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = 300
 Log buffer size (4KB)                        (LOGBUFSZ) = 256
 Log file size (4KB)                         (LOGFILSIZ) = 1024
 Number of primary log files                (LOGPRIMARY) = 6
 Number of secondary log files               (LOGSECOND) = 4
 Changed path to log files                  (NEWLOGPATH) =
 Path to l

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值