博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
SQL1015N The database is in an inconsistent state. SQLSTATE=55025
阅读量:4116 次
发布时间:2019-05-25

本文共 1552 字,大约阅读时间需要 5 分钟。

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://krdpi.baihongyu.com/

你可能感兴趣的文章
linux free命令输出详解
查看>>
[转]C++ 虚函数表解析
查看>>
C++ 对象的内存布局(上)
查看>>
C++ 对象的内存布局(下)
查看>>
浅谈多态基类析构函数声明为虚函数
查看>>
Android SDK Manager 无法更新问题解决
查看>>
python文件操作
查看>>
Java之线程
查看>>
Java之文件IO
查看>>
面试的一道机试题: 排序 难度(**)
查看>>
Windows编译OpenSSL
查看>>
vector动态二维数组
查看>>
谈谈Visual Studio中的清单
查看>>
Magento初探
查看>>
编译时C/C++编译器(cl.exe)crash
查看>>
ReSIProcate之header宏
查看>>
ReSIProcate之各工程功能简单介绍
查看>>
ReSIProcate如何建立调试环境
查看>>
深入tomcat验证机制
查看>>
针对Sip Proxy的多路压力测试程序
查看>>