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  5734 
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.com) 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 */...
|
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...
|
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...
|
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...
|
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...
|
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?
...
|
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,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
| |
