Saturday, April 17, 2021

Backup and restore database - The database is in an inconsistent state. SQLSTATE=55025

 [db2inst1@database-rhel79 ~]$ db2 BACKUP DATABASE unicadb TO /home/db2inst1/dbbackup/

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

[db2inst1@database-rhel79 ~]$ db2 force application

SQL0104N  An unexpected token "END-OF-STATEMENT" was found following

"APPLICATION".  Expected tokens may include:  "ALL".  SQLSTATE=42601

[db2inst1@database-rhel79 ~]$ db2stop

04/18/2021 09:10:30     0   0   SQL1064N  DB2STOP processing was successful.

SQL1064N  DB2STOP processing was successful.

[db2inst1@database-rhel79 ~]$ db2start

04/18/2021 09:10:43     0   0   SQL1063N  DB2START processing was successful.

SQL1063N  DB2START processing was successful.

[db2inst1@database-rhel79 ~]$ db2 BACKUP DATABASE unicadb TO /home/db2inst1/dbbackup/

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


[db2inst1@database-rhel79 ~]$ db2 restart database unicadb

DB20000I  The RESTART DATABASE command completed successfully.

[db2inst1@database-rhel79 ~]$ db2 force applications all

DB20000I  The FORCE APPLICATION command completed successfully.

DB21024I  This command is asynchronous and may not be effective immediately.


[db2inst1@database-rhel79 ~]$ db2stop

04/18/2021 09:13:35     0   0   SQL1064N  DB2STOP processing was successful.

SQL1064N  DB2STOP processing was successful.

[db2inst1@database-rhel79 ~]$ db2start

04/18/2021 09:13:45     0   0   SQL1063N  DB2START processing was successful.

SQL1063N  DB2START processing was successful.

[db2inst1@database-rhel79 ~]$ db2 get db cfg for unicadb

SQL1224N  The database manager is not able to accept new requests, has

terminated all requests in progress, or has terminated the specified request

because of an error or a forced interrupt.  SQLSTATE=55032

[db2inst1@database-rhel79 ~]$ db2 BACKUP DATABASE unicadb TO /home/db2inst1/dbbackup/

SQL2059W  A device full warning was encountered on device

"/home/db2inst1/dbbackup/".

Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) ^Cc


Backup successful. The timestamp for this backup image is : 20210418091446


No comments:

Post a Comment