DB2 instance goes down every one hour - A serious error in production server

vijay.db

Hi Team,

Very serious problem with my DB2 V8.1 Fixpack 6 running in AIX 5.1
machine. Every one hour my DB2 instance processes are killed and it's
going down. Several trap files are generated in the db2 diag log
directory. Following the detailed entry in the db2diag.log:

2007-02-28-05.00.10.650672 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:1 Database:******

Error in agent servicing application with coor_node:
0x0FFFFFFFFFFF3600 : 0x0000 ..

2007-02-28-05.00.24.866073 Instance:****** Node:000
PID:2109578(db2agent (MCL01P1) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:2 Database:******

Error in agent servicing application with coor_agent_index:
0x0FFFFFFFFFFF3602 : 0x0281 ..

2007-02-28-05.00.24.959073 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:3 Database:******

Error in agent servicing application with CLIENT PID:
0x0FFFFFFFFFFF3618 : 3636 3236 34 66264

2007-02-28-05.00.24.964498 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:4 Database:******

Error in agent servicing application with INBOUND APPLICATION ID:
0x000000011003AF93 : 4741 3644 4136 3139 2E43 3433 382E 3030
GA6DA619.C438.00
0x000000011003AFA3 : 3244 3938 3034 3537 3137
2D98045717

2007-02-28-05.00.24.970115 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:5 Database:******

Error in agent servicing application with INBOUND SEQUENCE NUMBER:
0x000000011003AFB4 : 0x0001 ..

2007-02-28-05.00.24.975732 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:6 Database:******

Error in agent servicing application with OUTBOUND APPLICATION ID:

2007-02-28-05.00.24.980011 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:7 Database:******
Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

2007-02-28-05.00.24.984003 Instance:****** Node:000
PID:2109578(db2agent (dbaname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:8 Database:******
Error in agent servicing application with AUTHORIZATION ID:
0x07800000001D6C65 : 4443 544D 5F44 4220 0000 0000 0000 0000
DCTM_DB ........
0x07800000001D6C75 : 0000 0000 0000 0000 0000 0000 0000
00 ...............

2007-02-28-05.00.24.989338 Instance:****** Node:000
PID:2109578(db2agent (MCL01P1) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:9 Database:MCL01P1

Error in agent servicing application with PRODUCT SIGNATURE:
0x07800000001D6E88 : 0x53514C3038303136
SQL08016

2007-02-28-05.00.24.994618 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
base sys utilities sqleagnt_sigsegvh Probe:10 Database:******

Error in agent servicing application with APPLICATION NAME:
0x07800000001D6E5E : 646F 6375 6D65 6E74 756D
documentum

2007-02-28-05.00.25.014507 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
oper system services sqloEDUCodeTrapHandler Probe:10
Database:******

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.

2007-02-28-05.00.25.053871 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
oper system services sqloEDUCodeTrapHandler Probe:20
Database:******

Signal number received

0x0FFFFFFFFFFF3730 : 0x0000000A ....

PID:2109578 TID:1 Node:000 Title: siginfo_t...

0x0FFFFFFFFFFF3A20 : 0000 000A 0000 0000 0000 0009 0000
0000 ................
0x0FFFFFFFFFFF3A30 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
0x0FFFFFFFFFFF3A40 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
0x0FFFFFFFFFFF3A50 : 0000 0000 0000 0000 0000 0000 0000
0000 ................

2007-02-28-05.00.25.081306 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
relation data serv sqlrr_signal_handler Probe:50 Database:******

DIA0505I Execution of a component signal handling function has begun.

PID:2109578 TID:1 Node:000 Title: RDS AGENT CB
Dump File:/home/dumclp1/sqllib/db2dump/21095781.000

PID:2109578 TID:1 Node:000 Title: SQLCA
Dump File:/home/dumclp1/sqllib/db2dump/21095781.000

PID:2109578 TID:1 Node:000 Title: RDS UCINTFC
Dump File:/home/dumclp1/sqllib/db2dump/21095781.000

PID:2109578 TID:1 Node:000 Title: RDS UCINTFC: pCurrentPID =
0x0FFFFFFFFFFF3390 :
0x000000011003AF00 ........

PID:2109578 TID:1 Node:000 Title: RDS UCINTFC: pCurrentPID-

>pkgnamcsn.rdbcolid =

2007-02-28-05.00.25.110629 Instance:****** Node:000
PID:2109578(db2agent (******) 0) TID:1
Appid:GA6DA619.C438.002D98045717
relation data serv sqlrr_dump_ffdc Probe:20 Database:******

DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007M-^?

PID:2109578 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08016
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2007-02-28-05.00.25.303996 Instance:****** Node:000
PID:2109578(db2agent (dbname) 0) TID:1
Appid:GA6DA619.C438.002D98045717
relation data serv sqlrr_dump_ffdc Probe:902 Database:******

DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007M-^?
This is the same error message we are getting in the diag log for
every one hour. Searched in google for different conditions no clue..

Did any one faced a similar situation like this? what is the root
cause of this error and what can be done to resolve this.

NOTE: This DB2 here works with DOCUMENTUM application which inturn
works with the SAN storage media for data/image handling.

As this's a serious error in a Production Server..looking for some
quick solutions.

Thanks,
vj_dba

Feb 28 '07 #1

Subscribe Post Reply

6368

Mark A

<vi******@gmail.comwrote in message
news:11**********************@k78g2000cwa.googlegr oups.com...

Hi Team,

Very serious problem with my DB2 V8.1 Fixpack 6 running in AIX 5.1
machine. Every one hour my DB2 instance processes are killed and it's
going down. Several trap files are generated in the db2 diag log
directory. Following the detailed entry in the db2diag.log:

You need to contact IBM support if you get those type of errors.

Feb 28 '07 #2

Similar topics

Please HELP .. instance crash ver 8.2

by: Mike | last post by:

Greetings, Having a major problem here. running version 8.2 on win2003 server. The problem I am having is backing up a database seems to get to the last part of the backup and then fails. This...

DB2 Database

BUG/PRODUCTION-DOWN: UserControl running from HTML not working.

by: ATS | last post by:

BUG/PRODUCTION-DOWN: UserControl running from HTML not working. Someone please help, I have a production down situation. For whatever reason, UserControls are not owkring from HTML/IE. When...

C# / C Sharp

HELP! Error Loading ASPX : Object Reference not set to an instance object

by: Pedro Correia | last post by:

Hello, When i run my aspx i get this weird error: System.NullReferenceException: Object reference not set to an instance of an object. at emp.PAGTRF.InitializeComponent() at...

ASP.NET

Mysterious Error: Object reference not set to an instance of an object

by: Max | last post by:

Hi There! I'm having a mysterious error right after I login using Forms Authentication in my ASP.NET app. Below is the error... Exception Details: System.NullReferenceException: Object...

ASP.NET

Error connecting to SQLExpress 2005 locally (error: 26 - Error Locating Server/Instance Specified)

by: hfk0 | last post by:

Hello, I'm a newbie here and was wondering anyone could help me with this. I have a simple ASP.NET 2 web application running perfectly fine with IIS and SQLServerExpress installed locally on...

ASP.NET

Sporadic error:" Object reference not set to an instance of an object."

by: Michel Couche | last post by:

Hello, I have an ASP.Net application that uses the Wizard control to build a newsletter. There are three steps in the wizard. The customer's specific design data are loaded from a database in...

ASP.NET

SOAPpy server shutting down?

by: sberry | last post by:

I have a soap server I am running on an OS X Server using SOAPpy. To start the server I am running server = SOAPpy.SOAPServer(('IPADDRESS", PORT), namespace=NAMESPACE) server.serve_forever() I...

Python

Failed to generate a user instance of SQL Server ...

by: James R. Davis | last post by:

.... due to failure in receiving user's application data path. Okay, this simply cannot be a problem unique to me and I assume there is a straight forward solution, but it escapes me. I have...

ASP.NET

How to track down a 500 error

by: Claus Mygind | last post by:

I have 3 web servers (one production and two test). Production machine runs Apache 2.0.54 Old test machine runs Apache 2.0.44 New test machine runs Apache 2.0.54 In one of my apps I make an...

Apache Web Server

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA

Applying ComboBox filters Sequentially

by: SueHopson | last post by:

Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

Microsoft Access / VBA