473,320 Members | 1,713 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 7433
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Marc Walgren | last post by:
Greetings I have an ASP application to enter reservations. There are multiple user security settings that require some users to have a restricted list of client in a drop list on a form. I...
1
by: The Pistoleer | last post by:
I have an inconsistent problem with some Internet pages when using Netscape (7.1) that I cannot reproduce with IE nor locally. Below is an example link. There are several tables on the pages. ...
2
by: gangulyarindam | last post by:
Hi, I am facing a peculiar problem while looking ahead in a live Database currently under operation in one of my client’s Project. An Application that is updating 3 - tables in the Database is...
3
by: xixi | last post by:
hi, we are using db2 udb v8.1 on win 64 bit with fp3 with type 4 db2jcc.jar driver. Table inspection start: NJIPD.ARPTDIS Data inspection phase start. Data obj: 6161 In pool: 2 Data...
4
by: MurDock | last post by:
Hi there, our system lost its only active log. I get an I/O error when connecting, referencing the log file and sql error 1036C sqlstate 58030. (Its version 7.1) Is there any way to get the...
1
by: James | last post by:
When I ran db2dart to check a database, I got the following warning and error messages. 1.Warning: The database state is not consistent. 2.Warning: Errors reported about reorg rows may be due to...
1
by: aj | last post by:
What is the difference (if any) between inspect check database and db2dart ??? Do they both find the same potential problems? Does one provide more comprehensive checking than the other? ...
6
by: Hemant Shah | last post by:
Folks, One of our clients is performing an audit, and the auditor(s) asked following question, and I am not sure how to answer it: 28. Is there a control that prevents the corruption of...
3
by: Rahul Babbar | last post by:
Hi All, When could be the possible reasons that could make a database inconsistent? I was told by somebody that it could become inconsistent if you " force all the applications to a close on...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.