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