SQL1015N The database is in an inconsistent state. SQLSTATE=55025

转载 2012年03月27日 10:48:25

Problem(Abstract)

Attempt to migrate instance through db2imigr or checking database for migration through db2ckmig result in DBI1205E when using IBM DB2 for Linux- UNIX and Windows.

Symptom

The migration log will show the following error message:

SQL1015N The database is in an inconsistent state. SQLSTATE=55025

Cause

The error message in the migration log suggests that one of the databases under the instance being migrated, or the database being checked for migration via db2ckmig is in inconsistent state.

Diagnosing the problem

The database configuration can be checked to confirm if a database is in consistent state using the following command:

db2 get db cfg for <DATABASE_NAME>

The following parameter will indicate if the given database is in consistent state in version 9.5 and below:

Database is consistent = NO

In version 9.7, the following parameter will indicate if the given database is consistent:


All committed transactions have been written to disk = NO


In this example, the database is not in consistent state.


Resolving the problem

User can bring the database back in consistent state using the following steps:

1. db2 restart database <DATABASE_NAME>
2. db2 force applications all
3. db2stop
4. db2start

Please note that if the database becomes consistent after the step # 1, user does not have to restart the instance (step 2, 3,and 4). This must be done for all the databases that are inconsistent state prior to their migration. In multi-partitioned environment, this must be done on all or only inconsistent partitions.

参考资源:http://www-01.ibm.com/support/docview.wss?uid=swg21449895

SQLSTATE=55025 and SQLSTATE=55025

事件描述: 1.连接数据库 db2 connct to ocbs ,报错:SQL0290N,SQLSTATE=55039 无法访问表空间 2.备份数据库 db2 backup db ocbs ,报...
  • dtm19931001
  • dtm19931001
  • 2015年03月14日 10:38
  • 1100

SQL1015N The database is in an inconsistent state. SQLSTATE=55025

Problem(Abstract) Attempt to migrate instance through db2imigr or checking database for migration t...
  • soconglin
  • soconglin
  • 2012年03月27日 10:48
  • 7009

D_db2_upgrade

转自:http://www.db2china.net/home/space.php?uid=3431&do=blog&id=25313 1.安装DB2 V9.7的介质程序和注册新版本License ...
  • g18560
  • g18560
  • 2013年05月19日 23:54
  • 1783

DB2 restart database命令的作用总结

信息中心对于RESTART DATABASE的作用只有一句话的介绍,就是做crash recovery用的。这里总结一下这个命令的作用 信息中心的介绍 Restarts a databas...
  • qingsong3333
  • qingsong3333
  • 2017年03月14日 19:01
  • 1084

db2 kill session 后不能启动 解决

关于启动db2start 报错: [db2inst1@wen ~]$ db2start 10/01/2012 08:53:27     0   0   SQL1072C  The database...
  • shenghuiping2001
  • shenghuiping2001
  • 2012年10月01日 21:30
  • 1928

DB2常见错误及解决办法

创建数据库的时候,报42704错误。如: Sql代码 =>create database test    =>SQL0204N  "SYSTEM_1386_US" is a...
  • yllzhq
  • yllzhq
  • 2011年10月10日 22:02
  • 12228

db2注意事项

1.   db2 nullif()      nullif('1','1')与nullif(1,1)虽然都返回null,但是两条记录union起来之后该字段只能存放数值类型,或者‘2.5’这种可以强...
  • crj_9527
  • crj_9527
  • 2015年12月08日 22:16
  • 674

SQL1072C异常

现象: 执行:db2stop force 得到提示: 12/13/2012 17:23:56     0   0   SQL1072C  The database manager resourc...
  • yixiayizi
  • yixiayizi
  • 2012年12月13日 17:27
  • 2474

db2 SQL1034C The database is damaged. SQLSTATE=58031

背景: 维护的项目,大半夜的db2挂了,版本:V8.2,db2客服不支持服务了(PS:他们TM有多不待见低版本啊 擦!!!),竟然让我去谷歌怎么操作,我要在谷歌上找到了,我还找你800干嘛! ...
  • DongAoYuan
  • DongAoYuan
  • 2013年12月29日 21:01
  • 2398

java.sql.SQLException: OALL8 is in an inconsistent state.

盖因Connection没有正常关闭所引起的取得数据库连接异常,不过这个错报的,有点太隐晦了吧……...
  • wangMail_3366
  • wangMail_3366
  • 2009年04月23日 13:51
  • 4889
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:SQL1015N The database is in an inconsistent state. SQLSTATE=55025
举报原因:
原因补充:

(最多只允许输入30个字)