DB2 Rollforward DB query status

jadionne

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?

Mar 14 '06 #1

Norbert Munkel

Hi,

ja******@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
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?

"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

Mar 14 '06 #2

jadionne

Thanks for the fast reply!! This helped greatly.

Mar 14 '06 #3

jdokos

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

Mar 16 '06 #4