Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Posts
    6

    Unanswered: ADM11003E DB2 failed to create

    Hi,
    I found this error message in diaglog, database manager was not restarted, getting these messages again and again.....

    ADM11003E DB2 failed to create the memory segment used for
    communication with fenced routines. If restarting DB2, ensure that no
    db2fmp processes are active on the instance prior to start. Otherwise
    you can adjust the value through the DB2_FMP_COMM_HEAPSZ registry
    variable, or you can decrease the value of ASLHEAPSZ in the database
    manager configuration

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Have you tried to adjust DB2_FMP_COMM_HEAPSZ or ASLHEAPSZ ?

    ANdy

  3. #3
    Join Date
    Sep 2008
    Posts
    6
    I didn't try, but i checked the values ASLHEAPSZ = 15 and
    DB2_FMP_COMM_HEAPSZ =

    How can we calculate these values?

    Thanks

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The documentation of DB2_FMP_COMM_HEAPSZ:

    * Operating system: Windows, UNIX
    * Default: 20 MB, or enough space to run 10 fenced routines (whichever is larger). On AIX®, the default is 256 MB
    * This variable specifies, in 4 KB pages, the size of the pool used for fenced routine invocations, such as stored procedure or user-defined function calls. The space used by each fenced routine is twice the value of the aslheapsz configuration parameter.

    If you are running a large number of fenced routines on your system, you may need to increase the value of this variable. If you are running a very small number of fenced routines, you can reduce it.

    Setting this value to 0 means that no set is created, and as a result no fenced routines can be invoked. It also means that the health monitor and the automatic database maintenance functionality (such as automatic backups, statistics collection, and REORG) will be disabled since this functionality relies on the fenced routine infrastructure.

    Andy

  5. #5
    Join Date
    Oct 2008
    Posts
    1
    purush,

    You may try e-mailing Chris Hodge as he may have some more info on this issue.

Posting Permissions

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