Db2 v5.2 on NT4 crashed

Walter Raboch

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

Philip Sherman

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

Jan M. Nelken

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

Philip Sherman

*** 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