473,320 Members | 2,098 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.

Db2 v5.2 on NT4 crashed

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
Nov 12 '05 #1
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


Nov 12 '05 #2
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)
Nov 12 '05 #3
*** 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


Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
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...
0
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...
0
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...
4
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...
2
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...
0
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...
4
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...
0
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...
8
by: Pallav singh | last post by:
#include<iostream.h> #include<memory.h> #include<string.h> // product class Pizza { private : std::string Topping;
1
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...
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...
0
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...
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...
1
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)...
1
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...
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.