Hi all,
a database of one of my customers chrashed two days ago. They have no
current backup - dont ask why but I think I have to shoot someone there.
I was able to restore most of the tables with db2dart. But I cant dump
some of the important ones. Table inspection start: D03T060 Data inspection phase start. Data obj: 16 In pool: 2 Error: Unable to read pool page 0, object page 0, from pool 2, Error: parent pool 2, object ID 16, object type Data. Error: This object page does not exist. Error: reading page: 0 from object: 16 Data inspection phase end.
Error: Unable to read pool page 0, object page 0, from pool 2, Error: parent pool 2, object ID 16, object type Data. Error: Unable to read pool page 0, object page 0, from pool 2, Error: parent pool 2, object ID 16, object type Data. Error: Unable to read pool page 0, object page 0, from pool 2, Error: parent pool 2, object ID 16, object type Data. Table inspection end.
The problem is pool page 0 ...
db2start DB08 /DDEL with table D03T060 in tablespace 2 and start page 0
gives:
Error: Unable to read pool page 0, object page 0, from pool 2, Error: parent pool 2, object ID 16, object type Data. Error: Unable to get table descriptor record.
Can someone help me to get at least some of the data ?
Thanks in advance,
Walter
--
ACHTUNG: neue Firmenanschrift
Dipl.Ing. (FH) Walter Raboch
ingen Software Consulting und Entwicklung GmbH
Reininghausstrasse 5
8020 Graz
Email: wa***********@ingen.at
Tel.: +43 316 585 949
Fax.: +43 316 585 949 494
HP: http://www.ingen.at 3 1684
I was able to replicate your "Error reading page: 0" on RHEL3, UDB 8.1.
db2dart goes directly to the physically stored data and works its magic
from there. Your error messages indicate that the table exists in the
catalog but cannot be located on disk.
Assuming that you are using SMS storage (a guess from "tablespace 2")
and haven't moved the logs from their default location:
1. Get the LOGPATH value from the database configuration
2. Go to the directory formed by replacing SQLLOGDIR with SQLT0002.0
3. Look for files "*16.*". There will be one or more depending on the
table definition and (if I remember correctly) indexes.
I suspect that at least one of the files will be missing. The *.DAT file
is the primary data file for the table. Since you have a table name and
ID, I suspect you got them from the catalog. If the catalog doesn't
match the data - possibly caused by a drop and create of the table, then
db2dart will give the error message you've received.
The numeric portion of the file name should correspond to the ID of the
tables. Check for files that don't have matching tables in the catalog.
As a last resort, you could see if the file(s) are recoverable from a
volume backup. This is NOT a recommended recovery technique because
volume backups do not contain data that was in the buffer pools when the
backup physically read the data.
Phil Sherman
Walter Raboch wrote: Hi all,
a database of one of my customers chrashed two days ago. They have no current backup - dont ask why but I think I have to shoot someone there.
I was able to restore most of the tables with db2dart. But I cant dump some of the important ones.
>Table inspection start: D03T060 >> >> Data inspection phase start. Data obj: 16 In pool: 2 >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Error: This object page does not exist. >> Error: reading page: 0 from object: 16 >> Data inspection phase end. >> >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Table inspection end. The problem is pool page 0 ...
db2start DB08 /DDEL with table D03T060 in tablespace 2 and start page 0 gives: >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Error: Unable to get table descriptor record.
Can someone help me to get at least some of the data ?
Thanks in advance,
Walter
Walter Raboch wrote: a database of one of my customers chrashed two days ago. They have no current backup - dont ask why but I think I have to shoot someone there.
Walter - Austria makes one of the better guns - use them!
What were tablespaces defined as? DMS or SMS?
Do you have OS level backup of the all files involved?
How many tables / tablespaces are involved?
From: http://www-1.ibm.com/support/docview...id=swg21168270
V5.2 support ended on June, 2001
V6.1 support ended on December, 2001
V7.1 support ended on December, 2002/June 2003 for EE and EEE
V7.2 support will end on September, 2004
Current version is V8.2
Any thoughts?
Jan M. Nelken
(jasinek at attglobal dot net)
*** Dup reply - original not seen in newsgroup 2004/08/29 @ 0130 UT ***
I was able to replicate your "Error reading page: 0" on RHEL3, UDB 8.1.
db2dart goes directly to the physically stored data and works its magic
from there. Your error messages indicate that the table exists in the
catalog but cannot be located on disk.
Assuming that you are using SMS storage (a guess from "tablespace 2")
and haven't moved the logs from their default location:
1. Get the LOGPATH value from the database configuration
2. Go to the directory formed by replacing SQLLOGDIR with SQLT0002.0
3. Look for files "*16.*". There will be one or more depending on the
table definition and (if I remember correctly) indexes.
I suspect that at least one of the files will be missing. The *.DAT file
is the primary data file for the table. Since you have a table name and
ID, I suspect you got them from the catalog. If the catalog doesn't
match the data - possibly caused by a drop and create of the table, then
db2dart will give the error message you've received.
The numeric portion of the file name should correspond to the ID of the
tables. Check for files that don't have matching tables in the catalog.
As a last resort, you could see if the file(s) are recoverable from a
volume backup. This is NOT a recommended recovery technique because
volume backups do not contain data that was in the buffer pools when the
backup physically read the data.
Phil Sherman
Walter Raboch wrote: Hi all,
a database of one of my customers chrashed two days ago. They have no current backup - dont ask why but I think I have to shoot someone there.
I was able to restore most of the tables with db2dart. But I cant dump some of the important ones.
>Table inspection start: D03T060 >> >> Data inspection phase start. Data obj: 16 In pool: 2 >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Error: This object page does not exist. >> Error: reading page: 0 from object: 16 >> Data inspection phase end. >> >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Table inspection end. The problem is pool page 0 ...
db2start DB08 /DDEL with table D03T060 in tablespace 2 and start page 0 gives: >> Error: Unable to read pool page 0, object page 0, from pool 2, >> Error: parent pool 2, object ID 16, object type Data. >> Error: Unable to get table descriptor record.
Can someone help me to get at least some of the data ?
Thanks in advance,
Walter This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Subhash |
last post by:
Hello,
I am trying to generate dynamic graphics using the GD library and TTF
fonts. The resulting image shows up fine. But in the apache error_log
file the following lines are appended:
child...
|
by: Sarah Tanembaum |
last post by:
It turns out that the culprit that crashed my php5ts.dll as below is
php_threads.dll.
Is there any fix for this?
Thanks
BTW: I remove php_threads.dll from extensions and it works now. Am I...
|
by: Matt |
last post by:
Hi everyone,
I'm using the command "mysqlcheck --all-databases --auto-repair --silent"
and I see these warnings and errors (listed below) on a daily occurrence.
What could cause these indexes to...
|
by: Hunter Hillegas |
last post by:
Looks like my copy of 7.4, which seems to have been running fine until now,
crashed last night at about 1am.
All my alarms went off and I got it started again, but I'd like to know what
happened...
|
by: ChrisWinterscheid |
last post by:
Occasionally we see these messages in the db2diag.log file. Can someone
tell me what they mean and are they anything to worry about?
2005-03-03-10.42.04.286220 Instance:db2inst1 Node:000...
|
by: Hemant Shah |
last post by:
Folks,
One of our system crashed last week. It had few database instances on it.
They are all for development and was deteremined that they do not need to be
backed up (database backup, the file...
|
by: Fish |
last post by:
I have an Access applicaion I built for my buiness. Last week the
application crashed and I haven't been able to get it running again
since in any form.
Now every time I try to run the...
|
by: Curious |
last post by:
A program crashed silently. Fortunately, I was able to get a .dmp
file. Hopefully it can provide us with info on why it crashed.
When I opened the .dmp file in Notepad, it took a long time to...
|
by: Pallav singh |
last post by:
#include<iostream.h>
#include<memory.h>
#include<string.h>
// product
class Pizza
{
private :
std::string Topping;
|
by: raghulvarma |
last post by:
Hai friends,
I need to know what would happen when my IIS gets crashed? what would happen to all the projects present inside it?How should I rectify that?What should I do when I am...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
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...
|
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...
| |