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(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
base sys utilities sqleagnt_sigseg vh Probe:1 Database:******

Error in agent servicing application with coor_node:
0x0FFFFFFFFFFF3 600 : 0x0000 ..

2007-02-28-05.00.24.866073 Instance:****** Node:000
PID:2109578(db2 agent (MCL01P1) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
base sys utilities sqleagnt_sigseg vh Probe:2 Database:******

Error in agent servicing application with coor_agent_inde x:
0x0FFFFFFFFFFF3 602 : 0x0281 ..

2007-02-28-05.00.24.959073 Instance:****** Node:000
PID:2109578(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
base sys utilities sqleagnt_sigseg vh Probe:3 Database:******

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

2007-02-28-05.00.24.964498 Instance:****** Node:000
PID:2109578(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
base sys utilities sqleagnt_sigseg vh Probe:4 Database:******

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

2007-02-28-05.00.24.970115 Instance:****** Node:000
PID:2109578(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
base sys utilities sqleagnt_sigseg vh Probe:5 Database:******

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

2007-02-28-05.00.24.975732 Instance:****** Node:000
PID:2109578(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
base sys utilities sqleagnt_sigseg vh Probe:6 Database:******

Error in agent servicing application with OUTBOUND APPLICATION ID:

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

2007-02-28-05.00.24.984003 Instance:****** Node:000
PID:2109578(db2 agent (dbaname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
base sys utilities sqleagnt_sigseg vh Probe:8 Database:******
Error in agent servicing application with AUTHORIZATION ID:
0x07800000001D6 C65 : 4443 544D 5F44 4220 0000 0000 0000 0000
DCTM_DB ........
0x07800000001D6 C75 : 0000 0000 0000 0000 0000 0000 0000
00 ...............

2007-02-28-05.00.24.989338 Instance:****** Node:000
PID:2109578(db2 agent (MCL01P1) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
base sys utilities sqleagnt_sigseg vh Probe:9 Database:MCL01P 1

Error in agent servicing application with PRODUCT SIGNATURE:
0x07800000001D6 E88 : 0x53514C3038303 136
SQL08016

2007-02-28-05.00.24.994618 Instance:****** Node:000
PID:2109578(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
base sys utilities sqleagnt_sigseg vh Probe:10 Database:******

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

2007-02-28-05.00.25.014507 Instance:****** Node:000
PID:2109578(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
oper system services sqloEDUCodeTrap Handler 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(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
oper system services sqloEDUCodeTrap Handler Probe:20
Database:******

Signal number received

0x0FFFFFFFFFFF3 730 : 0x0000000A ....

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

0x0FFFFFFFFFFF3 A20 : 0000 000A 0000 0000 0000 0009 0000
0000 ............... .
0x0FFFFFFFFFFF3 A30 : 0000 0000 0000 0000 0000 0000 0000
0000 ............... .
0x0FFFFFFFFFFF3 A40 : 0000 0000 0000 0000 0000 0000 0000
0000 ............... .
0x0FFFFFFFFFFF3 A50 : 0000 0000 0000 0000 0000 0000 0000
0000 ............... .

2007-02-28-05.00.25.081306 Instance:****** Node:000
PID:2109578(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
relation data serv sqlrr_signal_ha ndler 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 =
0x0FFFFFFFFFFF3 390 :
0x000000011003A F00 ........

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

>pkgnamcsn.rdbc olid =

2007-02-28-05.00.25.110629 Instance:****** Node:000
PID:2109578(db2 agent (******) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
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(db2 agent (dbname) 0) TID:1
Appid:GA6DA619. C438.002D980457 17
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 Reply

6489

Mark A

<vi******@gmail .comwrote in message
news:11******** **************@ k78g2000cwa.goo glegroups.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

5564

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 brings the whole instance down and it has to be restarted. In addition the job seems to be stuck in the TOOLSDB as if I try to delete the backup job I get "The task is currently running". So I went to the command line and tried "db2 backup database...

DB2 Database

1569

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 script tries to run a UserControl's method or use a property, IE gives an error "Object doesn't support this property or method". Example:

C# / C Sharp

1551

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 emp.PAGTRF.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain()

ASP.NET

2440

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 reference not set to an instance of an object. The exception throws at the code that tries to set a property (String data type) at my Menu user control.

ASP.NET

9011

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 my WinXP as a testing server (I created the app in Visual Studio.NET 2005). When deploying this app on the production server (running Win2000 Server, IIS and SQLServerExpress 2005), I'm getting the following

ASP.NET

2881

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 step 1 of the wizard and saved into a session variable. In step 2, when the user clicks on a button, I load the design data from the session variable and these are saved for further handling in a HashTable. The HashTable is defined in the...

ASP.NET

1020

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 am starting the server manually in the background by running from the command line as follows: ../mySOAPServer.py & However, when I log out of my ssh session, the server often stops

Python

1941

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 completed a fully functional application using ASP.NET 2 on my development site. Wanting to make it functional on a different server, I installed SQL Express on the target server, then moved the application using Visual Web Development to the new...

ASP.NET

3646

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 ajax call (only one of several others work fine). I get this error message <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head>

Apache Web Server

8896

Changing the language in Windows 10

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,...

Windows Server

9653

Problem With Comparison Operator <=> in G++

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

C / C++

9451

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

9421

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9333

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

8328

AI Job Threat for Devs

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

Career Advice

6869

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4942

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2872

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP