467,202 Members | 1,016 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,202 developers. It's quick & easy.

DB2 Rollforward DB query status

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
  • viewed: 10757
Share:
3 Replies
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
Thanks for the fast reply!! This helped greatly.

Mar 14 '06 #3
You can also use 'db2pd -db dbname -recovery' if you are on 8.2

Mar 16 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Steven | last post: by
2 posts views Thread by shenanwei@gmail.com | last post: by
3 posts views Thread by t2581@hotmail.com | last post: by
reply views Thread by smujifor | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.