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
Error: BPS check read error for pool page 772794, from object
ID 6161, pool 2,
Error: BPS Header Revision Number (0) invalid, DB2DART
processing will assume version 5,
Error: BPS Header BEGOFF (21330) incorrect, DB2DART
processing will assume value of 48,
Error: BPS Header DATLEN (21076) incorrect, DB2DART
processing will assume value of 4048,
in pool page 772794, from object ID 6161, pool 2.
Error: Pool page 772794 is not a page for object ID 6161,
pool 2.
Error: Failed to determine object relative page number, for
given pool page 772794 of object ID 6161 pool 2 type (x1)
Error: Bad Index page next leaf field 772794
Error: in page 34793, pool page 772793, of obj 6161, in
tablespace 2.
Error: Page data will be dumped to report.
can someone help me on explaining what error this and how it happened,
how to fix it.
3  5781 
Looks like a bad index. You should probably contact IBM service/support
to figure out which index it is. Dropping and recreating the index
should solve the problem. Reorging it could also be attempted.
xixi wrote: 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
Error: BPS check read error for pool page 772794, from object
ID 6161, pool 2,
Error: BPS Header Revision Number (0) invalid, DB2DART
processing will assume version 5,
Error: BPS Header BEGOFF (21330) incorrect, DB2DART
processing will assume value of 48,
Error: BPS Header DATLEN (21076) incorrect, DB2DART
processing will assume value of 4048,
in pool page 772794, from object ID 6161, pool 2.
Error: Pool page 772794 is not a page for object ID 6161,
pool 2.
Error: Failed to determine object relative page number, for
given pool page 772794 of object ID 6161 pool 2 type (x1)
Error: Bad Index page next leaf field 772794
Error: in page 34793, pool page 772793, of obj 6161, in
tablespace 2.
Error: Page data will be dumped to report.
can someone help me on explaining what error this and how it happened,
how to fix it.
In article <c0************ **************@ posting.google. com>, xixi
(da****@yahoo.c om) says... 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
Error: BPS check read error for pool page 772794, from object
ID 6161, pool 2,
Error: BPS Header Revision Number (0) invalid, DB2DART
processing will assume version 5,
Error: BPS Header BEGOFF (21330) incorrect, DB2DART
processing will assume value of 48,
Error: BPS Header DATLEN (21076) incorrect, DB2DART
processing will assume value of 4048,
in pool page 772794, from object ID 6161, pool 2.
Error: Pool page 772794 is not a page for object ID 6161,
pool 2.
Error: Failed to determine object relative page number, for
given pool page 772794 of object ID 6161 pool 2 type (x1)
Error: Bad Index page next leaf field 772794
Error: in page 34793, pool page 772793, of obj 6161, in
tablespace 2.
Error: Page data will be dumped to report.
can someone help me on explaining what error this and how it happened,
how to fix it.
You can mark the index invalid with
DB2DART <dbname> /TSI <tablespaceid > /OI <objectid>
In your case the tablespaceid = 2 and the objectid = 6161.
Warning: the db should be offline before running db2dart (I would
backup also before running it)
The index will automatically be rebuild when activating the database
( = connecting to the db) or the first time the table is used,
depending on the database configuration parm INDEXREC (RESTART when
activating the db, ACCESS when index is accessed). By default it's
ACCESS on Windows and RESTART on UNIX.
Hope this helps.
since i have created some index under the table, if i drop them, and
back up the database, restore it , and recreate the index again, will
the bad page error happen again? what cause the bad page error? thanks
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: maceo |
last post by:
I have a script that will print out the results of a table and make a
calculation of a total of one of the columns. See example:
<?php
/* Database connection */
include(MYSQL_CONNECT_INCLUDE);
/* Select all pilots */
$query = "SELECT * FROM pilots ORDER BY pilot_num ASC";
|
by: Tao Wang |
last post by:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
I am quite confused on a equation, as following:
#include <iostream>
int main(){
int i = 2;
|
by: allenj |
last post by:
Are the following true statements?
On v7, db2dart should only be run against an activated db with no
connections.
On v8, db2dart should only be run against a deactivated db (which of
course implies that there are no connections)
-------------------------
In my v7 dead tree manuals, I can find no mention of db2dart in the
|
by: xixi |
last post by:
we are using db2 udb v8.1 on win 64 bit with fp3 with type 4
db2jcc.jar driver.
i use db2dart analyze one database. one of the tablespace (database
managed) has
this error, please help me understand this. thanks
Traversing extent map for:
OTR ID: 17
Parent object ID = 17 pool ID = 4
|
by: mairhtin o'feannag |
last post by:
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
| | |
by: dotyet |
last post by:
Hi Everyone,
I am using db2dart to dump some sample table data in delimited format,
but I am finding inconsistencies between the actual data in database
table and the records dumped in .del file.
>>>>
db2dart sample /ddel
|
by: Jack Wright |
last post by:
Dear All,
Is there a Visual Code Inspection Tool for .net...that can check
the code for coding style and warn about coding mistakes done by
programmers?
TALIA
Many Regards
Sunil
|
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
|
by: Peter Duniho |
last post by:
Is there a straightfoward API in .NET that allows for inspection of a
database? That is, to look at the structure of the database, without
knowing anything in advance about it? For example, retrieving a list of
tables in the database.
Doing a little browsing in MSDN, I see that the abstract representation of
a database appears to be the DataSet class. I also see that I can use
"data adapter" classes (e.g. OdbcDataAdapter) to connect a...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
