Results 1 to 3 of 3

Thread: performance

  1. #1
    Join Date
    Nov 2003

    Unanswered: performance

    hi to all
    we are using db2 7.2 on linux 6.2 pl tell me how to improve
    my system perpormance.


    Database Manager Configuration

    Node type = Database Server with local and remote clients

    Database manager configuration release level = 0x0900

    CPU speed (millisec/instruction) (CPUSPEED) = 5.117063e-07

    Max number of concurrently active databases (NUMDB) = 8
    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 1.1 installation path (JDK11_PATH) =

    Diagnostic error capture level (DIAGLEVEL) = 3
    Diagnostic data directory path (DIAGPATH) = /Kalanjali/db2inst1/sqllib/db2dump

    Default database monitor switches
    Buffer pool (DFT_MON_BUFPOOL) = OFF
    Lock (DFT_MON_LOCK) = OFF
    Sort heap threshold (4KB) (SHEAPTHRES) = 20000

    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) = 1000
    DRDA services heap size (4KB) (DRDA_HEAP_SZ) = 128

    Priority of agents (AGENTPRI) = SYSTEM
    Max number of existing agents (MAXAGENTS) = 200
    Agent pool size (NUM_POOLAGENTS) = 4 (calculated)
    Initial number of agents in pool (NUM_INITAGENTS) = 0
    Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
    Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
    Max number of logical agents (MAX_LOGICAGENTS) = MAX_COORDAGENTS

    Keep DARI process (KEEPDARI) = YES
    Max number of DARI processes (MAXDARI) = MAX_COORDAGENTS
    Initialize DARI process with JVM (INITDARI_JVM) = NO
    Initial number of fenced DARI process (NUM_INITDARIS) = 0

    Index re-creation time (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) = db2cdb2inst1
    APPC Transaction program name (TPNAME) =
    IPX/SPX File server name (FILESERVER) =
    IPX/SPX DB2 server object name (OBJECTNAME) =
    IPX/SPX Socket number (IPX_SOCKET) = 879E

    Discovery mode (DISCOVER) = SEARCH
    Discovery communication protocols (DISCOVER_COMM) = TCPIP
    Discover server instance (DISCOVER_INST) = ENABLE

    Directory services type (DIR_TYPE) = NONE
    Directory path name (DIR_PATH_NAME) = /.:/subsys/database/
    Directory object name (DIR_OBJ_NAME) =
    Routing information object name (ROUTE_OBJ_NAME) =
    Default client comm. protocols (DFT_CLIENT_COMM) =

    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) = 512
    Number of FCM connection entries (FCM_NUM_CONNECT) = (FCM_NUM_RQB * 0.75)
    Number of FCM message anchors (FCM_NUM_ANCHORS) = (FCM_NUM_RQB * 0.75)

  2. #2
    Join Date
    Nov 2003
    some times we are getting SQL0900N ERROR.
    suddenly database is disconnected.
    y it is happend.
    we are using EMBEDED C programs.
    pl tell me

  3. #3
    Join Date
    Aug 2001
    Use the Performance Tuning Wizard to get recommendations for the database config parms ....

    BTW, this wizard is available on the right-click menu of the database name in Control Centre


    Originally posted by jagan_5378
    some times we are getting SQL0900N ERROR.
    suddenly database is disconnected.
    y it is happend.
    we are using EMBEDED C programs.
    pl tell me
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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