level 1
柔眸丶泊
楼主
964,数据库日志已满。尝试更改参数依然964。
Log file size (4KB) (LOGFILSIZ) = 6144
Number of primary log files (LOGPRIMARY) = 192
Number of secondary log files (LOGSECOND) = 64
错误信息:
2019-05-08-19.18.02.974776+480 E2767667E633 LEVEL: Error
PID : 52730 TID : 140054450136832 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-10981 APPID: 172.21.17.196.52567.190508111531
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 22 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:2860
MESSAGE : ADM1823E The active log is full and is held by application handle
"0-11090". Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.
2019-05-08-19.18.03.029207+480 E2768301E595 LEVEL: Error
PID : 52730 TID : 140054450136832 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-10981 APPID: 172.21.17.196.52567.190508111531
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 22 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:6666
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.
2019-05-08-19.18.03.063656+480 I2768897E593 LEVEL: Error
PID : 52730 TID : 140054450136832 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-10981 APPID: 172.21.17.196.52567.190508111531
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 22 EDUNAME: db2agent (AMLDB) 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.
2019-05-08-19.18.02.978923+480 E2769491E633 LEVEL: Error
PID : 52730 TID : 140046321575680 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-11097 APPID: 172.21.17.196.52802.190508111817
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 94 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:2860
MESSAGE : ADM1823E The active log is full and is held by application handle
"0-11090". Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.
2019-05-08-19.18.03.064357+480 E2770125E595 LEVEL: Error
PID : 52730 TID : 140046321575680 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-11097 APPID: 172.21.17.196.52802.190508111817
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 94 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:6666
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.
2019-05-08-19.18.03.064653+480 I2770721E593 LEVEL: Error
PID : 52730 TID : 140046321575680 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-11097 APPID: 172.21.17.196.52802.190508111817
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 94 EDUNAME: db2agent (AMLDB) 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.
2019-05-08-19.18.03.064934+480 I2771315E868 LEVEL: Error
PID : 52730 TID : 140046321575680 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-11097 APPID: 172.21.17.196.52802.190508111817
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 94 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_array_input, probe:210
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -964 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRI039
sqlerrd : (1) 0x85100009 (2) 0x00000009 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFB22 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2019年05月10日 01点05分
1
Log file size (4KB) (LOGFILSIZ) = 6144
Number of primary log files (LOGPRIMARY) = 192
Number of secondary log files (LOGSECOND) = 64
错误信息:
2019-05-08-19.18.02.974776+480 E2767667E633 LEVEL: Error
PID : 52730 TID : 140054450136832 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-10981 APPID: 172.21.17.196.52567.190508111531
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 22 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:2860
MESSAGE : ADM1823E The active log is full and is held by application handle
"0-11090". Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.
2019-05-08-19.18.03.029207+480 E2768301E595 LEVEL: Error
PID : 52730 TID : 140054450136832 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-10981 APPID: 172.21.17.196.52567.190508111531
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 22 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:6666
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.
2019-05-08-19.18.03.063656+480 I2768897E593 LEVEL: Error
PID : 52730 TID : 140054450136832 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-10981 APPID: 172.21.17.196.52567.190508111531
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 22 EDUNAME: db2agent (AMLDB) 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.
2019-05-08-19.18.02.978923+480 E2769491E633 LEVEL: Error
PID : 52730 TID : 140046321575680 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-11097 APPID: 172.21.17.196.52802.190508111817
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 94 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:2860
MESSAGE : ADM1823E The active log is full and is held by application handle
"0-11090". Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.
2019-05-08-19.18.03.064357+480 E2770125E595 LEVEL: Error
PID : 52730 TID : 140046321575680 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-11097 APPID: 172.21.17.196.52802.190508111817
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 94 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:6666
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.
2019-05-08-19.18.03.064653+480 I2770721E593 LEVEL: Error
PID : 52730 TID : 140046321575680 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-11097 APPID: 172.21.17.196.52802.190508111817
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 94 EDUNAME: db2agent (AMLDB) 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.
2019-05-08-19.18.03.064934+480 I2771315E868 LEVEL: Error
PID : 52730 TID : 140046321575680 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AMLDB
APPHDL : 0-11097 APPID: 172.21.17.196.52802.190508111817
AUTHID : DB2INST1 HOSTNAME: T_FXQ_DB
EDUID : 94 EDUNAME: db2agent (AMLDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_array_input, probe:210
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -964 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRI039
sqlerrd : (1) 0x85100009 (2) 0x00000009 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFB22 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: