DB2 Rollforward DB query status

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jadionne@gmail.com - 14 Mar 2006 13:28 GMT

I am doing a rollforward and want to query the status of the
rollforward. I issue the command: DB2 Rollforward database namdwh
query status.
I get the following error:
C:\Documents and Settings\webi>db2 rollforward database namdwh query
status
SQL1035N The database is currently in use. SQLSTATE=57019

I know its in use...I am the one using it. How do I get around this?

Reply to this Message

Norbert Munkel - 14 Mar 2006 14:08 GMT

Hi,

jadionne@gmail.com schrieb:

> I am doing a rollforward and want to query the status of the
> rollforward. I issue the command: DB2 Rollforward database namdwh
[quoted text clipped - 5 lines]
>
> I know its in use...I am the one using it. How do I get around this?

"query status" does not work while the database is rolling forward. The
SQL1035N results from an ongoing rollforward operation.

"db2 list utilities show detail" and db2diag.log should tell you a
little bit more about the current rollforward state.

regards,

Norbert

Reply to this Message

jadionne@gmail.com - 14 Mar 2006 15:12 GMT

Thanks for the fast reply!! This helped greatly.

Reply to this Message

jdokos - 16 Mar 2006 15:50 GMT

You can also use 'db2pd -db dbname -recovery' if you are on 8.2

Reply to this Message