I'm using WebTools on SAPDB 7.4 for Linux on RedHat 9 to attempt to create a new database.
The procedure seemed to make sense to me, but at the end the database
would not start. An examination of KNLDIAG shows the following
interesting lines:
2003-08-03 09:37:02 18273 12891 INFO maximum core size: 0 MB
2003-08-03 09:37:05 18275 12929 TASKING Task T1 started
2003-08-03 09:37:05 0 12853 DBSTATE Caught signal 11(SIGSEGV)
2003-08-03 09:37:05 0 ERR 11330 COREHAND ABORTING due to signal 11
DBMPAHI looks like this:
20030803 00090616 KERNELVERSION KERNEL 7.4.3 BUILD
027-121-048-452
C GENERAL
20030803 00090616 INSTANCE_TYPE OLTP
C GENERAL
20030803 00090616 _SERVERDB_FOR_SAP YES
C SUPPORT
20030803 00090616 _UNICODE NO
C EXTENDED
20030803 00090616 DEFAULT_CODE ASCII
C EXTENDED
20030803 00090616 DATE_TIME_FORMAT INTERNAL
C EXTENDED
20030803 00090616 CONTROLUSERID ZDBM
C NO
20030803 00090616 MAXARCHIVELOGS 1
C GENERAL
20030803 00090616 MAXDATADEVSPACES 1
C GENERAL
20030803 00090616 LOG_BACKUP_TO_PIPE NO
C EXTENDED
20030803 00090616 MAXBACKUPDEVS 2
C GENERAL
20030803 00090616 BACKUP_BLOCK_CNT 8
C EXTENDED
20030803 00090616 LOG_MIRRORED NO
C GENERAL
20030803 00090616 LOG_MODE SINGLE
C NO
20030803 00090616 _MAXDEVSPACES 3
C SUPPORT
20030803 00090616 _MULT_IO_BLOCK_CNT 8
C SUPPORT
20030803 00090616 _DELAY_LOGWRITER 0
C SUPPORT
20030803 00090616 LOG_IO_QUEUE 50
C EXTENDED
20030803 00090616 _RESTART_TIME 600
C SUPPORT
20030803 00090616 MAXCPU 1
C GENERAL
20030803 00090616 MAXUSERTASKS 50
C GENERAL
20030803 00090616 _TREE_RGNS 8
C EXTENDED
20030803 00090616 _TRANS_RGNS 8
C EXTENDED
20030803 00090616 _TAB_RGNS 8
C EXTENDED
20030803 00090616 _OMS_REGIONS 0
C NO
20030803 00090616 _OMS_RGNS 8
C NO
20030803 00090616 OMS_HEAP_LIMIT 0
C NO
20030803 00090616 OMS_HEAP_COUNT 1
C NO
20030803 00090616 OMS_HEAP_BLOCKSIZE 10000
C NO
20030803 00090616 OMS_HEAP_THRESHOLD 100
C NO
20030803 00090616 OMS_VERS_THRESHOLD 2097152
C NO
20030803 00090616 HEAP_CHECK_LEVEL 0
C NO
20030803 00090616 _ROW_RGNS 8
C EXTENDED
20030803 00090616 _MIN_SERVER_DESC 11
C SUPPORT
20030803 00090616 MAXSERVERTASKS 11
C EXTENDED
20030803 00090616 _MAXTRANS 252
C SUPPORT
20030803 00090616 MAXLOCKS 2520
C GENERAL
20030803 00090616 _LOCK_SUPPLY_BLOCK 100
C SUPPORT
20030803 00090616 DEADLOCK_DETECTION 4
C EXTENDED
20030803 00090616 SESSION_TIMEOUT 900
C EXTENDED
20030803 00090616 OMS_STREAM_TIMEOUT 30
C SUPPORT
20030803 00090616 REQUEST_TIMEOUT 5000
C EXTENDED
20030803 00090616 _IOPROCS_PER_DEV 2
C SUPPORT
20030803 00090616 _IOPROCS_FOR_PRIO 0
C SUPPORT
20030803 00090616 _USE_IOPROCS_ONLY NO
C SUPPORT
20030803 00090616 _IOPROCS_SWITCH 2
C SUPPORT
20030803 00090616 LRU_FOR_SCAN NO
C EXTENDED
20030803 00090616 _PAGE_SIZE 8192
C SUPPORT
20030803 00090616 _PACKET_SIZE 36864
C SUPPORT
20030803 00090616 _MINREPLY_SIZE 4096
C SUPPORT
20030803 00090616 _MBLOCK_DATA_SIZE 32768
C SUPPORT
20030803 00090616 _MBLOCK_QUAL_SIZE 8192
C SUPPORT
20030803 00090616 _MBLOCK_STACK_SIZE 16384
C SUPPORT
20030803 00090616 _WORKSTACK_SIZE 8192
C SUPPORT
20030803 00090616 _WORKDATA_SIZE 8192
C SUPPORT
20030803 00090616 _CAT_CACHE_MINSIZE 262144
C SUPPORT
20030803 00090616 CAT_CACHE_SUPPLY 1632
C EXTENDED
20030803 00090616 INIT_ALLOCATORSIZE 237568
C SUPPORT
20030803 00090616 _TASKCLUSTER_01 tw;al;ut;2000*sv,100*bup;10*ev,
10*gc;
C SUPPORT
20030803 00090616 _TASKCLUSTER_02 ti,100*dw;30000*us;
C SUPPORT
20030803 00090616 _TASKCLUSTER_03 compress
C SUPPORT
20030803 00090616 _DYN_TASK_STACK NO
C SUPPORT
20030803 00090616 _MP_RGN_QUEUE YES
C SUPPORT
20030803 00090616 _MP_RGN_DIRTY_READ NO
C SUPPORT
20030803 00090616 _MP_RGN_BUSY_WAIT NO
C SUPPORT
20030803 00090616 _MP_DISP_LOOPS 2
C SUPPORT
20030803 00090616 _MP_DISP_PRIO NO
C SUPPORT
20030803 00090616 XP_MP_RGN_LOOP 0
C SUPPORT
20030803 00090616 MP_RGN_LOOP 0
C EXTENDED
20030803 00090616 _MP_RGN_PRIO NO
C SUPPORT
20030803 00090616 MAXRGN_REQUEST 300
C EXTENDED
20030803 00090616 _PRIO_BASE_U2U 100
C SUPPORT
20030803 00090616 _PRIO_BASE_IOC 80
C SUPPORT
20030803 00090616 _PRIO_BASE_RAV 80
C SUPPORT
20030803 00090616 _PRIO_BASE_REX 40
C SUPPORT
20030803 00090616 _PRIO_BASE_COM 10
C SUPPORT
20030803 00090616 _PRIO_FACTOR 80
C SUPPORT
20030803 00090616 _DELAY_COMMIT NO
C SUPPORT
20030803 00090616 _SVP_1_CONV_FLUSH NO
C SUPPORT
20030803 00090616 _MAXGARBAGE_COLL 0
C NO
20030803 00090616 _MAXTASK_STACK 400
C SUPPORT
20030803 00090616 _DW_IO_AREA_SIZE 50
C SUPPORT
20030803 00090616 _DW_IO_AREA_FLUSH 50
C SUPPORT
20030803 00090616 _FBM_DEVSP_COMPR 50
C SUPPORT
20030803 00090616 _FBM_DEVSP_BALANCE 10
C SUPPORT
20030803 00090616 _FBM_LOW_IO_RATE 10
C SUPPORT
20030803 00090616 CACHE_SIZE 10000
C GENERAL
20030803 00090616 _DW_LRU_TAIL_FLUSH 25
C SUPPORT
20030803 00090616 XP_DATA_CACHE_RGNS 0
C EXTENDED
200308
03 00090616 _DATA_CACHE_RGNS 8
C EXTENDED
20030803 00090616 CONVERTER_REGIONS 8
C EXTENDED
20030803 00090616 _MAXDATAWRITER 8
C SUPPORT
20030803 00090616 SEQUENCE_CACHE 1
C EXTENDED
20030803 00090616 _IDXFILE_LIST_SIZE 2048
C SUPPORT
20030803 00090616 _SERVER_DESC_CACHE 64
C SUPPORT
20030803 00090616 _SERVER_CMD_CACHE 12
C SUPPORT
20030803 00090616 DEVNO_BIT_COUNT 8
C EXTENDED
20030803 00090616 OPTIM_MAX_MERGE 500
C EXTENDED
20030803 00090616 OPTIM_INV_ONLY YES
C EXTENDED
20030803 00090616 OPTIM_CACHE NO
C SUPPORT
20030803 00090616 OPTIM_JOIN_FETCH 0
C SUPPORT
20030803 00090616 JOIN_SEARCH_LEVEL 0
C EXTENDED
20030803 00090616 JOIN_MAXTAB_LEVEL4 16
C EXTENDED
20030803 00090616 JOIN_MAXTAB_LEVEL9 5
C EXTENDED
20030803 00090616 _READAHEAD_BLOBS 25
C SUPPORT
20030803 00090616 RUNDIRECTORY
/var/opt/sapdb/indep_data/wrk/ZAMPLES
C GENERAL
20030803 00090616 OPMSG1 /dev/console
C GENERAL
20030803 00090616 OPMSG2 /dev/null
C GENERAL
20030803 00090616 _KERNELDIAGFILE knldiag
C SUPPORT
20030803 00090616 KERNELDIAGSIZE 800
C EXTENDED
20030803 00090616 _EVENTFILE knldiag.evt
C SUPPORT
20030803 00090616 _EVENTSIZE 0
C SUPPORT
20030803 00090616 _MAXEVENTTASKS 1
C SUPPORT
20030803 00090616 _MAXEVENTS 100
C EXTENDED
20030803 00090616 _KERNELTRACEFILE knltrace
C SUPPORT
20030803 00090616 TRACE_PAGES_TI 2
C EXTENDED
20030803 00090616 TRACE_PAGES_GC 0
C EXTENDED
20030803 00090616 TRACE_PAGES_AL 5
C EXTENDED
20030803 00090616 TRACE_PAGES_DW 3
C EXTENDED
20030803 00090616 TRACE_PAGES_US 10
C EXTENDED
20030803 00090616 TRACE_PAGES_UT 5
C EXTENDED
20030803 00090616 TRACE_PAGES_SV 5
C EXTENDED
20030803 00090616 TRACE_PAGES_EV 2
C EXTENDED
20030803 00090616 TRACE_PAGES_BUP 0
C EXTENDED
20030803 00090616 KERNELTRACESIZE 594
C SUPPORT
20030803 00090616 _AK_DUMP_ALLOWED YES
C SUPPORT
20030803 00090616 _KERNELDUMPFILE knldump
C SUPPORT
20030803 00090616 _RTEDUMPFILE rtedump
C SUPPORT
20030803 00090616 _UTILITY_PROTFILE dbm.utl
C SUPPORT
20030803 00090616 UTILITY_PROTSIZE 100
C EXTENDED
20030803 00090616 _BACKUP_HISTFILE dbm.knl
C SUPPORT
20030803 00090616 _BACKUP_MED_DEF dbm.mdf
C SUPPORT
20030803 00090616 _MAX_MESSAGE_FILES 0
C EXTENDED
20030803 00090616 _EVENT_ALIVE_CYCLE 0
C EXTENDED
20030803 00090616 _SHMCHUNK 32
C SUPPORT
20030803 00090616 _SHAREDDYNDATA 10135
C SUPPORT
20030803 00090616 _SHAREDDYNPOOL 3539
C SUPPORT
20030803 00090616 _SHMKERNEL 89842
C SUPPORT
20030803 00090616 DIAG_HISTORY_NUM 2
C EXTENDED
20030803 00090616 DIAG_HISTORY_PATH
/var/opt/sapdb/indep_data/wrk/ZAMPLES/DIAGHISTORY
C EXTENDED
20030803 00090616 _DIAG_SEM 0
C NO
20030803 00090616 SHOW_MAX_STACK_USE NO
C SUPPORT
20030803 00090616 LOG_SEGMENT_SIZE 0
C GENERAL
20030803 00090616 SUPPRESS_CORE YES
C SUPPORT
20030803 00090616 FORMATTING_MODE PARALLEL
C EXTENDED
20030803 00090616 FORMAT_DATAVOLUME YES
C EXTENDED
20030803 00090616 LOAD_BALANCING_CHK 0
C EXTENDED
20030803 00090616 LOAD_BALANCING_DIF 10
C SUPPORT
20030803 00090616 LOAD_BALANCING_EQ 5
C SUPPORT
20030803 00090616 EXPAND_COM_TRACE NO
C SUPPORT
20030803 00090616 ALLOW_DEMANGLE YES
C SUPPORT
20030803 00090616 USE_OPEN_DIRECT NO
C SUPPORT
20030803 00090616 USE_COROUTINES NO
C SUPPORT
20030803 00090616 USE_STACK_ON_STACK YES
C SUPPORT
20030803 00090616 USE_UCONTEXT YES
C SUPPORT
20030803 00090643 SESSION_TIMEOUT 31
900
C EXTENDED
20030803 00090656 REQUEST_TIMEOUT 31
5000
C EXTENDED
20030803 00090806 OFFICIAL_NODE SANCTUARY
C EXTENDED
20030803 00092056 MAXDATADEVSPACES 11
1
C GENERAL
20030803 00092056 _MAXDEVSPACES 13
3
C SUPPORT
20030803 00092056 _MIN_SERVER_DESC 21
11
C SUPPORT
20030803 00092056 MAXSERVERTASKS 21
11
C EXTENDED
20030803 00092056 _MAXTRANS 292
252
C SUPPORT
20030803 00092056 MAXLOCKS 2920
2520
C GENERAL
20030803 00092056 _MAXDATAWRITER 11
8
C SUPPORT
20030803 00092056 _SERVER_DESC_CACHE 74
64
C SUPPORT
20030803 00092056 _SERVER_CMD_CACHE 22
12
C SUPPORT
20030803 00092056 KERNELTRACESIZE 653
594
C SUPPORT
20030803 00092056 _SHAREDDYNDATA 10282
10135
C SUPPORT
20030803 00092056 _SHAREDDYNPOOL 4031
3539
C SUPPORT
20030803 00092056 _SHMKERNEL 92047
89842
C SUPPORT
20030803 00092957 MAXARCHIVELOGS 2
1
C GENERAL
20030803 00092957 _MAXDEVSPACES 14
13
C SUPPORT
20030803 00092957 _SHMKERNEL 92052
92047
C SUPPORT
20030803 00092957 LOG_SEGMENT_SIZE 666
0
The following appears strange to me, and I wonder if it is
contributing factor:
OMS_HEAP_LIMIT 0
Any suggestions?
Mike
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
