473,554 Members | 2,142 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 7448
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**********@r ocketmaildot.co m> a écrit dans le
message de news:Xn******** *************** ***********@64. 164.98.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**********@r ocketmaildot.co m> a écrit dans le
message de news:Xn******** *************** ***********@64. 164.98.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**********@r ocketmaildot.co m> a écrit dans le
message de news:Xn******** *************** ***********@64. 164.98.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
2073
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 constructed the following function: CREATE FUNCTION (@pUserId int)
1
1675
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. The tables at the top containing small images are working correctly. The tables below that contain product descriptions and input to purchase an...
2
1634
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 missing to update a certain number of Fields in one of the Tables. The fact is not frequent and I have checked through the Server Performance Monitor...
3
5750
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 inspection phase end. Index inspection phase start. Index obj: 6161 In pool: 2
4
3535
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 database to create a new log, without having to do a restore? we don't have a backup. Thanks
1
13941
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 the inconsistent state of the database. 3.Found some orphaned extent numbers in a DMS user tablespace. Any advice on how to change database to be...
1
4849
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? TIA
6
10730
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 databases (e.g. is there database integrity checking)? Please provide a description of the control and the name and phone number of the person who can...
3
6175
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 that database and transactions are not committed or rollbacked" I infact, don't believe it, because i suppose when we do a "force
0
7605
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7530
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7808
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8047
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7570
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7893
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5162
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3556
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
845
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.