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
