Database migration rc=2 Problem

nemeth81 · #1 (**permalink**) 02-19-10, 13:22

Hi Gurus,
During the migration of the DB, I am facing the following problem.

D:\SQLLIB\BIN>Db2 migrate db D73
SQL1704N Database migration failed. Reason code "2".

There is one host with 2 db2 instances = 2 database. DB binaries has migrated to 9.5, one of the DB can be migrate, but with the another I am facing this problem.

Could you help me, what could be the problem?
DB is not in roll forward pending state.

Thanks.

n_i · #2 (**permalink**) 02-19-10, 13:45

Code:

$ db2 "? sql1704"


SQL1704N Database migration failed.  Reason code
          "<reason-code>".

Explanation:

Database migration failed. The reason codes are as follows:

...

 2 database is not migrateable.  The database could be in one of
the following states:

o   backup pending state

o   roll-forward pending state

o   transaction inconsistent state

o   HADR has marked the database inconsistent

nemeth81 · #3 (**permalink**) 02-19-10, 13:51

Thanks, I am checking it. None of the above mentioned.
No hadr in, no backup, and no rollforward pending.
any other idea?

n_i · #4 (**permalink**) 02-19-10, 13:57

Code:

db2 get db cfg for <yourdb> | findstr "consistent pending"

nemeth81 · #5 (**permalink**) 02-19-10, 14:39

Thanks, The query did not get back result.
Maybe it could be an authorisation problem ?
One host with 2 db. Q73, and D73.
during the installation of the 9.5, I am using db2q73 user.
I can migrate the Q73, it is working fine. I can't migrate the D73.
maybe the problem with the users?
how could I check it, fix it?
thanks

nemeth81 · #6 (**permalink**) 02-19-10, 14:39

Thanks, The query did not get back result.
Maybe it could be an authorisation problem ?
One host with 2 db. Q73, and D73.
during the installation of the 9.5, I am using db2q73 user.
I can migrate the Q73, it is working fine. I can't migrate the D73.
maybe the problem with the users?
how could I check it, fix it?
thanks

n_i · #7 (**permalink**) 02-19-10, 14:48

Quote:

Originally Posted by nemeth81

The query did not get back result.

What query? Can you see the database configuration parameters?

Internet Services

Web Development

Digital Marketing

Consumer Tech