By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

DB2 Rollforward DB query status

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
Thanks for the fast reply!! This helped greatly.

Mar 14 '06 #3

P: n/a
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.