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
Reininghausstra sse 5
8020 Graz
Email: wa***********@i ngen.at
Tel.: +43 316 585 949
Fax.: +43 316 585 949 494
HP: http://www.ingen.at 3  1699 
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 pid 29141 exit signal Segmentation fault (11)
MMCACHE: PHP crashed on opline 14 of imagettfbbox() at
test.php:13
Seems like it might be a GD library problem but I am not sure. Any
|
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 going
to miss any
any critical php5 functionality withouth php_threads.dll? Thanks
|
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 be out of order? Another thing I don't
understand is why an increase in the number rows constitutes a warning?
Hoping to here from MySQL users who have came across this. I'm using the
MyISAM storage engine and MySQL 4.1.11 on Red Hat...
|
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 so I can sleep soundly. :-)
Here's the serverlog entry:
LOG: recycled transaction log file "0000000000000028"
FATAL: lock file "/usr/local/pgsql/data/postmaster.pid" already exists
|
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
PID:64936(db2sysc 0) TID:1 Appid:none
base sys utilities sqleChildCrashHandler Probe:15
DiagData
0x10008A70 : 4120 6E6F 6E2D 4544 5520 6368 696C 6420 A non-EDU child
0x10008A80 : 6372 6173 6865 642E crashed.
| | |
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 system was getting backed up).
The system had been running without any problem for few years so some of the
developers relied on it being up all the time and added data that could not
be easily re-created.
|
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 application I get the following
standard error.
"Microsoft Access has encountered a problem and needs to close. We are
sorry for the inconvenience."
|
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 open
it. Then I see unreadable characters, supposedly to be executable-type
of file.
Anyone can advise me on how to extract info from the .dmp file?
|
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 asked to rectify the IIS which is crashed and the web page only specifies "Server Crashed" and no other information is provided?
Could you plz specify a good link where I could get more information on IIS?
Thanks
Raghul
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
