WebSphere Issues

14/08/2010

SQL1015N: The database is inconsistent state SQLSTATE=55025

Filed under: DB2, Linux, WebSphere Portal — Ishtiaque @ 7:24 am

When you start the HADR database after power failure or abnormal termination of the database instance at primary node you might get the following error:

SQL1015N: The database is inconsistent state SQLSTATE=55025

1. Make sure HADR is started on standby machine,  if it’s not started then run the following command to start it:

db2 start hadr on db sample as standby

2. Run the following command to successfully activate and start the database at primary instance:

db2 restart db sample

References:

1. http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.msg.doc/doc/sql1015.htm

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: