DB2数据库静态参数修改（归档模式和日志组数，都需要重启db）

最新推荐文章于 2024-06-01 07:10:51 发布
最新推荐文章于 2024-06-01 07:10:51 发布
阅读量7k 收藏
点赞数 1
分类专栏： DB2
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/laven54/article/details/18405279
版权

1、修改日志组数目

[db2inst1@DB2test183 ~]$ db2 update db cfg using LOGPRIMARY 5

DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W  One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
[db2inst1@DB2test183 ~]$ ls -l /home/db2inst1/db2inst1/NODE0000/SQL00002/LOGSTREAM0000/
total 12312
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 06:45 S0000000.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 06:45 S0000001.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 06:45 S0000002.LOG
[db2inst1@DB2test183 ~]$ db2 restart db aaa
DB20000I  The RESTART DATABASE command completed successfully.
[db2inst1@DB2test183 ~]$
[db2inst1@DB2test183 ~]$
[db2inst1@DB2test183 ~]$ ls -l /home/db2inst1/db2inst1/NODE0000/SQL00002/LOGSTREAM0000/
total 20532
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 06:45 S0000000.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 06:45 S0000001.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 06:45 S0000002.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 06:45 S0000003.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 06:45 S0000004.LOG

[db2inst1@DB2test183 ~]$





小知识：
get db/dbm cfg  中的 show detail  选项可以看出参数值是否已经生效


[db2inst1@DB2test183 ~]$ db2 update db cfg using LOGPRIMARY 6
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
[db2inst1@DB2test183 ~]$ db2 get db cfg for aaa show detail|grep -i primary
 Number of primary log files (LOGPRIMARY) = 5 6    （前面的是修改之前的原始值，后面的数字是修改之后的值，目前还未生效。简言之，前后数值不一致即说明参数更改未生效）
 Percent max primary log space by transaction (MAX_LOG) = 0 0
[db2inst1@DB2test183 ~]$ db2 get db cfg for aaa |grep -i primary
 Number of primary log files (LOGPRIMARY) = 6
 Percent max primary log space by transaction (MAX_LOG) = 0
[db2inst1@DB2test183 ~]$
[db2inst1@DB2test183 ~]$
[db2inst1@DB2test183 ~]$ db2 restart db aaa
DB20000I The RESTART DATABASE command completed successfully.
[db2inst1@DB2test183 ~]$
[db2inst1@DB2test183 ~]$
[db2inst1@DB2test183 ~]$ db2 get db cfg for aaa |grep -i primary
 Number of primary log files (LOGPRIMARY) = 6 
 Percent max primary log space by transaction (MAX_LOG) = 0 





2、修改数据库归档模式
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa |grep -i logarchmeth1
 First log archive method (LOGARCHMETH1) = OFF
 Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1 (LOGARCHOPT1) =
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$ db2 update db cfg using LOGARCHMETH1 disk:/home/db2inst1/archivelog/aa
SQL5099N The value "/home/db2inst1/archivelog/aa" indicated by the database
configuration parameter "LOGARCHMETH1" is not valid, reason code "2".
SQLSTATE=08004
[db2inst1@DB2test183 aaa]$ db2 update db cfg for aaa using LOGARCHMETH1 disk:/home/db2inst1/archivelog/aaa
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa |grep -i logarchmeth1
 First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/archivelog/aaa/
 Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1 (LOGARCHOPT1) =
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa show detail |grep -i logarchmeth1
 First log archive method (LOGARCHMETH1) = OFF DISK:/home/db2inst1/archivelog/aaa/
 Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF OFF
 Options for logarchmeth1 (LOGARCHOPT1) =
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$ db2 archive log for aaa
SQL0104N An unexpected token "aaa" was found following "FOR". Expected
tokens may include: "DATABASE". SQLSTATE=42601
[db2inst1@DB2test183 aaa]$ db2 archive log databae aaa
SQL0104N An unexpected token "databae" was found following "LOG". Expected
tokens may include: "FOR". SQLSTATE=42601
[db2inst1@DB2test183 aaa]$ db2 archive log databae for aaa
SQL0104N An unexpected token "databae" was found following "LOG". Expected
tokens may include: "FOR". SQLSTATE=42601
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$ db2 restart db aaa
SQL1116N A connection to or activation of database "AAA" failed because the
database is in BACKUP PENDING state. SQLSTATE=57019
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa show detail |grep -i logarchmeth1
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa show detail |grep -i logarchmeth1
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa |grep -i logarchmeth1
 First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/archivelog/aaa/
 Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1 (LOGARCHOPT1) =
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa show detail |grep -i logarchmeth1
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa show detail |grep -i pri
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa show detail |grep -i log
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa show detail|grep -i primary
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa |grep -i log
 Log retain for recovery status = NO
 User exit for logging status = YES
 Catalog cache size (4KB) (CATALOGCACHE_SZ) = 300
 Log buffer size (4KB) (LOGBUFSZ) = 2149
 Log file size (4KB) (LOGFILSIZ) = 1024
 Number of primary log files (LOGPRIMARY) = 6
 Number of secondary log files (LOGSECOND) = 3
 Changed path to log files (NEWLOGPATH) =
 Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00002/LOGSTREAM0000/
 Overflow log path (OVERFLOWLOGPATH) =
 Mirror log path (MIRRORLOGPATH) =
 First active log file = S0000000.LOG
 Block log on disk full (BLK_LOG_DSK_FUL) = NO
 Block non logged operations (BLOCKNONLOGGED) = NO
 Percent max primary log space by transaction (MAX_LOG) = 0
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
 Percent log file reclaimed before soft chckpt (SOFTMAX) = 0
 HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
 HADR spool log data limit (4KB) (HADR_SPOOL_LIMIT) = AUTOMATIC(0)
 HADR log replay delay (seconds) (HADR_REPLAY_DELAY) = 0
 First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/archivelog/aaa/
 Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1 (LOGARCHOPT1) =
 Second log archive method (LOGARCHMETH2) = OFF
 Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF
 Options for logarchmeth2 (LOGARCHOPT2) =
 Failover log archive path (FAILARCHPATH) =
 Number of log archive retries on error (NUMARCHRETRY) = 5
 Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
 Log pages during index build (LOGINDEXBUILD) = OFF
 Log DDL Statements (LOG_DDL_STMTS) = NO
 Log Application Information (LOG_APPL_INFO) = NO
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa show detail |grep -i log
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$ ls -l /home/db2inst1/db2inst1/NODE0000/SQL00002/LOGSTREAM0000/
total 24628
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:26 S0000000.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:26 S0000001.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:13 S0000002.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:13 S0000003.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:13 S0000004.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:13 S0000005.LOG
[db2inst1@DB2test183 aaa]$ ls -l /home/db2inst1/archivelog/aaa
total 4
drwxr-x---. 3 db2inst1 db2iadm1 4096 Jan 16 08:26 db2inst1
[db2inst1@DB2test183 aaa]$ ls -l /home/db2inst1/archivelog/aaa/db2inst1/AAA/NODE0000/LOGSTREAM0000/C0000000/
total 0

[db2inst1@DB2test183 aaa]$ db2 archive log for db aaa
SQL1116N A connection to or activation of database "AAA" failed because the
database is in BACKUP PENDING state. SQLSTATE=57019

[db2inst1@DB2test183 aaa]$ db2 backup database aaa
Backup successful. The timestamp for this backup image is : 20140116083522

[db2inst1@DB2test183 aaa]$ db2 archive log for db aaa
DB20000I The ARCHIVE LOG command completed successfully.


[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa |grep -i log
 Log retain for recovery status = NO
 User exit for logging status = YES
 Catalog cache size (4KB) (CATALOGCACHE_SZ) = 300
 Log buffer size (4KB) (LOGBUFSZ) = 2149
 Log file size (4KB) (LOGFILSIZ) = 1024
 Number of primary log files (LOGPRIMARY) = 6
 Number of secondary log files (LOGSECOND) = 3
 Changed path to log files (NEWLOGPATH) =
 Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00002/LOGSTREAM0000/
 Overflow log path (OVERFLOWLOGPATH) =
 Mirror log path (MIRRORLOGPATH) =
 First active log file = S0000002.LOG
 Block log on disk full (BLK_LOG_DSK_FUL) = NO
 Block non logged operations (BLOCKNONLOGGED) = NO
 Percent max primary log space by transaction (MAX_LOG) = 0
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
 Percent log file reclaimed before soft chckpt (SOFTMAX) = 0
 HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
 HADR spool log data limit (4KB) (HADR_SPOOL_LIMIT) = AUTOMATIC(0)
 HADR log replay delay (seconds) (HADR_REPLAY_DELAY) = 0
 First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/archivelog/aaa/
 Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1 (LOGARCHOPT1) =
 Second log archive method (LOGARCHMETH2) = OFF
 Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF
 Options for logarchmeth2 (LOGARCHOPT2) =
 Failover log archive path (FAILARCHPATH) =
 Number of log archive retries on error (NUMARCHRETRY) = 5
 Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
 Log pages during index build (LOGINDEXBUILD) = OFF
 Log DDL Statements (LOG_DDL_STMTS) = NO
 Log Application Information (LOG_APPL_INFO) = NO



[db2inst1@DB2test183 aaa]$ db2 archive log for db aaa
DB20000I The ARCHIVE LOG command completed successfully.
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa |grep -i first
 First active log file = S0000004.LOG
 First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/archivelog/aaa/
[db2inst1@DB2test183 aaa]$ db2 archive log for db aaa
DB20000I The ARCHIVE LOG command completed successfully.
[db2inst1@DB2test183 aaa]$ db2 get db cfg for aaa |grep -i first
 First active log file = S0000006.LOG
 First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/archivelog/aaa/
[db2inst1@DB2test183 aaa]$ ls -l /home/db2inst1/archivelog/aaa/db2inst1/AAA/NODE0000/LOGSTREAM0000/C0000000/
total 48
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:37 S0000000.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:37 S0000001.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:38 S0000002.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:38 S0000003.LOG
[db2inst1@DB2test183 aaa]$ ls -l /home/db2inst1/db2inst1/NODE0000/SQL00002/LOGSTREAM0000/
total 12336
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:38 S0000004.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:38 S0000005.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:38 S0000006.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:38 S0000007.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:38 S0000008.LOG
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$ db2 archive log for db aaa
DB20000I The ARCHIVE LOG command completed successfully.
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$
[db2inst1@DB2test183 aaa]$ ls -l /home/db2inst1/archivelog/aaa/db2inst1/AAA/NODE0000/LOGSTREAM0000/C0000000/
total 96
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:37 S0000000.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:37 S0000001.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:38 S0000002.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:38 S0000003.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000004.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000005.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000006.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000007.LOG
[db2inst1@DB2test183 aaa]$ ls -l /home/db2inst1/db2inst1/NODE0000/SQL00002/LOGSTREAM0000/
total 16440
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000006.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000007.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:38 S0000008.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:39 S0000009.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:39 S0000010.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:39 S0000011.LOG
[db2inst1@DB2test183 aaa]$ db2 archive log for db aaa
DB20000I The ARCHIVE LOG command completed successfully.
[db2inst1@DB2test183 aaa]$ ls -l /home/db2inst1/archivelog/aaa/db2inst1/AAA/NODE0000/LOGSTREAM0000/C0000000/
total 96
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:37 S0000000.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:37 S0000001.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:38 S0000002.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:38 S0000003.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000004.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000005.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000006.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:39 S0000007.LOG
[db2inst1@DB2test183 aaa]$ ls -l /home/db2inst1/db2inst1/NODE0000/SQL00002/LOGSTREAM0000/
total 16440
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:40 S0000008.LOG
-rw-------. 1 db2inst1 db2iadm1 12288 Jan 16 08:40 S0000009.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:39 S0000010.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:39 S0000011.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:40 S0000012.LOG
-rw-------. 1 db2inst1 db2iadm1 4202496 Jan 16 08:40 S0000013.LOG

lurou
关注
专栏目录
DB2 DPF安装
u010412555的博客
08-14 607
DB2 DBF安装
Windows 7 SP1 64bit 实施单机环境下DB2 V9.5.7 HADR实现实例级故障切换
夜澜偶作庄周梦 酒后聊为楚客狂
06-30 4164
MicrosoftInternetExplorer402DocumentNotSpecified7.8Normal0 High Availability Disaster Recovery (HADR)是数据库级别的高可用性数据复制机制，HADR 实现是基于 HDR 的 Informix 实现的（是数据库中高可用性灾难恢复相对比较成熟的功能）。本质上讲，HA
sap system copy
05-26
基于db2的 sap system copy
DB2大型数据之备份与复原
最新发布
weixin_61703384的博客
06-01 1197
本实验目标：这个演示使用数据库MUSICDB执行备份和恢复相关的任务。在本练习中，您将为归档日志记录准备数据库，创建备份映像并将数据库恢复到选定的时间点。您还将配置数据库日志空间来处理具有大型事务的应用程序。准备工作首先需要连接实例Linux系统先连接LInux用户并登录，然后切换到实例所在的用户：输入密码即可然后换到ddl脚本所在的目录，并连接到数据库“SQL1363W ”中的“W”表示警告，这里表示需要重启数据库该命令修改的配置参数才会生效。因此需要进行以下操作。
db2 修改数据库配置
平凡
02-19 2181
修改日志文件大小、主日志参数后需要重启数据库，修改辅日志参数则不许要重启数据库
问题解决：Db2修改locklist不能立即生效(SQL1363W)原因分析
匿_名_用_户的专栏
10-09 1698
问题描述： 调整DB2内存参数locklist的时候，正常情况下是能够立即生效的。但这次修改却报SQL1363W，需要重新激活数据库才能生效： db2inst1@node01:~> db2 connect to sample Database Connection Information Database server = DB2/LINUXX8664 10.5...
SQL5099N reason code "4" SQLSTATE=08004
cuaiwan9841的博客
05-26 913
...
解决db2 backup pending状态
weoln的专栏
12-21 6535
做数据库恢复时，经常会遇见数据库恢复一半时出错，导致数据库处于backup pending状态。解决方法有两种： 一、重新备份数据库。将数据库重新备份，备份成功后数据库状态会更新为正常状态。  二、执行下面的脚本：  update db cfg for DBNAME using LOGARCHMETH1 offupdate db cfg for DBNAME using
数据库精选 60 道面试题
herongwei 的 BLOG
03-02 9535
大家好，我是贺同学。金三银四到了，给大家整理一些数据库必知必会的面试题。基础相关1、关系型和非关系型数据库的区别？关系型数据库的优点容易理解，因为它采用了关系模型来组织数据。可以保持数据的...
大数据-玩转数据-Oracle系统知识小结
s_unbo的博客
03-19 5472
一、说明 Oracle数据库是甲骨文的核心产品，Oracle 的操作都遵循sql标准，所以各个版本在基本操作方面都变化不大。Oracle划分在大型关系数据库范畴，比较Mysql或Nosql数据库来说，还是缺少些扩容的灵活性，但传统金融、通信、电力、航空、保险、大型企业用得比较多。 二、背景知识、数据建模和Linux 1.关系数据库 关系型数据库，是指采用了关系模型来组织数据的数据库，其以行和列的形式存储数据，以便于用户理解，关系型数据库这一系列的行和列被称为表，一组表组成了数据库。用户通过查询来检索数据库中
数据库Oracle11g DataGuard部署参考文档
咸鱼的梦想专栏
08-01 7912
目 录 第一章 引言 4 1.1. 编写目的 4 1.2. 定义、首字母缩写词和缩略语 4 第二章 安装主、备库ORACLE软件 4 2.1. 安装前规划 4 2.2. 修改/ETC/HOSTS(主、备) 4 2.3. 检查并建立相关目录（主、备） 4 2.3.1. 数据文件目录 4 2.3.2. 归档日志文件目录 5 2.3.3. 临时备份文件目录 5 2.4. 做好数据备份 5 第三章 DAT...
RMAN异机复制数据库
塞尔达的传说
04-08 196
原 RMAN 异机 复制数据库https://blog.csdn.net/tianlesoftware/article/details/5749932版权声明： https://blog.csdn.net/tianlesoftware/article/details/5749932 关于RMAN 复制的理论知识，参考我的Blog： RMAN 复制目标数据库的理论知识 http://www.cn...
DB2数据库BACKUP PENDING状态（修改日志模式导致）(转)
weixin_30647065的博客
07-27 727
DB2数据库LOGRETAIN参数用来标示数据库的日志模式： LOGRETAIN= RECOVERY，表示归档日志模式；LOGRETAIN=NO，表示循环日志模式。 若修改数据库LOGRETAIN参数，从循环日志模式改为归档日志模式，则会导致数据库backup pending状态。如： 执行“db2 update db cfg for dbname using LOGRETAI...
DB2修改日志模式报 SQLSTATE=57019
weixin36的博客
01-06 626
总结一下 DB2 默认为循环归档，根据应用要求调整为日志归档模式 ============================================= 修改之后启动时报错 SQL1116N A connection to or activation of database "XXX" cannot be made because of BACKUP PENDING. SQ...
[转]怎么终止数据库的“BACKUP PENDING”状态？在线等待。。。
jasonhongcn的专栏
04-19 764
  【发表评论】【查看原文】【DB2讨论区】【关闭】 昨天我备份完数据库后，再连接的时候，它一直提示数据库处于“BACKUP PENDING”状态，我该如何处理？  lukehan 回复于：2003-07-24 13:22:54 正常只有在备份时才处于BACKUP PENDING状态，备份结束了应该返回正常状态，所以可能是你的备份没做完吧。 ...
db2启动错误 SQLSTATE=57019
热门推荐
::: 移动互联网时代开发者 :::
08-22 1万+
想启动DB2数据库，就到DB2命令行中运行db2start，结果出现如下错误：未发出启动数据库管理器的命令。SQLSTATE=57019。想了半天，这几天除了修改一次DB2登陆密码以外，没在DB2上做其它的事情。打开控制面板中的服务，看到DB2的某些服务并没有启动。看来问题就出在这里了。查看其属性，将登陆中的密码修改，然后重新启动。问题解决。
db2 日志管理
荣耀之路
04-20 8282
DB2日志是以文件的形式存放在文件系统中，分为两种模式：循环日志和归档日志。当创建新数据库时，日志的缺省模式是循环日志。在这种模式下，只能实现数据库的脱机备份和恢复。如果要实现联机备份和恢复，必须设为归档日志模式。
有关SQLSTATE57014和57019的解决方法
梦开始的地方
08-16 6383
一、SQLSTATE57014，SQL0952N由于中断而取消处理  问题背景：近日对1400+万的数据进行select，在db2下是29秒。在sql里面添加处理逻辑后是1分40秒。在开发程序中操作同样的sql，执行过程中报错“SQLSTATE57014，SQL0952N由于中断而取消处理”。debug后问题出在数据源配置结果集上。 解决方法：                1. 问题产生...
db2 online backup 设置
cntkcn4698的博客
11-27 522
--db2图像安装基本学会 结构基本了解 详细东西 还需要一步一步学习--在线备份设置[db2inst2@localhost ~]$ db2 get db cfg for ts|grep -i log Log retain fo...
DB2数据库管理：循环日志与归档日志解析
"这篇资料主要介绍了IBM的DB2数据库系统，特别是关注了两种日志类型——循环日志和归档日志，并涉及DB2的基础知识、系统管理、以及相关产品组件。资料还提到了DB2在OLTP和数据仓库中的应用，支持Internet和面向对象...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值