Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: memory availability

    1) I am having db2 ESE 9.5 server on Win2003.

    2) When I was doing: db2start, I get the error:
    SQL1022C There is not enough memory available to process the command.

    3) I failed to do anything from what was suggested as user response:

    a) Change the MEMMAN NO SWAP, NO MOVE option in the CONFIG.SYS file to SWAP, MOVE. I could not find CONFIG.SYS anywhere. Can you tell me where it is located or if on windows it has a different name.

    b) Remove background processes - How to do this?. First of all what all are the db2 background processes and what all can we remove.

    c) Decrease the values of the configuration parameters that define allocation of memory, including udf_mem_sz if UDFs are involved in the failing statement.
    This is a parameter of type db manager configuration. UDFs were not involved in the failing statement.
    What all parameters define allocation of memory.

    d) Install more random access memory (RAM). want to keep it as last option.

    e) If a remote procedure was invoked, ensure that the remote procedure uses a local variable space that is less than or equal to 4K. Even though remote procedure was not involved, I would like to know how to accomplish this.

    f) If you are using Remote Data Services, increase the Remote Data Services heap size (rsheapsz) in the server and client configuration because at least one block is used per application. This is the one that fits I think. I could not find rsheapsz in list of db and dbm cfg parameters. When can I find and set this both in client and in server.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Several question I would ask.

    1) How much RAM do you have on the server?
    2) 32 or 64 bit?
    3) what else is running on the server?
    4) what is the dbm config?

    Andy

  3. #3
    Join Date
    Jul 2008
    Posts
    131
    1)ram-1GB, its a desktop machine for testing purpose and not the production server
    2)32 bit
    3)db2 only and rational clearquest
    4)
    Database Manager Configuration

    Node type = Enterprise Server Edition with local and remote clients

    Database manager configuration release level = 0x0c00

    Maximum total of files open (MAXTOTFILOP) = 16000
    CPU speed (millisec/instruction) (CPUSPEED) = 3.857478e-007
    Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+002

    Max number of concurrently active databases (NUMDB) = 7
    Federated Database System Support (FEDERATED) = NO
    Transaction processor monitor name (TP_MON_NAME) =

    Default charge-back account (DFT_ACCOUNT_STR) =

    Java Development Kit installation path (JDK_PATH) = C:\PROGRA~1\IBM
    B\java\jdk

    Diagnostic error capture level (DIAGLEVEL) = 3
    Notify Level (NOTIFYLEVEL) = 3
    Diagnostic data directory path (DIAGPATH) =

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

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

    Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
    Client Kerberos Plugin (CLNT_KRB_PLUGIN) = IBMkrb5
    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
    Cluster manager (CLUSTER_MGR) =

    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) = C:

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

    Agent stack size (AGENT_STACK_SZ) = 16
    Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
    Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000

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

    Directory cache support (DIR_CACHE) = YES

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

    Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

    Priority of agents (AGENTPRI) = SYSTEM
    Agent pool size (NUM_POOLAGENTS) = 100
    Initial number of agents in pool (NUM_INITAGENTS) = 0
    Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC
    Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC

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

    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) = TWDPC239
    SPM log size (SPM_LOG_FILE_SZ) = 256
    SPM resync agent limit (SPM_MAX_RESYNC) = 20
    SPM log path (SPM_LOG_PATH) =

    NetBIOS Workstation name (NNAME) =

    TCP/IP Service name (SVCENAME) = db2c_DB2
    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

    Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0

    No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096
    No. of int. communication channels (FCM_NUM_CHANNELS) = 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

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by nittal
    1) I am having db2 ESE 9.5 server on Win2003.

    2) When I was doing: db2start, I get the error:
    SQL1022C There is not enough memory available to process the command.

    3) I failed to do anything from what was suggested as user response:

    a) Change the MEMMAN NO SWAP, NO MOVE option in the CONFIG.SYS file to SWAP, MOVE. I could not find CONFIG.SYS anywhere. Can you tell me where it is located or if on windows it has a different name.

    b) Remove background processes - How to do this?. First of all what all are the db2 background processes and what all can we remove.

    c) Decrease the values of the configuration parameters that define allocation of memory, including udf_mem_sz if UDFs are involved in the failing statement.
    This is a parameter of type db manager configuration. UDFs were not involved in the failing statement.
    What all parameters define allocation of memory.

    d) Install more random access memory (RAM). want to keep it as last option.

    e) If a remote procedure was invoked, ensure that the remote procedure uses a local variable space that is less than or equal to 4K. Even though remote procedure was not involved, I would like to know how to accomplish this.

    f) If you are using Remote Data Services, increase the Remote Data Services heap size (rsheapsz) in the server and client configuration because at least one block is used per application. This is the one that fits I think. I could not find rsheapsz in list of db and dbm cfg parameters. When can I find and set this both in client and in server.
    Your system is obviously memory constrained. 1 GB is not enough. Ways to fixed based on the user responses:

    a) config.sys is from the old DOS/early windows days. I do not know if it is used any more.

    b) background process are anything that is non-DB2 and non essential for the OS. Things like email, web browsers, etc.

    c) decrease the dbm config parms that deal with memory. These usually have the word heap or size in them. Read the manual on how what you do will impact the system. You can also look into using STMM.

    d) You do need to increase RAM. You might as well and go for the max 4 GB.

    e & f) are probably not the problem at this time.

    Andy

Posting Permissions

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