473,396 Members | 2,052 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,396 software developers and data experts.

DB2 post FP13 crash

Hi All.
I've installed DB2 V8.1 (base) on AIX 5.3 (TL5) and it all works.
When I update it to FP13 (having done nothing else to the system at
all), it dies. Here is the db2diag.log file.

Is anyone else having any difficulties with FP13?
2006-10-05-13.59.08.069544 Instance:db2inst1 Node:000
PID:33036(db2star2) TID:1 Appid:none
base sys utilities startdbm Probe:911

ADM7513W Database manager has started.

2006-10-05-13.59.11.143161 Instance:db2inst1 Node:000
PID:32928(db2bp) TID:1 Appid:none
base sys utilities sqleatin Probe:1

DIA8515C A system error has occurred.
ZRC=0x87340014

2006-10-05-15.07.49.876346+600 I371C341 LEVEL: Severe
PID : 27494 TID : 1 PROC : db2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlepstart, probe:80
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.

2006-10-05-15.07.49.889514+600 I713C282 LEVEL: Severe
PID : 27494 TID : 1 PROC : db2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlepstart, probe:85
MESSAGE : /home/db2inst1/sqllib/tmp/db2start.30148.dat

2006-10-05-15.08.16.881791+600 I996C341 LEVEL: Severe
PID : 27500 TID : 1 PROC : db2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlepstart, probe:80
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.

2006-10-05-15.08.16.883612+600 I1338C282 LEVEL: Severe
PID : 27500 TID : 1 PROC : db2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlepstart, probe:85
MESSAGE : /home/db2inst1/sqllib/tmp/db2start.30150.dat

2006-10-05-15.10.11.499747 Instance:db2inst1 Node:000
PID:31162(db2wdog 0) TID:1 Appid:none
oper system services sqloRunInstance Probe:102

ADM0503C An unexpected internal processing error has occurred. ALL
DB2
PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Diagnostic

information has been recorded. Contact IBM Support for further
assistance.

2006-10-05-15.10.12.049998 Instance:db2inst1 Node:000
PID:31162(db2wdog 0) TID:1 Appid:none
oper system services sqloRunInstance Probe:105

DiagData
0000 0102 0000 0009 ........

2006-10-05-15.10.12.197914 Instance:db2inst1 Node:000
PID:31162(db2wdog 0) TID:1 Appid:none
base sys utilities sqleCleanupResources Probe:5

DiagData
0000 0102 ....

2006-10-05-15.10.14.771749 Instance:db2inst1 Node:000
PID:12050(db2ckpwd 0) TID:1 Appid:none
oper system services sqlorque Probe:9

Unexpected system error 0x24 has occurred.
This has been mapped to ZRC 0x83000024.

PID:12050 TID:1 Node:000 Title: SYSTEM ERROR DESCRIPTION
Identifier removed
2006-10-05-15.10.14.936622 Instance:db2inst1 Node:000
PID:12050(db2ckpwd 0) TID:1 Appid:none
oper system services sqlockpw_daemon_main Probe:50

8300 0024 ...$

2006-10-05-15.10.14.766296 Instance:db2inst1 Node:000
PID:31372(db2ckpwd 0) TID:1 Appid:none
oper system services sqlorque Probe:9

Unexpected system error 0x24 has occurred.
This has been mapped to ZRC 0x83000024.

PID:31372 TID:1 Node:000 Title: SYSTEM ERROR DESCRIPTION
Identifier removed
2006-10-05-15.10.15.427203 Instance:db2inst1 Node:000
PID:31372(db2ckpwd 0) TID:1 Appid:none
oper system services sqlockpw_daemon_main Probe:50

8300 0024 ...$

2006-10-05-15.10.14.779711 Instance:db2inst1 Node:000
PID:33290(db2ckpwd 0) TID:1 Appid:none
oper system services sqlorque Probe:9

Unexpected system error 0x24 has occurred.
This has been mapped to ZRC 0x83000024.

PID:33290 TID:1 Node:000 Title: SYSTEM ERROR DESCRIPTION
Identifier removed
2006-10-05-15.10.16.002201 Instance:db2inst1 Node:000
PID:33290(db2ckpwd 0) TID:1 Appid:none
oper system services sqlockpw_daemon_main Probe:50

8300 0024 ...$

2006-10-05-15.28.53.373737+600 I4029C341 LEVEL: Severe
PID : 6802 TID : 1 PROC : db2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlepstart, probe:80
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.

2006-10-05-15.28.53.430119+600 I4371C282 LEVEL: Severe
PID : 6802 TID : 1 PROC : db2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlepstart, probe:85
MESSAGE : /home/db2inst1/sqllib/tmp/db2start.28390.dat

Of course the /home/db2inst1/sqllib/tmp dir is empty.

-Chris

Oct 5 '06 #1
6 5158
<ch****@warpspeed.com.auwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
Hi All.
I've installed DB2 V8.1 (base) on AIX 5.3 (TL5) and it all works.
When I update it to FP13 (having done nothing else to the system at
all), it dies. Here is the db2diag.log file.

Is anyone else having any difficulties with FP13?
Did you follow ALL of the instructions for the FP13 isntall, including
updating the instance, updating the databases, rebinding packages, ipclean,
etc?

Oct 5 '06 #2

Mark A wrote:
<ch****@warpspeed.com.auwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
Hi All.
I've installed DB2 V8.1 (base) on AIX 5.3 (TL5) and it all works.
When I update it to FP13 (having done nothing else to the system at
all), it dies. Here is the db2diag.log file.

Is anyone else having any difficulties with FP13?

Did you follow ALL of the instructions for the FP13 isntall, including
updating the instance, updating the databases, rebinding packages, ipclean,
etc?
I probably missed something. Want to point me to the readme, 'cause I
could not find it; even when I went looking.

I've not been able to create any databases and it is the database
manager that is failing to start.

Were their major changes between the FP11 and FP13 install?

Thanks for you help.

-Chris

Oct 5 '06 #3

ch****@warpspeed.com.au wrote:
Mark A wrote:
<ch****@warpspeed.com.auwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
Hi All.
I've installed DB2 V8.1 (base) on AIX 5.3 (TL5) and it all works.
When I update it to FP13 (having done nothing else to the system at
all), it dies. Here is the db2diag.log file.
>
Is anyone else having any difficulties with FP13?
Did you follow ALL of the instructions for the FP13 isntall, including
updating the instance, updating the databases, rebinding packages, ipclean,
etc?
I deleted the instance (db2idrop db2inst1) and then recreated it (
"/usr/opt/db2_08_01/instance/db2icrt -a SERVER -s ese -u db2fenc1 -w 32
-p db2c_db2inst1 db2inst1").

Back up and running.

:-)))

-Chris

Oct 5 '06 #4
ch****@warpspeed.com.au wrote:
I deleted the instance (db2idrop db2inst1) and then recreated it (
"/usr/opt/db2_08_01/instance/db2icrt -a SERVER -s ese -u db2fenc1 -w 32
-p db2c_db2inst1 db2inst1").

Back up and running.

:-)))

-Chris
The read.me instructions are included with the fixpack. You can't miss
it. Check the download page.

Since you recreated the instance and databases, then you did not have
upgrade the old ones. But next time you might to read the instructions.

Oct 5 '06 #5

Mark A wrote:
The read.me instructions are included with the fixpack. You can't miss
it. Check the download page.

Since you recreated the instance and databases, then you did not have
upgrade the old ones. But next time you might to read the instructions.
Point taken. :-)

All I could find was the release.txt file, all half a meg of it.

I did try the db2imigr but it core dumps as well.

At least I'm up and running.

Thanks.

-Chris

Oct 6 '06 #6
ch****@warpspeed.com.au wrote:
Point taken. :-)

All I could find was the release.txt file, all half a meg of it.

I did try the db2imigr but it core dumps as well.

At least I'm up and running.

Thanks.

-Chris
db2imigr is not part of the upgrade instructions if you already have a
previous V8 instance. You cannot guess on fixpack upgrades, you must
follow the instructions. If you can't find the instructions, do not do
the upgrade. The read.me file can be downloaded separately from the
fixpack at the fixpack download page.

Oct 6 '06 #7

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

Similar topics

48
by: Joseph | last post by:
Hi I'm writing a commercial program which must be reliable. It has to do some basic reading and writing to and from files on the hard disk, and also to a floppy. I have foreseen a potential...
8
by: Eric Brunel | last post by:
Hi all, I was creating a Tkinter widget in the style of the reversed tabs below Excel worksheets and I stepped in a serious problem: the code I made makes python crash with a seg fault, bus...
10
by: xixi | last post by:
i have db2 udb v8.1 on windows 64 bit 2003 server, after db2 server start , i found this in the db2diag.log, is this error? 2004-05-05-15.28.30.780000 Instance:DB2 Node:000...
34
by: NewToCPP | last post by:
Hi, Why does a C/C++ programs crash? When there is access to a null pointer or some thing like that programs crash, but why do they crash? Thanks.
5
by: yoyo | last post by:
Just to help somebody else if they are looking, we wasted 2 hours last night trying to figure out the problem. (With a manager over our shoulder) We upgraded our 8.1 FP11 instance to FP13....
3
by: bernard.charriere | last post by:
Hello, We have to load and store datas in format XML in a Database DB2 V8.1 FP13, instance 64 bits with DataPartitionned Feature, around 3 Tb of datas stored in the DB ( 6 Generations of 500...
12
by: benjamin.krulewitch | last post by:
I'm debugging an issue with a C program that causes the computer to crash, and I'm attempting to log information immediately before the crash occurs. I us my BKprintLog function (see below) to...
110
by: alf | last post by:
Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...
11
by: =?Utf-8?B?R2VyaGFyZA==?= | last post by:
I have run into a situation that if a page/tab that uses the Ajax toolkit (using .net version 3.5) is closed before the Ajax enable controls complete loading, then IE locks up. Does it in both IE7...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
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...
0
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,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
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,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

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.