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?

Hi,

jadionne@gmail.com schrieb:[color=blue]
> 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?[/color]

"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

Thanks for the fast reply!! This helped greatly.

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