Hello Everybody,

I am facing a problem with DB2 and after making lot of efforts couldn't resolve that one. Please help me out to resolve this problem. Thanks in advance for all the help.

Background info:

I am using DB2 on AIX 5.1.0.0. DB2level is:
DB21085I Instance "igbcust" uses "32" bits and DB2 code release "SQL08012"
with level identifier "02030106".
Informational tokens are "DB2 v8.1.1.16", "s030508", "U486566", and FixPak "2".
Product is installed at "/usr/opt/db2_08_01".

Problem:

Getting error: "SQL1042C An unexpected system error occurred. SQLSTATE=58004."

Everything was fine few days back but all of a sudden (after instance restart), I
started getting above error messages while putting a stored procedure and also at the same time notice error in db2diag.log (see below).

I noticed this type of error when I try to put any stored procedure into that database
or if some application (mostly VB app) queries database to get the parameter info of the stored procedure from the
database. And it is consistent. But I am able to call the existing procedure manually from a command line.

To resolve this problem, as suggested in the db2diag.log, I tried to decrease all the database share memory
parameters (i.e. buffer pools, lock list, database heap, shared sortheap threshold, package cache, and utility heap)
and restarted the instance but no luck :-(

Please help me out in it. Thanks.

Rahul

=============================

DB2Diag.log Error msg:



2004-05-07-18.30.24.519476 Instance:igbcust Node:000
PID:314028(db2agent (BER) 0) TID:1 Appid:G92D7F0E.O03C.094BD7223002
oper system services sqlocshr2 Probe:200 Database:BER

pSetHdl:
0x3172B540 : 9000 0000 9000 0000 0E9E C000 0000 007B ..........À....{
0x3172B550 : 0002 0000 ....

2004-05-07-18.30.24.560771 Instance:igbcust Node:000
PID:314028(db2agent (BER) 0) TID:1 Appid:G92D7F0E.O03C.094BD7223002
routine_infrastructure sqlerGetFMPIPC Probe:60 Database:BER

Unable to create or attach to the segment used for fenced routine communications. Decrease the amount of database shared memory used
by your instance, and try again
0x2FF18460 : 0x00000000 ....

2004-05-07-18.30.24.593704 Instance:igbcust Node:000
PID:314028(db2agent (BER) 0) TID:1 Appid:G92D7F0E.O03C.094BD7223002
routine_infrastructure sqlerGetFMPIPC Probe:60 Database:BER

ADM11000E DB2 is unable to create or attach to the memory segment used for
fenced routine communications. Decrease the amount of database shared memory
used by your instance, and retry.

2004-05-07-18.30.24.626669 Instance:igbcust Node:000
PID:314028(db2agent (BER) 0) TID:1 Appid:G92D7F0E.O03C.094BD7223002
routine_infrastructure sqlerAddFmpToPool Probe:10 Database:BER

DiagData
0x2FF186D0 : 0xFFFFFBEE ÿÿûî

Since you are on fixpak 2, I would look at the APAR's for later fixpaks, or just install fixpak 5 and see what happens.