Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    3

    Unanswered: ADM11000E DB2 is unable to create or attach to the memory segment

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •