Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    47

    Unanswered: Db2 Fmp Messages Causes System Failures

    We migrated db2 udb7.2 to 8.1.14. We are getting the following messages on our diaog.log and causing system unavailable. Our applicaiton uses lots of java based stored procedures to serve the requests. We don't see this behavior on 7.2. Any thoughts?

    Settings:

    (KEEPFENCED) = YES
    (FENCED_POOL) = 25
    (NUM_INITFENCED) = 1

    (ASLHEAPSZ) = 15

    (JDK_PATH) = /usr/j2se
    (JAVA_HEAP_SZ) = 16384

    (QUERY_HEAP_SZ) = 3500

    DB2_FMP_COMM_HEAPSZ 40000



    2006-12-22-10.18.58.303802-300 E5389522C586 LEVEL: Error
    PID : 9666 TID : 1 PROC : db2agent
    (XPSDB) 0
    INSTANCE: pdpd099 NODE : 000 DB : XPSDB
    APPHDL : 0-997 APPID: 94ADB383.C9DD.061219210331
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFMPIPC, probe:70
    MESSAGE : ADM11002E Insufficient shared memory available for
    communication
    with the db2fmp process. Use the DB2_FMP_COMM_HEAPSZ registry
    variable to increase the amount of shared memory available
    for fenced
    routines.


    Thanks
    Shri
    p.srinivasarao

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    We had a similiar situation awhile back. What are your settings for MAXAGENTS, NUM_POOLAGENTS, NUM_INITAGENTS, MAX_COORDAGENTS, MAXCAGENTS, and MAX_CONNECTIONS?

    Andy

  3. #3
    Join Date
    Jan 2003
    Posts
    47

    Configuration

    Database Manager Configuration

    Node type = Enterprise Server Edition with local and remote clients

    Database manager configuration release level = 0x0a00

    CPU speed (millisec/instruction) (CPUSPEED) = 3.820478e-07
    Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02

    Max number of concurrently active databases (NUMDB) = 2
    Data Links support (DATALINKS) = NO
    Federated Database System Support (FEDERATED) = YES
    Transaction processor monitor name (TP_MON_NAME) =

    Default charge-back account (DFT_ACCOUNT_STR) =

    Java Development Kit installation path (JDK_PATH) = /usr/j2se

    Diagnostic error capture level (DIAGLEVEL) = 3
    Notify Level (NOTIFYLEVEL) = 2
    Diagnostic data directory path (DIAGPATH) = /usr/local/db2/XXXX/sqllib/db2dump

    Default database monitor switches
    Buffer pool (DFT_MON_BUFPOOL) = ON
    Lock (DFT_MON_LOCK) = ON
    Sort (DFT_MON_SORT) = ON
    Statement (DFT_MON_STMT) = ON
    Table (DFT_MON_TABLE) = ON
    Timestamp (DFT_MON_TIMESTAMP) = ON
    Unit of work (DFT_MON_UOW) = ON
    Monitor health of instance and databases (HEALTH_MON) = OFF

    SYSADM group name (SYSADM_GROUP) = DB2IADM1
    SYSCTRL group name (SYSCTRL_GROUP) = DB2CTRL1
    SYSMAINT group name (SYSMAINT_GROUP) = DB2MAIN1
    SYSMON group name (SYSMON_GROUP) =

    Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
    Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
    Group Plugin (GROUP_PLUGIN) =
    GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
    Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
    Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
    Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
    Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
    Database manager authentication (AUTHENTICATION) = SERVER
    Cataloging allowed without authority (CATALOG_NOAUTH) = NO
    Trust all clients (TRUST_ALLCLNTS) = YES
    Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
    Bypass federated authentication (FED_NOAUTH) = NO

    Default database path (DFTDBPATH) = /db

    Database monitor heap size (4KB) (MON_HEAP_SZ) = 8192
    Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 16384
    Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
    Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
    Backup buffer default size (4KB) (BACKBUFSZ) = 1024
    Restore buffer default size (4KB) (RESTBUFSZ) = 1024

    Sort heap threshold (4KB) (SHEAPTHRES) = 12288

    Directory cache support (DIR_CACHE) = YES

    Application support layer heap size (4KB) (ASLHEAPSZ) = 15
    Max requester I/O block size (bytes) (RQRIOBLK) = 32767
    Query heap size (4KB) (QUERY_HEAP_SZ) = 3500

    Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

    Priority of agents (AGENTPRI) = SYSTEM
    Max number of existing agents (MAXAGENTS) = 700
    Agent pool size (NUM_POOLAGENTS) = 50
    Initial number of agents in pool (NUM_INITAGENTS) = 50
    Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS - NUM_INITAGENTS)
    Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
    Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS

    Keep fenced process (KEEPFENCED) = YES
    Number of pooled fenced processes (FENCED_POOL) = 25
    Initial number of fenced processes (NUM_INITFENCED) = 1

    Index re-creation time and redo index build (INDEXREC) = RESTART

    Transaction manager database name (TM_DATABASE) = 1ST_CONN
    Transaction resync interval (sec) (RESYNC_INTERVAL) = 180

    SPM name (SPM_NAME) =
    SPM log size (SPM_LOG_FILE_SZ) = 256
    SPM resync agent limit (SPM_MAX_RESYNC) = 20
    SPM log path (SPM_LOG_PATH) =

    TCP/IP Service name (SVCENAME) = xxxxx
    Discovery mode (DISCOVER) = SEARCH
    Discover server instance (DISCOVER_INST) = ENABLE

    Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
    Enable intra-partition parallelism (INTRA_PARALLEL) = NO

    No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024
    Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
    Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
    Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC

    Node connection elapse time (sec) (CONN_ELAPSE) = 10
    Max number of node connection retries (MAX_CONNRETRIES) = 5 Max time difference between nodes (min) (MAX_TIME_DIFF) = 60

    db2start/db2stop timeout (min) (START_STOP_TIME) = 10
    p.srinivasarao

Posting Permissions

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