DB2 diag.log The active log is full error
2015-05-19-21.39.55.755252+000 E8980598E592 LEVEL: Error
PID : 8299 TID : 139625540609792PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MHWEB
APPHDL : 0-52870 APPID: 127.0.0.1.47303.150514211500
AUTHID : MHWEB
EDUID : 96 EDUNAME: db2agent (MHWEB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:2860
MESSAGE : ADM1823E The active log is full and is held by application handle
"60170". Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.
2015-05-19-21.39.55.755376+000 I8981191E554 LEVEL: Error
PID : 8299 TID : 139625540609792PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MHWEB
APPHDL : 0-52870 APPID: 127.0.0.1.47303.150514211500
AUTHID : MHWEB
EDUID : 96 EDUNAME: db2agent (MHWEB) 0
FUNCTION: DB2 UDB, data protection services, sqlpWriteLR, probe:6680
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.
数据库系统是循环日志，diag.log一直在报日志满错误，然后就是断开APP连接，回滚。
PID : 8299 TID : 139625540609792PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MHWEB
APPHDL : 0-52870 APPID: 127.0.0.1.47303.150514211500
AUTHID : MHWEB
EDUID : 96 EDUNAME: db2agent (MHWEB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:2860
MESSAGE : ADM1823E The active log is full and is held by application handle
"60170". Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.
2015-05-19-21.39.55.755376+000 I8981191E554 LEVEL: Error
PID : 8299 TID : 139625540609792PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MHWEB
APPHDL : 0-52870 APPID: 127.0.0.1.47303.150514211500
AUTHID : MHWEB
EDUID : 96 EDUNAME: db2agent (MHWEB) 0
FUNCTION: DB2 UDB, data protection services, sqlpWriteLR, probe:6680
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.
数据库系统是循环日志，diag.log一直在报日志满错误，然后就是断开APP连接，回滚。
9同行回答
事务日志满的问题一是事务日志设置的过小或者遇到大事务，还有一种情况是事务长期未提交，造成占用的事务日志不能被重写，应用应该尽量事务小型化，多次提交，及时提交，避免事务日志满收起
浏览1708
浏览1690
单个logfilsiz太小收起
浏览1647
浏览1695
MHWEB db2jcc_applica 60170 127.0.0.1.63909.150518143000
这个是干什么用的，日志报错都指向了APPID：127.0.0.1.63909.150518143000收起
这个是干什么用的，日志报错都指向了APPID：127.0.0.1.63909.150518143000收起
浏览1708
把LOGFILSIZ、LOGPRIMARY、LOGSECOND都增大就可以，确保你存放日志的空间足够就可以。
你现在一个日志的大小是4MB，最多33日志，总共才132MB,是会日志不够的。
你调整成下面的，同时确保日志存储磁盘有12GB空间就可以。
db2 connect to XXX
db2 update db LOGFILSIZ using 16384
db2 update db LOGPRIMARY using 60
db2 update db LOGSECOND using 120
db2stop
db2start收起
你现在一个日志的大小是4MB，最多33日志，总共才132MB,是会日志不够的。
你调整成下面的，同时确保日志存储磁盘有12GB空间就可以。
db2 connect to XXX
db2 update db LOGFILSIZ using 16384
db2 update db LOGPRIMARY using 60
db2 update db LOGSECOND using 120
db2stop
db2start收起
浏览1645
Log file size (4KB) (LOGFILSIZ) = 1024
Number of primary log files (LOGPRIMARY) = 13
Number of secondary log files (LOGSECOND) = 20
昨天新调整LOGSECOND参数，由3调整到20,
但是通过数据库快照发现：日志最大使用空间又打到了设置值，这个不能无限制增大吧
Log space available to the database (Bytes)= 137637691
Log space used by the database (Bytes) = 233669
Maximum secondary log space used (Bytes) = 82843990
Maximum total log space used (Bytes) = 137156950收起
Number of primary log files (LOGPRIMARY) = 13
Number of secondary log files (LOGSECOND) = 20
昨天新调整LOGSECOND参数，由3调整到20,
但是通过数据库快照发现：日志最大使用空间又打到了设置值，这个不能无限制增大吧
Log space available to the database (Bytes)= 137637691
Log space used by the database (Bytes) = 233669
Maximum secondary log space used (Bytes) = 82843990
Maximum total log space used (Bytes) = 137156950收起
浏览1762