Hi all, I've got a - Windows 2000 system, - Maxdb 7.5.0.08 running. param_startsession param_init param_put MAXUSERTASKS 100 param_checkall param_commitsession db_reg db_admin db_activate dba,dba load_systab -ud domain
after creation of a database with the script above the database is not able to start. I can't activate the database instance. After setting up the command db_activate dba,dba the following error occurs: ERR -24988,ERR_SQL: sql error What's wrong here? After setting up the db_warm command in the dbmcli: ERR -24895,ERR_SHUTDOWN: shutdown of database occured -71,connection broken TIA for your help Silke knldiag file: -------------------------------------------------------------------------------- Date Time TID(hex) Typ MsgID Label Message-Text -------------------------------------------------------------------------------- 2004-02-23 14:06:06 0x3FC 19705 CONNECT Loading default TCPIP-DLL, ( 'sqltcp.dll') 2004-02-23 14:06:06 0x3FC 19707 CONNECT WINSOCK: 2.0, SQLTCP-DLL: 7.5.0 2004-02-23 14:06:08 0x3FC 19841 DIAGHIST Backup of diagnostic files is in progress 2004-02-23 14:06:11 0x3FC 19842 DIAGHIST Backup of diagnostic files has finished 2004-02-23 14:06:11 0x3FC 19769 INFO Starting SERVERDB: 'TESTDB' 2004-02-23 14:06:11 0x3FC 19770 INFO SERVERNODE: 'silke' 2004-02-23 14:06:11 0x3FC 19771 INFO Process ID: 1832 2004-02-23 14:06:11 0x3FC 19773 INFO Date: 2004-02-23 2004-02-23 14:06:11 0x3FC 19772 INFO Owner: 'SYSTEM' 2004-02-23 14:06:11 0x3FC 19775 INFO Processors: 1 2004-02-23 14:06:11 0x3FC 19782 INFO Fiber: 'YES' 2004-02-23 14:06:11 0x3FC 19776 INFO Max virtual memory: 2047 MB 2004-02-23 14:06:11 0x3FC 19777 INFO Total physical memory: 63 MB 2004-02-23 14:06:11 0x3FC 19778 INFO Available physical memory: 10 MB 2004-02-23 14:06:11 0x3FC 202 RTE Memory allocation not limited 2004-02-23 14:06:11 0x3FC 203 RTE System page cache usage enabled 2004-02-23 14:06:11 0x3FC 19692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw;30000*us;compress 2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of 'BUP': 0 2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' DW': 8 2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' US': 100 2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' SV': 11 2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' EV': 1 2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' GC': 0 2004-02-23 14:06:16 0x3FC 19860 MEMORY RTE PageAllocator: 10000 Pages allocated 2004-02-23 14:06:17 0x3FC 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages 2004-02-23 14:06:17 0x3FC 19812 EVENTING Eventbuffer 100 events 1 tasks 2004-02-23 14:06:17 0x3FC 19815 EVENTING No AliveEvent generation 2004-02-23 14:06:18 0x3FC 19831 TRACE_IO Configured _MAX_MESSAGE_FILES:0 2004-02-23 14:06:18 0x3FC 19832 TRACE_IO Disabled: No TraceMessagefiles wanted 2004-02-23 14:06:18 0x76C 19688 THREAD CLOCK thread started 2004-02-23 14:06:18 0x750 19688 THREAD TIMER thread started 2004-02-23 14:06:18 0x720 19688 THREAD ASYNC0 thread started 2004-02-23 14:06:18 0x734 196 RTE CONSOLE thread started 2004-02-23 14:06:18 0x55C 19821 TASKING Thread 1372 starting 2004-02-23 14:06:18 0x738 19821 TASKING Thread 1848 starting 2004-02-23 14:06:18 0x5B8 19688 THREAD REQUESTOR thread started 2004-02-23 14:06:28 0x3FC 19649 CONNECT Kernel threads initialization timeout 2004-02-23 14:06:28 0x764 19821 TASKING Thread 1892 starting 2004-02-23 14:06:28 0x748 19627 TASKING UKT started, TID:0x748 2004-02-23 14:06:28 0x760 19627 TASKING UKT started, TID:0x760 2004-02-23 14:06:28 0x730 19627 TASKING UKT started, TID:0x730 2004-02-23 14:06:28 0x6C4 19627 TASKING UKT started, TID:0x6C4 2004-02-23 14:06:28 0x6A8 19627 TASKING UKT started, TID:0x6A8 2004-02-23 14:06:28 0x778 19627 TASKING UKT started, TID:0x778 2004-02-23 14:06:28 0x464 19627 TASKING UKT started, TID:0x464 2004-02-23 14:06:30 0x6A8 19615 VOLUMEIO Attaching volume 'knltrace' 2004-02-23 14:06:30 0x780 19613 DBSTATE I/O thread for 'knltrace' started 2004-02-23 14:06:31 0x6A8 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:6 2004-02-23 14:06:31 0x6A8 32 Admin Kernel state: 'ADMIN' reached 2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_A51_CACHE : 2424 2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES user + 1 : 101 2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES headlist all : 404 2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES headlist elem: 4 2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES list all : 2020 2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES list element : 20 2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX FileListItemSize : 8 2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX NumFileListItems : 2048 2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX FileListSizeAll : 16384 2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX FunnelItemSize : 8 2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX QueueItemPtrSize : 4 2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX QueueItemSize : 36 2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX SortItemSize : 16 2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX NumFunnelItems : 2048 2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX FunnelSizeAll : 131072 2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_B49_IDXSIZE : 147456 2004-02-23 14:06:31 0x6A8 19600 VERSION 'Kernel 7.5.0 Build 008-123-061-548' 2004-02-23 14:06:31 0x6A8 19600 VERSION 'W32/INTEL 7.5.0 Build 008-123-061-548' 2004-02-23 14:06:31 0x6A8 54003 dynDATA DYND_K57_KB_PAGES : 11 2004-02-23 14:06:31 0x6A8 54003 dynDATA BACKUP RESTART REC (8K): 1 2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP TASK LIST : 48 2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP TAPE LIST : 688 2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP DEVSP LIST : 16 2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP SRR QUEUE : 224 2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_K38_SAVE_GLOB : 976 2004-02-23 14:06:31 0x6A8 54003 dynDATA DYND_K38_SAVE : 73 2004-02-23 14:06:31 0x6A8 54003 dynDATA BACKUP RESTART REC (8K): 1 2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP TASK LIST : 32 2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP TAPE LIST : 688 2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP DEVSP LIST : 16 2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP SRR QUEUE : 128 2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_K38_AUTOSAVE : 864 2004-02-23 14:06:31 0x6A8 54003 dynDATA DYND_K38_AUTOSAVE : 41 2004-02-23 14:06:31 0x6A8 54003 dynpool KB50 mdesc item size : 232 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 mdesc items : 114 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 mdesc list size : 26448 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 mdesc list aligned: 26448 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet items : 12 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet desc size : 16 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet desc list : 192 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet size : 36656 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packetsize aligned: 36656 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet list : 439872 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parent list : 2592 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 kbfunction_task : 113 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parent items / 0.7: 161 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parent desc size : 16 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parentdesc aligned: 2576 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parent hash list : 644 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parenthash aligned: 656 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 maxservertasks : 11 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 server desc size : 24 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 server list : 264 2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 serverlist aligned: 272 2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_K90_DISTRIB : 470016 2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 5 2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:0 2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 12 2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:1 2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 11 2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:2 2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 10 2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:3 2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 9 2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:4 2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 8 2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:5 2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 7 2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:6 2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 6 2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:7 2004-02-23 14:06:33 0x750 199 RTE Kernel state changed from STARTING to ADMIN 2004-02-23 14:06:33 0x750 19601 DBSTATE SERVERDB is ready ============================================ begin of write cycle ================== 2004-02-23 14:06:34 0x748 19633 CONNECT Connect req. (T4, Node:'', PID:1856) 2004-02-23 14:06:34 0x748 19651 CONNECT Connection released, T4 2004-02-23 14:06:35 0x748 19633 CONNECT Connect req. (T4, Node:'', PID:1856) 2004-02-23 14:06:35 0x748 19651 CONNECT Connection released, T4 2004-02-23 14:06:35 0x748 19633 CONNECT Connect req. (T4, Node:'', PID:1856) 2004-02-23 14:06:35 0x748 WRN 10 IOMan The Data volume 1 is offline. 2004-02-23 14:06:35 0x748 ERR 17 IOMan EMERGENCY SHUTDOWN 2004-02-23 14:06:35 0x748 ERR 8 Admin ERROR '' CAUSED EMERGENCY SHUTDOWN 2004-02-23 14:06:35 0x748 19620 DBSTATE Shutdown normal requested 2004-02-23 14:06:35 0x6C4 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:1 2004-02-23 14:06:35 0x3FC 19684 TASKING Tracewriter termination timeout: 1200 sec 2004-02-23 14:06:44 0x6C4 19619 TASKING Releasing tracewriter 2004-02-23 14:06:44 0x3FC 19890 DIAGHIST Backup of diagnostic files will be forced at next restart 2004-02-23 14:06:44 0x3FC 19600 VERSION 'Kernel 7.5.0 Build 008-123-061-548' 2004-02-23 14:06:44 0x3FC 19654 DBSTATE SERVERDB 'TESTDB' has stopped -------------------------------------------- current write position ----------------
