DB2 Error Collection
收集全面数据：db2support <output path> -d <database name> -s -m将在相关路径下产生db2support.zip文件
db2diag -A： 在线切换日志（将之前日志另存为一个文件）db2diag -t 2012-03-06 -l error查看从2012-03-06开始所有Error级别的信息
错误描述：无法启动DB2数据库，系统报错SQL6048N
[db2inst1@sdbf ~]$ db2start
05/25/2010 15:50:07 0 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
SQL1032N No start database manager command was issued. SQLSTATE=57019
原因：DB2配置文件中的主机名与系统主机名不同
解决方案：
1. 修改DB2配置文件中的主机名
例如：
[commerce@wcs sqllib]$ more db2nodes.cfg
0 wcs.test.com 0
2. /etc/hosts文件中添加“IP 主机名”
错误描述：恢复数据库后，无法连接进入数据库
db2 connect to <database name> SQL1117N A connection to or activation of database "<database name>" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019
原因：DB2认为需要回滚日志
解决方案：
输入命令：db2 rollforward db b2ctest1 to end of logs and stop
错误描述：启动instance后，无法
错误描述：数据库连接超时
ERRORCODE=-4499
解决方案：db2set DB2COMM=TCPIP
错误描述：SQL1015N The database is in an inconsistent state. SQLSTATE=55025解决方案：数据库重启db2 deactivate database <dbname>db2 activate database <dbname>db2 restart database <dbname>
错误描述：SQL1072C The database manager resources are in an inconsistent state. The database manager might have been incorrectly terminated, or another application might be using system resources in a way that conflicts with the database manager's use of system resources. System resource cleanup might be required. SQL1032N No start database manager command was issued. SQLSTATE=57019解决方案：到db2用户家目录中sqllib下删除 .ftok 文件rm .ftok创建新的 .ftok 文件touch .ftok
错误描述：图像化界面创建instance报错，JVMDUMP006I Processing dump event "abort", detail "" - please wait.JVMDUMP032I JVM requested System dump using '/opt/ibm/db2/V9.7/instance/core.20120307.161652.9362.0001.dmp' in response to an eventJVMDUMP010I System dump written to /opt/ibm/db2/V9.7/instance/core.20120307.161652.9362.0001.dmpJVMDUMP032I JVM requested Java dump using '/tmp/javacore.20120307.161652.9362.0002.txt' in response to an eventJVMDUMP010I Java dump written to /tmp/javacore.20120307.161652.9362.0002.txtJVMDUMP032I JVM requested Snap dump using '/opt/ibm/db2/V9.7/instance/Snap.20120307.161652.9362.0003.trc' in response to an eventJVMDUMP010I Snap dump written to /opt/ibm/db2/V9.7/instance/Snap.20120307.161652.9362.0003.trcJVMDUMP013I Processed dump event "abort", detail "".解决方案：使用命令行创建instance来找出实际问题2012-3-8 问题是主机hostname设置错误，/etc/host 和 /etc/sysconfig/network设置的不一样1. 清空global profile register参数cd /opt/ibm/db2/V9.7/adm./db2set -g DB2SYSTEM=./db2set -g DB2INSTDEF=2. 命令行创建instance, 再删除cd /opt/ibm/db2/V9.7/instance./db2icrt -u commfenc commerce./db2idrip -f commerce
错误描述：db2diag发现如下错误：
2011-04-25-21.12.23.482036-240 I182391A469 LEVEL: Info
PID : 45941232 TID : 1029 PROC : db2sysc
INSTANCE: db2instance NODE : 000
EDUID : 1029 EDUNAME: db2ipccm
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::RequestAgentForAppl, probe:1459
MESSAGE : ZRC=0xFFFFFB36=-1226
DATA #1 : <preformatted>
The number of background tasks has reached the limit of 20, will try again later.
0 200 235 235 235 234 60 200 235 235 235 234 6原因： This is due to the APAR IC69285 for DB2 V9.7 FP4 and APAR IC67852 for DB2 V9.5 FP7 which added a limit.解决方案：db2set DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:500 无需重启，直接生效
错误描述：db2diag发现如下错误：2012-03-30-09.47.01.031913+480 E2299602E573 LEVEL: WarningPID : 21133 TID : 1166608704 PROC : db2acd 0
INSTANCE: crm NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10512W Health indicator "Statistics Collection Required"
("db.tb_runstats_req") is in state "Update statistics required" on
"database" "crm.CRM ". Collection (Object Name, Timestamp, Value,
Detail): " ("SYSTOOLS"."POLICY", 03/30/2012 09:47:00.000000, 2,
RUNSTATS)".
解决方案：db2 runstats on table systools.policy
错误描述：db2diag发现如下错误：
2012-03-30-19.39.11.703483+480 I18508379E497 LEVEL: Error
PID : 20311 TID : 47811500435776PROC : db2sysc 0
INSTANCE: commerce NODE : 000
APPHDL : 0-7471 APPID: 10.5.161.49.2810.120330114312
AUTHID : COMMERCE
EDUID : 589 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:10
MESSAGE : ZRC=0xFFFFFC0B=-1013
DATA #1 : String, 45 bytes
Error while reading and verifying config file
原因：是由于客户端发出的命令里面，数据库的名字写错了。
解决方案：1：请确保数据库的名字正确
2：确保数据库被正确的编目。
db2 list db directory
错误描述：V8 --> V9 实例可以启动，但是数据库无法启动。
SQL10003C There are not enough system resources to process the request. The request cannot be processed. SQLSTATE=57011
原因：参数配置错误 db cfg级别：maxappls
解决方案：
db2 update db cfg for <db name> using maxappls automatic
错误描述：V8 -> V9 恢复时报错：
SQL2519N The database was restored but the restored database was not upgrade to the current release.Error "-902" with tokens "SYSCOLDIST Migration DMS=80080003: SYSBOOT update " is returned.
原因：恢复后自动升级失败
解决方案：
1. 重启服务器
2. db2 migrate db <dbname>
QUEST/RAPIDSQL软件无法使用：原因：系统变量设置故障
解决方案：
调整系统变量PATH定义，将IBM相关的调整到最前面。
错误描述：unable to drop table1. 检查表空间状态，结果为0x0020
2. 说明需要对表空间做备份。
db2 backup database <db name> tablespace (<tablespace_name>) online to <directory>
3. 根本原因使用了load，正确方法需要加上NONRECOVERABLE参数
错误描述：db2 connect to <dbname>报错：SQL0332N There is no available conversion for the source code page "819" to the target code page "1136". Reason code "1". SQLSTATE=57017解决方案：1. 开启新窗口输入：db2set db2codepage=8192. db2 terminate3. db2 connect to <dbname>
db2diag -A： 在线切换日志（将之前日志另存为一个文件）db2diag -t 2012-03-06 -l error查看从2012-03-06开始所有Error级别的信息
错误描述：无法启动DB2数据库，系统报错SQL6048N
[db2inst1@sdbf ~]$ db2start
05/25/2010 15:50:07 0 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
SQL1032N No start database manager command was issued. SQLSTATE=57019
原因：DB2配置文件中的主机名与系统主机名不同
解决方案：
1. 修改DB2配置文件中的主机名
例如：
[commerce@wcs sqllib]$ more db2nodes.cfg
0 wcs.test.com 0
2. /etc/hosts文件中添加“IP 主机名”
错误描述：恢复数据库后，无法连接进入数据库
db2 connect to <database name> SQL1117N A connection to or activation of database "<database name>" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019
原因：DB2认为需要回滚日志
解决方案：
输入命令：db2 rollforward db b2ctest1 to end of logs and stop
错误描述：启动instance后，无法
错误描述：数据库连接超时
ERRORCODE=-4499
解决方案：db2set DB2COMM=TCPIP
错误描述：SQL1015N The database is in an inconsistent state. SQLSTATE=55025解决方案：数据库重启db2 deactivate database <dbname>db2 activate database <dbname>db2 restart database <dbname>
错误描述：SQL1072C The database manager resources are in an inconsistent state. The database manager might have been incorrectly terminated, or another application might be using system resources in a way that conflicts with the database manager's use of system resources. System resource cleanup might be required. SQL1032N No start database manager command was issued. SQLSTATE=57019解决方案：到db2用户家目录中sqllib下删除 .ftok 文件rm .ftok创建新的 .ftok 文件touch .ftok
错误描述：图像化界面创建instance报错，JVMDUMP006I Processing dump event "abort", detail "" - please wait.JVMDUMP032I JVM requested System dump using '/opt/ibm/db2/V9.7/instance/core.20120307.161652.9362.0001.dmp' in response to an eventJVMDUMP010I System dump written to /opt/ibm/db2/V9.7/instance/core.20120307.161652.9362.0001.dmpJVMDUMP032I JVM requested Java dump using '/tmp/javacore.20120307.161652.9362.0002.txt' in response to an eventJVMDUMP010I Java dump written to /tmp/javacore.20120307.161652.9362.0002.txtJVMDUMP032I JVM requested Snap dump using '/opt/ibm/db2/V9.7/instance/Snap.20120307.161652.9362.0003.trc' in response to an eventJVMDUMP010I Snap dump written to /opt/ibm/db2/V9.7/instance/Snap.20120307.161652.9362.0003.trcJVMDUMP013I Processed dump event "abort", detail "".解决方案：使用命令行创建instance来找出实际问题2012-3-8 问题是主机hostname设置错误，/etc/host 和 /etc/sysconfig/network设置的不一样1. 清空global profile register参数cd /opt/ibm/db2/V9.7/adm./db2set -g DB2SYSTEM=./db2set -g DB2INSTDEF=2. 命令行创建instance, 再删除cd /opt/ibm/db2/V9.7/instance./db2icrt -u commfenc commerce./db2idrip -f commerce
错误描述：db2diag发现如下错误：
2011-04-25-21.12.23.482036-240 I182391A469 LEVEL: Info
PID : 45941232 TID : 1029 PROC : db2sysc
INSTANCE: db2instance NODE : 000
EDUID : 1029 EDUNAME: db2ipccm
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::RequestAgentForAppl, probe:1459
MESSAGE : ZRC=0xFFFFFB36=-1226
DATA #1 : <preformatted>
The number of background tasks has reached the limit of 20, will try again later.
0 200 235 235 235 234 60 200 235 235 235 234 6原因： This is due to the APAR IC69285 for DB2 V9.7 FP4 and APAR IC67852 for DB2 V9.5 FP7 which added a limit.解决方案：db2set DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:500 无需重启，直接生效
错误描述：db2diag发现如下错误：2012-03-30-09.47.01.031913+480 E2299602E573 LEVEL: WarningPID : 21133 TID : 1166608704 PROC : db2acd 0
INSTANCE: crm NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10512W Health indicator "Statistics Collection Required"
("db.tb_runstats_req") is in state "Update statistics required" on
"database" "crm.CRM ". Collection (Object Name, Timestamp, Value,
Detail): " ("SYSTOOLS"."POLICY", 03/30/2012 09:47:00.000000, 2,
RUNSTATS)".
解决方案：db2 runstats on table systools.policy
错误描述：db2diag发现如下错误：
2012-03-30-19.39.11.703483+480 I18508379E497 LEVEL: Error
PID : 20311 TID : 47811500435776PROC : db2sysc 0
INSTANCE: commerce NODE : 000
APPHDL : 0-7471 APPID: 10.5.161.49.2810.120330114312
AUTHID : COMMERCE
EDUID : 589 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:10
MESSAGE : ZRC=0xFFFFFC0B=-1013
DATA #1 : String, 45 bytes
Error while reading and verifying config file
原因：是由于客户端发出的命令里面，数据库的名字写错了。
解决方案：1：请确保数据库的名字正确
2：确保数据库被正确的编目。
db2 list db directory
错误描述：V8 --> V9 实例可以启动，但是数据库无法启动。
SQL10003C There are not enough system resources to process the request. The request cannot be processed. SQLSTATE=57011
原因：参数配置错误 db cfg级别：maxappls
解决方案：
db2 update db cfg for <db name> using maxappls automatic
错误描述：V8 -> V9 恢复时报错：
SQL2519N The database was restored but the restored database was not upgrade to the current release.Error "-902" with tokens "SYSCOLDIST Migration DMS=80080003: SYSBOOT update " is returned.
原因：恢复后自动升级失败
解决方案：
1. 重启服务器
2. db2 migrate db <dbname>
QUEST/RAPIDSQL软件无法使用：原因：系统变量设置故障
解决方案：
调整系统变量PATH定义，将IBM相关的调整到最前面。
错误描述：unable to drop table1. 检查表空间状态，结果为0x0020
2. 说明需要对表空间做备份。
db2 backup database <db name> tablespace (<tablespace_name>) online to <directory>
3. 根本原因使用了load，正确方法需要加上NONRECOVERABLE参数
错误描述：db2 connect to <dbname>报错：SQL0332N There is no available conversion for the source code page "819" to the target code page "1136". Reason code "1". SQLSTATE=57017解决方案：1. 开启新窗口输入：db2set db2codepage=8192. db2 terminate3. db2 connect to <dbname>
Comments
Post a Comment