cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

MaxDB 7.6.00.18 Couldn't be Started on Windows 2003

Go to solution
HuseyinBilgen
Active Contributor

on ‎09-04-2006 10:55 PM

0 Kudos

Hi,

Because of problem "SAP DBTech JDBC: Cannot connect to jdbc:sapdb://LOCALHOST/PRT [Task limit]." i decided to increase the value of MAXUSERTASKS to 1000 which has default value 50. After setting parameter via Database Manager GUI, I restarted the DB. But the DB did not come up.

Although I've setted the parameter back to 50 result is same.

Here is the log file <b>knldiag.err</b> content:

-

2006-09-05 00:35:03 --- Starting GMT 2006-09-04 21:35:03 7.6.00 Build 018-123-119-055

2006-09-05 00:35:16 0xDD4 ERR 18876 FIBER Could not create fiber, rc = 8

2006-09-05 00:35:16 0xDD4 ERR 18197 DBCRASH RTE Abort exception

2006-09-05 00:35:16 0xE08 ERR 54008 MEMORY RTEMem_RteAllocator : could not allocat

2006-09-05 00:35:16 0xE08 ERR 54008 MEMORY e memory

2006-09-05 00:35:16 0xE08 ERR 54008 MEMORY required : 671120

2006-09-05 00:35:16 0xE08 ERR 54008 MEMORY allocated : 12328960

2006-09-05 00:35:16 0xE08 ERR 54008 MEMORY supplement : 1048576

2006-09-05 00:35:16 0xE08 ERR 54008 MEMORY limit : -1

2006-09-05 00:35:16 0xD64 ERR 18008 TASKING Could not create thread: 'UKT', rc = 8

2006-09-05 00:35:16 0xD64 ERR 18197 DBCRASH RTE Abort exception

2006-09-05 00:35:17 0x37C ERR 18176 CONSOLE Wrong REQUESTOR thread request

2006-09-05 00:35:18 ___ Stopping GMT 2006-09-04 21:35:18 7.6.00 Build 018-123-119-055

2006-09-05 00:36:50 --- Starting GMT 2006-09-04 21:36:50 7.6.00 Build 018-123-119-055

2006-09-05 00:37:03 0xF10 ERR 18876 FIBER Could not create fiber, rc = 8

2006-09-05 00:37:03 0xF10 ERR 18197 DBCRASH RTE Abort exception

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY RTEMem_RteAllocator : could not allocat

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY e memory

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY required : 671120

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY allocated : 12328960

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY supplement : 1048576

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY limit : -1

2006-09-05 00:37:03 0xB6C ERR 18008 TASKING Could not create thread: 'UKT', rc = 8

2006-09-05 00:37:03 0xB6C ERR 18197 DBCRASH RTE Abort exception

2006-09-05 00:37:04 0xE3C ERR 18176 CONSOLE Wrong REQUESTOR thread request

2006-09-05 00:37:05 ___ Stopping GMT 2006-09-04 21:37:05 7.6.00 Build 018-123-119-055

and also <b>knldiag</b>

-

-

Date Time TID(hex) Typ MsgID Label Message-Text

-

2006-09-05 00:36:50 0xB6C 19705 CONNECT Loading default TCPIP-DLL, ( 'sqltcp.dll')

2006-09-05 00:36:50 0xB6C 19707 CONNECT WINSOCK: 2.0, SQLTCP-DLL: 7.6.0

2006-09-05 00:36:50 0xB6C 20233 RTE Dump of all kernel parameters start

2006-09-05 00:36:51 0xB6C 20206 RTE Using mode NORMAL for data volume 1

2006-09-05 00:36:51 0xB6C 20206 RTE Using mode NORMAL for data volume 2

2006-09-05 00:36:51 0xB6C 20206 RTE Using mode NORMAL for data volume 3

2006-09-05 00:36:51 0xB6C 20206 RTE Using mode NORMAL for data volume 4

2006-09-05 00:36:51 0xB6C 20206 RTE Using mode NORMAL for data volume 5

2006-09-05 00:36:51 0xB6C 20234 RTE ADMIN=1

2006-09-05 00:36:51 0xB6C 20234 RTE AKDUMP_ALLOWED=YES

2006-09-05 00:36:51 0xB6C 20234 RTE ALLOW_MULTIPLE_SERVERTASK_UKTS=NO

2006-09-05 00:36:51 0xB6C 20234 RTE AUTHENTICATION_ALLOW=

2006-09-05 00:36:51 0xB6C 20234 RTE AUTHENTICATION_DENY=

2006-09-05 00:36:51 0xB6C 20234 RTE AUTOSAVE=1

2006-09-05 00:36:51 0xB6C 20234 RTE AUTO_RECREATE_BAD_INDEXES=NO

2006-09-05 00:36:51 0xB6C 20234 RTE BACKUPRESULT=1

2006-09-05 00:36:51 0xB6C 20234 RTE BACKUP_BLOCK_CNT=8

2006-09-05 00:36:51 0xB6C 20234 RTE BACKUPHISTFILE=dbm.knl

2006-09-05 00:36:51 0xB6C 20234 RTE BACKUPMED_DEF=dbm.mdf

2006-09-05 00:36:51 0xB6C 20234 RTE CACHE_SIZE=200000

2006-09-05 00:36:51 0xB6C 20234 RTE CALLSTACKLEVEL=0

2006-09-05 00:36:51 0xB6C 20234 RTE CATCACHE_MINSIZE=262144

2006-09-05 00:36:51 0xB6C 20234 RTE CAT_CACHE_SUPPLY=64064

2006-09-05 00:36:51 0xB6C 20234 RTE CHECKDATA=1

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_BACKUP=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_COMMON=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_CONVERTER=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_DATACACHE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_DATAPAGELOG=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_FBM=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_IOMAN=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_KB_REGIONS=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_LOCK_SUPPLY=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_LOCK=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_LOGHISTORY=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_LOGPAGE=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_LOGTRANS=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_LOGVOLUME=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_REGIONS=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_SRVTASKS=0

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_TABLE_WIDTH=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_TASK_SPECIFIC_CATALOGCACHE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_TRANSLIST=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_TREE_LOCKS=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CHECK_TREE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE CLUSTERED_IO=NO

2006-09-05 00:36:51 0xB6C 20234 RTE COLUMNCOMPRESSION=YES

2006-09-05 00:36:51 0xB6C 20234 RTE _COMMENT=

2006-09-05 00:36:51 0xB6C 20234 RTE CONTROLPASSWORD=***

2006-09-05 00:36:51 0xB6C 20234 RTE CONTROLUSERID=CONTROL

2006-09-05 00:36:51 0xB6C 20234 RTE CONVERTER_REGIONS=8

2006-09-05 00:36:51 0xB6C 20234 RTE DATABASEFULL=1

2006-09-05 00:36:51 0xB6C 20234 RTE DATACACHE_RGNS=64

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_GROUPS=1

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_MODE_0001=NORMAL

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_MODE_0002=NORMAL

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_MODE_0003=NORMAL

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_MODE_0004=NORMAL

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_MODE_0005=NORMAL

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_NAME_0001=D:\sapdb\PRT\sapdata\DISKD0001

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_NAME_0002=D:\sapdb\PRT\sapdata\DISKD0002

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_NAME_0003=D:\sapdb\PRT\sapdata\DISKD0003

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_NAME_0004=D:\sapdb\PRT\sapdata\DISKD0004

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_NAME_0005=D:\sapdb\PRT\sapdata\DISKD0005

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_SIZE_0001=512000

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_SIZE_0002=512000

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_SIZE_0003=512000

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_SIZE_0004=512000

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_SIZE_0005=512000

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_TYPE_0001=F

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_TYPE_0002=F

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_TYPE_0003=F

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_TYPE_0004=F

2006-09-05 00:36:51 0xB6C 20234 RTE DATA_VOLUME_TYPE_0005=F

2006-09-05 00:36:51 0xB6C 20234 RTE DATE_TIME_FORMAT=INTERNAL

2006-09-05 00:36:51 0xB6C 20234 RTE DBFILLINGABOVELIMIT=70L80M85M90H95H96H97H98H99H

2006-09-05 00:36:51 0xB6C 20234 RTE DBFILLINGBELOWLIMIT=70L80L85L90L95L

2006-09-05 00:36:51 0xB6C 20234 RTE DDLTRIGGER=YES

2006-09-05 00:36:51 0xB6C 20234 RTE DEADLOCK_DETECTION=4

2006-09-05 00:36:51 0xB6C 20234 RTE DEFAULT_CODE=ASCII

2006-09-05 00:36:51 0xB6C 20234 RTE DELAYCOMMIT=NO

2006-09-05 00:36:51 0xB6C 20234 RTE DELAYLOGWRITER=0

2006-09-05 00:36:51 0xB6C 20234 RTE DIAG_HISTORY_NUM=2

2006-09-05 00:36:51 0xB6C 20234 RTE DIAG_HISTORY_PATH=d:\sapdb\data\wrk\PRT\DIAGHISTORY

2006-09-05 00:36:51 0xB6C 20234 RTE DIAGSEM=0

2006-09-05 00:36:51 0xB6C 20234 RTE DWIO_AREA_FLUSH=50

2006-09-05 00:36:51 0xB6C 20234 RTE DWIO_AREA_SIZE=50

2006-09-05 00:36:51 0xB6C 20234 RTE DWLRU_TAIL_FLUSH=25

2006-09-05 00:36:51 0xB6C 20234 RTE ENABLE_CHECK_INSTANCE=YES

2006-09-05 00:36:51 0xB6C 20234 RTE ENABLE_SYSTEM_TRIGGERS=YES

2006-09-05 00:36:51 0xB6C 20234 RTE ERROR=3

2006-09-05 00:36:51 0xB6C 20234 RTE _EVENTFILE=knldiag.evt

2006-09-05 00:36:51 0xB6C 20234 RTE _EVENTSIZE=0

2006-09-05 00:36:51 0xB6C 20234 RTE EVENT=1

2006-09-05 00:36:51 0xB6C 20234 RTE EXPAND_COM_TRACE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE EXTERNAL_DUMP_REQUEST=NO

2006-09-05 00:36:51 0xB6C 20234 RTE FBMLOW_IO_RATE=10

2006-09-05 00:36:51 0xB6C 20234 RTE FBM_VOLUME_BALANCE=10

2006-09-05 00:36:51 0xB6C 20234 RTE FBM_VOLUME_COMPRESSION=50

2006-09-05 00:36:51 0xB6C 20234 RTE FILEDIR_SPINLOCKPOOL_SIZE=10

2006-09-05 00:36:51 0xB6C 20234 RTE FORBID_LOAD_BALANCING=NO

2006-09-05 00:36:51 0xB6C 20234 RTE FORMATTING_MODE=PARALLEL

2006-09-05 00:36:51 0xB6C 20234 RTE FORMAT_DATAVOLUME=YES

2006-09-05 00:36:51 0xB6C 20234 RTE HASHED_RESULTSET_CACHESIZE=262144

2006-09-05 00:36:51 0xB6C 20234 RTE HASHED_RESULTSET=YES

2006-09-05 00:36:51 0xB6C 20234 RTE HEAP_CHECK_LEVEL=0

2006-09-05 00:36:51 0xB6C 20234 RTE HIRES_TIMER_TYPE=CPU

2006-09-05 00:36:51 0xB6C 20234 RTE HS_STORAGE_DLL=libhsscopy

2006-09-05 00:36:51 0xB6C 20234 RTE HS_SYNC_INTERVAL=50

2006-09-05 00:36:51 0xB6C 20234 RTE IDXFILELIST_SIZE=2048

2006-09-05 00:36:51 0xB6C 20234 RTE INIT_ALLOCATORSIZE=237568

2006-09-05 00:36:51 0xB6C 20234 RTE INSTANCE_TYPE=OLTP

2006-09-05 00:36:51 0xB6C 20234 RTE IOPROCSFOR_PRIO=1

2006-09-05 00:36:51 0xB6C 20234 RTE IOPROCSPER_DEV=1

2006-09-05 00:36:51 0xB6C 20234 RTE IOPROCSSWITCH=2

2006-09-05 00:36:51 0xB6C 20234 RTE JOIN_MAXTAB_LEVEL4=64

2006-09-05 00:36:51 0xB6C 20234 RTE JOIN_MAXTAB_LEVEL9=5

2006-09-05 00:36:51 0xB6C 20234 RTE JOIN_SEARCH_LEVEL=0

2006-09-05 00:36:51 0xB6C 20234 RTE JOIN_TABLEBUFFER=128

2006-09-05 00:36:51 0xB6C 20234 RTE _KERNELDIAGFILE=knldiag

2006-09-05 00:36:51 0xB6C 20234 RTE KERNELDIAGSIZE=800

2006-09-05 00:36:51 0xB6C 20234 RTE _KERNELDUMPFILE=knldump

2006-09-05 00:36:51 0xB6C 20234 RTE _KERNELTRACEFILE=knltrace

2006-09-05 00:36:51 0xB6C 20234 RTE KERNELTRACESIZE=5844

2006-09-05 00:36:51 0xB6C 20234 RTE KERNELVERSION=KERNEL 7.6.00 BUILD 018-123-119-055

2006-09-05 00:36:51 0xB6C 20234 RTE LOAD_BALANCING_CHK=0

2006-09-05 00:36:51 0xB6C 20234 RTE LOAD_BALANCING_DIF=10

2006-09-05 00:36:51 0xB6C 20234 RTE LOAD_BALANCING_EQ=5

2006-09-05 00:36:51 0xB6C 20234 RTE LOCAL_REDO_LOG_BUFFER_SIZE=0

2006-09-05 00:36:51 0xB6C 20234 RTE LOCKSUPPLY_BLOCK=100

2006-09-05 00:36:51 0xB6C 20234 RTE LOGABOVELIMIT=50L75L90M95M96H97H98H99H

2006-09-05 00:36:51 0xB6C 20234 RTE LOGFULL=1

2006-09-05 00:36:51 0xB6C 20234 RTE LOGSEGMENTFULL=1

2006-09-05 00:36:51 0xB6C 20234 RTE LOG_BACKUP_TO_PIPE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE LOG_IO_QUEUE=200

2006-09-05 00:36:51 0xB6C 20234 RTE LOG_MIRRORED=NO

2006-09-05 00:36:51 0xB6C 20234 RTE LOG_QUEUE_COUNT=1

2006-09-05 00:36:51 0xB6C 20234 RTE LOG_SEGMENT_SIZE=170666

2006-09-05 00:36:51 0xB6C 20234 RTE LOG_VOLUME_NAME_001=C:\sapdb\PRT\saplog\DISKL001

2006-09-05 00:36:51 0xB6C 20234 RTE LOG_VOLUME_SIZE_001=512000

2006-09-05 00:36:51 0xB6C 20234 RTE LOG_VOLUME_TYPE_001=F

2006-09-05 00:36:51 0xB6C 20234 RTE LRU_FOR_SCAN=NO

2006-09-05 00:36:51 0xB6C 20234 RTE MAXBACKUPDEVS=2

2006-09-05 00:36:51 0xB6C 20234 RTE MAXCPU=1

2006-09-05 00:36:51 0xB6C 20234 RTE MAXDATAVOLUMES=11

2006-09-05 00:36:51 0xB6C 20234 RTE _MAXEVENTS=100

2006-09-05 00:36:51 0xB6C 20234 RTE _MAXEVENTTASKS=2

2006-09-05 00:36:51 0xB6C 20234 RTE MAXGARBAGECOLL=1

2006-09-05 00:36:51 0xB6C 20234 RTE MAXLOCKS=300000

2006-09-05 00:36:51 0xB6C 20234 RTE MAXLOGVOLUMES=2

2006-09-05 00:36:51 0xB6C 20234 RTE MAXPAGER=64

2006-09-05 00:36:51 0xB6C 20234 RTE MAXRGN_REQUEST=-1

2006-09-05 00:36:51 0xB6C 20234 RTE MAXSERVERTASKS=1023

2006-09-05 00:36:51 0xB6C 20234 RTE MAXTASKSTACK=1024

2006-09-05 00:36:51 0xB6C 20234 RTE _MAXTRANS=4104

2006-09-05 00:36:51 0xB6C 20234 RTE MAXUSERTASKS=50

2006-09-05 00:36:51 0xB6C 20234 RTE MAXVOLUMES=14

2006-09-05 00:36:51 0xB6C 20234 RTE MAX_HASHTABLE_MEMORY=5120

2006-09-05 00:36:51 0xB6C 20234 RTE MAX_LOG_QUEUE_COUNT=0

2006-09-05 00:36:51 0xB6C 20234 RTE MAXMESSAGE_FILES=0

2006-09-05 00:36:51 0xB6C 20234 RTE MAX_MESSAGE_LIST_LENGTH=100

2006-09-05 00:36:51 0xB6C 20234 RTE MAX_RETENTION_TIME=480

2006-09-05 00:36:51 0xB6C 20234 RTE MAX_SERVERTASK_STACK=150

2006-09-05 00:36:51 0xB6C 20234 RTE MAX_SINGLE_HASHTABLE_SIZE=512

2006-09-05 00:36:51 0xB6C 20234 RTE MAX_SPECIALTASK_STACK=200

2006-09-05 00:36:51 0xB6C 20234 RTE MBLOCKDATA_SIZE=32768

2006-09-05 00:36:51 0xB6C 20234 RTE MBLOCKQUAL_SIZE=16384

2006-09-05 00:36:51 0xB6C 20234 RTE MBLOCKSTACK_SIZE=32768

2006-09-05 00:36:51 0xB6C 20234 RTE MBLOCKSTRAT_SIZE=8192

2006-09-05 00:36:51 0xB6C 20234 RTE MCOD=YES

2006-09-05 00:36:51 0xB6C 20234 RTE MEMORY_ALLOCATION_LIMIT=0

2006-09-05 00:36:51 0xB6C 20234 RTE MEM_ENHANCE_LIMIT=0

2006-09-05 00:36:51 0xB6C 20234 RTE MINI_DUMP=NORMAL

2006-09-05 00:36:51 0xB6C 20234 RTE MINREPLYSIZE=4096

2006-09-05 00:36:51 0xB6C 20234 RTE MINSERVERTASKS=73

2006-09-05 00:36:51 0xB6C 20234 RTE MIN_RETENTION_TIME=60

2006-09-05 00:36:51 0xB6C 20234 RTE MONITOR_READ=2147483647

2006-09-05 00:36:51 0xB6C 20234 RTE MONITOR_ROWNO=0

2006-09-05 00:36:51 0xB6C 20234 RTE MONITOR_SELECTIVITY=0

2006-09-05 00:36:51 0xB6C 20234 RTE MONITOR_TIME=2147483647

2006-09-05 00:36:51 0xB6C 20234 RTE MPDISP_LOOPS=1

2006-09-05 00:36:51 0xB6C 20234 RTE MPDISP_PRIO=DEFAULT

2006-09-05 00:36:51 0xB6C 20234 RTE MPRGN_BUSY_WAIT=DEFAULT

2006-09-05 00:36:51 0xB6C 20234 RTE MPRGN_DIRTY_READ=DEFAULT

2006-09-05 00:36:51 0xB6C 20234 RTE MP_RGN_LOOP=-1

2006-09-05 00:36:51 0xB6C 20234 RTE MPRGN_PRIO=DEFAULT

2006-09-05 00:36:51 0xB6C 20234 RTE MPRGN_QUEUE=YES

2006-09-05 00:36:51 0xB6C 20234 RTE MULTIO_BLOCK_CNT=4

2006-09-05 00:36:51 0xB6C 20234 RTE OFFICIAL_NODE=

2006-09-05 00:36:51 0xB6C 20234 RTE OMS_HEAP_BLOCKSIZE=10000

2006-09-05 00:36:51 0xB6C 20234 RTE OMS_HEAP_COUNT=1

2006-09-05 00:36:51 0xB6C 20234 RTE OMS_HEAP_LIMIT=0

2006-09-05 00:36:51 0xB6C 20234 RTE OMS_HEAP_THRESHOLD=100

2006-09-05 00:36:51 0xB6C 20234 RTE OMSREGIONS=0

2006-09-05 00:36:51 0xB6C 20234 RTE OMSRGNS=7

2006-09-05 00:36:51 0xB6C 20234 RTE OMS_RUN_IN_UDE_SERVER=NO

2006-09-05 00:36:51 0xB6C 20234 RTE OMS_STREAM_TIMEOUT=30

2006-09-05 00:36:51 0xB6C 20234 RTE OMS_VERS_THRESHOLD=2097152

2006-09-05 00:36:51 0xB6C 20234 RTE ONLINE=1

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_AGGREGATION=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_FETCH_REVERSE=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_FIRST_ROWS=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_JOIN_HASHTABLE=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_JOIN_HASH_MINIMAL_RATIO=1

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_JOIN_ONEPHASE=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_JOIN_OPERATOR_SORT=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_JOIN_OUTER=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_JOIN_PARALLEL_MINSIZE=1000000

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_JOIN_PARALLEL_SERVERS=0

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_MIN_MAX=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_OPERATOR_JOIN=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_QUAL_ON_INDEX=NO

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIMIZE_QUERYREWRITE=STATEMENT

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIM_CACHE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIM_INV_ONLY=YES

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIM_JOIN_FETCH=0

2006-09-05 00:36:51 0xB6C 20234 RTE OPTIM_MAX_MERGE=500

2006-09-05 00:36:51 0xB6C 20234 RTE OUTOFSESSIONS=2

2006-09-05 00:36:51 0xB6C 20234 RTE PACKETSIZE=131072

2006-09-05 00:36:51 0xB6C 20234 RTE PAGESIZE=8192

2006-09-05 00:36:51 0xB6C 20234 RTE PRIOBASE_COM=10

2006-09-05 00:36:51 0xB6C 20234 RTE PRIOBASE_IOC=80

2006-09-05 00:36:51 0xB6C 20234 RTE PRIOBASE_RAV=80

2006-09-05 00:36:51 0xB6C 20234 RTE PRIOBASE_REX=40

2006-09-05 00:36:51 0xB6C 20234 RTE PRIOBASE_U2U=100

2006-09-05 00:36:51 0xB6C 20234 RTE PRIOFACTOR=80

2006-09-05 00:36:51 0xB6C 20234 RTE PROTECT_DATACACHE_MEMORY=NO

2006-09-05 00:36:51 0xB6C 20234 RTE READAHEADBLOBS=32

2006-09-05 00:36:51 0xB6C 20234 RTE REQUEST_TIMEOUT=5000

2006-09-05 00:36:51 0xB6C 20234 RTE RESTARTTIME=600

2006-09-05 00:36:51 0xB6C 20234 RTE ROWRGNS=8

2006-09-05 00:36:51 0xB6C 20234 RTE _RTEDUMPFILE=rtedump

2006-09-05 00:36:51 0xB6C 20234 RTE RTE_TEST_REGIONS=0

2006-09-05 00:36:51 0xB6C 20234 RTE RUNDIRECTORY=d:\sapdb\data\wrk\PRT

2006-09-05 00:36:51 0xB6C 20234 RTE SEQUENCE_CACHE=1

2006-09-05 00:36:51 0xB6C 20234 RTE SERVERDBFOR_SAP=YES

2006-09-05 00:36:51 0xB6C 20234 RTE SESSION_TIMEOUT=900

2006-09-05 00:36:51 0xB6C 20234 RTE SET_VOLUME_LOCK=YES

2006-09-05 00:36:51 0xB6C 20234 RTE SHAREDSQL_COMMANDCACHESIZE=32768

2006-09-05 00:36:51 0xB6C 20234 RTE SHAREDSQL_EXPECTEDSTATEMENTCOUNT=1500

2006-09-05 00:36:51 0xB6C 20234 RTE SHAREDSQL=YES

2006-09-05 00:36:51 0xB6C 20234 RTE SHOW_MAX_KB_STACK_USE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE SHOW_MAX_STACK_USE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE STANDBY=0

2006-09-05 00:36:51 0xB6C 20234 RTE SUBTREE_LOCKS=NO

2006-09-05 00:36:51 0xB6C 20234 RTE SYMBOL_DEMANGLING=NO

2006-09-05 00:36:51 0xB6C 20234 RTE SYMBOL_RESOLUTION=YES

2006-09-05 00:36:51 0xB6C 20234 RTE SYSTEMERROR=3

2006-09-05 00:36:51 0xB6C 20234 RTE TABRGNS=8

2006-09-05 00:36:51 0xB6C 20234 RTE TASKCLUSTER01=tw;al;ut;2000sv,100bup;10ev,10gc;

2006-09-05 00:36:51 0xB6C 20234 RTE TASKCLUSTER02=ti,100dw;30000us;

2006-09-05 00:36:51 0xB6C 20234 RTE TASKCLUSTER03=compress

2006-09-05 00:36:51 0xB6C 20234 RTE TIME_MEASUREMENT=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_AK=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_ALLOCATOR=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_CATALOG=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_CLIENTKERNELCOM=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_COMMON=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_COMMUNICATION=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_CONVERTER=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_DATACHAIN=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_DATAPAM=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_DATATREE=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_DBPROC=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_DEFAULT=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_DELETE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_FBM=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_FILEDIR=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_FRAMECTRL=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_INDEX=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_INSERT=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_IOMAN=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_IPC=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_JOIN=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_KSQL=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_LOCK=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_LOGACTION=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_LOGHISTORY=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_LOGPAGE=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_LOGTRANS=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_LOGVOLUME=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_LONG=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_MEMORY=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_MESSAGES=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OBJECTCONTAINER=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OBJECT_ADD=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OBJECT_ALTER=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OBJECT_FREE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OBJECT_GET=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OBJECT=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_CONTAINERDIR=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_CONTEXT=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_ERROR=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_FLUSHCACHE=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_INTERFACE=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_KEYRANGE=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_KEY=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_LOCK=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_MEMORY=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_NEWOBJ=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_SESSION=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_STREAM=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_VAROBJECT=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OMS_VERSION=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_OPTIMIZE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_ORDER_STANDARD=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_ORDER=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGER=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES_BUP=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES_EV=2

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES_GC=20

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES_LW=5

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES_PG=3

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES_SV=5

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES_TI=2

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES_US=10

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES_UT=5

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PAGES=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_PRIMARY_TREE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_QUERYREWRITE=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_RUNTIME=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_SELECT=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_SHAREDSQL=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_SQLMANAGER=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_SRVTASKS=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_STOP_ERRORCODE=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_SYNCHRONISATION=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_SYSVIEW=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_TABLE=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_TIME=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_UPDATE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE TRACE_VOLUME=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRANS_HISTORY_SIZE=0

2006-09-05 00:36:51 0xB6C 20234 RTE TRANSRGNS=8

2006-09-05 00:36:51 0xB6C 20234 RTE TRANS_THRESHOLD_VALUE=60

2006-09-05 00:36:51 0xB6C 20234 RTE UKT_CPU_RELATIONSHIP=NONE

2006-09-05 00:36:51 0xB6C 20234 RTE _UNICODE=YES

2006-09-05 00:36:51 0xB6C 20234 RTE UPDATESTAT_PARALLEL_SERVERS=0

2006-09-05 00:36:51 0xB6C 20234 RTE UPDSTATWANTED=1

2006-09-05 00:36:51 0xB6C 20234 RTE USED_MAX_LOG_QUEUE_COUNT=1

2006-09-05 00:36:51 0xB6C 20234 RTE USESELECTFETCH=YES

2006-09-05 00:36:51 0xB6C 20234 RTE USEVARIABLEINPUT=NO

2006-09-05 00:36:51 0xB6C 20234 RTE USEASYNC_IO=YES

2006-09-05 00:36:51 0xB6C 20234 RTE USE_COROUTINES=YES

2006-09-05 00:36:51 0xB6C 20234 RTE USE_FIBERS=YES

2006-09-05 00:36:51 0xB6C 20234 RTE USEIOPROCS_ONLY=NO

2006-09-05 00:36:51 0xB6C 20234 RTE USE_MEM_ENHANCE=NO

2006-09-05 00:36:51 0xB6C 20234 RTE USE_OPEN_DIRECT=NO

2006-09-05 00:36:51 0xB6C 20234 RTE USE_SYSTEM_PAGE_CACHE=YES

2006-09-05 00:36:51 0xB6C 20234 RTE UTILITYPROTFILE=dbm.utl

2006-09-05 00:36:51 0xB6C 20234 RTE UTILITY_PROTSIZE=100

2006-09-05 00:36:51 0xB6C 20234 RTE VOLUMENO_BIT_COUNT=8

2006-09-05 00:36:51 0xB6C 20234 RTE WORKDATASIZE=8192

2006-09-05 00:36:51 0xB6C 20234 RTE WORKSTACKSIZE=8192

2006-09-05 00:36:51 0xB6C 20234 RTE XP_CONVERTER_REGIONS=0

2006-09-05 00:36:51 0xB6C 20234 RTE XP_DATA_CACHE_RGNS=0

2006-09-05 00:36:51 0xB6C 20234 RTE XP_MAXPAGER=0

2006-09-05 00:36:51 0xB6C 20235 RTE Dump of all kernel parameters done

2006-09-05 00:36:51 0xB6C 19841 DIAGHIST Backup of diagnostic files is in progress

2006-09-05 00:36:51 0xB6C 19842 DIAGHIST Backup of diagnostic files has finished

2006-09-05 00:36:51 0xB6C 19600 VERSION 'Kernel 7.6.00 Build 018-123-119-055'

2006-09-05 00:36:51 0xB6C 19600 VERSION 'W32/INTEL 7.6.00 Build 018-123-119-055'

2006-09-05 00:36:51 0xB6C 19769 INFO Starting SERVERDB: 'PRT'

2006-09-05 00:36:51 0xB6C 19770 INFO SERVERNODE: 'bayiportal.ipragaz.com.tr'

2006-09-05 00:36:51 0xB6C 19771 INFO Process ID: 3768

2006-09-05 00:36:51 0xB6C 19773 INFO Date: 2006-09-05

2006-09-05 00:36:51 0xB6C 19772 INFO Owner: 'SYSTEM'

2006-09-05 00:36:51 0xB6C 19774 INFO Product suite: 'Enterprise'

2006-09-05 00:36:51 0xB6C 19783 INFO Processors: 1 ( logical: 2 )

2006-09-05 00:36:51 0xB6C 19782 INFO Fiber: 'YES'

2006-09-05 00:36:51 0xB6C 19776 INFO Max virtual memory: 2047 MB

2006-09-05 00:36:51 0xB6C 19777 INFO Total physical memory: 3070 MB

2006-09-05 00:36:51 0xB6C 19778 INFO Available physical memory: 2630 MB

2006-09-05 00:36:51 0xB6C 20219 RTE Memory allocation not limited

2006-09-05 00:36:51 0xB6C 20220 RTE System page cache usage enabled

2006-09-05 00:36:51 0xB6C 19692 TCLUSTER tw;al;ut;2000sv,100bup;10ev,10gc;ti,100dw;30000us;compress

2006-09-05 00:36:51 0xB6C 19693 TCLUSTER number of 'BUP': 0

2006-09-05 00:36:51 0xB6C 19693 TCLUSTER number of ' DW': 64

2006-09-05 00:36:51 0xB6C 19693 TCLUSTER number of ' US': 50

2006-09-05 00:36:51 0xB6C 19693 TCLUSTER number of ' SV': 1023

2006-09-05 00:36:51 0xB6C 19693 TCLUSTER number of ' EV': 2

2006-09-05 00:36:51 0xB6C 19693 TCLUSTER number of ' GC': 1

2006-09-05 00:36:51 0xB6C 19692 TCLUSTER Total Number of UKT 7

2006-09-05 00:36:51 0xB6C 19692 TCLUSTER Number of UKT with User Tasks 1

2006-09-05 00:36:52 0xB6C 19860 MEMORY I/O buffer cache: 200000 Pages allocated

2006-09-05 00:36:52 0xB6C 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages

2006-09-05 00:36:52 0xB6C 19812 EVENTING Eventbuffer 100 events 2 tasks

2006-09-05 00:36:52 0xEC4 19821 TASKING Thread 3780 starting

2006-09-05 00:36:52 0xB6C 19831 TRACE_IO Configured MAXMESSAGE_FILES:0

2006-09-05 00:36:52 0xB6C 19832 TRACE_IO Disabled: No TraceMessagefiles wanted

2006-09-05 00:36:52 0xEA8 19688 THREAD CLOCK thread started

2006-09-05 00:36:52 0xACC 20213 RTE CONSOLE thread started

2006-09-05 00:36:52 0xE38 19821 TASKING Thread 3640 starting

2006-09-05 00:36:52 0xE50 19821 TASKING Thread 3664 starting

2006-09-05 00:36:52 0xE1C 19688 THREAD TIMER thread started

2006-09-05 00:36:52 0xEF0 19688 THREAD ASYNC0 thread started

2006-09-05 00:36:52 0xE5C 19821 TASKING Thread 3676 starting

2006-09-05 00:36:52 0xE3C 19688 THREAD REQUESTOR thread started

2006-09-05 00:37:03 0xB6C 19649 CONNECT Kernel threads initialization timeout

2006-09-05 00:37:03 0xEF8 19821 TASKING Thread 3832 starting

2006-09-05 00:37:03 0xF58 19627 TASKING UKT started, TID:0xF58

2006-09-05 00:37:03 0xF54 19821 TASKING Thread 3924 starting

2006-09-05 00:37:03 0xF08 19821 TASKING Thread 3848 starting

2006-09-05 00:37:03 0xCDC 19821 TASKING Thread 3292 starting

2006-09-05 00:37:03 0xF5C 19627 TASKING UKT started, TID:0xF5C

2006-09-05 00:37:03 0xF68 19627 TASKING UKT started, TID:0xF68

2006-09-05 00:37:03 0xF7C 19627 TASKING UKT started, TID:0xF7C

2006-09-05 00:37:03 0xF00 19627 TASKING UKT started, TID:0xF00

2006-09-05 00:37:03 0xF10 ERR 18876 FIBER Could not create fiber, rc = 8

2006-09-05 00:37:03 0xF10 ERR 18197 DBCRASH RTE Abort exception

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY RTEMem_RteAllocator : could not allocat

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY e memory

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY required : 671120

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY allocated : 12328960

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY supplement : 1048576

2006-09-05 00:37:03 0xE5C ERR 54008 MEMORY limit : -1

2006-09-05 00:37:03 0xE5C 54000 MEMORY free blocks size 20384 : 1

2006-09-05 00:37:03 0xE5C 54000 MEMORY free blocks size 323080 : 1

2006-09-05 00:37:03 0xE5C 54000 MEMORY free blocks size 416832 : 5

2006-09-05 00:37:03 0xB6C ERR 18008 TASKING Could not create thread: 'UKT', rc = 8

2006-09-05 00:37:03 0xB6C ERR 18197 DBCRASH RTE Abort exception

2006-09-05 00:37:04 0xB6C 19890 DIAGHIST Backup of diagnostic files will be forced at next restart

2006-09-05 00:37:04 0xB6C 19600 VERSION 'Kernel 7.6.00 Build 018-123-119-055'

2006-09-05 00:37:04 0xB6C 19654 DBSTATE SERVERDB 'PRT' has stopped

2006-09-05 00:37:04 0xE3C ERR 18176 CONSOLE Wrong REQUESTOR thread request

-

current write position -

any idea?

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

henrik_hempelmann
Explorer
‎09-05-2006 9:24 AM
0 Kudos

Huseyin,

increasing MAXUSERTASKS results in additional memory consumption. Unfortunately you hit memory limits in with your changed configuration. After resetting the MAXUSERTASKS back to 50 some depending configuration values aren't set back to the old values. Please check the parameter history

(e.g. Database Manager/Information/Parameters/History) for depending changed values and reset them to the old, more reasonable values (e.g. MAXLOCKS, CAT_CACHE_SUPPLY).

regards,

Henrik

Show replies
Show replies
roland_mallmann
Advisor
Advisor
‎09-05-2006 11:29 AM
0 Kudos

Hi,

my colleague, Henrik, is correct, in these older MaxDB 7.6 versions an increase of the parameter MAXUSERTASKS will automatically increase other parameters too, but a decrease will not automatically decrease those same dependent parameters.

I'd also suggest you to change back the setting of parameter MAXSERVERTASKS to its original value.

Just fyi: with your current

TASK_STACK size (1024), every UserTask will use around 1MB of stack. If you increase your amount of usertasks from 50 to 1000, you increase the memory used by stack from around 50mb to a 1gb!

Regards,

Roland

Answers (0)

Ask a Question