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

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


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.


The migration log will show the following error message:

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


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.


DB2 restart database命令的作用总结

信息中心对于RESTART DATABASE的作用只有一句话的介绍,就是做crash recovery用的。这里总结一下这个命令的作用 信息中心的介绍 Restarts a databas...

SQLSTATE=55025 and SQLSTATE=55025

事件描述: 1.连接数据库 db2 connct to ocbs ,报错:SQL0290N,SQLSTATE=55039 无法访问表空间 2.备份数据库 db2 backup db ocbs ,报...

bug宝典 hadoop篇 /hadoop/hdfs/data is in an inconsistent state: file VERSION has cTime missing.

原本2个datanode,现在只看到了一个 从下图也可以看到只有一个live nodes,但是也没有dead node啊。 检查进程, 缺少DataNode[hadoop@dashuju1...
  • warrah
  • warrah
  • 2017年02月20日 13:40
  • 488

JBPM工作流之出现Could not synchronize database state with session以及You have an error in your SQL syntax;的异


SQL1032N No start database manager command was issued . SQLSTATE=57019

在redhat AS4上装了个db2 装好后发现无法启动,使用db2start的时候报错: SQL6048N  A communication error occurred during ST...
  • MCpang
  • MCpang
  • 2012年11月30日 09:00
  • 7901

How to grant access to SQL logins on a standby database when the guest user is disabled in SQL Serve

Steps to reproduce the behavior In the following example, Pubs is the database, server1 is the se...
  • pbsh
  • pbsh
  • 2012年01月29日 11:45
  • 363

How can I connect Unity to an SQL database in order to implement an MMO?

问: Hello, first of all I'd like to thank each and everyone who has dedicated their time into pr...
  • Koupoo
  • Koupoo
  • 2012年07月12日 15:16
  • 378

Yii报错:SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in order clause is ambiguous

在使用Yii框架gridview通过id排序时,会报这个错误: CDbCommand 无法执行 SQL 语句: SQLSTATE[23000]: Integrity constraint violat...

How to Build An Action and Emotion Database for Simulated Driver’s State Recognition

Introduction   We use video data from simulated driving scenarioto analyze the state of the driver. ...
  • air1894
  • air1894
  • 2014年11月30日 19:13
  • 632

SQL1032N 未发出启动数据库管理器的命令。 SQLSTATE=57019

一、 db2安装完后,一般需要新建用户组,新建用户(一个特殊用户db2efenc 属于db2fadm组)还有一个实例用户(同需要建立实例同名  属于db2iadm组) 然后创建实例   二、 然后创建...
您举报文章:SQL1015N The database is in an inconsistent state. SQLSTATE=55025