for this db2 version.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of r x Sent: Wednesday, August 14, 2002 2:34 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [DB2EUG] DB2 Instance Memory problem Hi, We have installed DB2 V5.1 on AIX 4.3 When trying to start db2 instance using ' db2start ' we get the following error : SQL1220N The database manager shared memory set cannot be allocated. No databases are created yet, and all the parameters were in default values. The total amt of RAM is 756MB and paging space of 1.5GB Then i have changed the following parameters in dbmcfg : NUMDB = 2 MAXAGENTS = 50 JAVA_HEAP_SZ = 256 Still we are unable to start the instance. Following is the dbmcfg file for ref : Database Manager Configuration Node type = Database Server with local and remote clients Database manager configuration release level = 0x0800 CPU speed (millisec/instruction) (CPUSPEED) = 1.220223e-06 Max number of concurrently active databases (NUMDB) = 8 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) = /home/db2v5/sqllib/db2dump 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 Unit of work (DFT_MON_UOW) = OFF SYSADM group name (SYSADM_GROUP) = DB2 SYSCTRL group name (SYSCTRL_GROUP) = SYSMAINT group name (SYSMAINT_GROUP) = Database manager authentication (AUTHENTICATION) = SERVER Cataloging allowed without authority (CATALOG_NOAUTH) = NO Trust all clients (TRUST_ALLCLNTS) = YES Trusted client authentication (TRUST_CLNTAUTH) = CLIENT Default database path (DFTDBPATH) = /home/db2v5 Database monitor heap size (4KB) (MON_HEAP_SZ) = 48 UDF shared memory set size (4KB) (UDF_MEM_SZ) = 256 Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 512 Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0 Backup buffer default size (4KB) (BACKBUFSZ) = 1024 Restore buffer default size (4KB) (RESTBUFSZ) = 1024 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 Keep DARI process (KEEPDARI) = YES Max number of DARI processes (MAXDARI) = MAX_COORDAGENTS 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) = db2cdb2inst10 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) Any ideas ? Note that there are no other applcations running on the server except for AIX OS. Thanks in adv. Ravi. __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
**************************Disclaimer************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***************************************************************************
