471,895 Members | 1,943 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,895 software developers and data experts.

database in an inconsistent status when doing DB2DART

I keep getting the following when I run DB2DART /LHWM to reset the HWM :

Warning: The database state is not consistent.

Warning: Errors reported about reorg rows may be due to the inconsistent
state of the database.
DB2DART Processing completed with warning(s)!
Complete DB2DART report found in:
/home/db2gen/sqllib/db2dump/DART0000/GEN.RPT
Is this something I should worry about? The DB CFG reports that the
database is not consistent as well. I have no transactions not committed,
so I am curious why the DB would not be consistent.

Mairhtin
Nov 12 '05 #1
3 7360
Are you sure that there are no connections at all on the db. This is
required for DB2DART.
Could you also be running the CC or monitoring as you attempt to run
DB2DART.
Try a force applications all and deactivate the db before running.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"mairhtin o'feannag" <ir**********@rocketmaildot.com> a écrit dans le
message de news:Xn**********************************@64.164.9 8.29...
I keep getting the following when I run DB2DART /LHWM to reset the HWM :

Warning: The database state is not consistent.

Warning: Errors reported about reorg rows may be due to the inconsistent
state of the database.
DB2DART Processing completed with warning(s)!
Complete DB2DART report found in:
/home/db2gen/sqllib/db2dump/DART0000/GEN.RPT
Is this something I should worry about? The DB CFG reports that the
database is not consistent as well. I have no transactions not committed,
so I am curious why the DB would not be consistent.

Mairhtin


Nov 12 '05 #2
Are you sure that there are no connections at all on the db. This is
required for DB2DART.
Could you also be running the CC or monitoring as you attempt to run
DB2DART.
Try a force applications all and deactivate the db before running.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"mairhtin o'feannag" <ir**********@rocketmaildot.com> a écrit dans le
message de news:Xn**********************************@64.164.9 8.29...
I keep getting the following when I run DB2DART /LHWM to reset the HWM :

Warning: The database state is not consistent.

Warning: Errors reported about reorg rows may be due to the inconsistent
state of the database.
DB2DART Processing completed with warning(s)!
Complete DB2DART report found in:
/home/db2gen/sqllib/db2dump/DART0000/GEN.RPT
Is this something I should worry about? The DB CFG reports that the
database is not consistent as well. I have no transactions not committed,
so I am curious why the DB would not be consistent.

Mairhtin


Nov 12 '05 #3
Are you sure that there are no connections at all on the db. This is
required for DB2DART.
Could you also be running the CC or monitoring as you attempt to run
DB2DART.
Try a force applications all and deactivate the db before running.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"mairhtin o'feannag" <ir**********@rocketmaildot.com> a écrit dans le
message de news:Xn**********************************@64.164.9 8.29...
I keep getting the following when I run DB2DART /LHWM to reset the HWM :

Warning: The database state is not consistent.

Warning: Errors reported about reorg rows may be due to the inconsistent
state of the database.
DB2DART Processing completed with warning(s)!
Complete DB2DART report found in:
/home/db2gen/sqllib/db2dump/DART0000/GEN.RPT
Is this something I should worry about? The DB CFG reports that the
database is not consistent as well. I have no transactions not committed,
so I am curious why the DB would not be consistent.

Mairhtin


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by The Pistoleer | last post: by
2 posts views Thread by gangulyarindam | last post: by
3 posts views Thread by xixi | last post: by
1 post views Thread by James | last post: by
1 post views Thread by aj | last post: by
6 posts views Thread by Hemant Shah | last post: by
3 posts views Thread by Rahul Babbar | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.