473,699 Members | 2,768 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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
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
Nov 12 '05 #1
3 1697
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
2565
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
0
2183
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
0
5225
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...
4
1745
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
2
3788
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.
0
1088
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.
4
1962
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."
0
1021
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?
8
1513
by: Pallav singh | last post by:
#include<iostream.h> #include<memory.h> #include<string.h> // product class Pizza { private : std::string Topping;
1
1974
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
0
8615
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9173
Oralloy
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...
0
8882
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7748
agi2029
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...
0
5872
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4375
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...
0
4627
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3057
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
2
2345
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.